Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| c_pk | int8 | 19 | null |
|
|
||||||
| c_created | timestamp | 29,6 | √ | null |
|
|
|||||
| c_created_by | varchar | 255 | √ | null |
|
|
|||||
| c_updated_by | varchar | 255 | √ | null |
|
|
|||||
| c_updated | timestamp | 29,6 | √ | null |
|
|
|||||
| c_ol | int8 | 19 | √ | null |
|
|
|||||
| c_next_location | varchar | 255 | √ | null |
|
|
|||||
| c_pos | int4 | 10 | √ | null |
|
|
|||||
| c_source_location | varchar | 255 | √ | null |
|
|
|||||
| c_route_id | int8 | 19 | √ | null |
|
|
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| tms_rsrv_route_details_pkey | Primary key | Asc | c_pk |
| uc_route_pos | Must be unique | Asc/Asc | c_route_id + c_pos |