Full Stack Web-Project

Tables (13)

answer

  • id — int — Primary key — NOT NULL
  • content — tinytext — NOT NULL
  • create_date — datetime(6)
  • inquiry_id — int — Foreign key → inquiry.id
  • member_id — int — Foreign key → member.id

board

  • id — int — Primary key — NOT NULL
  • board_type — enum('AD','BOARD','NOTICE')
  • content — tinytext — NOT NULL
  • create_date — datetime(6)
  • title — varchar(255) — NOT NULL
  • memberid — int — Foreign key → member.id

cart

  • id — int — Primary key — NOT NULL
  • memberid — int — Foreign key → member.id — NOT NULL

discount

  • id — int — Primary key — NOT NULL
  • expire_at — datetime(6)
  • rate — double — NOT NULL
  • start_at — datetime(6)
  • discount_name — varchar(255) — NOT NULL

favorite

  • id — int — Primary key — NOT NULL
  • discountid — int — Foreign key → discount.id
  • productid — int — Foreign key → product.id
  • memberid — int — Foreign key → member.id — NOT NULL

imagefile

  • id — bigint — Primary key — NOT NULL
  • file_name — varchar(255)
  • file_path — varchar(255)
  • upload_at — datetime(6)
  • url — varchar(255)
  • uuid — varchar(255)

inquiry

  • id — int — Primary key — NOT NULL
  • content — varchar(255) — NOT NULL
  • create_date — datetime(6)
  • title — varchar(255) — NOT NULL
  • answer_id — int — Foreign key → answer.id
  • memberid — int — Foreign key → member.id

member

  • id — int — Primary key — NOT NULL
  • create_date — datetime(6)
  • email — varchar(255) — NOT NULL
  • first_name — varchar(100)
  • last_name — varchar(100)
  • oauth — enum('BOARD','GOOGLE','KAKAO')
  • password — varchar(255) — NOT NULL
  • role — enum('ADMIN','USER')
  • username — varchar(255) — NOT NULL

notice

  • id — int — Primary key — NOT NULL
  • content — varchar(255) — NOT NULL
  • create_date — datetime(6)
  • title — varchar(255) — NOT NULL
  • member_id — int — Foreign key → member.id

product

  • id — int — Primary key — NOT NULL
  • category — longtext
  • price — varchar(255) — NOT NULL
  • product_name — varchar(255) — NOT NULL
  • discountid — int — Foreign key → discount.id
  • product_detail_id — int — Foreign key → product_detail.id
  • content — longtext
  • image_url — varchar(255)
  • favoriteid — int — Foreign key → favorite.id
  • cartid — int — Foreign key → cart.id

product_detail

  • id — int — Primary key — NOT NULL
  • content — varchar(255)
  • product_id — int — Foreign key → product.id

purchase

  • id — int — Primary key — NOT NULL
  • method — enum('CARD','CASH')
  • status — enum('FINISHED','PENDING')
  • time — datetime(6)
  • total_amount — int — NOT NULL
  • member_id — int — Foreign key → member.id
  • payment_info — varchar(255) — NOT NULL

reply

  • id — int — Primary key — NOT NULL
  • content — tinytext — NOT NULL
  • boardid — int — Foreign key → board.id
  • member_id — int — Foreign key → member.id