actor_usr_history

760 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
audit_id int8 19 null
audit_time timestamptz 35,6 null
audit_action text 2147483647 null
audit_user int4 10 √ null
audit_ws int4 10 √ null
id int4 10 null
card int4 10 √ null
profile int4 10 null
usrname text 2147483647 null
email text 2147483647 √ null
passwd text 2147483647 null
standing int4 10 null
ident_type int4 10 null
ident_value text 2147483647 √ null
ident_type2 int4 10 √ null
ident_value2 text 2147483647 √ null
net_access_level int4 10 null
photo_url text 2147483647 √ null
prefix text 2147483647 √ null
first_given_name text 2147483647 null
second_given_name text 2147483647 √ null
family_name text 2147483647 null
suffix text 2147483647 √ null
guardian text 2147483647 √ null
pref_prefix text 2147483647 √ null
pref_first_given_name text 2147483647 √ null
pref_second_given_name text 2147483647 √ null
pref_family_name text 2147483647 √ null
pref_suffix text 2147483647 √ null
name_keywords text 2147483647 √ null
name_kw_tsvector tsvector 2147483647 √ null
alias text 2147483647 √ null
day_phone text 2147483647 √ null
evening_phone text 2147483647 √ null
other_phone text 2147483647 √ null
mailing_address int4 10 √ null
billing_address int4 10 √ null
home_ou int4 10 null
dob date 13 √ null
active bool 1 null
master_account bool 1 null
super_user bool 1 null
barred bool 1 null
deleted bool 1 null
juvenile bool 1 null
usrgroup int4 10 null
claims_returned_count int4 10 null
credit_forward_balance numeric 6,2 null
last_xact_id text 2147483647 null
create_date timestamptz 35,6 null
expire_date timestamptz 35,6 null
claims_never_checked_out_count int4 10 null
last_update_time timestamptz 35,6 √ null
locale text 2147483647 √ null

Indexes

Constraint Name Type Sort Column(s)
actor_usr_history_pkey Primary key Asc audit_id
aud_actor_usr_hist_id_idx Performance Asc id

Relationships

Close relationships within degrees of separation