Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| iddriver | int4 | 10 | null |
|
|
||||||
| idunit | int4 | 10 | null |
|
|
||||||
| assignstartdate | timestamptz | 35,6 | null |
|
|
||||||
| assignenddate | timestamptz | 35,6 | √ | null |
|
|
|||||
| enabled | bool | 1 | true |
|
|
||||||
| createbyuser | int8 | 19 | null |
|
|
||||||
| creationdate | timestamp | 29,6 | null |
|
|
||||||
| lastmodifiedbyuser | int8 | 19 | null |
|
|
||||||
| lastmodificationdate | timestamptz | 35,6 | null |
|
|
||||||
| originatingsystem | varchar | 50 | null |
|
|
||||||
| iddriver_unit | bigserial | 19 | √ | nextval('driver_unit_iddriver_unit_seq'::regclass) |
|
|
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| pk_driver_unit_iddriver_unit | Primary key | Asc | iddriver_unit |
| idx_driver_unit_iddriver | Performance | Asc | iddriver |
| idx_driver_unit_idunit | Performance | Asc | idunit |
Relationships
Close relationships within degrees of separation
