tdis_user


Columns

Column Type Size Nulls Auto Default Children Parents Comments
contact_id int4 10 null
tdis_element.user_id tdis_element_user_fkR
tdis_element_history.user_id tdis_element_history_user_fkR
tdis_notification.user_id tdis_notification_user_fkR
tdis_session.user_id tdis_session_user_fkC
tdis_user_keyword.user_id tdis_user_keyword_user_fkC
tdis_user_project_role.user_id tdis_user_project_role_user_fkC
tdis_user_report.user_id tdis_user_report_user_fkC
tdis_user_search.user_id tdis_user_search_user_fkC
tdis_contact.id tdis_user_isa_contact_fkR
username varchar 2147483647 null
password varchar 72 null
date_created timestamptz 35,6 √ null
date_updated timestamptz 35,6 √ null
user_photo bytea 2147483647 √ null
login_status varchar 2147483647 √ null
last_logged_in timestamptz 35,6 √ null

Indexes

Constraint Name Type Sort Column(s)
tdis_user_pk Primary key Asc contact_id

Relationships

Close relationships within degrees of separation