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