ERD2024_01
Tables (5)
Untitled (Customer)
- Key (id) — int — Primary key — NOT NULL
- Field (Name) — NameType
- Field (Country) — NameType
Untitled (Supplier)
- Key (id) — int — Primary key — NOT NULL
- Field (CompanyName) — nvarchar(30)
- Field (zipcode) — char5)
- Field (Country) — nvarchar(30)
- Field (city) — nvarchar(30)
Untitled (Product)
- Key (id) — int — Primary key — NOT NULL
- Field (ProductName) — nvarchar(30)
- Key (SupplierId) — nvarchar(30) — Foreign key → Untitled.Key — NOT NULL
Untitled (OrderItem)
- Key (OrderId) — int — Foreign key → Untitled.Key — NOT NULL
- Key (ProductId) — int — Foreign key → Untitled.Key — NOT NULL
- Field (unitePrice) — float
- Field (quantify) — int
Untitled (_Order)
- Key (id) — int — Primary key — NOT NULL
- Field (TotalAmount) — int
- Key (CustomerId) — NameType — Foreign key → Untitled.Key — NOT NULL