여행꾹꾹
테이블 (7)
course_places
- id — BIGINT — 기본 키 — NOT NULL
- course_id — BIGINT — 외래 키 — NOT NULL
- place_id — BIGINT — 외래 키 → places.id — NOT NULL
- sequence — INT — NOT NULL — 방문 순서
course_progresses
- id — BIGINT — 기본 키 — NOT NULL
- user_id — BIGINT — 외래 키 — NOT NULL
- course_id — BIGINT — 외래 키 — NOT NULL
- status — VARCHAR(20) — NOT NULL — IN_PROGRESS/COMPLETED/ABANDONED
- started_at — DATETIME — NOT NULL
- completed_at — DATETIME
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
courses
- id — BIGINT — 기본 키 — NOT NULL
- region_id — BIGINT — 외래 키 → regions.id — NOT NULL
- title — VARCHAR(100) — NOT NULL
- description — TEXT
- thumbnail_url — VARCHAR(255)
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
place_verifications
- id — BIGINT — 기본 키
- course_progress_id — BIGINT — 외래 키 — NOT NULL
- place_id — BIGINT — 외래 키 → places.id — NOT NULL
- verified_latitude — DECIMAL(10, 8) — NOT NULL — 인증 위도
- verified_longitude — DECIMAL(11, 8) — NOT NULL — 인증 경도
- photo_verified — BOOLEAN
- photo_url — VARCHAR(255)
- verified_at — DATETIME — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME
places
- id — BIGINT — 기본 키
- region_id — BIGINT — 외래 키 → regions.id — NOT NULL
- name — VARCHAR(100) — NOT NULL
- description — TEXT
- latitude — DECIMAL(10, 8) — NOT NULL — 위도
- longitude — DECIMAL(11, 8) — NOT NULL — 경도
- image_url — VARCHAR(255)
- address — VARCHAR(255)
- phone_number — VARCHAR(255)
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
regions
- id — BIGINT — 기본 키 — NOT NULL
- name — VARCHAR(255)
users
- id — BIGINT — 기본 키 — NOT NULL
- nickname — VARCHAR(50) — NOT NULL
- provider — VARCHAR(20) — NOT NULL — kakao/naver
- provider_id — VARCHAR(255) — NOT NULL
- profile_image_url — VARCHAR(255)
- total_points — INTEGER
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL