dim_company


Columns

Column Type Size Nulls Auto Default Children Parents Comments
company_id int8 19 null
bridge_company_to_company_code.company_id Implied Constraint R
bridge_company_to_organization_unit.company_id Implied Constraint R
dim_contract_voucher_definition.company_id Implied Constraint R
fct_contract.company_id Implied Constraint R
fct_contract_voucher.company_id Implied Constraint R
company_name varchar 256 √ null
external_company_identifier varchar 256 √ null
company_number varchar 256 √ null
active bool 1 √ null
archived bool 1 √ null
chamber_of_commerce_number varchar 256 √ null
vat_number varchar 256 √ null
contact_firstname varchar 256 √ null
contact_lastname varchar 256 √ null
contact_title varchar 256 √ null
contact_street varchar 256 √ null
contact_house_number varchar 256 √ null
contact_zip varchar 256 √ null
contact_city varchar 256 √ null
contact_country varchar 256 √ null
contact_email varchar 256 √ null
contact_phone_number varchar 256 √ null
contact_mobile_number varchar 256 √ null
contact_fax varchar 256 √ null
contact_email_status varchar 256 √ null
invoice_firstname varchar 256 √ null
invoice_lastname varchar 256 √ null
invoice_title varchar 256 √ null
invoice_street varchar 256 √ null
invoice_house_number varchar 256 √ null
invoice_zip varchar 256 √ null
invoice_city varchar 256 √ null
invoice_country varchar 256 √ null
invoice_email varchar 256 √ null
invoice_phone_number varchar 256 √ null
invoice_mobile_number varchar 256 √ null
invoice_fax varchar 256 √ null
invoice_email_status varchar 256 √ null
last_updated timestamptz 35 √ null

Relationships

Close relationships within degrees of separation