SSAFY_TRIP
Tables (13)
attractions
- no — INT — Primary key — NOT NULL
- detail_id — INT — Foreign key → plan_details.detail_id — NOT NULL
- no (no2) — INT — Foreign key → plan_details.no — NOT NULL
- detail_id (detail_id3) — INT — Foreign key → plan_details.detail_id — NOT NULL
- content_id — INT — NOT NULL
- title — VARCHAR(500)
- content_type_id — INT
- area_code — INT
- si_gun_gu_code — INT
- first_image1 — VARCHAR(100)
- first_image2 — VARCHAR(100)
- map_level — INT
- latitude — DECIMAL(20,17)
- longitude — DECIMAL(20,17)
- tel — VARCHAR(20)
- addr1 — VARCHAR(100)
- addr2 — VARCHAR(100)
- homepage — VARCHAR(1000)
- overview — VARCHAR(10000)
boards
- board_id — INT — Primary key — NOT NULL
- story_id — INT
- title — VARCHAR(100) — NOT NULL
- content — TEXT
- hit — INT
- created_at — DATETIME
- storybooks_story_id — INT — NOT NULL
- member_id — VARCHAR(20) — Foreign key → members.member_id — NOT NULL
contenttypes
- content_type_id — INT — Primary key — NOT NULL
- content_type_name — VARCHAR(45)
guguns
- no — INT — Primary key — NOT NULL
- sido_code — INT — NOT NULL
- gugun_code — INT — NOT NULL
- gugun_name — VARCHAR(20)
member_travel_types
- type_id — INT — Primary key — NOT NULL
- mbti_code — VARCHAR(10)
- keywords — VARCHAR(200)
- created_at — DATETIME
members
- member_id — VARCHAR(20) — Primary key — NOT NULL
- member_pw — VARCHAR(200) — NOT NULL
- member_name — VARCHAR(45) — NOT NULL
- email — VARCHAR(100) — NOT NULL
- join_date — DATETIME
- role — ENUM('USER','ADMIN')
plan_details
- detail_id — INT — Primary key — NOT NULL
- no (no2) — INT — Foreign key → attractions.no — NOT NULL
- detail_id (detail_id3) — INT — Foreign key → attractions.detail_id — NOT NULL
- content_id — INT — NOT NULL
- plan_date — INT
- sequence — INT
- plan_id — INT — Foreign key → plans.plan_id — NOT NULL
- no — INT — Foreign key → attractions.no — NOT NULL
- detail_id (detail_id2) — INT — Foreign key → attractions.detail_id — NOT NULL
plans
- plan_id — INT — Primary key — NOT NULL
- member_id — VARCHAR(20) — NOT NULL
- title — VARCHAR(100) — NOT NULL
- start_date — DATE
- end_date — DATE
- description — VARCHAR(1000)
- created_at — DATETIME
sidos
- no — INT — Primary key — NOT NULL
- sido_code — INT — NOT NULL
- sido_name — VARCHAR(20)
story_pages
- page_id — INT — Primary key — NOT NULL
- story_id — INT — NOT NULL
- content_id — INT — NOT NULL
- image_path — VARCHAR(300)
- user_memo — TEXT
- ai_generated_text — TEXT
- page_order — INT — NOT NULL
storybooks
- story_id — INT — Primary key — NOT NULL
- member_id — VARCHAR(20) — NOT NULL
- title — VARCHAR(200) — NOT NULL
- created_at — DATETIME
- hit — INT
- is_public — CHAR(1)
- thumbnail_path — VARCHAR(300)
- plans_plan_id — INT — NOT NULL
survey
- no — INT — Primary key — NOT NULL
- question — VARCHAR(100) — NOT NULL
- type — VARCHAR(10) — NOT NULL
survey_options
- no — INT — Primary key — NOT NULL
- option_order — INT — NOT NULL
- option — VARCHAR(100) — NOT NULL
- survey_no — INT — NOT NULL