Table
Tables (5)
Cart (Untitled3)
- Cart_ID (Key) — Long — Primary key — NOT NULL
- UserID (Key2) — Long — Foreign key → User.UserID — NOT NULL
- OrderTime (Field) — datetime
- Delivery (Field2) — Boolean
- OrderStatus (Field3) — String
Cart_Item (Untitled2)
- CartItem_ID (Key) — Long — Primary key — NOT NULL
- Product_Num (Field) — String
- Order_Count (Field2) — Int
- Cart_ID (Key2) — Long — Foreign key → Cart.Cart_ID — NOT NULL
- Product_ID (Key3) — Long — Foreign key → Product.Product_ID — NOT NULL
- IsChecked? (Field3) — Boolean
Product (Untitled)
- Product_ID (Key) — Long — Primary key — NOT NULL
- Product_Num (Field) — Int
- ProductName (Field2) — String
- Stock_Count (Field4) — Int
- Image (Field6) — String(?)
- IsSoldOut? (Field5) — Boolean
- IsEnd? (Field9) — Boolean
- Price (Field7) — Int
- Product_Explanation (Field8) — String
- UserName(seller) (Field3) — String
- DeliveryPrice (Field10) — Int
User (Untitled4)
- UserID (Key) — Primary key — NOT NULL
- UserName (Field) — String
- PassWord (Field2) — String
- Email (Field3) — String
- Phone_Number (Field4) — Int
- Role (Field5) — String\
- Address (Field6) — String
- Grade (Field7) — String