Columns
Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
---|---|---|---|---|---|---|---|---|---|---|---|
contract_term_id | int8 | 19 | null |
|
|
The primary key of this table. System column calculated by the source System. |
|||||
contract_id | int8 | 19 | null |
|
|
Contract connected to this term |
|||||
customer_id | int8 | 19 | null |
|
|
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 |
|
|
The date at which this contract term started. |
|||||
end_date | date | 13 | null |
|
|
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). |