asd

테이블 (4)

제품

  • item_num — varchar(10) — 기본 키 — NOT NULL
  • item_name — varchar(20)
  • item_main_category — varchar(10)
  • item_sub_category — varchar(10)
  • item_price — Integer
  • item_stock — Integer
  • item_detail — Text
  • item_filename — varchar(20)

주문

  • Key — VARCHAR(255) — 기본 키 — NOT NULL
  • member_id — varchar(20) — NOT NULL

주소

  • address_num — Integer — 기본 키 — NOT NULL
  • address_address — varchar(50)
  • address_post — varchar(10)
  • address_detail — varchar(50)

회원

  • member_id — varchar(20) — 기본 키 — NOT NULL
  • member_pw — varchar(255)
  • member_name — varchar(30)
  • member_phone — varchar(20)
  • member_gender — varchar(10)
  • member_email — varchar(255)
  • member_role — varchar(255)
  • address_num — Integer — NOT NULL