1 DROP SCHEMA IF EXISTS staging CASCADE;
7 CREATE TABLE staging.user_stage (
8 row_id BIGSERIAL PRIMARY KEY,
9 row_date TIMESTAMP WITH TIME ZONE DEFAULT NOW(),
10 usrname TEXT NOT NULL,
14 ident_type INT DEFAULT 3,
15 first_given_name TEXT,
16 second_given_name TEXT,
20 home_ou INT DEFAULT 2,
22 complete BOOL DEFAULT FALSE
25 CREATE TABLE staging.card_stage ( -- for new library barcodes
26 row_id BIGSERIAL PRIMARY KEY,
27 row_date TIMESTAMP WITH TIME ZONE DEFAULT NOW(),
28 usrname TEXT NOT NULL,
29 barcode TEXT NOT NULL,
30 complete BOOL DEFAULT FALSE
33 CREATE TABLE staging.mailing_address_stage (
34 row_id BIGSERIAL PRIMARY KEY,
35 row_date TIMESTAMP WITH TIME ZONE DEFAULT NOW(),
36 usrname TEXT NOT NULL, -- user's SIS barcode, for linking
39 city TEXT NOT NULL DEFAULT '',
40 state TEXT NOT NULL DEFAULT 'OK',
41 country TEXT NOT NULL DEFAULT 'US',
42 post_code TEXT NOT NULL,
43 complete BOOL DEFAULT FALSE
46 CREATE TABLE staging.billing_address_stage (
47 LIKE staging.mailing_address_stage INCLUDING DEFAULTS
50 ALTER TABLE staging.billing_address_stage ADD CONSTRAINT PRIMARY KEY (row_id);
52 CREATE TABLE staging.statcat_stage (
53 row_id BIGSERIAL PRIMARY KEY,
54 row_date TIMESTAMP WITH TIME ZONE DEFAULT NOW(),
55 usrname TEXT NOT NULL,
56 statcat TEXT NOT NULL, -- for things like 'Year of study'
57 value TEXT NOT NULL, -- and the value, such as 'Freshman'
58 complete BOOL DEFAULT FALSE