favory

테이블 (10)

댓글 (comments)

  • Key (id) — bigint — 기본 키 — NOT NULL
  • Field (favory_id) — bigint
  • Field (user_id) — bigint
  • Field (content) — varchar(100)
  • Field (created_at) — timestamp(6)
  • Field (updated_at) — timestamp(6)
  • Field (deleted_at) — timestamp(6)

리뷰 (favory)

  • Key (id) — bigint — 기본 키 — NOT NULL
  • Field (user_id) — bigint
  • Field (media_id) — bigint
  • Field (title) — varchar(100)
  • Field (content) — text
  • Field (like_count) — bigint
  • Field (created_at) — timestamp(6)
  • Field (updated_at) — timestamp(6)
  • Field (deleted_at) — timestamp(6)

리뷰태그 (favory_tag_mappings)

  • Key (id) — bigint — 기본 키
  • Field (favory_id) — bigint
  • Field (tag_id) — bigint
  • Field (created_at) — datetime(6)
  • Field (updated_at) — datetime(6)

미디어 (media)

  • Key (id) — bigint — 기본 키 — NOT NULL
  • Field (external_id) — varchar(200)
  • Field (type) — varchar(20)
  • Field (title) — VARCHAR(200)
  • Field (creator) — VARCHAR(200)
  • Field (year) — int
  • Field (image_url) — varchar(500)
  • Field (created_at) — timestamp(6)
  • Field (updated_at) — timestamp(6)

미디어태그 (media_tag_mapping)

  • Key (id) — bigint — 기본 키 — NOT NULL
  • Field (media_id) — bigint
  • Field (tag_id) — bigint
  • Field (created_at) — datetime(6)
  • Field (updated_at) — datetime(6)

이메일인증 (email_verifications)

  • Key (id) — bigint — 기본 키
  • Field (email) — varchar(255)
  • Field (code_hash) — varchar(255)
  • Field (code_expires_at) — timestamp(6)
  • Field (verify_token_hash) — varchar(255)
  • Field (verify_token_expires_at) — timestamp(6)
  • Field (verified_at) — timestamp(6)
  • Field (created_at) — timestamp(6)
  • Field (updated_at) — timestamp(6)

좋아요 (likes)

  • Key (id) — bigint — 기본 키
  • Field (user_id) — bigint
  • Field (favory_id) — bigint
  • Field (created_at) — datetime(6)

최근검색 (search_recent)

  • Key (id) — bigint — 기본 키 — NOT NULL
  • Field (user_id) — bigint
  • Field (keyword) — varchar(200)
  • Field (last_used_at) — timestamp(6)
  • Field (created_at) — timestamp(6)
  • Field (updated_at) — timestamp(6)

태그 (tags)

  • Key (id) — bigint — 기본 키 — NOT NULL
  • Field (name) — varchar(50)
  • Field (created_at) — timestamp(6)
  • Field (updated_at) — timestamp(6)

회원 (users)

  • Key (id) — bigint — 기본 키 — NOT NULL
  • Field (email) — varchar(255)
  • Field (password) — varchar(255)
  • Field (provider) — enum('GOOGLE', 'LOCAL')
  • Field (provider_id) — varchar(100)
  • Field (nickname) — varchar(50)
  • Field (profile_image_url) — varchar(500)
  • Field (profile_message) — text
  • Field (created_at) — timestamp(6)
  • Field (updated_at) — timestamp(6)