육캔두잇

테이블 (10)

category

  • id — BIGINT
  • name — VARCHAR(50) — NOT NULL
  • type — VARCHAR(30) — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

course

  • id — BIGINT
  • member_id — BIGINT — 외래 키 → member.id
  • title — VARCHAR(255) — NOT NULL
  • description — TEXT
  • course_type — VARCHAR(30) — NOT NULL
  • start_date — DATE — NOT NULL
  • end_date — DATE
  • base_area — VARCHAR(100)
  • companion_type — VARCHAR(30)
  • total_distance — INT
  • estimated_time — INT
  • recommendation_reason — TEXT
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

course_place

  • id — BIGINT
  • course_id — BIGINT — 외래 키 → course.id — NOT NULL
  • place_id — BIGINT — 외래 키 → place.id — NOT NULL
  • event_id — BIGINT — 외래 키 → event.id
  • visit_order — INT — NOT NULL
  • visit_date — DATE
  • start_time — TIME
  • end_time — TIME
  • stay_minutes — INT
  • move_minutes_from_prev — INT
  • distance_from_prev — INT
  • recommendation_reason — TEXT
  • created_at — DATETIME — NOT NULL

crowd_status

  • id — BIGINT
  • place_id — BIGINT — 외래 키 → place.id
  • area_name — VARCHAR(100) — NOT NULL
  • congestion_level — VARCHAR(30) — NOT NULL
  • population_min — INT
  • population_max — INT
  • message — VARCHAR(500)
  • measured_at — DATETIME — NOT NULL
  • created_at — DATETIME — NOT NULL

event

  • id — BIGINT
  • place_id — BIGINT — 외래 키 → place.id
  • category_id — BIGINT — 외래 키 → category.id — NOT NULL
  • title — VARCHAR(255) — NOT NULL
  • start_date — DATE — NOT NULL
  • end_date — DATE — NOT NULL
  • event_time — VARCHAR(100)
  • fee — VARCHAR(100)
  • target — VARCHAR(255)
  • homepage_url — VARCHAR(500)
  • image_url — VARCHAR(500)
  • description — TEXT
  • source — VARCHAR(30) — NOT NULL
  • external_id — VARCHAR(100)
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

member

  • id — BIGINT
  • email — VARCHAR(255) — NOT NULL
  • password — VARCHAR(255) — NOT NULL
  • nickname — VARCHAR(100) — NOT NULL
  • profile_image_url — VARCHAR(500)
  • role — VARCHAR(20) — NOT NULL
  • status — VARCHAR(20) — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

place

  • id — BIGINT
  • category_id — BIGINT — 외래 키 → category.id — NOT NULL
  • name — VARCHAR(255) — NOT NULL
  • address — VARCHAR(500)
  • road_address — VARCHAR(500)
  • latitude — DECIMAL(10, 7) — NOT NULL
  • longitude — DECIMAL(10, 7) — NOT NULL
  • phone — VARCHAR(50)
  • place_url — VARCHAR(500)
  • description — TEXT
  • source — VARCHAR(30) — NOT NULL
  • external_id — VARCHAR(100)
  • is_active — BOOLEAN — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

saved_course

  • id — BIGINT
  • member_id — BIGINT — 외래 키 → member.id — NOT NULL
  • course_id — BIGINT — 외래 키 → course.id — NOT NULL
  • memo — VARCHAR(500)
  • created_at — DATETIME — NOT NULL

user_preference

  • id — BIGINT
  • member_id — BIGINT — 외래 키 → member.id — NOT NULL
  • preferred_area — VARCHAR(100)
  • companion_type — VARCHAR(30)
  • mobility_level — VARCHAR(30)
  • avoid_crowded — BOOLEAN — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

user_preference_category

  • id — BIGINT
  • user_preference_id — BIGINT — 외래 키 → user_preference.id — NOT NULL
  • category_id — BIGINT — 외래 키 → category.id — NOT NULL