tourSide
Tables (10)
festival
- festival_id — BIGINT
- subregion_id — INT — NOT NULL
- title — VARCHAR(255) — NOT NULL
- start_date — DATE
- end_date — DATE
- overview — TEXT
- image_url — VARCHAR(255)
- mapx — DOUBLE
- mapy — DOUBLE
- last_updated — DATETIME
option
- option_id — INT
- question_id — INT — NOT NULL
- text — VARCHAR(255) — NOT NULL
- image_url — VARCHAR(255)
option_trait_map
- option_id — INT — Primary key — NOT NULL
- trait_code — VARCHAR(50) — Primary key — NOT NULL
- score — INT — NOT NULL
question
- question_id — INT
- text — TEXT — NOT NULL
- image_url — VARCHAR(255)
- display_order — INT
region
- region_id — INT
- region_name — VARCHAR(50) — NOT NULL
subregion
- subregion_id — INT
- region_id — INT — NOT NULL
- name — VARCHAR(50) — NOT NULL
- area_code — INT
- sigungu_code — INT
- image_url — VARCHAR(255)
- description — TEXT
tourspot
- tourspot_id — BIGINT
- subregion_id — INT — NOT NULL
- title — VARCHAR(255) — NOT NULL
- overview — TEXT
- image_url — VARCHAR(255)
- mapx — DOUBLE
- mapy — DOUBLE
- content_type_id — INT
trait
- trait_code — VARCHAR(50)
- name — VARCHAR(100) — NOT NULL
- description — TEXT
- image_url — VARCHAR(255)
trait_region_map
- trait_code — VARCHAR(50) — Primary key — NOT NULL
- subregion_id — INT — Primary key — NOT NULL
user_response_log
- response_id — BIGINT
- session_key — VARCHAR(100)
- question_id — INT — NOT NULL
- option_id — INT — NOT NULL
- timestamp — DATETIME