api_location


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id serial 10 √ nextval('api_location_id_seq'::regclass)
api_chest.location_id api_chest_location_id_9348aee0_fk_api_location_id R
api_origindestination.destination_id api_origindestinatio_destination_id_2c84604a_fk_api_locat R
api_origindestination.origin_id api_origindestination_origin_id_3e8024a6_fk_api_location_id R
api_voucher.location_destination_id api_voucher_location_destination_id_aac8b3ae_fk_api_location_id R
api_voucher.location_origin_id api_voucher_location_origin_id_a336bd9d_fk_api_location_id R
deleted timestamptz 35,6 √ null
code varchar 255 null
code_brinks varchar 255 √ null
name varchar 255 null
description text 2147483647 √ null
created_at timestamptz 35,6 null
updated_at timestamptz 35,6 null
company_id int4 10 √ null
api_company.id api_location_company_id_525b3e76_fk_api_company_id R
type_location_id int4 10 √ null
api_typelocation.id api_location_type_location_id_335311dd_fk_api_typelocation_id R
zone_id int4 10 √ null
api_zone.id api_location_zone_id_010943a5_fk_api_zone_id R
type_address varchar 255 √ null
address varchar 255 √ null
contact varchar 255 √ null
email varchar 255 √ null
point_name varchar 255 √ null
reference_point varchar 255 √ null
telephone varchar 255 √ null

Indexes

Constraint Name Type Sort Column(s)
api_location_pkey Primary key Asc id
api_location_code_12da2884_like Performance Asc code
api_location_code_key Must be unique Asc code
api_location_company_id_525b3e76 Performance Asc company_id
api_location_type_location_id_335311dd Performance Asc type_location_id
api_location_zone_id_010943a5 Performance Asc zone_id

Relationships

Close relationships within degrees of separation