Column Name
| Datatype
| Description
|
---|---|---|
FILE_ID*
| INTEGER
| Source ID (primary key).
|
SUBJECT_AREA*
| VARCHAR2 (240)
| Folder name.
|
DATABASE_TYPE
| VARCHAR2 (240)
| Type of database extracted from.
|
DATABASE_NAME
| VARCHAR2 (240)
| Name of database extracted from (DSN).
|
FILE_NAME
| VARCHAR2 (240)
| Name of file definitions.
|
SCHEMA_FILE_NAME
| VARCHAR2 (240)
| File from which schema was extracted.
|
SELECT_INFO_ID
| INTEGER
| File organization information.
|
DISPLAY_SIZE
| INTEGER
| Display size (uncompressed).
|
PHYSICAL_SIZE
| INTEGER
| Physical size (compressed binary).
|
MIN_PHYSICAL_SIZE
| INTEGER
| Minimum physical size (varying records).
|
FIRST_FIELD_ID
| INTEGER
| Link to first field of file definitions.
|
SOURCE_DESCRIPTION
| VARCHAR2 (2000)
| Source description.
|
VERSION_ID
| INTEGER
| Version ID.
|
SOURCE_VERSION_NUMBER
| NUMBER
| Source version number.
|
*Indicates that the column is a key column.
|