Columns
Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
DOCUMENT_ID | NUMBER | 18 | null |
|
|
Field Document ID. Stores primary key for this table. |
||||||||||||||||||||||||||||||
NAME | VARCHAR2 | 500 | null |
|
|
Field Name. Stores the name given to this record. |
||||||||||||||||||||||||||||||
EXTENSION | VARCHAR2 | 100 | √ | null |
|
|
Field Extension. Stores the extension of the file. |
|||||||||||||||||||||||||||||
DESCRIPTION | VARCHAR2 | 4000 | √ | null |
|
|
Field Description. Stores the description given to this record. |
|||||||||||||||||||||||||||||
CONTENT_TYPE | VARCHAR2 | 250 | null |
|
|
Field Content Type. Stores content type of the file. |
||||||||||||||||||||||||||||||
BINARY | BLOB | 4000 | null |
|
|
Field Extension. Stores the binary of the file, BLOB data type |
||||||||||||||||||||||||||||||
VERSION_ID | NUMBER | 18 | 0 |
|
|
Field Version. Stores the version of the record. |
||||||||||||||||||||||||||||||
CUSER | VARCHAR2 | 75 | null |
|
|
Field Create User. Stores who create the record. |
||||||||||||||||||||||||||||||
CDATE | TIMESTAMP(6) | 11,6 | SYSTIMESTAMP |
|
|
Field Create Date. Stores when the record was created. |
||||||||||||||||||||||||||||||
MUSER | VARCHAR2 | 75 | null |
|
|
Field Modified User. Stores who modified the record. |
||||||||||||||||||||||||||||||
MDATE | TIMESTAMP(6) | 11,6 | SYSTIMESTAMP |
|
|
Field Modified Date. Stores when the record was modified. |
Indexes
Constraint Name | Type | Sort | Column(s) |
---|---|---|---|
DOCUMENT_PK | Primary key | Asc | DOCUMENT_ID |