쇼핑몰

테이블 (4)

Product

  • product_id — bigint — 기본 키 — NOT NULL
  • product_name — varchar(50) — NOT NULL
  • product_price — VARCHAR(255)
  • product_description — varchar(200) — NOT NULL
  • product_image — varchar(600) — NOT NULL
  • product_disply_yn — enum('Y','N') — NOT NULL
  • created_at — TIMESTAMP
  • modified_at — TIMESTAMP
  • pd_category_id — bigint — 외래 키 → Product_category.pd_category_id — NOT NULL

Product_category

  • pd_category_id — bigint — 기본 키 — NOT NULL
  • pd_category_name — varchar(20) — NOT NULL
  • pd_category_parent_id — bigint — 부모의 카테고리 번호. 생략 할지고민중

order

  • order_id — bigint — 기본 키 — NOT NULL
  • user_id — bigint — NOT NULL
  • order_payment_yn — enum — NOT NULL — Y = 결재O , N = 결재 X
  • order_cancel_yn — enum — NOT NULL — Y = 주문 O , N = 주문 취소
  • order_zipcode — varchar(7) — NOT NULL
  • order_address — varchar30) — NOT NULL
  • order_address_info — varchar(30) — NOT NULL
  • order_phonenumber — int — NOT NULL
  • order_requirement — varchar(100)
  • created_at — TIMESTAMP
  • modified_at — TIMESTAMP

user

  • user_id — bigint — 기본 키 — NOT NULL
  • user_role — int — NOT NULL — user=0, admin = 1
  • user_name — varchar(15) — NOT NULL
  • user_nickname — varchar(15)
  • user_email — varchar(30)
  • user_password — varchar — 비밀번호 타입은 알고리즘에 따라 변경
  • user_phonenumber — int — 휴대폰 입력시 - 제외 입력
  • created_at — TIMESTAMP
  • modified_at — TIMESTAMP