피로마켓

테이블 (15)

city

  • id — BIGINT — 기본 키 — NOT NULL
  • province_id — BIGINT — 외래 키 → province.id — NOT NULL
  • name — VARCHAR(30) — NOT NULL

comments

  • id — BIGINT — 기본 키 — NOT NULL
  • community_post_id — BIGINT — 외래 키 → community_post.id — NOT NULL
  • user_id — BIGINT — 외래 키 → users.id — NOT NULL
  • parent_comment_id — BIGINT — 외래 키 → comments.id
  • content — VARCHAR(1000) — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

community_like

  • id — BIGINT — 기본 키 — NOT NULL
  • user_id — BIGINT — 외래 키 → users.id — NOT NULL
  • community_post_id — BIGINT — 외래 키 → community_post.id — NOT NULL
  • created_at — DATETIME — NOT NULL

community_post

  • id — BIGINT — 기본 키 — NOT NULL
  • user_id — BIGINT — 외래 키 → users.id — NOT NULL
  • title — VARCHAR(100) — NOT NULL
  • content — TEXT — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

community_post_hashtag

  • id — BIGINT — 기본 키 — NOT NULL
  • community_post_id — BIGINT — 외래 키 → community_post.id — NOT NULL
  • hashtag_id — BIGINT — 외래 키 → hashtag.id — NOT NULL
  • created_at — DATETIME — NOT NULL

community_post_image

  • id — BIGINT — 기본 키 — NOT NULL
  • community_post_id — BIGINT — 외래 키 → community_post.id — NOT NULL
  • image_url — VARCHAR(500) — NOT NULL
  • display_order — INT — NOT NULL
  • created_at — DATETIME — NOT NULL

district

  • id — BIGINT — 기본 키 — NOT NULL
  • city_id — BIGINT — 외래 키 → city.id — NOT NULL
  • name — VARCHAR(30) — NOT NULL

follows

  • id — BIGINT — 기본 키 — NOT NULL
  • follower_id — BIGINT — 외래 키 → users.id — NOT NULL
  • following_id — BIGINT — 외래 키 → users.id — NOT NULL
  • created_at — DATETIME — NOT NULL

hashtag

  • id — BIGINT — 기본 키 — NOT NULL
  • name — VARCHAR(50) — NOT NULL
  • created_at — DATETIME — NOT NULL

province

  • id — BIGINT — 기본 키 — NOT NULL
  • name — VARCHAR(30) — NOT NULL

purchase

  • id — BIGINT — 기본 키 — NOT NULL
  • buyer_id — BIGINT — 외래 키 → users.id — NOT NULL
  • sale_post_id — BIGINT — 외래 키 → sale_post.id — NOT NULL
  • purchase_date — DATETIME — NOT NULL
  • purchase_quantity — INT — NOT NULL
  • unit_price — DECIMAL(12,2) — NOT NULL
  • purchase_status — VARCHAR(20) — NOT NULL

sale_post

  • id — BIGINT — 기본 키 — NOT NULL
  • seller_id — BIGINT — 외래 키 → users.id — NOT NULL
  • title — VARCHAR(100) — NOT NULL
  • content — TEXT — NOT NULL
  • price — DECIMAL(12,2) — NOT NULL
  • stock_quantity — INT — NOT NULL
  • sale_status — VARCHAR(20) — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

sale_post_image

  • id — BIGINT — 기본 키 — NOT NULL
  • sale_post_id — BIGINT — 외래 키 → sale_post.id — NOT NULL
  • image_url — VARCHAR(500) — NOT NULL
  • display_order — INT — NOT NULL
  • created_at — DATETIME — NOT NULL

user_tag

  • id — BIGINT — 기본 키 — NOT NULL
  • community_post_id — BIGINT — 외래 키 → community_post.id — NOT NULL
  • tagged_user_id — BIGINT — 외래 키 → users.id — NOT NULL
  • created_at — DATETIME — NOT NULL

users

  • id — BIGINT — 기본 키 — NOT NULL
  • login_id — VARCHAR(50) — NOT NULL
  • password — VARCHAR(255) — NOT NULL
  • name — VARCHAR(30) — NOT NULL
  • age — INT — NOT NULL
  • district_id — BIGINT — 외래 키 → district.id — NOT NULL
  • detail_address — VARCHAR(255) — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL