1 DROP SCHEMA 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 CREATE TABLE staging.statcat_stage (
51 row_id BIGSERIAL PRIMARY KEY,
52 row_date TIMESTAMP WITH TIME ZONE DEFAULT NOW(),
53 usrname TEXT NOT NULL,
54 statcat TEXT NOT NULL, -- for things like 'Year of study'
55 value TEXT NOT NULL, -- and the value, such as 'Freshman'
56 complete BOOL DEFAULT FALSE