Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| id | int8 | 19 | √ | null |
|
|
|||||
| proccode | varchar | 30 | √ | null |
|
|
|||||
| procmodule | varchar | 10 | √ | null |
|
|
|||||
| taskid | int8 | 19 | √ | null |
|
|
|||||
| conseqid | int8 | 19 | √ | null |
|
|
|||||
| conseqorder | int4 | 10 | √ | null |
|
|
|||||
| conseqtype | varchar | 10 | √ | null |
|
|
|||||
| conseqcode | varchar | 30 | √ | null |
|
|
|||||
| receivertype | varchar | 10 | √ | null |
|
|
|||||
| receiverid | int8 | 19 | √ | null |
|
|
|||||
| proccodetarget | varchar | 30 | √ | null |
|
|
|||||
| taskidtarget | int8 | 19 | √ | null |
|
|
|||||
| conseqlabel | varchar | 100 | √ | null |
|
|
|||||
| lancode | varchar | 10 | √ | null |
|
|
|||||
| receiverroleprofile | varchar | 10 | √ | null |
|
|
|||||
| applicationrule | varchar | 300 | √ | null |
|
|
|||||
| targetphase | varchar | 10 | √ | null |
|
|
|||||
| targetstatus | varchar | 10 | √ | null |
|
|
|||||
| triggermode | varchar | 10 | √ | null |
|
|
|||||
| emailto | varchar | 10 | √ | null |
|
|
|||||
| emailcc | varchar | 10 | √ | null |
|
|
|||||
| subentity | varchar | 10 | √ | null |
|
|
|||||
| entitytarget | varchar | 10 | √ | null |
|
|
|||||
| entityproctarget | varchar | 30 | √ | null |
|
|
|||||
| entitytaskidtarget | int8 | 19 | √ | null |
|
|
|||||
| subentityid | int4 | 10 | √ | null |
|
|