프리퀄_ERD

테이블 (10)

Favorite (Untitled8)

  • Key (favorite_id) — INTEGER — 기본 키 — NOT NULL
  • Key (user_id) — INTEGER — 외래 키 → Users.Key — NOT NULL
  • Key (work_id) — INTEGER — 외래 키 → LiteraryWork.Key — NOT NULL
  • Field (created_at) — TIMESTAMP

KContent (Untitled2)

  • Key (content_id) — INTEGER — 기본 키 — NOT NULL
  • Field (tmdb_id) — INTEGER
  • Field (title) — VARCHAR(255)
  • Field (content_type) — VARCHAR(20)
  • Field (overveiw) — TEXT
  • Field (tmdb_genres) — JSONB
  • Field (runtime) — INTEGER
  • Field (platform) — VARCHAR(100)
  • Field (release_date) — TIMESTAMP
  • Field (poster_url) — TEXT
  • Field (source) — VARCHAR(50)
  • Field (created_at) — TIMESTAMP
  • Field (updated_at) — TIMESTAMP

KContentTag (Untitled5)

  • Key (content_tag_id) — INTEGER — 기본 키 — NOT NULL
  • Key (content_id) — INTEGER — 외래 키 → KContent.Key — NOT NULL
  • Key (tag_id) — INTEGER — 외래 키 → Tag.Key — NOT NULL
  • Field (weight) — SMALLINT
  • Field (created_by) — VARCHAR(100)
  • Field (created_at) — TIMESTAMP

LiteraryWork (Untitled3)

  • Key (work_id) — INTEGER — 기본 키 — NOT NULL
  • Field (source_id) — INTEGER
  • Field (source) — VARCHAR(50)
  • Field (title) — VARCHAR(255)
  • Field (literature_type) — VARCHAR(20)
  • Field (author) — VARCHAR(100)
  • Field (summary) — TEXT
  • Field (genre) — VARCHAR(100)
  • Field (era) — VARCHAR(50)
  • Field (published_year) — INTEGER
  • Field (cover_url) — TEXT
  • Field (created_at) — TIMESTAMP

LiteraryWorkTag (Untitled6)

  • Key (work_tag_id) — INTEGER — 기본 키 — NOT NULL
  • Key (work_id) — INTEGER — 외래 키 → LiteraryWork.Key — NOT NULL
  • Key (tag_id) — INTEGER — 외래 키 → Tag.Key — NOT NULL
  • Field (weight) — SMALLINT
  • Field (created_by) — VARCHAR(100)
  • Field (created_at) — TIMESTAMP

Recommendation (Untitled7)

  • Key (recommendation_id) — INTEGER — 기본 키 — NOT NULL
  • Key (user_id) — INTEGER — 외래 키 → Users.Key — NOT NULL
  • Key (content_id) — INTEGER — 외래 키 → KContent.Key — NOT NULL
  • Key (work_id) — INTEGER — 외래 키 → LiteraryWork.Key — NOT NULL
  • Field (similarity_score) — FLOAT
  • Field (created_at) — TIMESTAMP

Tag (Untitled4)

  • Key (tag_id) — INTEGER — 기본 키 — NOT NULL
  • Field (name) — VARCHAR(100)
  • Field (category) — VARCHAR(30)
  • Field (description) — TEXT
  • Field (selection_guide) — TEXT

Translation (Untitled9)

  • Key (translation_id) — INTEGER — 기본 키 — NOT NULL
  • Key (work_id) — INTEGER — 외래 키 → LiteraryWork.Key — NOT NULL
  • Field (language) — VARCHAR(20)
  • Field (translated_title) — VARCHAR(255)
  • Field (translator) — VARCHAR(100)
  • Field (publisher) — VARCHAR(100)
  • Field (isbn) — VARCHAR(20)
  • Field (purchase_url) — TEXT
  • Field (cover_url) — TEXT
  • Field (published_year) — INTEGER

Users (Untitled)

  • Key (user_id) — INTEGER — 기본 키 — NOT NULL
  • Field (login_id) — VARCHAR(50)
  • Field (password_hash) — VARCHAR(255)
  • Field (username) — VARCHAR(50)
  • Field2 (email) — VARCHAR(255)
  • Field2 (language) — VARCHAR(10)
  • Field (role) — VARCHAR(20)
  • Field (is_active) — BOOLEAN
  • Field (created_at) — TIMESTAMP
  • Field (updated_at) — TIMESTAMP
  • Field (is_email_verified) — BOOLEAN

VisualAid (Untitled10)

  • Key (visual_aid_id) — INTEGER — 기본 키 — NOT NULL
  • Key (work_id) — INTEGER — 외래 키 → LiteraryWork.Key — NOT NULL
  • Field (three_line_summary) — TEXT
  • Field (taste_preview) — TEXT
  • Field (timeline) — TEXT
  • Field (relationship_diagram) — TEXT
  • Field (key_sentence) — TEXT
  • Field (created_at) — TIMESTAMP