Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| company_id | int8 | 19 | null |
|
|
The primary key of this table. System column calculated by the source System. |
|||||
| company_name | varchar | 256 | null |
|
|
The name of the partner company. |
|||||
| external_company_identifier | varchar | 256 | √ | null |
|
|
A string to identify the company in external systems. |
||||
| company_number | varchar | 256 | null |
|
|
More human-readable identifier key to identify the company. Formatted as |
|||||
| active | bool | 1 | null |
|
|
Whether the company currently is assignable to contracts. |
|||||
| archived | bool | 1 | null |
|
|
Permanently removed but kept for historic relations. |
|||||
| last_updated | timestamptz | 35 | √ | null |
|
|
System column. UTC Timestamp at which entry was calculated (lags behind source system). |
Relationships
Close relationships within degrees of separation
