CarrotMarket_DB

Tables (7)

chat_tb

  • id — BIGINT — Primary key — NOT NULL
  • 구매자 (buyer) — BIGINT — Foreign key → user_tb.id — NOT NULL
  • 판매자 (seller) — BIGINT — Foreign key → user_tb.id — NOT NULL
  • product_id — BIGINT — Foreign key → product_tb.id — NOT NULL
  • createAt — DATETIME
  • updateAt — DATETIME

product_category_tb

  • id — BIGINT — Primary key — NOT NULL
  • 세부 상품 유형 (product_type) — VARCHAR

product_image_tb

  • id — BIGINT — Primary key — NOT NULL
  • 상품 id (product_id) — BIGINT — Foreign key → product_tb.id — NOT NULL
  • createAt — DATETIME
  • updateAt — DATETIME
  • 경로 (image_path) — VARCHAR

product_tb

  • id — BIGINT — Primary key — NOT NULL
  • user.id (user_id) — BIGINT — Foreign key → user_tb.id — NOT NULL
  • 상품 유형 id (type_id) — BIGINT — Foreign key → product_category_tb.id — NOT NULL
  • createAt — DATETIME
  • updateAt — DATETIME
  • 제목 (title) — VARCHAR
  • 내용 (content) — VARCHAR
  • 좋아요 (interested) — INT
  • 조회수 (views) — INT
  • 판매 여부 (status) — VARCHAR

region_tb

  • id — BIGINT — Primary key — NOT NULL
  • user.id (user_id) — BIGINT — Foreign key → user_tb.id — NOT NULL
  • createAt — DATETIME
  • updateAt — DATETIME
  • 동네 이름 (region_name) — VARCHAR
  • 동네 인증 여부 (auth) — BOOLEAN

user_image_tb

  • id — BIGINT — Primary key — NOT NULL
  • createAt — DATETIME
  • updateAt — DATETIME
  • 경로 (image_path) — VARCHAR

user_tb

  • id — BIGINT — Primary key — NOT NULL
  • image.id (image_id) — BIGINT — Foreign key → user_image_tb.id — NOT NULL
  • createAt — DATETIME
  • updateAt — DATETIME
  • 매너 온도 (manner_tem) — INT
  • 매너 평가 (manner_eval) — VARCHAR
  • 거래 후기 (review) — VARCHAR
  • nickname — VARCHAR
  • 활동 배지 (badge) — BIGINT
  • 전화번호 (phone_number) — VARCHAR