tbl_users

56 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
refid serial 10 √ nextval('tbl_users_refid_seq'::regclass)
tbl_lithic_audit.audit_author tbl_evidence_log_audit_audit_author_fkeyR
tbl_photos_audit.audit_author tbl_photos_audit_author_fkeyR
tbl_users_audit.audit_author tbl_users_audit_audit_author_fkeyR
fname varchar 50 √ null
lname varchar 50 √ null
contact text 2147483647 √ null
user_type varchar 100 √ 'normal'::character varying
user_name varchar 50 √ null
passphrase varchar 32 √ null
comment text 2147483647 √ null
can_delete bool 1 √ false
can_alter bool 1 √ false
can_manage_users bool 1 √ false
can_login bool 1 √ false

Indexes

Constraint Name Type Sort Column(s)
tbl_users_pkey Primary key Asc refid
idx_tbl_users Must be unique Asc refid
tbl_users_user_name_key Must be unique Asc user_name

Relationships

Close relationships within degrees of separation