I have two tables
loadingDetail | stowageDetail [PK] loadingID (int) | [PK] StowageID (int) [PK] transactionID (in) | [PK] room (int) | [UNIQUE] transactionID (int)
loadingDetailcan be duplicated when the
loadingIDvalue is different.
loadingDetailcan have only one
loadingDetailcan be deleted when there is no
How I can represent that in a database diagram?
I'm really looking for a database-diagram possible answer. But I tried to find something about many-to-one relationships in database diagrams and it seems can't find it. The relationship is like many Containers put inside Big Box. The Containers just can removed if the Big Box is already removed. The supported database diagram "I know" is one-to-many which in my condition does not fit because the Box is removed the first, then Containers the second.