ER Diagram


erDiagram   
Contract ||--|{ ContractSchedule : "per period"
Contract}o..||ContractType: "is of"
Contract||--o{Item: "for"
Item||--o{ItemCategory: "of"
Item||..o{ItemAttribute :"grading factors"
ItemAttribute||..o{ItemAttrMassAdjustTable :"default table"
ContractType||--o{ContractTypeElement : "default set"
ContractSchedule||--o{LoadAllocation:"is allocated to"
ContractSchedule}o..||VariantAdjustTable: "grade discounts"
ContractSchedule}o..||AttrMassAdjustTable: "mass adjustments"
ContractSchedule}o..||AttrValueAdjustTable: "mass adjustments"
ContractSchedule}o..||FuturesContract:"default Contract"
ContractSchedule||..o{ContractSchedSpread:"is spread"
ContractSchedule||..o{ContractSchedPrice: "commodity hedge"
ContractSchedule||..o{ContractSchedBasis : "bases calculation"
ContractSchedule||--o{Loaction: "delivery point"
ContractSchedule}o--||Season: "Growing Season"
ContractSchedSpread}o..||FutureSpread: "Spread"
Season}o--||ItemCategory: "Is for"
ContractSchedBasis}o--|{BasisElement: "of type"
ContractSchedPrice}o--||FuturesTrade: "allocated to"
FuturesTrade}o..|{FutureSpread: "Buy and Sell"
FuturesTrade}o..|{FuturesContract: "of type"
FuturesTrade}o..|{FuturesExchangeDealer: "executed by"
FuturesTrade}o..|{FuturesExchange: "executed by"
FuturesTrade}o..|{BankFinanceAllocation: "allocated to"
BankFinanceAllocation}o..|{BankFinance: "financed in"
FuturesExchangeDealer}o..|{FuturesExchange: "registered on"
FuturesExchange||--o{FuturesInstrument:"Listed on"
FutureSpread}|..|{FuturesContract:"Spredding contacts"
LoadAllocation}|--||Load:"is allocated to"
Load||..o{LoadingInstAllocation:"is allocated to"
LoadingInstAllocation}o--||LoadingInstruction: "is allocated to"
LoadAllocation||..o{LoadAllocatonAttPremium: "has premiums"
Load||..o{LoadAttribiteValue: "grading"
FuturesContract}o..||FuturesInstrument : "Is of type"
AttrMassAdjustTable||--o{AttrMassAdjustMatrix: "value matrix"
AttrValueAdjustTable||--o{AttrValueAdjustMatrix: "value matrix"
VariantAdjustTable||--o{VariantAdjustMatrix: "value matrix"