mart

Tables (6)

category (Untitled2)

  • category_id (Key) — INT(11) — Primary key — NOT NULL
  • category_name (Field)

order (Untitled4)

  • order_id (Key) — INT(11) — Primary key — NOT NULL
  • user_id (Key2) — VARCHAR(50) — Foreign key → user.user_id — NOT NULL
  • user_id (Field) — VARCHAR(50)
  • order_date (Field2) — DATE
  • total_price (Field3) — INT(11)
  • order_state (Field4)

orderdetail (Untitled3)

  • orderdetail_id (Key) — INT(11) — Primary key — NOT NULL
  • product_id (Key2) — INT(11) — Foreign key → product.product_id — NOT NULL
  • category_id (Key22) — INT(11) — Foreign key → product.category_id — NOT NULL
  • order_id (Key3) — INT(11) — Foreign key → order.order_id — NOT NULL
  • user_id (Key23) — VARCHAR(50) — Foreign key → order.user_id — NOT NULL
  • order_id (Field) — INT(11)
  • product_name (Field2) — VARCHAR(45)
  • count INT (Field3) — INT(11)
  • orderdetail_price (Field4) — INT(11)

product (Untitled)

  • product_id (Key) — INT(11) — Primary key — NOT NULL
  • category_id (Key2) — INT(11) — Foreign key → category.category_id — NOT NULL
  • product_name (Field) — VARCHAR(45)
  • product_price (Field2) — INT(11)
  • img_path (Field3) — VARCHAR(255)
  • category (Field4)

product (Untitled6)

  • product_id (Key) — Primary key — NOT NULL
  • Field

user (Untitled5)

  • user_id (Key) — VARCHAR(50) — Primary key — NOT NULL
  • user_pw (Field) — VARCHAR(5)
  • user_name (Field2) — VARCHAR(45)
  • address (Field3) — VARCHAR(100)
  • phone (Field4) — VARCHAR(45)
  • tel (Field5)