composite relationship

A composite relationship is a relationship between two geodatabaseA geodatabase is a spatial data storage format that can contain multiple datasets of geographic features and non-spatial tabular data, as well as attachments, field domain definitions, and relationships between layers/tables.Learn more tables in which each feature in the destination tableA destination table is a table that has been associated with an origin table using a key.Learn more is expected to be related to an origin featureAn origin feature is a feature in an origin table that is associated with a destination feature in a destination table.Learn more. In other words, any orphan destination features are considered a violation of the relationship. For example, a building and its mailbox must be related. While the building (origin) can exist on its own, a mailbox (destination) must be related to a building. When an origin feature is deleted, the destination feature should also be deleted. This is known as a cascade delete. Also see simple relationshipA simple relationship is a relationship between two tables in which features in the destination table are independent of features in the origin table.Learn more.