test
Tables (4)
OrderDetails (주문상세내역)
- OrderDetailID (Key) — Primary key — NOT NULL
- OrderID (Key2) — Foreign key → Orders.OrderID — NOT NULL
- CustomerID (Key22) — Foreign key → Orders.CustomerID — NOT NULL
- Key (Key3) — Foreign key → Products.ProductID — NOT NULL
- Quantity (Field)
- Subtotal (Field2)
Orders (주문)
- OrderID (Key) — Primary key — NOT NULL
- CustomerID (Key2) — Foreign key → customers.CustomerID — NOT NULL
- OrderDate (Field)
- TotalAmount (Field2)
Products (상품)
- ProductID (Key) — Primary key — NOT NULL
- Name (Field2)
- Price (Field3)
- Stock (Field4)
customers (고객)
- CustomerID (Key) — Primary key — NOT NULL
- Name (Field)
- Email (Field2)
- Phone (Field3)