"MATL_STAT to CMPNT_MATL" |
RelationshipType | Non-Identifying |
Do Not Generate | False |
Relationship Name | FK_CM_TO_MATL_STAT |
Relationship Business Name | |
Physical Only | No |
Parent Table | MATL_STAT |
Child Table | CMPNT_MATL |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
Deferrable | NO |
Initially Deferred | NO |
Disabled | NO |
NoValidate | NO |
"MATL_STAT to CMPNT_MATL" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"MATL_STAT to CMPNT_MATL" Foreign Keys |
Parent Key | Child Key |
MATL_STAT_ID | MATL_STAT_ID |
"MATL_STAT to CMPNT_MATL" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"MATL_STAT to CMPNT_MATL" Bound Attachments |
Name | Current Value |
"MATL_TYPE to CMPNT_MATL" |
RelationshipType | Non-Identifying |
Do Not Generate | False |
Relationship Name | FK_CM_TO_MATL_TYPE |
Relationship Business Name | |
Physical Only | No |
Parent Table | MATL_TYPE |
Child Table | CMPNT_MATL |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
Deferrable | NO |
Initially Deferred | NO |
Disabled | NO |
NoValidate | NO |
"MATL_TYPE to CMPNT_MATL" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"MATL_TYPE to CMPNT_MATL" Foreign Keys |
Parent Key | Child Key |
MATL_TYPE_ID | MATL_TYPE_ID |
"MATL_TYPE to CMPNT_MATL" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"MATL_TYPE to CMPNT_MATL" Bound Attachments |
Name | Current Value |
"CMPNT_MATL to CMPNT" |
RelationshipType | Non-Identifying |
Do Not Generate | False |
Relationship Name | FK_CMPNT_TO_CMPNT_MATL |
Relationship Business Name | |
Physical Only | No |
Parent Table | CMPNT_MATL |
Child Table | CMPNT |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
Deferrable | NO |
Initially Deferred | NO |
Disabled | NO |
NoValidate | NO |
"CMPNT_MATL to CMPNT" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"CMPNT_MATL to CMPNT" Foreign Keys |
Parent Key | Child Key |
MATL_ID | MATL_ID |
"CMPNT_MATL to CMPNT" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"CMPNT_MATL to CMPNT" Bound Attachments |
Name | Current Value |
"CMPNT_STAT to CMPNT" |
RelationshipType | Non-Identifying |
Do Not Generate | False |
Relationship Name | FK_CMPNT_TO_CMPNT_STAT |
Relationship Business Name | |
Physical Only | No |
Parent Table | CMPNT_STAT |
Child Table | CMPNT |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
Deferrable | NO |
Initially Deferred | NO |
Disabled | NO |
NoValidate | NO |
"CMPNT_STAT to CMPNT" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"CMPNT_STAT to CMPNT" Foreign Keys |
Parent Key | Child Key |
CMPNT_STAT_ID | CMPNT_STAT_ID |
"CMPNT_STAT to CMPNT" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"CMPNT_STAT to CMPNT" Bound Attachments |
Name | Current Value |
"CMPNT_TYPE to CMPNT" |
RelationshipType | Non-Identifying |
Do Not Generate | False |
Relationship Name | FK_CMPNT_TO_CMPNT_TYPE |
Relationship Business Name | |
Physical Only | No |
Parent Table | CMPNT_TYPE |
Child Table | CMPNT |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
Deferrable | NO |
Initially Deferred | NO |
Disabled | NO |
NoValidate | NO |
"CMPNT_TYPE to CMPNT" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"CMPNT_TYPE to CMPNT" Foreign Keys |
Parent Key | Child Key |
CMPNT_TYPE_ID | CMPNT_TYPE_ID |
"CMPNT_TYPE to CMPNT" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"CMPNT_TYPE to CMPNT" Bound Attachments |
Name | Current Value |
"MNFCTR to CMPNT" |
RelationshipType | Non-Identifying |
Do Not Generate | False |
Relationship Name | FK_CMPNT_TO_MNFCTR |
Relationship Business Name | |
Physical Only | No |
Parent Table | MNFCTR |
Child Table | CMPNT |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
Deferrable | NO |
Initially Deferred | NO |
Disabled | NO |
NoValidate | NO |
"MNFCTR to CMPNT" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"MNFCTR to CMPNT" Foreign Keys |
Parent Key | Child Key |
MNFCTR_ID | MNFCTR_ID |
"MNFCTR to CMPNT" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"MNFCTR to CMPNT" Bound Attachments |
Name | Current Value |
"DISTR_STAT to DISTR" |
RelationshipType | Non-Identifying |
Do Not Generate | False |
Relationship Name | FK_DISTR_TO_DISTR_STAT |
Relationship Business Name | |
Physical Only | No |
Parent Table | DISTR_STAT |
Child Table | DISTR |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
Deferrable | NO |
Initially Deferred | NO |
Disabled | NO |
NoValidate | NO |
"DISTR_STAT to DISTR" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"DISTR_STAT to DISTR" Foreign Keys |
Parent Key | Child Key |
DISTR_STAT_ID | DISTR_STAT_ID |
"DISTR_STAT to DISTR" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"DISTR_STAT to DISTR" Bound Attachments |
Name | Current Value |
"DISTR_TYPE to DISTR" |
RelationshipType | Non-Identifying |
Do Not Generate | False |
Relationship Name | FK_DISTR_TO_DISTR_TYPE |
Relationship Business Name | |
Physical Only | No |
Parent Table | DISTR_TYPE |
Child Table | DISTR |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
Deferrable | NO |
Initially Deferred | NO |
Disabled | NO |
NoValidate | NO |
"DISTR_TYPE to DISTR" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"DISTR_TYPE to DISTR" Foreign Keys |
Parent Key | Child Key |
DISTR_TYPE_ID | DISTR_TYPE_ID |
"DISTR_TYPE to DISTR" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"DISTR_TYPE to DISTR" Bound Attachments |
Name | Current Value |
"DISTR to MNFCTR_DISTR_ASSC" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | FK_MDA_TO_DISTR |
Relationship Business Name | |
Physical Only | No |
Parent Table | DISTR |
Child Table | MNFCTR_DISTR_ASSC |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
Deferrable | NO |
Initially Deferred | NO |
Disabled | NO |
NoValidate | NO |
"DISTR to MNFCTR_DISTR_ASSC" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"DISTR to MNFCTR_DISTR_ASSC" Foreign Keys |
Parent Key | Child Key |
DISTR_ID | DISTR_ID |
"DISTR to MNFCTR_DISTR_ASSC" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"DISTR to MNFCTR_DISTR_ASSC" Bound Attachments |
Name | Current Value |
"MNFCTR to MNFCTR_DISTR_ASSC" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | FK_MDA_TO_MNFCTR |
Relationship Business Name | |
Physical Only | No |
Parent Table | MNFCTR |
Child Table | MNFCTR_DISTR_ASSC |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
Deferrable | NO |
Initially Deferred | NO |
Disabled | NO |
NoValidate | NO |
"MNFCTR to MNFCTR_DISTR_ASSC" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"MNFCTR to MNFCTR_DISTR_ASSC" Foreign Keys |
Parent Key | Child Key |
MNFCTR_ID | MNFCTR_ID |
"MNFCTR to MNFCTR_DISTR_ASSC" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"MNFCTR to MNFCTR_DISTR_ASSC" Bound Attachments |
Name | Current Value |
"MNFCTR_STAT to MNFCTR" |
RelationshipType | Non-Identifying |
Do Not Generate | False |
Relationship Name | FK_MNFCTR_TO_MNFCTR_STAT |
Relationship Business Name | |
Physical Only | No |
Parent Table | MNFCTR_STAT |
Child Table | MNFCTR |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
Deferrable | NO |
Initially Deferred | NO |
Disabled | NO |
NoValidate | NO |
"MNFCTR_STAT to MNFCTR" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"MNFCTR_STAT to MNFCTR" Foreign Keys |
Parent Key | Child Key |
MNFCTR_STAT_ID | MNFCTR_STAT_ID |
"MNFCTR_STAT to MNFCTR" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"MNFCTR_STAT to MNFCTR" Bound Attachments |
Name | Current Value |
"MNFCTR_TYPE to MNFCTR" |
RelationshipType | Non-Identifying |
Do Not Generate | False |
Relationship Name | FK_MNFCTR_TO_MNFCTR_TYPE |
Relationship Business Name | |
Physical Only | No |
Parent Table | MNFCTR_TYPE |
Child Table | MNFCTR |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
Deferrable | NO |
Initially Deferred | NO |
Disabled | NO |
NoValidate | NO |
"MNFCTR_TYPE to MNFCTR" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"MNFCTR_TYPE to MNFCTR" Foreign Keys |
Parent Key | Child Key |
MNFCTR_TYPE_ID | MNFCTR_TYPE_ID |
"MNFCTR_TYPE to MNFCTR" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"MNFCTR_TYPE to MNFCTR" Bound Attachments |
Name | Current Value |