bridge_rate_to_rate_code


Description

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

Columns

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

Surrogate primary key.
rate_id int8 19 √ null
dim_rate.rate_id erp_v2_bridge_rate_to_rate_code_rate_id__erp_v2_dim_rate_rate_id_fkey_9ee2eae02ce4 R

The foreign key to the rate table.
rate_code_id int8 19 √ null
dim_rate_code.rate_code_id erp_v2_bridge_rate_to_rate_code_rate_code_id__erp_v2_dim_rate_code_rate_code_id_fkey_dd41198c328b R

The foreign key to the Rate Code table.
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