DIFF |
Default Table Name | DIFF |
Definition |
DIFF Columns |
ColumnName | Domain | Datatype | NULL | Definition |
ERROR_CODE | VARCHAR2(2) | YES | ||
ERROR | VARCHAR2(40) | YES | ||
DBTBNAME | VARCHAR2(30) | YES | ||
SYSTBNAME | VARCHAR2(30) | YES | ||
DBCOLUMN | VARCHAR2(30) | YES | ||
SYSCOLUMN | VARCHAR2(30) | YES | ||
DBCOLSEQ | NUMBER(5, 0) | YES | ||
SYSCOLSEQ | NUMBER(5, 0) | YES | ||
DBLENGTH | NUMBER(5, 0) | YES | ||
SYSLENGTH | NUMBER(5, 0) | YES | ||
DBSCALE | NUMBER(5, 0) | YES | ||
SYSSCALE | NUMBER(5, 0) | YES | ||
DBNULLS | VARCHAR2(1) | YES | ||
SYSNULLS | VARCHAR2(1) | YES | ||
DBCOLTYPE | VARCHAR2(30) | YES | ||
SYSCOLTYPE | VARCHAR2(30) | YES | ||
DBINDEXNAME | VARCHAR2(30) | YES | ||
SYSINDEXNAME | VARCHAR2(30) | YES | ||
DBUNIQUERULE | VARCHAR2(1) | YES | ||
SYSUNIQUERULE | VARCHAR2(1) | YES | ||
DBCONSTRAINTNAME | VARCHAR2(30) | YES | ||
SYSCONSTRAINTNAME | VARCHAR2(30) | YES | ||
DBPARTBNAME | VARCHAR2(30) | YES | ||
SYSPARTBNAME | VARCHAR2(30) | YES | ||
DBREFDCOLUMN | VARCHAR2(30) | YES | ||
SYSREFDCOLUMN | VARCHAR2(30) | YES | ||
DBREFSCOLUMN | VARCHAR2(30) | YES | ||
SYSREFSCOLUMN | VARCHAR2(30) | YES | ||
DBFKSEQNO | NUMBER(5, 0) | YES | ||
SYSFKSEQNO | NUMBER(5, 0) | YES | ||
DBDELETERULE | VARCHAR2(1) | YES | ||
SYSDELETERULE | VARCHAR2(1) | YES | ||
DBTRIGGERNAME | VARCHAR2(30) | YES | ||
SYSTRIGGERNAME | VARCHAR2(30) | YES | ||
RUN_VER_CD | VARCHAR2(15) | YES | ||
OBJ_NAME | VARCHAR2(30) | YES | ||
S_OBJ_TYPE | VARCHAR2(1) | YES | ||
INDEX_TABLE_NAME | VARCHAR2(18) | YES | ||
TOTAL_ROWS | NUMBER(5, 0) | YES | ||
OBJECT_NAME | VARCHAR2(128) | YES | ||
OBJECT_TYPE | VARCHAR2(13) | YES | ||
OBJECT_STATUS | VARCHAR2(7) | YES |
DIFF Primary and Unique Keys |
Key Name | Key Type | Keys |
DIFF Foreign Keys |
Parent Relationships: |
Table Name | Type | Cardinality | Constraint Name | VerbPhrase | InversePhrase | Foreign Keys | Is Supertype | Deferrable | Initially Deferred |
Child Relationships: |
Table Name | Type | Cardinality | Constraint Name | VerbPhrase | InversePhrase | Foreign Keys | Is Subtype | Deferrable | Initially Deferred |