on-01

Tables (9)

Cart (Untitled8)

  • cart_id (Key) — Primary key — NOT NULL
  • user_id (Key2) — Foreign key → User.user_id — NOT NULL
  • product_id (Key3) — Foreign key → Product.product_id — NOT NULL

Category (Untitled3)

  • category_id (Key) — Primary key — NOT NULL
  • cname (Field)

Chat (Untitled4)

  • chat_id (Key) — Primary key — NOT NULL
  • message (Field2)
  • user_id (Key2) — Foreign key → User.user_id — NOT NULL

Comment (Untitled7)

  • comment_id (Key) — Primary key — NOT NULL
  • Field
  • Field2
  • Field3

Notice (Untitled5)

  • notice_id (Key) — Primary key — NOT NULL
  • topic (Field)
  • content (Field2)

Order (Untitled2)

  • order_id (Key) — Primary key — NOT NULL
  • order_date (Field2)
  • total_price (Field3)
  • progress (Field)
  • user_id (Key2) — Foreign key → User.user_id — NOT NULL

Orderdetail (Untitled6)

  • order_detail_id (Key) — Primary key — NOT NULL
  • order_id (Key2) — Foreign key → Order.order_id — NOT NULL
  • product_id (Key3) — Foreign key → Product.product_id — NOT NULL

Product (Untitled)

  • product_id (Key) — Primary key — NOT NULL
  • pname (Field)
  • pdescription (Field2)
  • pdiscount (Field3)
  • pprice (Field4)
  • pcategory (Field5)
  • powner (Field6)
  • pcomment (Field7)
  • category_id (Key2) — Foreign key → Category.category_id — NOT NULL

User (회원정보)

  • user_id (Key) — Primary key — NOT NULL
  • username (Field)
  • password (Field2)
  • address (Field3)
  • number (Field4)
  • email (Field5)
  • usertype (Field6)
  • create_date (Field7)
  • notice_id (Key2) — Foreign key → Notice.notice_id — NOT NULL