erd2
Tables (17)
bookmark
- id — BIGINT — Primary key — NOT NULL
- member_id — BIGINT — Foreign key → member.id — NOT NULL
- target_id — BIGINT — NOT NULL
- target_type — ENUM — NOT NULL
- created_date — DATETIME — NOT NULL
- modified_date — DATETIME — NOT NULL
- status — ENUM — NOT NULL
category
- id — BIGINT — Primary key — 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 — Primary key — NOT NULL
- member_id — BIGINT — Foreign key → member.id — NOT NULL
- short_form_id — BIGINT — Foreign key → 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 — Primary key — NOT NULL
- member_id — BIGINT — Foreign key → member.id — NOT NULL
- contents_id — BIGINT — Foreign key → 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 — Primary key — NOT NULL
- uploader_id — BIGINT — Foreign key → member.id — NOT NULL
- series_id — BIGINT — Foreign key → series.id
- title — VARCHAR(255) — NOT NULL
- description — VARCHAR(255) — NOT NULL
- actors — VARCHAR(255) — NOT NULL
- poster_url — TEXT — NOT NULL
- thumbnail_url — TEXT — NOT NULL
- duration — INT
- video_size — INT
- bookmark_count — BIGINT — NOT NULL
- likes_count — BIGINT — NOT NULL
- public_status — ENUM — NOT NULL
- origin_url — TEXT — NOT NULL
- master_playlist_url — TEXT
- created_date — DATETIME — NOT NULL
- modified_date — DATETIME — NOT NULL
- status — ENUM — NOT NULL
contents_tag
- id — BIGINT — Primary key — NOT NULL
- tag_id — BIGINT — Foreign key → tag.id — NOT NULL
- contents_id — BIGINT — Foreign key → contents.id — NOT NULL
- created_date — DATETIME — NOT NULL
- modified_date — DATETIME — NOT NULL
- status — ENUM — NOT NULL
ingest_job
- id — BIGINT — Primary key — NOT NULL
- short_form_id — BIGINT — Foreign key → short_form.id
- contents_id — BIGINT — Foreign key → contents.id
- ingest_status — ENUM — NOT NULL
- created_date — DATETIME — NOT NULL
- modified_date — DATETIME — NOT NULL
- status — ENUM — NOT NULL
- Field
likes
- id — BIGINT — Primary key — NOT NULL
- member_id — BIGINT — Foreign key → member.id — NOT NULL
- target_id — BIGINT — NOT NULL
- target_type — ENUM — NOT NULL
- created_date — DATETIME — NOT NULL
- modified_date — DATETIME — NOT NULL
- status — ENUM — NOT NULL
member
- id — BIGINT — Primary key — 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 — Primary key — NOT NULL
- member_id — BIGINT — Foreign key → member.id — NOT NULL
- contents_id — BIGINT — Foreign key → 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 — Primary key — NOT NULL
- member_id — BIGINT — Foreign key → member.id — NOT NULL
- tag_id — BIGINT — Foreign key → tag.id — NOT NULL
- created_date — DATETIME — NOT NULL
- modified_date — DATETIME — NOT NULL
- status — ENUM — NOT NULL
series
- id — BIGINT — Primary key — NOT NULL
- uploader_id — BIGINT — NOT NULL
- title — VARCHAR(255) — NOT NULL
- description — VARCHAR(255) — NOT NULL
- actors — VARCHAR(255) — NOT NULL
- poster_url — TEXT — NOT NULL
- thumbnail_url — TEXT — NOT NULL
- bookmark_count — BIGINT — NOT NULL
- likes_count — BIGINT — NOT NULL
- public_status — ENUM — NOT NULL
- created_date — DATETIME — NOT NULL
- modified_date — DATETIME — NOT NULL
- status — ENUM — NOT NULL
series_tag
- id — BIGINT — Primary key — NOT NULL
- tag_id — BIGINT — Foreign key → tag.id — NOT NULL
- series_id — BIGINT — Foreign key → series.id — NOT NULL
- created_date — DATETIME — NOT NULL
- modified_date — DATETIME — NOT NULL
- status — ENUM — NOT NULL
short_form
- id — BIGINT — Primary key — NOT NULL
- uploader_id — BIGINT — Foreign key → member.id — NOT NULL
- series_id — BIGINT — Foreign key → series.id
- contents_id — BIGINT — Foreign key → contents.id
- title — VARCHAR(255) — NOT NULL
- description — VARCHAR(255) — NOT NULL
- poster_url — TEXT — NOT NULL
- duration — INT
- video_size — INT
- bookmark_count — BIGINT — NOT NULL
- public_status — ENUM — NOT NULL
- 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 — Primary key — NOT NULL
- category_id — BIGINT — Foreign key → 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 — Primary key — NOT NULL
- ingest_job_id — BIGINT — Foreign key → 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 — Primary key — NOT NULL
- member_id — BIGINT — Foreign key → member.id — NOT NULL
- contents_id — BIGINT — Foreign key → contents.id — NOT NULL
- last_watched_at — DATETIME
- created_date — DATETIME — NOT NULL
- modified_date — DATETIME — NOT NULL
- status — ENUM — NOT NULL