Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| id | int8 | 19 | √ | null |
|
|
|||||
| procid | int8 | 19 | √ | null |
|
|
|||||
| notifid | int8 | 19 | √ | null |
|
|
|||||
| taskid | int8 | 19 | √ | null |
|
|
|||||
| conseqid | int8 | 19 | √ | null |
|
|
|||||
| senderid | int8 | 19 | √ | null |
|
|
|||||
| receivertype | varchar | 10 | √ | null |
|
|
|||||
| receiverid | int8 | 19 | √ | null |
|
|
|||||
| holderid | int8 | 19 | √ | null |
|
|
|||||
| proccodetagret | varchar | 30 | √ | null |
|
|
|||||
| taskidtarget | int8 | 19 | √ | null |
|
|
|||||
| conseqstatus | varchar | 10 | √ | null |
|
|
|||||
| conseqstatusdate | date | 13 | √ | null |
|
|
|||||
| notifmessage | varchar | 250 | √ | null |
|
|
|||||
| targetdate | date | 13 | √ | null |
|
|
|||||
| receiverroleprofile | varchar | 10 | √ | null |
|
|
|||||
| proctaskid | int8 | 19 | √ | null |
|
|
|||||
| proctaskcheckid | int8 | 19 | √ | null |
|
|
|||||
| conseqtype | varchar | 10 | √ | null |
|
|
|||||
| checkid | int8 | 19 | √ | null |
|
|
|||||
| printid | int8 | 19 | √ | null |
|
|
|||||
| emailto | varchar | 200 | √ | null |
|
|
|||||
| emailcc | varchar | 200 | √ | null |
|
|
|||||
| procmodule | varchar | 10 | √ | null |
|
|
|||||
| objectid | int8 | 19 | √ | null |
|
|
|||||
| conseqcode | varchar | 30 | √ | null |
|
|
|||||
| entitytarget | varchar | 10 | √ | null |
|
|
|||||
| entityproctarget | varchar | 30 | √ | null |
|
|
|||||
| entitytaskidtarget | int8 | 19 | √ | null |
|
|
|||||
| objectreference | varchar | 30 | √ | null |
|
|