tbl_users_audit

143 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
fname varchar 50 √ null
lname varchar 50 √ null
contact text 2147483647 √ null
user_type varchar 100 √ null
user_name varchar 50 √ null
passphrase varchar 32 √ null
comment text 2147483647 √ null
uid serial 10 √ nextval('tbl_users_audit_uid_seq'::regclass)
refid int4 10 null
can_delete bool 1 √ null
can_alter bool 1 √ null
can_manage_users bool 1 √ null
can_login bool 1 √ null
audit_timestamp timestamp 29,6 √ now()
audit_author int4 10 √ '-1'::integer
tbl_users.refid tbl_users_audit_audit_author_fkeyR
audit_action varchar 10 √ 'unknown'::character varying

Indexes

Constraint Name Type Sort Column(s)
users_pkey Primary key Asc uid

Relationships

Close relationships within degrees of separation