ㅇ

Tables (12)

board

  • board_id — bigint — Primary key — NOT NULL
  • title — varchar(50) — NOT NULL
  • nickname — varchar(255) — NOT NULL
  • content — TEXT — NOT NULL
  • hashtag — varchar(100)
  • comment_count — int — NOT NULL
  • view_count — int
  • like_count — int
  • view_contain — varbinary(50)
  • like_contain — varbinary(50)
  • created_at — TIMESTAMP
  • category_id — varchar(20)
  • user_id — bigint — Foreign key → user.user_id — NOT NULL

cart

  • cart_id — bigint — Primary key — NOT NULL
  • user_id — bigint — Foreign key → user.user_id — NOT NULL

cart_item

  • cart_item_id — bigint — Primary key — NOT NULL
  • quantity — int
  • price — decimal
  • cart_id — bigint — Foreign key → cart.cart_id — NOT NULL
  • product_id — bigint — Foreign key → product.product_id — NOT NULL

categories

  • category_id — bigint — Primary key — NOT NULL
  • category_name — varchar(50) — NOT NULL

comment

  • comment_id — bigint — Primary key — NOT NULL
  • nickname — varchar(255) — NOT NULL
  • content — varchar(255) — NOT NULL
  • like_count — int — NOT NULL
  • like_contain — varbinary(50)
  • reply_contain — varbinary(50)
  • created_at — TIMESTAMP
  • board_id — bigint — Foreign key → board.board_id — NOT NULL
  • user_id — bigint — Foreign key → user.user_id — NOT NULL

delivery

  • delivery_id — bigint — Primary key — NOT NULL
  • purchase_id — bigint — Foreign key → purchase.purchase_id — NOT NULL
  • delivery_state — varchar(10) — NOT NULL
  • receiver_name — varchar(20) — NOT NULL
  • receiver_phone — varchar(20) — NOT NULL
  • receiver_addr — varchar(100) — NOT NULL
  • delivery_msg — varchar(200) — NOT NULL

product

  • product_id — bigint — Primary key — NOT NULL
  • product_name — varchar(255) — NOT NULL
  • content — TEXT
  • description — TEXT
  • price — DECIMAL(10, 2) — NOT NULL
  • image_url — varchar(500)
  • average_rating — DECIMAL(10, 2)
  • subcategory_id — bigint — Foreign key → subcategories.subcategory_id — NOT NULL
  • category_id — bigint — Foreign key → categories.category_id — NOT NULL

purchase

  • purchase_id — bigint — Primary key — NOT NULL
  • created_at — datetime
  • purchase_state — varchar(255)
  • user_id — bigint — Foreign key → user.user_id — NOT NULL

purchase_products

  • purchase_product_id — bigint — Primary key — NOT NULL
  • purchase_id — bigint — Foreign key → purchase.purchase_id — NOT NULL
  • product_id — bigint — Foreign key → product.product_id — NOT NULL
  • price — decimal(10, 2)
  • quantity — int
  • option — varchar(100)
  • review_state — varchar(5)

reviews

  • review_id — bigint — Primary key — NOT NULL
  • rating — DECIMAL(2, 1) — NOT NULL
  • comment — TEXT
  • created_at — TIMESTAMP
  • user_id — bigint — Foreign key → user.user_id — NOT NULL
  • product_id — bigint — Foreign key → product.product_id — NOT NULL

subcategories

  • subcategory_id — bigint — Primary key — NOT NULL
  • subcategory_name — varchar(50) — NOT NULL
  • description — TEXT
  • category_id (category_id2) — bigint — Foreign key → categories.category_id — NOT NULL

user

  • user_id — bigint — Primary key — NOT NULL
  • userid — varchar(255) — NOT NULL
  • nickname — varchar(255) — NOT NULL
  • email — varchar(255) — NOT NULL
  • password — varchar(60) — NOT NULL
  • role — varchar(255) — NOT NULL
  • address — varchar(255)
  • question — varchar(255)
  • answer — varchar(255)
  • created_at — DATETIME