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