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