Chapter 23. Schema staging

Table of Contents

Tables in staging

Below are the tables, views and functions for staging

Tables in staging

billing_address_stage

  • row_id bigint PRIMARY KEY DEFAULT nextval('staging.mailing_address_stage_row_id_seq'::regclass)
  • row_date timestamp with time zone DEFAULT now()
  • usrname text NOT NULL
  • street1 text
  • street2 text
  • city text NOT NULL DEFAULT ''::text
  • state text NOT NULL DEFAULT 'OK'::text
  • country text NOT NULL DEFAULT 'US'::text
  • post_code text NOT NULL
  • complete boolean DEFAULT false

card_stage

  • row_id bigserial PRIMARY KEY
  • row_date timestamp with time zone DEFAULT now()
  • usrname text NOT NULL
  • barcode text NOT NULL
  • complete boolean DEFAULT false

mailing_address_stage

  • row_id bigserial PRIMARY KEY
  • row_date timestamp with time zone DEFAULT now()
  • usrname text NOT NULL
  • street1 text
  • street2 text
  • city text NOT NULL DEFAULT ''::text
  • state text NOT NULL DEFAULT 'OK'::text
  • country text NOT NULL DEFAULT 'US'::text
  • post_code text NOT NULL
  • complete boolean DEFAULT false

statcat_stage

  • row_id bigserial PRIMARY KEY
  • row_date timestamp with time zone DEFAULT now()
  • usrname text NOT NULL
  • statcat text NOT NULL
  • value text NOT NULL
  • complete boolean DEFAULT false

user_stage

  • row_id bigserial PRIMARY KEY
  • row_date timestamp with time zone DEFAULT now()
  • usrname text NOT NULL
  • profile text
  • email text
  • passwd text
  • ident_type integer DEFAULT 3
  • first_given_name text
  • second_given_name text
  • family_name text
  • day_phone text
  • evening_phone text
  • home_ou integer DEFAULT 2
  • dob text
  • complete boolean DEFAULT false