OPP_CMPT |
Default Table Name | OPP_CMPT |
Definition |
OPP_CMPT Columns |
ColumnName | Domain | Datatype | NULL | Definition |
CMPT_ID![]() |
VARCHAR2(32) | NO | ||
CMPT_NAME | VARCHAR2(60) | NO | ||
RECORD_STATUS_CD | VARCHAR2(1) | NO | ||
CMPT_LOC | VARCHAR2(200) | YES | ||
INCUMB_FL | VARCHAR2(1) | NO | ||
LG_BUS_FL | VARCHAR2(1) | NO | ||
SM_BUS_FL | VARCHAR2(1) | NO | ||
COMMENTS | CLOB | YES | ||
STR_WEAK | CLOB | YES | ||
MODIFIED_BY | VARCHAR2(20) | NO | ||
TIME_STAMP | DATE | YES | ||
ROWVERSION | NUMBER(10, 0) | YES | ||
CL_DISADV_FL | VARCHAR2(1) | NO |
OPP_CMPT Primary and Unique Keys |
Key Name | Key Type | Keys |
PK_OPP_CMPT_IDX | PrimaryKey | CMPT_ID |
OPP_CMPT 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 |