api_guide


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id serial 10 √ nextval('api_guide_id_seq'::regclass)
api_guide_vouchers.guide_id api_guide_vouchers_guide_id_8b2fa829_fk_api_guide_id R
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
division_destination_id int4 10 √ null
api_division.id api_guide_division_destination_id_6399d8cf_fk_api_division_id R
division_origin_id int4 10 √ null
api_division.id api_guide_division_origin_id_d73b7bb9_fk_api_division_id R
employee_destination_id int4 10 √ null
api_employee.id api_guide_employee_destination_id_7dcfe7e4_fk_api_employee_id R
employee_origin_id int4 10 √ null
api_employee.id api_guide_employee_origin_id_dd264510_fk_api_employee_id R
type_guide_id int4 10 √ null
api_typeguide.id api_guide_type_guide_id_0f64d40d_fk_api_typeguide_id R
certified_cart bool 1 null
certified_cart_code varchar 255 √ null
crew_id int4 10 √ null
api_crew.id api_guide_crew_id_16fff8f9_fk_api_crew_id R
office_id int4 10 √ null
api_office.id api_guide_office_id_14ad6006_fk_api_office_id R

Indexes

Constraint Name Type Sort Column(s)
api_guide_pkey Primary key Asc id
api_guide_crew_id_16fff8f9 Performance Asc crew_id
api_guide_division_destination_id_6399d8cf Performance Asc division_destination_id
api_guide_division_origin_id_d73b7bb9 Performance Asc division_origin_id
api_guide_employee_destination_id_7dcfe7e4 Performance Asc employee_destination_id
api_guide_employee_origin_id_dd264510 Performance Asc employee_origin_id
api_guide_office_id_14ad6006 Performance Asc office_id
api_guide_type_guide_id_0f64d40d Performance Asc type_guide_id

Relationships

Close relationships within degrees of separation