api_company


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id serial 10 √ nextval('api_company_id_seq'::regclass)
api_bankaccount.bank_id api_bankaccount_bank_id_15746933_fk_api_company_id R
api_bankaccount.company_id api_bankaccount_company_id_48ada75d_fk_api_company_id R
api_clientbinnacle.company_id api_clientbinnacle_company_id_9ca7f97b_fk_api_company_id R
api_companycontact.company_id api_companycontact_company_id_27c3dbbc_fk_api_company_id R
api_contract.company_id api_contract_company_id_e37b23ce_fk_api_company_id R
api_location.company_id api_location_company_id_525b3e76_fk_api_company_id R
api_office.company_id api_office_company_id_a316f95c_fk_api_company_id R
api_quotation.company_id api_quotation_company_id_a137cb30_fk_api_company_id R
api_serviceorder.company_id api_serviceorder_company_id_3a05c0da_fk_api_company_id R
api_voucher.company_id api_voucher_company_id_fb2f06b9_fk_api_company_id R
deleted timestamptz 35,6 √ null
code varchar 255 null
code_brinks varchar 255 √ null
identification_number varchar 255 null
name varchar 255 null
alias varchar 255 √ null
abbreviation varchar 255 √ null
email varchar 255 √ null
phone varchar 255 √ null
web varchar 255 √ null
address varchar 255 √ null
is_carrier bool 1 null
is_financial_institution bool 1 null
is_active bool 1 null
created_at timestamptz 35,6 null
updated_at timestamptz 35,6 null
segment_company_id int4 10 √ null
api_segmentcompany.id api_company_segment_company_id_ec5b004f_fk_api_segme R
type_company_id int4 10 √ null
api_typecompany.id api_company_type_company_id_49ad1971_fk_api_typecompany_id R
is_commercial_institution bool 1 null
is_government_institution bool 1 null
varchar 100 √ null
dubious_reputation bool 1 null
office_belongs_id int4 10 √ null
api_office.id api_company_office_belongs_id_703e4dff_fk_api_office_id R

Indexes

Constraint Name Type Sort Column(s)
api_company_pkey Primary key Asc id
api_company_code_136012f2_like Performance Asc code
api_company_code_key Must be unique Asc code
api_company_identification_number_6ec712cf_like Performance Asc identification_number
api_company_identification_number_key Must be unique Asc identification_number
api_company_name_16600b64_like Performance Asc name
api_company_name_key Must be unique Asc name
api_company_office_belongs_id_703e4dff Performance Asc office_belongs_id
api_company_segment_company_id_ec5b004f Performance Asc segment_company_id
api_company_type_company_id_49ad1971 Performance Asc type_company_id

Relationships

Close relationships within degrees of separation