auditor.actor_usr_history

↑ auditor schema

Soft Deletes: This table uses a deleted boolean flag rather than physical row deletion. Ad-hoc queries must include WHERE deleted = false to exclude logically-deleted rows. The application layer enforces this automatically; direct SQL does not.

Columns

Column Type Nullable Default Notes

Column	Type	Nullable
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
card	`integer`	Yes
profile	`integer`	No
usrname	`text`	No
email	`text`	Yes
passwd	`text`	Yes
standing	`integer`	No
ident_type	`integer`	No
ident_value	`text`	Yes
ident_type2	`integer`	Yes
ident_value2	`text`	Yes
net_access_level	`integer`	No
photo_url	`text`	Yes
prefix	`text`	Yes
first_given_name	`text`	No
second_given_name	`text`	Yes
family_name	`text`	No
suffix	`text`	Yes
guardian	`text`	Yes
pref_prefix	`text`	Yes
pref_first_given_name	`text`	Yes
pref_second_given_name	`text`	Yes
pref_family_name	`text`	Yes
pref_suffix	`text`	Yes
name_keywords	`text`	Yes
name_kw_tsvector	`tsvector`	Yes
alias	`text`	Yes
day_phone	`text`	Yes
evening_phone	`text`	Yes
other_phone	`text`	Yes
mailing_address	`integer`	Yes
billing_address	`integer`	Yes
home_ou	`integer`	No
dob	`date`	Yes
active	`boolean`	No
master_account	`boolean`	No
super_user	`boolean`	No
barred	`boolean`	No
deleted SOFT-DEL	`boolean`	No
juvenile	`boolean`	No
usrgroup	`integer`	No
claims_returned_count	`integer`	No
credit_forward_balance	`numeric(6,2)`	No
last_xact_id	`text`	No
create_date	`timestamp with time zone`	No
expire_date	`timestamp with time zone`	No
claims_never_checked_out_count	`integer`	No
last_update_time	`timestamp with time zone`	Yes
locale	`text`	Yes

audit_id PK

bigint

audit_time

timestamp with time zone

audit_action

text

audit_user

integer

Yes

audit_ws

integer

Yes

integer

card

integer

Yes

profile

integer

usrname

text

Yes

passwd

text

Yes

standing

integer

ident_type

integer

ident_value

text

Yes

ident_type2

integer

Yes

ident_value2

text

Yes

net_access_level

integer

photo_url

text

Yes

prefix

text

Yes

first_given_name

text

second_given_name

text

Yes

family_name

text

suffix

text

Yes

guardian

text

Yes

pref_prefix

text

Yes

pref_first_given_name

text

Yes

pref_second_given_name

text

Yes

pref_family_name

text

Yes

pref_suffix

text

Yes

name_keywords

text

Yes

name_kw_tsvector

tsvector

Yes

alias

text

Yes

day_phone

text

Yes

evening_phone

text

Yes

other_phone

text

Yes

mailing_address

integer

Yes

billing_address

integer

Yes

home_ou

integer

dob

date

Yes

active

boolean

master_account

boolean

super_user

boolean

barred

boolean

deleted SOFT-DEL

boolean

juvenile

boolean

usrgroup

integer

claims_returned_count

integer

credit_forward_balance

numeric(6,2)

last_xact_id

text

create_date

timestamp with time zone

expire_date

timestamp with time zone

claims_never_checked_out_count

integer

last_update_time

timestamp with time zone

Yes

locale

text

Yes

Primary Key

(audit_id)

Indexes

Index Method Definition

Index	Method	Definition
`actor_usr_history_pkey` PK	btree	`CREATE UNIQUE INDEX actor_usr_history_pkey ON auditor.actor_usr_history USING btree (audit_id)`
`aud_actor_usr_hist_id_idx`	btree	`CREATE INDEX aud_actor_usr_hist_id_idx ON auditor.actor_usr_history USING btree (id)`

actor_usr_history_pkey PK

btree

CREATE UNIQUE INDEX actor_usr_history_pkey ON auditor.actor_usr_history USING btree (audit_id)

aud_actor_usr_hist_id_idx

btree

CREATE INDEX aud_actor_usr_hist_id_idx ON auditor.actor_usr_history USING btree (id)