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_pid | varchar | 255 | null |
|
|
||||||
c_action_type | varchar | 255 | null |
|
|
||||||
c_description | varchar | 255 | null |
|
|
||||||
c_enabled | bool | 1 | √ | null |
|
|
|||||
c_flex_1 | varchar | 255 | √ | null |
|
|
|||||
c_flex_2 | varchar | 255 | √ | null |
|
|
|||||
c_flex_3 | varchar | 255 | √ | null |
|
|
|||||
c_flex_4 | varchar | 255 | √ | null |
|
|
|||||
c_flex_5 | varchar | 255 | √ | null |
|
|
|||||
c_location_group_name | varchar | 255 | √ | null |
|
|
|||||
c_location_key | varchar | 255 | √ | null |
|
|
|||||
c_name | varchar | 255 | null |
|
|
||||||
c_program_name | varchar | 255 | null |
|
|
||||||
c_route_id | int8 | 19 | null |
|
|
Indexes
Constraint Name | Type | Sort | Column(s) |
---|---|---|---|
tms_rsrv_action_pkey | Primary key | Asc | c_pk |
uc_rsrv_action_name | Must be unique | Asc | c_name |
ukgygdi15e08na90j27mponyxlg | Must be unique | Asc | c_pid |