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 |
|
|
|||||
| checkid | int8 | 19 | √ | null |
|
|
|||||
| checkorder | int4 | 10 | √ | null |
|
|
|||||
| checktype | varchar | 10 | √ | null |
|
|
|||||
| checkcode | varchar | 10 | √ | null |
|
|
|||||
| checkrequesttype | varchar | 30 | √ | null |
|
|
|||||
| receivertype | varchar | 10 | √ | null |
|
|
|||||
| receiverroleprofile | varchar | 10 | √ | null |
|
|
|||||
| receiverid | int8 | 19 | √ | null |
|
|
|||||
| proccodetarget | varchar | 30 | √ | null |
|
|
|||||
| taskidtarget | int8 | 19 | √ | null |
|
|
|||||
| notifoverridestatus | bool | 1 | √ | null |
|
|
|||||
| notifoverridereceivertype | varchar | 10 | √ | null |
|
|
|||||
| notifoverridereceiverroleprofile | varchar | 10 | √ | null |
|
|
|||||
| notifoverridereceiverid | int8 | 19 | √ | null |
|
|
|||||
| doccode | varchar | 10 | √ | null |
|
|
|||||
| doclabel | text | 2147483647 | √ | null |
|
|
|||||
| ccode | varchar | 10 | √ | null |
|
|
|||||
| clabel | text | 2147483647 | √ | null |
|
|
|||||
| cmessage | text | 2147483647 | √ | null |
|
|
|||||
| checklabel | varchar | 100 | √ | null |
|
|
|||||
| lancode | varchar | 10 | √ | null |
|
|
|||||
| applicationrule | varchar | 300 | √ | null |
|
|
|||||
| cllancode | varchar | 10 | √ | null |
|
|
|||||
| dllancode | varchar | 10 | √ | null |
|
|