api_division


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id serial 10 √ nextval('api_division_id_seq'::regclass)
api_certifiedcart.division_id api_certifiedcart_division_id_4f344b14_fk_api_division_id R
api_certifiedcart.division_last_id api_certifiedcart_division_last_id_8c64f4db_fk_api_division_id R
api_crew.division_id api_crew_division_id_00e9199f_fk_api_division_id R
api_division_employees.division_id api_division_employees_division_id_6e5cb6ee_fk_api_division_id R
api_guide.division_destination_id api_guide_division_destination_id_6399d8cf_fk_api_division_id R
api_guide.division_origin_id api_guide_division_origin_id_d73b7bb9_fk_api_division_id R
api_origindestination.division_id api_origindestination_division_id_e1b11179_fk_api_division_id R
api_tourdetail.division_id api_tourdetail_division_id_28e733c7_fk_api_division_id R
api_voucher.division_id api_voucher_division_id_22412321_fk_api_division_id R
api_voucher.division_insured_id api_voucher_division_insured_id_b7770493_fk_api_division_id R
api_voucher.division_last_id api_voucher_division_last_id_b3a1ef99_fk_api_division_id R
deleted timestamptz 35,6 √ null
name varchar 255 null
description text 2147483647 √ null
created_at timestamptz 35,6 null
updated_at timestamptz 35,6 null
office_id int4 10 √ null
api_office.id api_division_office_id_ebb9b6b1_fk_api_office_id R
type_division_id int4 10 √ null
api_typedivision.id api_division_type_division_id_2ce76f96_fk_api_typedivision_id R
crew_id int4 10 √ null
api_crew.id api_division_crew_id_b679468d_fk_api_crew_id R
schedule varchar 255 √ null

Indexes

Constraint Name Type Sort Column(s)
api_division_pkey Primary key Asc id
api_division_crew_id_b679468d Performance Asc crew_id
api_division_name_7a1e01b6_like Performance Asc name
api_division_name_key Must be unique Asc name
api_division_office_id_ebb9b6b1 Performance Asc office_id
api_division_type_division_id_2ce76f96 Performance Asc type_division_id

Relationships

Close relationships within degrees of separation