ds
Tables (9)
cards
- card_id — BIGINT — Primary key — NOT NULL
- work_id — BIGINT — Foreign key → works.work_id — NOT NULL
- quote — TEXT — NOT NULL
- script_excerpt — TEXT — NOT NULL
- keywords — JSON — NOT NULL — "키워드1","키워드2","키워드3"
- temperature — TINYINT — NOT NULL — 1(차가움) - 5(따뜻함)
- intensity — TINYINT — NOT NULL — 1(잔잔함) - 5(격렬함)
- created_at — TIMESTAMP — NOT NULL
- updated_at — TIMESTAMP — NOT NULL
genres
- genre_id — INT — Primary key — NOT NULL
- name — VARCHAR(50) — NOT NULL
user_bookmarks
- bookmark_id — BIGINT — Primary key — NOT NULL
- user_id — BIGINT — Foreign key → users.user_id — NOT NULL
- card_id — BIGINT — Foreign key → cards.card_id — NOT NULL
- created_at — TIMESTAMP — NOT NULL
user_card_selections
- selection_id — BIGINT — Primary key — NOT NULL
- user_id — BIGINT — Foreign key → users.user_id — NOT NULL
- card_id — BIGINT — Foreign key → cards.card_id — NOT NULL
- selected_at — TIMESTAMP — NOT NULL
user_daily_cards
- daily_card_id — BIGINT — Primary key — NOT NULL
- user_id — BIGINT — Foreign key → users.user_id — NOT NULL
- card_id — BIGINT — Foreign key → cards.card_id — NOT NULL
- delivered_date — DATE — NOT NULL
- created_at — TIMESTAMP — NOT NULL
user_preferences
- user_id — BIGINT — Foreign key → users.user_id — NOT NULL
- format_weights — JSON
- genre_weights — JSON
- avg_temperature — FLOAT
- avg_intensity — FLOAT
- updated_at — TIMESTAMP — NOT NULL
users
- user_id — BIGINT — Primary key — NOT NULL
- anonymous_id — CHAR(36) — NOT NULL — 클라이언트가 발급한 UUID
- nickname — VARCHAR(50)
- created_at — TIMESTAMP — NOT NULL
- last_active_at — TIMESTAMP — NOT NULL
work_genres
- work_id — BIGINT — Foreign key → works.work_id — NOT NULL
- genre_id — INT — Foreign key → genres.genre_id — NOT NULL
works
- work_id — BIGINT — Primary key — NOT NULL
- title — VARCHAR(255) — NOT NULL
- format — ENUM('movie','drama','play','musical') — NOT NULL
- author — VARCHAR(100)
- release_year — INT
- full_script_text — LONGTEXT — NOT NULL
- created_at — TIMESTAMP — NOT NULL
- updated_at — TIMESTAMP — NOT NULL