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