개선 제시안

테이블 (17)

bookmark

  • id — BIGINT — 기본 키 — NOT NULL
  • member_id — BIGINT — 외래 키 → member.id — NOT NULL
  • media_id — BIGINT — 외래 키 → media.id — NOT NULL
  • created_date — DATETIME — NOT NULL
  • modified_date — DATETIME — NOT NULL
  • status — ENUM — NOT NULL

category

  • id — BIGINT — 기본 키 — NOT NULL
  • name — VARCHAR(255) — NOT NULL
  • created_date — DATETIME — NOT NULL
  • modified_date — DATETIME — NOT NULL
  • status — ENUM — NOT NULL

click_event

  • id — BIGINT — 기본 키 — NOT NULL
  • member_id — BIGINT — 외래 키 → member.id — NOT NULL
  • short_form_id — BIGINT — 외래 키 → short_form.id — NOT NULL
  • click_at — DATETIME — NOT NULL
  • click_type — ENUM — NOT NULL
  • created_date — DATETIME — NOT NULL
  • modified_date — DATETIME — NOT NULL
  • status — ENUM — NOT NULL

comment

  • id — BIGINT — 기본 키 — NOT NULL
  • member_id — BIGINT — 외래 키 → member.id — NOT NULL
  • contents_id — BIGINT — 외래 키 → contents.id — NOT NULL
  • content — VARCHAR(255) — NOT NULL
  • is_spoiler — BOOLEAN — NOT NULL
  • created_date — DATETIME — NOT NULL
  • modified_date — DATETIME — NOT NULL
  • status — ENUM — NOT NULL

contents

  • id — BIGINT — 기본 키 — NOT NULL
  • media_id — BIGINT — 외래 키 → media.id — NOT NULL
  • series_id — BIGINT — 외래 키 → series.id
  • actors — VARCHAR(255) — NOT NULL
  • duration — INT
  • video_size — INT
  • origin_url — TEXT — NOT NULL
  • master_playlist_url — TEXT
  • created_date — DATETIME — NOT NULL
  • modified_date — DATETIME — NOT NULL
  • status — ENUM — NOT NULL

ingest_job

  • id — BIGINT — 기본 키 — NOT NULL
  • media_id — BIGINT — 외래 키 → media.id — NOT NULL
  • ingest_status — ENUM — NOT NULL
  • created_date — DATETIME — NOT NULL
  • modified_date — DATETIME — NOT NULL
  • status — ENUM — NOT NULL

likes

  • id — BIGINT — 기본 키 — NOT NULL
  • member_id — BIGINT — 외래 키 → member.id — NOT NULL
  • media_id — BIGINT — 외래 키 → media.id — NOT NULL
  • created_date — DATETIME — NOT NULL
  • modified_date — DATETIME — NOT NULL
  • status — ENUM — NOT NULL

media

  • id — BIGINT — 기본 키 — NOT NULL
  • uploader_id — BIGINT — NOT NULL
  • title — VARCHAR(255) — NOT NULL
  • description — VARCHAR(255) — NOT NULL
  • poster_url — TEXT — NOT NULL
  • thumbnail_url — TEXT
  • bookmark_count — BIGINT — NOT NULL
  • likes_count — BIGINT — NOT NULL
  • media_type — ENUM — NOT NULL
  • public_status — ENUM — NOT NULL
  • created_date — DATETIME — NOT NULL
  • modified_date — DATETIME — NOT NULL
  • status — ENUM — NOT NULL

media_tag

  • id — BIGINT — 기본 키 — NOT NULL
  • tag_id — BIGINT — 외래 키 → tag.id — NOT NULL
  • media_id — BIGINT — 외래 키 → media.id — NOT NULL
  • created_date — DATETIME — NOT NULL
  • modified_date — DATETIME — NOT NULL
  • status — ENUM — NOT NULL

member

  • id — BIGINT — 기본 키 — NOT NULL
  • email — VARCHAR(255) — NOT NULL
  • password — VARCHAR(255)
  • nickname — VARCHAR(255) — NOT NULL
  • role — ENUM — NOT NULL
  • provider — ENUM — NOT NULL
  • provider_id — VARCHAR(255)
  • refresh_token — VARCHAR(255)
  • created_date — DATETIME — NOT NULL
  • modified_date — DATETIME — NOT NULL
  • status — ENUM — NOT NULL

playback

  • id — BIGINT — 기본 키 — NOT NULL
  • member_id — BIGINT — 외래 키 → member.id — NOT NULL
  • contents_id — BIGINT — 외래 키 → contents.id — NOT NULL
  • position_sec — INT — NOT NULL
  • created_date — DATETIME — NOT NULL
  • modified_date — DATETIME — NOT NULL
  • status — ENUM — NOT NULL

preferred_tag

  • id — BIGINT — 기본 키 — NOT NULL
  • member_id — BIGINT — 외래 키 → member.id — NOT NULL
  • tag_id — BIGINT — 외래 키 → tag.id — NOT NULL
  • created_date — DATETIME — NOT NULL
  • modified_date — DATETIME — NOT NULL
  • status — ENUM — NOT NULL

series

  • id — BIGINT — 기본 키 — NOT NULL
  • media_id — BIGINT — 외래 키 → media.id — NOT NULL
  • actors — VARCHAR(255) — NOT NULL
  • created_date — DATETIME — NOT NULL
  • modified_date — DATETIME — NOT NULL
  • status — ENUM — NOT NULL

short_form

  • id — BIGINT — 기본 키 — NOT NULL
  • media_id — BIGINT — 외래 키 → media.id — NOT NULL
  • series_id — BIGINT — 외래 키 → series.id
  • contents_id — BIGINT — 외래 키 → contents.id
  • duration — INT
  • video_size — INT
  • origin_url — TEXT — NOT NULL
  • master_playlist_url — TEXT
  • created_date — DATETIME — NOT NULL
  • modified_date — DATETIME — NOT NULL
  • status — ENUM — NOT NULL

tag

  • id — BIGINT — 기본 키 — NOT NULL
  • category_id — BIGINT — 외래 키 → category.id — NOT NULL
  • name — VARCHAR(255) — NOT NULL
  • created_date — DATETIME — NOT NULL
  • modified_date — DATETIME — NOT NULL
  • status — ENUM — NOT NULL

video_profile

  • id — BIGINT — 기본 키 — NOT NULL
  • ingest_job_id — BIGINT — 외래 키 → ingest_job.id — NOT NULL
  • media_playlist_url — TEXT — NOT NULL
  • resolution — ENUM — NOT NULL
  • profile_status — ENUM — NOT NULL
  • created_date — DATETIME — NOT NULL
  • modified_date — DATETIME — NOT NULL
  • status — ENUM — NOT NULL

watch_history

  • id — BIGINT — 기본 키 — NOT NULL
  • member_id — BIGINT — 외래 키 → member.id — NOT NULL
  • contents_id — BIGINT — 외래 키 → contents.id — NOT NULL
  • last_watched_at — DATETIME
  • created_date — DATETIME — NOT NULL
  • modified_date — DATETIME — NOT NULL
  • status — ENUM — NOT NULL