DOC_ARCHIVE

Groups

DOC_ARCHIVE

Col #Column NameData TypeField LengthNot 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

  

 

Â