QUIZ
Tables (4)
IMAGE
- image_id — CHAR(24) — Primary key — NOT NULL
- createdAt — DATETIME — NOT NULL
- extractedData — TEXT — NOT NULL
- fileName — VARCHAR(255) — NOT NULL
- imageUrl — VARCHAR(1024) — NOT NULL
- mimeType — VARCHAR(50) — NOT NULL
- originalName — VARCHAR(255) — NOT NULL
- size — BIGINT — NOT NULL
- status — VARCHAR(50) — NOT NULL
- updatedAt — DATETIME — NOT NULL
- location_id — VARCHAR(24) — Foreign key → LOCATION.location_id — NOT NULL
LOCATION
- location_id — VARCHAR(24) — Primary key — NOT NULL
- address — VARCHAR(255) — NOT NULL
- addressDetail — VARCHAR(255)
- authorEmail — VARCHAR(255) — NOT NULL
- authorId — CHAR(24) — NOT NULL
- authorName — VARCHAR(100) — NOT NULL
- createdAt — DATETIME — NOT NULL
- description — TEXT — NOT NULL
- gps_lat — DECIMAL(10,7) — NOT NULL
- gps_lon — DECIMAL(10,7) — NOT NULL
- image_id_0 — CHAR(24)
- image_id_1 — CHAR(24)
- image_id_2 — CHAR(24)
- image_id_3 — CHAR(24)
- image_id_4 — CHAR(24)
- keywords_0 — VARCHAR(100)
- keywords_1 — VARCHAR(100)
- keywords_2 — VARCHAR(100)
- keywords_3 — VARCHAR(100)
- keywords_4 — VARCHAR(100)
- keywords_5 — VARCHAR(100)
- Field6 (keywords_6) — VARCHAR(100)
- Field7 (keywords_7) — VARCHAR(100)
- Field8 (keywords_8) — VARCHAR(100)
- Field9 (keywords_9) — VARCHAR(100)
- Field10 (keywords_10) — VARCHAR(100)
- locationType — VARCHAR(100) — NOT NULL
- name — VARCHAR(255) — NOT NULL
- status — VARCHAR(50) — NOT NULL
- updatedAt — DATETIME — NOT NULL
SCENARIO
- scenario_id — VARCHAR(20) — Primary key — NOT NULL
- name — VARCHAR(100) — NOT NULL
- genre — VARCHAR(100) — NOT NULL
- characters_info — TEXT — NOT NULL
- overview — TEXT — NOT NULL
- opening_dialogue — TEXT — NOT NULL
- opening_question — VARCHAR(255) — NOT NULL
- opening_option1 — VARCHAR(255) — NOT NULL
- opening_option2 — VARCHAR(255) — NOT NULL
- start_text — TEXT — NOT NULL
STEP
- step_id — BIGINT — Primary key — NOT NULL
- scenario_id — VARCHAR(20) — Foreign key → SCENARIO.scenario_id — NOT NULL
- sequence — INT — NOT NULL
- location_id — VARCHAR(24) — Foreign key → LOCATION.location_id — NOT NULL
- background_text — TEXT — NOT NULL
- situation_text — TEXT — NOT NULL
- npc_name — VARCHAR(100)
- npc_dialogue — TEXT
- quiz_question — TEXT — NOT NULL
- quiz_option1 — VARCHAR(255) — NOT NULL
- quiz_option2 — VARCHAR(255) — NOT NULL
- quiz_option3 — VARCHAR(255) — NOT NULL
- quiz_answer — VARCHAR(255) — NOT NULL
- quiz_difficulty — VARCHAR(10) — NOT NULL
- culture_info — TEXT — NOT NULL
- reward_text — TEXT
- reward_effect — TEXT
- next_hint_text — TEXT — NOT NULL