api_crew


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id serial 10 √ nextval('api_crew_id_seq'::regclass)
api_division.crew_id api_division_crew_id_b679468d_fk_api_crew_id R
api_guide.crew_id api_guide_crew_id_16fff8f9_fk_api_crew_id R
api_voucher.crew_id api_voucher_crew_id_7965c564_fk_api_crew_id R
api_voucher.crew_last_id api_voucher_crew_last_id_917e6e0d_fk_api_crew_id R
deleted timestamptz 35,6 √ null
date timestamptz 35,6 √ null
created_at timestamptz 35,6 null
updated_at timestamptz 35,6 null
assistant_id int4 10 √ null
api_employee.id api_crew_assistant_id_a2b410e4_fk_api_employee_id R
assistant2_id int4 10 √ null
api_employee.id api_crew_assistant2_id_7b196e69_fk_api_employee_id R
division_id int4 10 √ null
api_division.id api_crew_division_id_00e9199f_fk_api_division_id R
driver_id int4 10 √ null
api_employee.id api_crew_driver_id_cb2bc17e_fk_api_employee_id R
vehicle_id int4 10 √ null
api_vehicle.id api_crew_vehicle_id_cbae26f9_fk_api_vehicle_id R
office_id int4 10 √ null
api_office.id api_crew_office_id_8d45f36a_fk_api_office_id R

Indexes

Constraint Name Type Sort Column(s)
api_crew_pkey Primary key Asc id
api_crew_assistant2_id_7b196e69 Performance Asc assistant2_id
api_crew_assistant_id_a2b410e4 Performance Asc assistant_id
api_crew_division_id_00e9199f Performance Asc division_id
api_crew_driver_id_cb2bc17e Performance Asc driver_id
api_crew_office_id_8d45f36a Performance Asc office_id
api_crew_vehicle_id_cbae26f9 Performance Asc vehicle_id

Relationships

Close relationships within degrees of separation