Schema staging
HomePrev Chapter 1. Database Schema Next

Schema staging

Table: billing_address_stage

Columns: 

field name : datatype -- parameters, contraints and notes
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,

Table: card_stage

Columns: 

field name : datatype -- parameters, contraints and notes
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,

Table: mailing_address_stage

Columns: 

field name : datatype -- parameters, contraints and notes
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,

Table: statcat_stage

Columns: 

field name : datatype -- parameters, contraints and notes
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,

Table: user_stage

Columns: 

field name : datatype -- parameters, contraints and notes
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,

Prev Up Next
Schema serial Home Schema stats

Report any errors in this documentation using Launchpad.
Documentation for Evergreen version 2.2
Copyright © 2007-2012, Memebers of the Evergreen Project