SEC_GRP |
Default Table Name | SEC_GRP |
Definition |
SEC_GRP Columns |
ColumnName | Domain | Datatype | NULL | Definition |
SEC_GRP_CD![]() |
VARCHAR2(50) | NO | ||
SEC_GRP_NAME | VARCHAR2(80) | NO | ||
ISSUING_AGENCY | VARCHAR2(30) | YES | ||
EXPIRE_DT | DATE | YES | ||
COMPANY_ID | VARCHAR2(10) | YES | ||
MODIFIED_BY | VARCHAR2(20) | YES | ||
TIME_STAMP | DATE | YES | ||
ROWVERSION | NUMBER(10, 0) | YES | ||
SG_UDF_DESC_1 | VARCHAR2(30) | YES | ||
SG_UDF_DESC_2 | VARCHAR2(30) | YES | ||
SG_UDF_DESC_3 | VARCHAR2(30) | YES | ||
SG_UDF_DESC_4 | VARCHAR2(30) | YES | ||
SG_UDF_DESC_5 | VARCHAR2(30) | YES | ||
S_STATUS_CD | VARCHAR2(1) | NO | ||
ACTIVE_DT | DATE | YES | ||
DEACTIVE_DT | DATE | YES |
SEC_GRP Primary and Unique Keys |
Key Name | Key Type | Keys |
UI_SEC_GRP_IDX_01 | PrimaryKey | SEC_GRP_CD |
SEC_GRP 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 |
SEC_GRP_PART | Identifying | One To Zero or More | FK_SEC_GRP_PART_SE_IDX | NO | NO | NO | |||
SEC_GRP_PROJ | Identifying | One To Zero or More | FK_SEC_GRP_PROJ_SE_IDX | NO | NO | NO | |||
SEC_GRP_USER | Identifying | One To Zero or More | FK_SEC_GRP_USER_SE_IDX | NO | NO | NO |