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

Product_user (Untitled5)

    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