프리퀄_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