Groups
DOC_ARCHIVE
| Col # | Column Name | Data Type | Field Length | Not Null? | Data Def. | Comments |
|---|---|---|---|---|---|---|
| 1 | ID | NUMBER | 22 | N | Primary key | |
| 2 | ACCOUNT_ID | NUMBER | 22 | Y | ||
| 3 | OBJECT_ID | NUMBER | 22 | Y | ||
| 4 | CODE | VARCHAR2 | 20 | Y | Indicates type of document | |
| 5 | DOC | BLOB | 4000 | Y | ||
| 6 | DESCRIPTION | VARCHAR2 | 100 | Y | ||
| 7 | CREATE_DATE | DATE | 7 | Y | ||
| 8 | TYPE | VARCHAR2 | 35 | Y | ||
| 9 | FILE_NAME | VARCHAR2 | 50 | Y | ||
| 10 | STATUS_ID | NUMBER | 22 | Y | References STATUS.ID | |
| 11 | DOC_CATEGORY_ID | NUMBER | 22 | Y | ||
| 12 | LOCKED_BY_OPERATOR_ID | NUMBER | 22 | Y |