AltProject

Tables (6)

category

  • category_id — long — Primary key — NOT NULL
  • 카테고리이름 (category_name) — varchar

chatRoom

  • room_number — long — Primary key — NOT NULL
  • 판매자 (seller_id) — long — Foreign key → user.user_id — NOT NULL
  • 구매자 (buyer_id) — long — Foreign key → user.user_id — NOT NULL

like

  • like_id — long — Primary key — NOT NULL
  • user_id (id2) — long — Foreign key → user.user_id — NOT NULL
  • product_id — long — Foreign key → product.product_id — NOT NULL

order

  • order_id — long — Primary key — NOT NULL
  • 구매되는 제품 (buy_product) — long — Foreign key → product.product_id — NOT NULL
  • 제시하는 제품 (request_product) — long — Foreign key → product.product_id — NOT NULL

product

  • product_id — long — Primary key — NOT NULL
  • 제품이름 (product_name) — varchar
  • 제품상세정보 (product_detail) — varchar
  • 작성시간 (time) — localDateTime
  • 수정시간 (edit_time) — localDateTime
  • 좋아요수 (like_count) — long
  • category_id — long — Foreign key → category.category_id — NOT NULL
  • user_id (id) — long — Foreign key → user.user_id — NOT NULL

user

  • user_id (id) — long — Primary key — NOT NULL
  • 이메일 (email) — varchar — NOT NULL
  • 이름 (name) — varchar
  • 패스워드 (password) — varchar