Orderprocessing20251030
Tables (7)
Addr (Untitled7)
- zipcode (Key) — char(5) — Primary key — NOT NULL
- do (Field) — nchar(10)
- city (Field2) — nchar(10)
- dong (Field3)
Customer (Untitled)
- id (Key) — int — Primary key — NOT NULL
- Lastname (Field) — nchar(30)
- FirstName (Field2) — nchar(30)
- Country (Field3) — nchar(30)
- tel (Field4) — char(14)
- zipcode (Field10) — char(5)
- do (Field5)
- city (Field6)
- dong (Field7)
- detail_addr (Field9)
OrderItem (Untitled4)
- id (Key) — int — Primary key — NOT NULL
- quantity (Field) — int
- productid (Key2) — int — Foreign key → Product.id — NOT NULL
- orderid (Key3) — int — Foreign key → _order.id — NOT NULL
Product (Untitled3)
- id (Key) — int — Primary key — NOT NULL
- productName (Field) — char(30)
- unitproce (Field2) — int
- Field3
Supplier (Untitled5)
- id (Key) — int — Primary key — NOT NULL
- Field — char(14)
- Field2
Supplier (Untitled6)
- id (Key) — Primary key — NOT NULL
_order (Untitled2)
- id (Key) — int — Primary key — NOT NULL
- orderdate (Field) — datetime2
- TotalAmount (Field2) — int
- customerid (Key2) — int — Foreign key → Customer.id — NOT NULL