CP_COMPANY |
Default Table Name | CP_COMPANY |
Definition |
CP_COMPANY Columns |
ColumnName | Domain | Datatype | NULL | Definition |
CP_COMPANY_CD![]() |
VARCHAR2(10) | NO | ||
CP_COMPANY_NAME | VARCHAR2(30) | NO | ||
ACTIVE_FL | VARCHAR2(1) | NO | ||
MODIFIED_BY | VARCHAR2(20) | NO | ||
ROWVERSION | NUMBER(10, 0) | NO | ||
TIME_STAMP | DATE | NO | ||
CP_COMPANY_LOGO_NAME_DIR_S | VARCHAR2(254) | YES |
CP_COMPANY Primary and Unique Keys |
Key Name | Key Type | Keys |
PI_0134 | PrimaryKey | CP_COMPANY_CD |
CP_COMPANY 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 |
LEAVE_TYPE | Non-Identifying | One To Zero or More | F00133 | NO | NO | NO | |||
UDT02 | Non-Identifying | One To Zero or More | F00134 | NO | NO | NO | |||
UDT04 | Non-Identifying | One To Zero or More | F00135 | NO | NO | NO | |||
UDT05 | Non-Identifying | One To Zero or More | F00136 | NO | NO | NO | |||
UDT06 | Identifying | One To Zero or More | F00137 | NO | NO | NO | |||
UDT07 | Identifying | One To Zero or More | F00138 | NO | NO | NO | |||
UDT09 | Non-Identifying | One To Zero or More | F00139 | NO | NO | NO | |||
EMPL_HISTORY | Non-Identifying | One To Zero or More | F00140 | NO | NO | NO | |||
TS | Non-Identifying | One To Zero or More | F00141 | NO | NO | NO | |||
EXP_RPT | Non-Identifying | One To Zero or More | F00203 | NO | NO | NO | |||
EXP_AUTH | Non-Identifying | One To Zero or More | F00347 | NO | NO | NO | |||
CORRECT_TS | Non-Identifying | One To Zero or More | F00555 | NO | NO | NO |