toy_travel
Tables (5)
Post
- post_id — LONG — Primary key — NOT NULL — Auto_Increment
- user_id — LONG — Foreign key → User.user_id — NOT NULL — Auto Increment
- title — VARCHAR(100) — NOT NULL — 자동 생성
- meet_time — DATETIME — NOT NULL
- gender_pref — ENUM — NOT NULL — M, F, ANY
- age_range — ENUM — 10s, 20s, ...
- category — ENUM — NOT NULL — MEAL, TOUR, BUDDY
- contet (content) — TEXT
- location_name — VARCHAR(100) — NOT NULL — 장소명
- address — VARCHAR(255) — NOT NULL — 전체 주소
- lat — DOUBLE — NOT NULL — 위도
- lng — DOUBLE — NOT NULL — 경도
- place_id — VARCHAR(100) — NOT NULL — Google Places ID
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME
Untitled (PostCategory)
- category_code — VARCHAR(20) — Primary key — NOT NULL — MEAL, TOUR, etc.
- name_ko — VARCHAR(50) — NOT NULL
- sort_order — INT — NOT NULL — 정렬 우선순위
- is_active — BOOLEAN — NOT NULL — 카테고리 활성 여부
User
- user_id — LONG — Primary key — NOT NULL — Auto Increment
- email — VARCHAR(100) — Google 필수, Kakao optional
- password — VARCHAR(255) — 소셜 로그인은 null
- provider — ENUM — NOT NULL — LOCAL, GOOGLE, KAKAO, NAER
- provider_id — VARCHAR(100) — 소셜 로그인용 ID
- nickname — VARCHAR(50) — NOT NULL — UI 표시용
- profile_image_url — VARCHAR(500) — 소셜 또는 업로드 이미지
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME
UserImage
- image_id — LONG — Primary key — NOT NULL — AUTO_INCREMENT
- user_id — LONG — Foreign key → User.user_id — NOT NULL — Auto Increment
- image_url — VARCHAR(500)
- is_main — BOOLEAN
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME
UserToken
- token_id — LONG — Primary key — NOT NULL
- user_id — LONG — Foreign key → User.user_id — NOT NULL — Auto Increment
- refresh_token — VARCHAR(512) — NOT NULL — JWT
- expires_at — DATETIME
- created_at — DATETIME