Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| id | int8 | 19 | √ | null |
|
|
|||||
| procid | int8 | 19 | √ | null |
|
|
|||||
| proctaskid | int8 | 19 | √ | null |
|
|
|||||
| proccode | varchar | 30 | √ | null |
|
|
|||||
| procmodule | varchar | 10 | √ | null |
|
|
|||||
| objectid | int8 | 19 | √ | null |
|
|
|||||
| taskid | int8 | 19 | √ | null |
|
|
|||||
| senderid | int8 | 19 | √ | null |
|
|
|||||
| receiverid | int8 | 19 | √ | null |
|
|
|||||
| holderid | int8 | 19 | √ | null |
|
|
|||||
| startdate | timestamp | 29,6 | √ | null |
|
|
|||||
| taskstatus | varchar | 10 | √ | null |
|
|
|||||
| receivertype | varchar | 10 | √ | null |
|
|
|||||
| receiverroleprofile | varchar | 10 | √ | null |
|
|
|||||
| funcode | varchar | 30 | √ | null |
|
|
|||||
| taskstatusdate | timestamp | 29,6 | √ | null |
|
|
|||||
| mgid | int8 | 19 | √ | null |
|
|
|||||
| brid | int8 | 19 | √ | null |
|
|
|||||
| subentity | varchar | 10 | √ | null |
|
|
|||||
| subentityid | int8 | 19 | √ | null |
|
|
|||||
| objectreference | varchar | 30 | √ | null |
|
|