auditor.actor_usr_address_history

audit_id PK

bigint

No

audit_time

timestamp with time zone

No

audit_action

text

No

audit_user

integer

Yes

audit_ws

integer

Yes

id

integer

No

valid

boolean

No

within_city_limits

boolean

No

address_type

text

No

usr

integer

No

street1

text

No

street2

text

Yes

city

text

No

county

text

Yes

state

text

Yes

country

text

No

post_code

text

No

pending

boolean

No

replaces

integer

Yes

actor_usr_address_history_pkey PK

btree

CREATE UNIQUE INDEX actor_usr_address_history_pkey ON auditor.actor_usr_address_history USING btree (audit_id)

aud_actor_usr_address_hist_id_idx

btree

CREATE INDEX aud_actor_usr_address_hist_id_idx ON auditor.actor_usr_address_history USING btree (id)