api_companycontact


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id serial 10 √ nextval('api_companycontact_id_seq'::regclass)
api_headinvoice.company_contact_id api_headinvoice_company_contact_id_afc2640f_fk_api_compa R
api_serviceorder.company_contact_id api_serviceorder_company_contact_id_1d8fb9c2_fk_api_compa R
deleted timestamptz 35,6 √ null
name varchar 255 √ null
phone varchar 255 √ null
mobile varchar 255 √ null
address varchar 255 √ null
employee_position varchar 255 √ null
email varchar 255 √ null
created_at timestamptz 35,6 null
updated_at timestamptz 35,6 null
company_id int4 10 √ null
api_company.id api_companycontact_company_id_27c3dbbc_fk_api_company_id R

Indexes

Constraint Name Type Sort Column(s)
api_companycontact_pkey Primary key Asc id
api_companycontact_company_id_27c3dbbc Performance Asc company_id

Relationships

Close relationships within degrees of separation