[Question] How to add attributes to a tie?
simkimsia opened this issue · 0 comments
I see that the online demo modeler does not allow adding of attributes to a tie. https://www.anchormodeling.com/modeler/latest/
So I was wondering how to make sense of a typical OrderLineItem that takes in Product as FK, and Order as FK as well.
I foresee that the primary key of OrderLineItem will be using sequence_number and Order pk (OD_ID) as composite id.
but how to attach the attributes (such as quantity, unit price, subtotal, etc) of a OrderLineItem to it since it will be a tie?
Or the correct way of thinking is that there are actually 3 anchors: Order, LineItem, and Product?
then there are two ties: Order <=> LineItem, LineItem <=> Product
And therefore any attributes typically associated with OrderLineItem is under LineItem?