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 |
|
|