| name | stereotype | datatype | documentation |
| customerid | PK | NUMERIC(10,0) | Unique identifier, not visible for users. |
| Is referenced by: | OrderTotal.ordertotalid | ||
| firstname | NULL | VARCHAR(30) | The first name of the customer. |
| lastname | NULL | VARCHAR(50) | The Lastname of the customer. |
| company | NULL | VARCHAR(60) | The Company name if the customer is a company. |
| address | NOT NULL | VARCHAR(100) | The customer address. |
| city | NOT NULL | VARCHAR(50) | City |
| zipcode | NULL | VARCHAR(20) | Zipcode |
| state | NULL | VARCHAR(2) | State |
| country | NULL | VARCHAR(30) | Country |
| name | stereotype | datatype | documentation |
| orderlineid | PK | NUMERIC(10,0) | Unique identifier, not visible for users. |
| amount | NOT NULL | NUMERIC(5,0) | |
| price | NOT NULL | NUMERIC(9,2) | |
| productid | FK | NUMERIC(10,0) | |
| References: | Product.productid | ||
| ordertotalid | FK | NUMERIC(10,0) | |
| References: | OrderTotal.ordertotalid | ||
| name | stereotype | datatype | documentation |
| ordertotalid | PK | NUMERIC(10,0) | Unique identifier, not visible for users. |
| Is referenced by: | Orderline.orderlineid | ||
| totalprice | NOT NULL | NUMERIC(9,2) | The total price for this order: The sum of amount * price of each orderline. |
| orderdate | NOT NULL | DATETIME | |
| remarks | NULL | TEXT | |
| customerid | FK | NUMERIC(10,0) | The customer that placed this order. |
| References: | Customer.customerid | ||
| name | stereotype | datatype | documentation |
| productid | PK | NUMERIC(10,0) | Unique identifier, not visible for users. |
| Is referenced by: | Orderline.orderlineid | ||
| productname | NOT NULL | VARCHAR(100) | |
| description | NULL | TEXT | |
| price | NOT NULL | NUMERIC(9,2) | |