api_office


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id serial 10 √ nextval('api_office_id_seq'::regclass)
api_company.office_belongs_id api_company_office_belongs_id_703e4dff_fk_api_office_id R
api_crew.office_id api_crew_office_id_8d45f36a_fk_api_office_id R
api_currency.office_id api_currency_office_id_a29f3933_fk_api_office_id R
api_department.office_id api_department_office_id_70a54f6e_fk_api_office_id R
api_division.office_id api_division_office_id_ebb9b6b1_fk_api_office_id R
api_guide.office_id api_guide_office_id_14ad6006_fk_api_office_id R
api_headinvoice.office_id api_headinvoice_office_id_54d49f40_fk_api_office_id R
api_rate.office_id api_rate_office_id_95db8cf1_fk_api_office_id R
api_reportoperation.office_id api_reportoperation_office_id_75245fa7_fk_api_office_id R
api_serviceorder.office_id api_serviceorder_office_id_461be3ab_fk_api_office_id R
api_stock.office_id api_stock_office_id_8841a501_fk_api_office_id R
api_stockserial.office_id api_stockserial_office_id_045b3804_fk_api_office_id R
api_stocktransaction.office_id api_stocktransaction_office_id_6cf6994c_fk_api_office_id R
api_vehicle.office_id api_vehicle_office_id_96e821d6_fk_api_office_id R
api_voucher.office_id api_voucher_office_id_ff07fc94_fk_api_office_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
company_id int4 10 √ null
api_company.id api_office_company_id_a316f95c_fk_api_company_id R
currency_id int4 10 √ null
api_currency.id api_office_currency_id_d681c056_fk_api_currency_id R
address varchar 255 √ null
email varchar 255 √ null
phone varchar 255 √ null
tax float8 17,17 null

Indexes

Constraint Name Type Sort Column(s)
api_office_pkey Primary key Asc id
api_office_company_id_a316f95c Performance Asc company_id
api_office_currency_id_d681c056 Performance Asc currency_id
api_office_name_77db0520_like Performance Asc name
api_office_name_key Must be unique Asc name

Relationships

Close relationships within degrees of separation