TestTable

Tables (5)

Category (Untitled5)

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

Order (Untitled2)

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

OrderDetail (Untitled3)

  • orderdetail_id (Key) — INT(11) — Primary key — NOT NULL
  • order_id (Key2) — INT(11) — Foreign key → Order.order_id — NOT NULL
  • product_id (Key3) — INT(11) — Foreign key → Product.product_id — NOT NULL
  • count (Field) — INT(11)
  • orderdetail_price (Field2) — INT(11)

Product (Untitled4)

  • product_id (Key) — INT(11) — Primary key — NOT NULL
  • category_id (Key2) — INT(11) — Foreign key → Category.category_id — NOT NULL

User (Untitled)

  • user_id (Key) — VARCHAR(255) — Primary key — NOT NULL
  • user_pw (Field) — VARCHAR(255)
  • user_name (Field2) — VARCHAR(30)
  • user_phone (Field3) — VARCHAR(20)