bridge_rate_bundle_to_company


Description

Bridge table linking rate bundles to partner companies for corporate deals, including any cooperation identifier used for that partnership.

Columns

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

The primary key of this table. Surrogate key built from the rate bundle and company.
rate_bundle_id int8 19 √ null
dim_rate_bundle.rate_bundle_id erp_v2_bridge_rate_bundle_to_company_rate_bundle_id__erp_v2_dim_rate_bundle_rate_bundle_id_fkey_ca45bd926733 R

The rate bundle that is linked to the company.
company_id int8 19 √ null
dim_company.company_id erp_v2_bridge_rate_bundle_to_company_company_id__erp_v2_dim_company_company_id_fkey_716408ac5f77 R

The company that the rate bundle is linked to.
cooperation_id varchar 256 √ null

Cooperation identifier used for company-specific bundle availability.
created_date timestamptz 35 √ null

Timestamp in UTC when the rate bundle/company link was created.
last_updated timestamptz 35 √ null

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

System column. UTC timestamp assigned when a table batch is applied on Redshift. It represents warehouse landing order at table-batch granularity, not source event order. Usable to filter for incremental extractions.

Relationships

Close relationships within degrees of separation