20233003
Tables (6)
Customer
- Id — int — Primary key — NOT NULL
- Lastname — nchar(30)
- Firstname (FirstName) — nchar(30)
- Country — nchar(30)
- Field (tel) — char(15)
- Field (detail_addr) — nchar(30)
- Key (Zipcode) — char(5) — Foreign key → Untitled.Key — NOT NULL
Untitled (Product)
- Key (Id) — int — Primary key — NOT NULL
- Field (productName) — char(30)
- Field (unitprice) — int
- Key (supplierid) — int — Foreign key → Untitled.Key — NOT NULL
Untitled (OrderItem)
- Key (Id) — int — Primary key — NOT NULL
- Field (Quantity) — int
- Key (productId) — int — Foreign key → Untitled.Key — NOT NULL
- Id (orderId) — int — Foreign key → _Order.Id — NOT NULL
Untitled (Supplier)
- Key (Id) — int — Primary key — NOT NULL
- Field (tel) — char(15)
- Field2 (detail_addr) — nchar(30)
- Key (Zipcode) — char(5) — Foreign key → Untitled.Key — NOT NULL
Untitled (ADDR)
- Key (Zipcode) — char(5) — Primary key — NOT NULL
- Field (do) — nchar(10)
- Field (city) — nchar(10)
- Field (dong) — nchar(10)
_Order
- Id — int — Primary key — NOT NULL
- orderdate — datetime2
- TotalAmount — int
- Id (customerId) — int — Foreign key → Customer.Id — NOT NULL