staging.billing_address_stage

Columns

Column Type Nullable Default Notes

row_id PK

bigint

No

nextval('staging.mailing_address_stage_row_id_seq'::regclass)

row_date

timestamp with time zone

Yes

now()

usrname

text

No

street1

text

Yes

street2

text

Yes

city

text

No

''::text

county

text

Yes

state

text

Yes

country

text

No

'US'::text

post_code

text

No

complete

boolean

Yes

false

Primary Key

(row_id)

Indexes

Index Method Definition

billing_address_stage_pkey PK

btree

CREATE UNIQUE INDEX billing_address_stage_pkey ON staging.billing_address_stage USING btree (row_id)