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