erd1

Tables (3)

order (주문)

  • order_id (Key) — int(11) — Primary key — NOT NULL
  • user_id (Key2) — varchar(55) — Foreign key → user.user_id — NOT NULL
  • product_id — int(11) — Foreign key → product.product_id — NOT NULL
  • order_date (Field2) — Date
  • sum_price (Field3) — int(11)
  • order_state (Field4) — varchar(20)

product (제품)

  • product_id — int(11) — Primary key — NOT NULL
  • product_name — varchar(55) — NOT NULL
  • product_price (Field) — int(11) — NOT NULL
  • category (Field2) — varchar(55)

user (회원)

  • user_id (Key) — varchar(55) — Primary key — NOT NULL
  • user_pw (Field) — varchar(55)
  • user_name (Field2) — varchar(55)
  • address (Field3) — varchar(100)
  • phone (Field4) — varchar(55)
  • homrtel (Field5) — varchar(55)