odeseoul

Tables (11)

course

  • id — int — Primary key — NOT NULL
  • name — varchar(45) — NOT NULL
  • level — int — NOT NULL — 1(초급), 2(중급), 3(고급)
  • distance — int — NOT NULL — 미터 단위
  • time — int — NOT NULL — 분 단위
  • description — text — NOT NULL
  • categories — json — NOT NULL
  • gugun_summary — varchar(45) — NOT NULL
  • route_summary — varchar(500) — NOT NULL
  • near_subway — varchar(45) — NOT NULL
  • access_way — varchar(500) — NOT NULL
  • region — enum('NORTH', 'SOUTH') — NOT NULL
  • image — varchar(500) — NOT NULL
  • route — multilinestring
  • created_at — datetime
  • updated_at — datetime
  • deleted_at — datetime

course_gugun

  • id — int — Primary key — NOT NULL
  • course_id — int — Foreign key → course.id — NOT NULL
  • location_code — varchar(45) — Foreign key → location.code — NOT NULL — 행정동코드
  • created_at — datetime
  • updated_at — datetime
  • deleted_at — datetime

course_review

  • id — int — Primary key — NOT NULL
  • course_id — int — Foreign key → course.id — NOT NULL
  • user_id — int — Foreign key → user.id — NOT NULL
  • score — int — NOT NULL
  • content — text — NOT NULL
  • image — varchar(500) — NOT NULL
  • created_at — datetime
  • updated_at — datetime
  • deleted_at — datetime

event

  • id — int — Primary key — NOT NULL
  • uuid — varchar(45) — NOT NULL
  • codename — varchar(45) — NOT NULL — 분류
  • guname — varchar(45) — NOT NULL — 자치구
  • title — varchar(500) — NOT NULL — 공연/행사명
  • place — varchar(500) — NOT NULL — 장소
  • use_target — varchar(500) — NOT NULL — 이용대상
  • use_fee — varchar(500) — NOT NULL — 이용요금
  • org_link — varchar(500) — NOT NULL — 홈페이지주소
  • main_image — varchar(500) — NOT NULL — 대표이미지
  • start_date — date — NOT NULL — 시작일
  • end_date — date — NOT NULL — 종료일
  • register_date — date — NOT NULL
  • created_at — datetime

location

  • code — varchar(45) — Primary key — NOT NULL — 행정동코드
  • address1 — varchar(45) — NOT NULL — 시도명
  • address2 — varchar(45) — NOT NULL — 시군구명
  • address3 — varchar(45) — NOT NULL — 읍면동명
  • latitude — double
  • longitude — double
  • seoul_gugun — tinyint(1) — NOT NULL
  • created_at — datetime
  • updated_at — datetime
  • deleted_at — datetime

notice

  • id — int — Primary key — NOT NULL
  • author — varchar(45) — NOT NULL
  • title — varchar(500) — NOT NULL
  • content — text — NOT NULL
  • created_at — datetime
  • updated_at — datetime
  • deleted_at — datetime

recruit

  • id — int — Primary key — NOT NULL
  • host_user_id — int — Foreign key → user.id — NOT NULL
  • course_id — int — Foreign key → course.id — NOT NULL
  • category — varchar(45) — NOT NULL
  • title — varchar(500) — NOT NULL
  • content — text — NOT NULL
  • image — varchar(500) — NOT NULL
  • current_people — int — NOT NULL
  • max_people — int — NOT NULL — 0: 제한없음
  • scheduled_at — datetime — NOT NULL
  • progress_status — enum('OPEN', 'CLOSED', 'DONE') — NOT NULL
  • created_at — datetime
  • updated_at — datetime
  • deleted_at — datetime

recruit_application

  • id — int — Primary key — NOT NULL
  • recruit_id — int — Foreign key → recruit.id — NOT NULL
  • member_user_id — int — Foreign key → user.id — NOT NULL
  • created_at — datetime
  • updated_at — datetime
  • deleted_at — datetime

recruit_comment

  • id — int — Primary key — NOT NULL
  • recruit_id — int — Foreign key → recruit.id — NOT NULL
  • user_id — int — Foreign key → user.id — NOT NULL
  • content — text — NOT NULL
  • created_at — datetime
  • updated_at — datetime
  • deleted_at — datetime

user

  • id — int — Primary key — NOT NULL
  • nickname — varchar(45) — NOT NULL
  • profile_image — varchar(500) — NOT NULL
  • location_code — varchar(45) — Foreign key → location.code — 행정동코드
  • login_id — varchar(45) — NOT NULL
  • login_pw — varchar(500) — NOT NULL
  • refresh_token — varchar(500) — NOT NULL
  • signup_status — enum('BEFORE_REGISTERED','REGISTERED') — NOT NULL
  • created_at — datetime
  • updated_at — datetime
  • deleted_at — datetime

user_picked_course

  • id — int — Primary key — NOT NULL
  • user_id — int — Foreign key → user.id — NOT NULL
  • course_id — int — Foreign key → course.id — NOT NULL
  • created_at — datetime
  • updated_at — datetime
  • deleted_at — datetime