api_historicalguide


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id int4 10 null
deleted timestamptz 35,6 √ null
status varchar 255 √ null
date timestamptz 35,6 √ null
am_pm text 2147483647 √ null
created_at timestamptz 35,6 null
updated_at timestamptz 35,6 null
history_id serial 10 √ nextval('api_historicalguide_history_id_seq'::regclass)
history_date timestamptz 35,6 null
history_change_reason varchar 100 √ null
history_type varchar 1 null
division_destination_id int4 10 √ null
division_origin_id int4 10 √ null
employee_destination_id int4 10 √ null
employee_origin_id int4 10 √ null
history_user_id int4 10 √ null
auth_user.id api_historicalguide_history_user_id_1818c5c8_fk_auth_user_id R
type_guide_id int4 10 √ null
certified_cart bool 1 null
certified_cart_code varchar 255 √ null
crew_id int4 10 √ null
office_id int4 10 √ null

Indexes

Constraint Name Type Sort Column(s)
api_historicalguide_pkey Primary key Asc history_id
api_historicalguide_crew_id_27142e0f Performance Asc crew_id
api_historicalguide_division_destination_id_b2affea6 Performance Asc division_destination_id
api_historicalguide_division_origin_id_67520cb7 Performance Asc division_origin_id
api_historicalguide_employee_destination_id_2921fd11 Performance Asc employee_destination_id
api_historicalguide_employee_origin_id_a2b64059 Performance Asc employee_origin_id
api_historicalguide_history_user_id_1818c5c8 Performance Asc history_user_id
api_historicalguide_id_e2267e77 Performance Asc id
api_historicalguide_office_id_22852b26 Performance Asc office_id
api_historicalguide_type_guide_id_5d3ed716 Performance Asc type_guide_id

Relationships

Close relationships within degrees of separation