SHOP_ERD

Tables (17)

answer

  • answer_pk_num — INT
  • answer_content — TEXT — NOT NULL
  • answer_regdate — DATETIME — NOT NULL
  • answer_fk_question_num — INT — NOT NULL
  • answer_fk_user_num — INT — NOT NULL

brand

  • brand_pk_num — INT
  • brand_name — VARCHAR(20) — NOT NULL
  • brand_pic — VARCHAR(255)

cart

  • cart_pk_num — INT
  • cart_quantity — INT — NOT NULL
  • cart_fk_product_num — INT — NOT NULL
  • cart_fk_size_num — INT — NOT NULL
  • cart_fk_user_num — INT — NOT NULL

category

  • category_pk_num — INT
  • category_name — VARCHAR(255) — NOT NULL

coupon

  • coupon_pk_num — INT
  • coupon_code — VARCHAR(100) — NOT NULL
  • coupon_type — ENUM('percentage', 'fixed') — NOT NULL
  • coupon_value — INT — NOT NULL
  • coupon_start — DATE — NOT NULL
  • coupon_end — DATE — NOT NULL
  • coupon_minimum — INT

notice

  • notice_pk_num — INT
  • notice_title — VARCHAR(255) — NOT NULL
  • notice_content — TEXT
  • notice_regdate — DATETIME — NOT NULL
  • notice_import — TINYINT

order

  • order_pk_num — INT
  • order_date — DATETIME — NOT NULL
  • order_status — ENUM('결제대기', '배송준비중', '배송중', '배송완료') — NOT NULL
  • order_location — TEXT
  • order_totalprice — DOUBLE — NOT NULL
  • order_fk_user_num — INT — NOT NULL
  • order_fk_coupon_num — INT

orderhistory

  • orderhis_pk_num — INT
  • orderhis_quantity — INT — NOT NULL
  • orderhis_price — INT — NOT NULL
  • orderhis_review — TINYINT
  • orderhis_fk_product_num — INT — NOT NULL
  • orderhis_fk_size_num — INT — NOT NULL
  • orderhis_fk_order_num — INT — NOT NULL

product

  • product_pk_num — INT
  • product_name — VARCHAR(255) — NOT NULL
  • product_description — TEXT
  • product_price — INT — NOT NULL
  • product_stock — INT — NOT NULL
  • product_sale — INT
  • product_promotion — TINYINT
  • product_fk_brand_num — INT
  • product_fk_category_num — INT
  • product_fk_target_num — INT

productpic

  • propic_pk_num — INT
  • propic_path — VARCHAR(255) — NOT NULL
  • propic_fk_product_num — INT — NOT NULL

productsize

  • prosize_pk_num — INT
  • prosize_fk_size_num — INT — NOT NULL
  • prosize_fk_product_num — INT — NOT NULL

question

  • question_pk_num — INT
  • question_title — VARCHAR(255) — NOT NULL
  • question_content — TEXT — NOT NULL
  • question_regdate — DATETIME — NOT NULL
  • question_private — TINYINT
  • question_fk_user_num — INT — NOT NULL
  • question_fk_product_num — INT

review

  • review_pk_num — INT
  • review_content — TEXT
  • review_rating — ENUM('1', '2', '3', '4', '5')
  • review_date — DATETIME — NOT NULL
  • review_pic — VARCHAR(255)
  • review_fk_user_num — INT — NOT NULL
  • review_fk_product_num — INT — NOT NULL

size

  • size_pk_num — INT
  • size_value — VARCHAR(20) — NOT NULL

target

  • target_pk_num — INT
  • target_name — VARCHAR(10) — NOT NULL

user

  • user_pk_num — INT
  • user_id — VARCHAR(30) — NOT NULL
  • user_pw — VARCHAR(30) — NOT NULL
  • user_birth — DATE
  • user_addr — TEXT
  • user_name — VARCHAR(10) — NOT NULL
  • user_tel — VARCHAR(20)
  • user_mail — VARCHAR(50)
  • user_roll — VARCHAR(20)

usercoupon

  • usercoup_pk_num — INT
  • usercoup_fk_user_num — INT — NOT NULL
  • usercoup_fk_coupon_num — INT — NOT NULL
  • usercoup_possible — TINYINT