Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| id | int8 | 19 | √ | null |
|
|
|||||
| docid | int8 | 19 | √ | null |
|
|
|||||
| docmodule | varchar | 10 | √ | null |
|
|
|||||
| objectid | int8 | 19 | √ | null |
|
|
|||||
| objectreference | varchar | 10 | √ | null |
|
|
|||||
| tpid | int8 | 19 | √ | null |
|
|
|||||
| tpreference | varchar | 30 | √ | null |
|
|
|||||
| tpname | varchar | 100 | √ | null |
|
|
|||||
| doccode | varchar | 10 | √ | null |
|
|
|||||
| doctype | varchar | 10 | √ | null |
|
|
|||||
| docstatus | varchar | 10 | √ | null |
|
|
|||||
| doccheckstatus | varchar | 10 | √ | null |
|
|
|||||
| doccheckuserid | int8 | 19 | √ | null |
|
|
|||||
| docpath | varchar | 250 | √ | null |
|
|
|||||
| docrequesttype | varchar | 10 | √ | null |
|
|
|||||
| docdoublecheck | bool | 1 | √ | null |
|
|
|||||
| overridereceivertype | varchar | 10 | √ | null |
|
|
|||||
| overridereceiverroleprofile | varchar | 10 | √ | null |
|
|
|||||
| overridereceiverid | int8 | 19 | √ | null |
|
|
|||||
| checkreceivertype | varchar | 10 | √ | null |
|
|
|||||
| checkreceiverroleprofile | varchar | 10 | √ | null |
|
|
|||||
| checkreceiverid | int8 | 19 | √ | null |
|
|
|||||
| creationdate | date | 13 | √ | null |
|
|
|||||
| userid | int8 | 19 | √ | null |
|
|
|||||
| docstatusreason | varchar | 10 | √ | null |
|
|
|||||
| docstatuscomment | varchar | 250 | √ | null |
|
|
|||||
| checkcategory | varchar | 10 | √ | null |
|
|
|||||
| applicationruledisplay | varchar | 300 | √ | null |
|
|
|||||
| applicationrulerequest | varchar | 300 | √ | null |
|
|
|||||
| pardocid | int8 | 19 | √ | null |
|
|
|||||
| docstatusdate | timestamp | 29,6 | √ | null |
|
|
|||||
| doccheckstatusdate | timestamp | 29,6 | √ | null |
|
|
|||||
| mgid | int8 | 19 | √ | null |
|
|
|||||
| taskid | int8 | 19 | √ | null |
|
|