| contract_term_id |
int8 |
19 |
|
|
null |
|
|
The primary key of this table. System column calculated by the source System. |
| contract_id |
int8 |
19 |
|
|
null |
|
| fct_contract.contract_id |
fct_contract_term_dates_contract_id_fkey |
R |
|
Contract connected to this term |
| customer_id |
int8 |
19 |
|
|
null |
|
| dim_customer.customer_id |
fct_contract_term_dates_customer_id_fkey |
R |
|
Customer that holds this contract |
| organization_unit_id |
int8 |
19 |
|
|
null |
|
|
The gym (organization_unit) for which contract was generated. |
| start_date |
date |
13 |
|
|
null |
|
| dim_date.date |
fct_contract_term_dates_start_date_fkey |
R |
|
The date at which this contract term started. |
| end_date |
date |
13 |
|
|
null |
|
| dim_date.date |
fct_contract_term_dates_end_date_fkey |
R |
|
The date at which this contract term ended. |
| last_updated |
timestamptz |
35 |
√ |
|
null |
|
|
System column. UTC Timestamp at which entry was calculated (lags behind source system). |
