taro-mvp

Tables (5)

CELEBRITY

  • id — BIGINT — Primary key — NOT NULL
  • name — VARCHAR(50) — NOT NULL
  • birth_date — DATE — NOT NULL
  • type — VARCHAR(20) — NOT NULL

DAILY_FORTUNE_HISTORY

  • id — BIGINT — Primary key — NOT NULL
  • card_id — BIGINT — Foreign key → TAROT_CARD.id — NOT NULL
  • direction — VARCHAR(10) — NOT NULL
  • result — TEXT
  • created_at — DATETIME — NOT NULL

TAROT_CARD

  • id — BIGINT — Primary key — NOT NULL
  • name_kr — VARCHAR(100) — NOT NULL
  • arcana — VARCHAR(10) — NOT NULL
  • definition — TEXT — NOT NULL
  • keywords — LONGTEXT — NOT NULL
  • meaning_upright — TEXT — NOT NULL
  • meaning_reversed — TEXT — NOT NULL
  • fortune_upright — TEXT
  • fortune_reversed — TEXT
  • image_url — VARCHAR(255)
  • sort_order — INT — NOT NULL

TAROT_HISTORY

  • id — BIGINT — Primary key — NOT NULL
  • question — TEXT — NOT NULL
  • category — VARCHAR(20) — NOT NULL
  • summary — TEXT — NOT NULL
  • situation — TEXT — NOT NULL
  • emotion — TEXT — NOT NULL
  • advice — TEXT — NOT NULL
  • created_at — DATETIME — NOT NULL

TAROT_HISTORY_CARD

  • id — BIGINT — Primary key — NOT NULL
  • history_id — BIGINT — Foreign key → TAROT_HISTORY.id — NOT NULL
  • card_id — BIGINT — Foreign key → TAROT_CARD.id — NOT NULL
  • direction — VARCHAR(10) — NOT NULL
  • position — INT — NOT NULL