com_user

5 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id uuid 2147483647 null
agd_appointment_duration.user_id fk_agd_appointment_duration_on_user R
agd_appointment_participant.user_id fk_agd_appointment_participant_on_user R
agd_appointment_time_slot.user_id fk_agd_appointment_time_slot_on_user R
bac_ins_f_db_visit.agent_id fk_bac_ins_f_db_visit_on_agent R
com_custom_field.user_id fk_com_custom_field_on_user N
com_data_exchange_report.importer_id fk_com_data_exchange_report_on_importer R
com_setting.user_id fk_com_setting_on_user R
ins_inspection_agent.agent_id fk_ins_inspection_agent_on_agent R
ins_inspection_case_comment.user_id fk_ins_inspection_case_comment_on_user R
ins_inspection_comment.user_id fk_ins_inspection_comment_on_user R
ins_inspection_decision.decision_maker_id fk_ins_inspection_decision_on_decision_maker R
ins_inspection_department_user.agent_id fk_ins_inspection_department_user_on_agent R
ins_inspection_request.status_maker_id fk_ins_inspection_request_on_status_maker R
thirdp_base_third_party_comment.user_id fk_thirdp_base_third_party_comment_on_user R
version int4 10 null
created_by varchar 255 √ null
created_date timestamp 29,6 √ null
last_modified_by varchar 255 √ null
last_modified_date timestamp 29,6 √ null
username varchar 255 null
password varchar 255 √ null
first_name varchar 255 √ null
last_name varchar 255 null
civility_id uuid 2147483647 √ null
com_civility.id fk_com_user_on_civility R
email varchar 255 null
active bool 1 √ null
time_zone_id varchar 255 √ null
phone_number varchar 255 √ null
mobile_number varchar 255 √ null
job_position varchar 255 √ null
public_name varchar 255 √ null
reference varchar 255 √ null
color varchar 255 √ null

Indexes

Constraint Name Type Sort Column(s)
pk_com_user Primary key Asc id
idx_com_user_civility Performance Asc civility_id
idx_com_user_on_username Must be unique Asc username

Relationships

Close relationships within degrees of separation