테스트
테이블 (7)
Cart
- CartID — INT
- UserID — INT — NOT NULL
- ProductID — INT — NOT NULL
- Quantity — INT — NOT NULL
Category
- CategoryID — INT
- Name — VARCHAR(255) — NOT NULL
Order
- OrderID — INT
- UserID — INT — NOT NULL
- OrderDate — DATETIME — NOT NULL
- TotalAmount — DECIMAL(10, 2) — NOT NULL
- ShippingInfoID — INT
Product
- ProductID — INT
- Name — VARCHAR(255) — NOT NULL
- Price — DECIMAL(10, 2) — NOT NULL
- StockQuantity — INT — NOT NULL
- Description — TEXT
- CategoryID — INT
ShippingAddress
- ShippingAddressID — INT
- UserID — INT — NOT NULL
- Address — TEXT — NOT NULL
- Recipient — VARCHAR(255) — NOT NULL
- PhoneNumber — VARCHAR(20) — NOT NULL
ShippingInfo
- ShippingInfoID — INT
- ShippingAddressID — INT — NOT NULL
- Status — VARCHAR(50)
- TrackingNumber — VARCHAR(255)
User
- UserID — INT
- Name — VARCHAR(255) — NOT NULL
- Email — VARCHAR(255) — NOT NULL
- Password — VARCHAR(255) — NOT NULL
- PhoneNumber — VARCHAR(20)