bridge_company_to_company_code


Description

Bridge table linking companies to their assigned company codes (tags). A company can have multiple codes and a code can be assigned to multiple companies.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
company_to_company_code_id varchar 256 null

Surrogate primary key.
company_id int8 19 √ null
dim_company.company_id Implied Constraint R

Foreign key to dim_company.
company_code_id int8 19 √ null
dim_company_code.company_code_id Implied Constraint R

Foreign key to dim_company_code.
last_updated timestamptz 35 √ null

System column. UTC Timestamp at which entry was calculated (lags shortly behind source system).

Relationships

Close relationships within degrees of separation