"Material Status to Component Material" |
RelationshipType | Non-Identifying |
Do Not Generate | False |
Relationship Name | fk_cm_to_matl_stat |
Relationship Business Name | |
Logical Only | No |
Parent Entity | Material Status |
Child Entity | Component Material |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
"Material Status to Component Material" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"Material Status to Component Material" Foreign Keys |
Parent Key | Child Key |
Material Status Identifier | Material Status Identifier |
"Material Status to Component Material" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"Material Status to Component Material" Bound Attachments |
Name | Current Value |
"Material Type to Component Material" |
RelationshipType | Non-Identifying |
Do Not Generate | False |
Relationship Name | fk_cm_to_matl_type |
Relationship Business Name | |
Logical Only | No |
Parent Entity | Material Type |
Child Entity | Component Material |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
"Material Type to Component Material" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"Material Type to Component Material" Foreign Keys |
Parent Key | Child Key |
Material Type Identifier | Material Type Identifier |
"Material Type to Component Material" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"Material Type to Component Material" Bound Attachments |
Name | Current Value |
"Component Material to Component" |
RelationshipType | Non-Identifying |
Do Not Generate | False |
Relationship Name | fk_cmpnt_to_cmpnt_matl |
Relationship Business Name | |
Logical Only | No |
Parent Entity | Component Material |
Child Entity | Component |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
"Component Material to Component" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"Component Material to Component" Foreign Keys |
Parent Key | Child Key |
Material Identifier | Material Identifier |
"Component Material to Component" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"Component Material to Component" Bound Attachments |
Name | Current Value |
"Component Status to Component" |
RelationshipType | Non-Identifying |
Do Not Generate | False |
Relationship Name | fk_cmpnt_to_cmpnt_stat |
Relationship Business Name | |
Logical Only | No |
Parent Entity | Component Status |
Child Entity | Component |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
"Component Status to Component" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"Component Status to Component" Foreign Keys |
Parent Key | Child Key |
Component Status Identifier | Component Status Identifier |
"Component Status to Component" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"Component Status to Component" Bound Attachments |
Name | Current Value |
"Component Type to Component" |
RelationshipType | Non-Identifying |
Do Not Generate | False |
Relationship Name | fk_cmpnt_to_cmpnt_type |
Relationship Business Name | |
Logical Only | No |
Parent Entity | Component Type |
Child Entity | Component |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
"Component Type to Component" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"Component Type to Component" Foreign Keys |
Parent Key | Child Key |
Component Type Identifier | Component Type Identifier |
"Component Type to Component" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"Component Type to Component" Bound Attachments |
Name | Current Value |
"BICS.Manufacturer to Component" |
RelationshipType | Non-Identifying |
Do Not Generate | False |
Relationship Name | fk_cmpnt_to_mnfctr |
Relationship Business Name | |
Logical Only | No |
Parent Entity | BICS.Manufacturer |
Child Entity | Component |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
"BICS.Manufacturer to Component" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"BICS.Manufacturer to Component" Foreign Keys |
Parent Key | Child Key |
Manufacturer Id | Manufacturer Id |
"BICS.Manufacturer to Component" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"BICS.Manufacturer to Component" Bound Attachments |
Name | Current Value |
"Distributor Status to Distributor" |
RelationshipType | Non-Identifying |
Do Not Generate | False |
Relationship Name | fk_distr_to_distr_stat |
Relationship Business Name | |
Logical Only | No |
Parent Entity | Distributor Status |
Child Entity | Distributor |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
"Distributor Status to Distributor" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"Distributor Status to Distributor" Foreign Keys |
Parent Key | Child Key |
Distributor Status Identifier | Distributor Status Identifier |
"Distributor Status to Distributor" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"Distributor Status to Distributor" Bound Attachments |
Name | Current Value |
"Distributor Type to Distributor" |
RelationshipType | Non-Identifying |
Do Not Generate | False |
Relationship Name | fk_distr_to_distr_type |
Relationship Business Name | |
Logical Only | No |
Parent Entity | Distributor Type |
Child Entity | Distributor |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
"Distributor Type to Distributor" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"Distributor Type to Distributor" Foreign Keys |
Parent Key | Child Key |
Distributor Type Identifier | Distributor Type Identifier |
"Distributor Type to Distributor" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"Distributor Type to Distributor" Bound Attachments |
Name | Current Value |
"Distributor to Manufacturer Distributor Association" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | fk_mda_to_distr |
Relationship Business Name | |
Logical Only | No |
Parent Entity | Distributor |
Child Entity | Manufacturer Distributor Association |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
"Distributor to Manufacturer Distributor Association" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"Distributor to Manufacturer Distributor Association" Foreign Keys |
Parent Key | Child Key |
Distributor Identifer | Distributor Identifer |
"Distributor to Manufacturer Distributor Association" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"Distributor to Manufacturer Distributor Association" Bound Attachments |
Name | Current Value |
"BICS.Manufacturer to Manufacturer Distributor Association" |
RelationshipType | Identifying |
Do Not Generate | False |
Relationship Name | fk_mda_to_mnfctr |
Relationship Business Name | |
Logical Only | No |
Parent Entity | BICS.Manufacturer |
Child Entity | Manufacturer Distributor Association |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
"BICS.Manufacturer to Manufacturer Distributor Association" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"BICS.Manufacturer to Manufacturer Distributor Association" Foreign Keys |
Parent Key | Child Key |
Manufacturer Id | Manufacturer Id |
"BICS.Manufacturer to Manufacturer Distributor Association" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"BICS.Manufacturer to Manufacturer Distributor Association" Bound Attachments |
Name | Current Value |
"Manufacturer Status to Manufacturer" |
RelationshipType | Non-Identifying |
Do Not Generate | False |
Relationship Name | fk_mnfctr_to_mnfctr_stat |
Relationship Business Name | |
Logical Only | No |
Parent Entity | Manufacturer Status |
Child Entity | Manufacturer |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
"Manufacturer Status to Manufacturer" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"Manufacturer Status to Manufacturer" Foreign Keys |
Parent Key | Child Key |
Manufacturer Status Identifier | Manufacturer Status Identifier |
"Manufacturer Status to Manufacturer" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"Manufacturer Status to Manufacturer" Bound Attachments |
Name | Current Value |
"Manufacturer Type to Manufacturer" |
RelationshipType | Non-Identifying |
Do Not Generate | False |
Relationship Name | fk_mnfctr_to_mnfctr_type |
Relationship Business Name | |
Logical Only | No |
Parent Entity | Manufacturer Type |
Child Entity | Manufacturer |
Cardinality | One To Zero or More |
Existence | Mandatory |
Propagated Key | Primary Key |
"Manufacturer Type to Manufacturer" Relationship Description |
Verb Sentence | |
Inverse Verb Sentence | |
Definition | |
Note |
"Manufacturer Type to Manufacturer" Foreign Keys |
Parent Key | Child Key |
Manufacturer Type Identifier | Manufacturer Type Identifier |
"Manufacturer Type to Manufacturer" Trigger Templates |
ParentInsert | None |
ParentUpdate | None |
ParentDelete | None |
ChildInsert | None |
ChildUpdate | None |
ChildDelete | None |
"Manufacturer Type to Manufacturer" Bound Attachments |
Name | Current Value |