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