S_CHILD_PARENT |
Default Table Name | S_CHILD_PARENT |
Definition |
S_CHILD_PARENT Attributes |
Attribute/Logical Rolename | Domain | Datatype | NULL | Definition |
ENTRY_TYPE | VARCHAR(2) | YES | ||
CON_STRAINT | VARCHAR(30) | YES | ||
CHILD_NAME | VARCHAR(30) | YES | ||
CHILD_COLUMN | VARCHAR(30) | YES | ||
COL_TYPE | VARCHAR(30) | YES | ||
PARENT_NAME | VARCHAR(30) | YES | ||
PARENT_COLUMN | VARCHAR(30) | YES | ||
SEQ_NO | NUMERIC(5, 0) | YES | ||
DELETE_RULE | VARCHAR(1) | YES | ||
COMMENTS | VARCHAR(254) | YES |
S_CHILD_PARENT Keys |
Key Name | Key Type | Keys |
SI_1123 | Inversion Entry | CON_STRAINT, CHILD_NAME, PARENT_NAME, SEQ_NO |
S_CHILD_PARENT Relationships |
Parent Relationships: |
Entity Name | Type | Cardinality | Business Name | VerbPhrase | InversePhrase | Foreign Keys | Is Supertype |
Child Relationships: |
Entity Name | Type | Cardinality | Business Name | VerbPhrase | InversePhrase | Foreign Keys | Is Subtype |