|
|
|
```mermaid
|
|
|
|
erDiagram
|
|
|
|
CUSTOMER {
|
|
|
|
string name
|
|
|
|
string custNumber
|
|
|
|
string sector
|
|
|
|
}
|
|
|
|
ORDER {
|
|
|
|
int orderNumber
|
|
|
|
string deliveryAddress
|
|
|
|
}
|
|
|
|
LINE-ITEM {
|
|
|
|
string productCode
|
|
|
|
int quantity
|
|
|
|
float pricePerUnit
|
|
|
|
}
|
|
|
|
CUSTOMER ||--o{ ORDER : places
|
|
|
|
ORDER ||--|{ LINE-ITEM : contains
|
|
|
|
|
|
|
|
``` |
|
|
|
\ No newline at end of file |