zi존 백엔드

테이블 (8)

Comment

  • id — BIGINT — 기본 키
  • user_id — BIGINT — NOT NULL
  • post_id — BIGINT — NOT NULL
  • content — TEXT — NOT NULL
  • created_at — DATETIME
  • updated_at — DATETIME

Follow

  • id — BIGINT — 기본 키
  • follower_id — BIGINT — NOT NULL
  • following_id — BIGINT — NOT NULL
  • created_at — DATETIME
  • UNIQUE(follower_id, — following_id)

Like

  • id — BIGINT — 기본 키
  • user_id — BIGINT — NOT NULL
  • post_id — BIGINT — NOT NULL
  • created_at — DATETIME
  • UNIQUE(user_id, — post_id)

Place

  • id — BIGINT — 기본 키
  • name — VARCHAR(255) — NOT NULL
  • category — VARCHAR(100) — NOT NULL
  • latitude — DECIMAL(10,8) — NOT NULL
  • longitude — DECIMAL(11,8) — NOT NULL
  • created_at — DATETIME

Post

  • id — BIGINT — 기본 키
  • user_id — BIGINT — NOT NULL
  • title — VARCHAR(255) — NOT NULL
  • content — TEXT — NOT NULL
  • image_url — VARCHAR(500)
  • latitude — DECIMAL(10,8)
  • longitude — DECIMAL(11,8)
  • place_id — BIGINT
  • created_at — DATETIME
  • updated_at — DATETIME

Ranking

  • id — BIGINT
  • place_id — BIGINT — NOT NULL
  • post_id — BIGINT — NOT NULL
  • like_count — INT — NOT NULL
  • period — ENUM('1개월', '3개월', '6개월') — NOT NULL
  • created_at — DATETIME

Scrap

  • id — BIGINT — 기본 키
  • user_id — BIGINT — NOT NULL
  • post_id — BIGINT — NOT NULL
  • created_at — DATETIME
  • UNIQUE(user_id, — post_id)

User

  • id — BIGINT — 기본 키
  • email — VARCHAR(255) — NOT NULL
  • nickname — VARCHAR(50) — NOT NULL
  • profile_image_url — VARCHAR(500)
  • provider — ENUM('naver', 'google', 'local') — NOT NULL
  • created_at — DATETIME
  • updated_at — DATETIME