Relationship Parent to Child Rule | Relationship Parent to Child Phrase | Relationship Child to Parent Phrase | Relationship Type | Relationship Child to Parent Rule | Relationship Parent Entity Name | Relationship Parent Entity Primary Key Attribute Name | Relationship Parent Table Name | Relationship Child Table Name | Relationship Child Table Primary Key Column Name |
---|---|---|---|---|---|---|---|---|---|
A PARTY may be acting as many PARTY ROLEs. | may be acting as | must be for | Identifying | A PARTY ROLE must be for exactly one PARTY. | PARTY | PARTY ID | PARTY | PARTY_ROLE | PARTY_ID |
A PARTY may be acting as many PARTY ROLEs. | may be acting as | must be for | Identifying | A PARTY ROLE must be for exactly one PARTY. | PARTY_ROLE | ROLE_TYPE_ID | |||
A PARTY RELATIONSHIP TYPE may be the description for many PARTY RELATIONSHIPs. | may be the description for | must be described by | Non-identifying | A PARTY RELATIONSHIP must be described by exactly one PARTY RELATIONSHIP TYPE. | PARTY RELATIONSHIP TYPE | PARTY RELATIONSHIP TYPE ID | PARTY_RELATIONSHIP_TYPE | PARTY_RELATIONSHIP | PARTY_ID_FROM |
A PARTY RELATIONSHIP TYPE may be the description for many PARTY RELATIONSHIPs. | may be the description for | must be described by | Non-identifying | A PARTY RELATIONSHIP must be described by exactly one PARTY RELATIONSHIP TYPE. | PARTY_RELATIONSHIP | PARTY_ID_TO | |||
A PARTY RELATIONSHIP TYPE may be the description for many PARTY RELATIONSHIPs. | may be the description for | must be described by | Non-identifying | A PARTY RELATIONSHIP must be described by exactly one PARTY RELATIONSHIP TYPE. | PARTY_RELATIONSHIP | FROM_DATE | |||
A PARTY RELATIONSHIP TYPE may be the description for many PARTY RELATIONSHIPs. | may be the description for | must be described by | Non-identifying | A PARTY RELATIONSHIP must be described by exactly one PARTY RELATIONSHIP TYPE. | PARTY_RELATIONSHIP | ROLE_TYPE_ID_TO | |||
A PARTY RELATIONSHIP TYPE may be the description for many PARTY RELATIONSHIPs. | may be the description for | must be described by | Non-identifying | A PARTY RELATIONSHIP must be described by exactly one PARTY RELATIONSHIP TYPE. | PARTY_RELATIONSHIP | ROLE_TYPE_ID_FROM | |||
A PARTY ROLE may be involved in many PARTY RELATIONSHIPs. | may be involved in | must be established from | Identifying | A PARTY RELATIONSHIP must be established from exactly one PARTY ROLE. | PARTY ROLE | PARTY ID | PARTY_ROLE | PARTY_RELATIONSHIP | PARTY_ID_FROM |
A PARTY ROLE may be involved in many PARTY RELATIONSHIPs. | may be involved in | must be established from | Identifying | A PARTY RELATIONSHIP must be established from exactly one PARTY ROLE. | PARTY ROLE | ROLE TYPE ID | PARTY_RELATIONSHIP | PARTY_ID_TO | |
A PARTY ROLE may be involved in many PARTY RELATIONSHIPs. | may be involved in | must be established from | Identifying | A PARTY RELATIONSHIP must be established from exactly one PARTY ROLE. | PARTY_RELATIONSHIP | FROM_DATE | |||
A PARTY ROLE may be involved in many PARTY RELATIONSHIPs. | may be involved in | must be established from | Identifying | A PARTY RELATIONSHIP must be established from exactly one PARTY ROLE. | PARTY_RELATIONSHIP | ROLE_TYPE_ID_TO | |||
A PARTY ROLE may be involved in many PARTY RELATIONSHIPs. | may be involved in | must be established from | Identifying | A PARTY RELATIONSHIP must be established from exactly one PARTY ROLE. | PARTY_RELATIONSHIP | ROLE_TYPE_ID_FROM | |||
A PARTY ROLE may be involved in many PARTY RELATIONSHIPs. | may be involved in | must be established to | Identifying | A PARTY RELATIONSHIP must be established to exactly one PARTY ROLE. | PARTY ROLE | PARTY ID | PARTY_ROLE | PARTY_RELATIONSHIP | PARTY_ID_FROM |
A PARTY ROLE may be involved in many PARTY RELATIONSHIPs. | may be involved in | must be established to | Identifying | A PARTY RELATIONSHIP must be established to exactly one PARTY ROLE. | PARTY ROLE | ROLE TYPE ID | PARTY_RELATIONSHIP | PARTY_ID_TO | |
A PARTY ROLE may be involved in many PARTY RELATIONSHIPs. | may be involved in | must be established to | Identifying | A PARTY RELATIONSHIP must be established to exactly one PARTY ROLE. | PARTY_RELATIONSHIP | FROM_DATE | |||
A PARTY ROLE may be involved in many PARTY RELATIONSHIPs. | may be involved in | must be established to | Identifying | A PARTY RELATIONSHIP must be established to exactly one PARTY ROLE. | PARTY_RELATIONSHIP | ROLE_TYPE_ID_TO | |||
A PARTY ROLE may be involved in many PARTY RELATIONSHIPs. | may be involved in | must be established to | Identifying | A PARTY RELATIONSHIP must be established to exactly one PARTY ROLE. | PARTY_RELATIONSHIP | ROLE_TYPE_ID_FROM | |||
A PARTY ROLE TYPE may be used to define many PARTY RELATIONSHIP TYPEs. | may be used to define | may be from | Non-identifying | A PARTY RELATIONSHIP TYPE may be from zero or one PARTY ROLE TYPEs. | PARTY ROLE TYPE | ROLE TYPE ID | PARTY_ROLE_TYPE | PARTY_RELATIONSHIP_TYPE | PARTY_RELATIONSHIP_TYPE_ID |
A PARTY ROLE TYPE may be the description for many PARTY ROLEs. | may be the description for | must be described by | Identifying | A PARTY ROLE must be described by exactly one PARTY ROLE TYPE. | PARTY ROLE TYPE | ROLE TYPE ID | PARTY_ROLE_TYPE | PARTY_ROLE | PARTY_ID |
A PARTY ROLE TYPE may be the description for many PARTY ROLEs. | may be the description for | must be described by | Identifying | A PARTY ROLE must be described by exactly one PARTY ROLE TYPE. | PARTY_ROLE | ROLE_TYPE_ID | |||
A PARTY ROLE TYPE may be used to define many PARTY RELATIONSHIP TYPEs. | may be used to define | may be to | Non-identifying | A PARTY RELATIONSHIP TYPE may be to zero or one PARTY ROLE TYPEs. | PARTY ROLE TYPE | ROLE TYPE ID | PARTY_ROLE_TYPE | PARTY_RELATIONSHIP_TYPE | PARTY_RELATIONSHIP_TYPE_ID |