Data Dictionary
>
FPSBASE Tables
> FPSBASE.DBF_TAB_COLUMNS
Table FPSBASE.DBF_TAB_COLUMNS"
See comments in DBF_REF_TAB_COLUMNS view.
-
Schema: FPSBASE
-
Tablespace: FPSDATA
-
Primary key: OWNER, TABLE_NAME, COLUMN_NAME
|
Column |
Type |
Nullable |
Comment |
|---|---|---|---|
|
OWNER |
VARCHAR2(30) |
N |
|
|
TABLE_NAME |
VARCHAR2(128) |
N |
|
|
COLUMN_NAME |
VARCHAR2(128) |
N |
Name of the column in DWH. Note: The column may exist in more than one table and/or schema. (* from FPSINPUT.GEN_EXPLANATIONS) |
|
CHAR_LENGTH |
NUMBER |
||
|
COLUMN_DML_SCOPE |
VARCHAR2(18) |
||
|
COLUMN_ID |
NUMBER |
||
|
DATA_LENGTH |
NUMBER |
N |
|
|
DATA_PRECISION |
NUMBER |
||
|
DATA_SCALE |
NUMBER |
||
|
DATA_TYPE |
VARCHAR2(128) |
||
|
IS_UPDATED_BY_TRIGGER |
CHAR(1) |
||
|
NULLABLE |
VARCHAR2(1) |
||
|
NUM_DISTINCT |
NUMBER |
||
|
OBJECT_TYPE |
VARCHAR2(23) |
||
|
PREFIX |
VARCHAR2(4000) |