erDiagram
orders ||--o{ shiporder : "shiporder*"
orders {
string batch_id
int version
}
shiporder ||--|| orderperson : "orderperson"
shiporder ||--o| orderperson : "shipto"
shiporder ||--|{ item : "item*"
shiporder {
string orderid
dateTime processed_at
}
item ||--o{ intfeature : "product_features_intfeature*"
item ||--o{ stringfeature : "product_features_stringfeature*"
item {
string product_name
string product_version
string note
integer quantity
decimal price
string currency
}
stringfeature {
string id
string value
}
intfeature {
string id
integer value
}
orderperson {
string name_attr
string name
string address
string city
string zip_codingSystem
string zip_state
string zip_value
string country
string-N phoneNumber
string companyId_type
string companyId_value
string coordinates
}