ㄷ

Tables (16)

email_verification

  • verification_id — BIGINT — Primary key — NOT NULL
  • email — VARCHAR(255) — NOT NULL
  • purpose — ENUM('SIGNUP', 'FIND_ID', 'RESET_PW') — NOT NULL
  • code — CHAR(6) — NOT NULL — 6자리 인증번호
  • expires_at — DATETIME — NOT NULL — 인증번호 만료 시각
  • request_count — INT — NOT NULL — 인증요청/재요청 횟수
  • fail_count — INT — NOT NULL — 인증코드 검증 실패 횟수
  • locked_until — DATETIME — 요청 또는 검증 제한 해제 시각
  • verified — TINYINT(1) — NOT NULL — 현재 목적의 인증 완료 여부
  • verified_at — DATETIME — 인증 완료 시각
  • last_sent_at — DATETIME — 마지막 발송 시각
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

membership

  • user_uuid — CHAR(36) — Foreign key → user_information.user_uuid — NOT NULL
  • plan — ENUM('FREE', 'PRO') — NOT NULL
  • status — ENUM('ACTIVE', 'CANCELED', 'PENDING') — NOT NULL
  • payment_provider — ENUM('GOOGLE_PLAY', 'APPLE', 'PG', 'NONE') — NOT NULL
  • payment_method_token — VARCHAR(255) — PG/스토어 결제수단 토큰 참조값
  • payment_method_label — VARCHAR(100) — 예 카드 끝 4자리 등
  • started_at — DATETIME
  • next_billing_at — DATETIME
  • canceled_at — DATETIME
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

my_place_category

  • category_id — BIGINT — Primary key — NOT NULL
  • user_uuid — CHAR(36) — Foreign key → user_information.user_uuid — NOT NULL
  • title — VARCHAR(100) — NOT NULL
  • description — VARCHAR(255)
  • privacy_scope — TINYINT — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

payment_history

  • payment_id — BIGINT — Primary key — NOT NULL
  • user_uuid — CHAR(36) — Foreign key → user_information.user_uuid — NOT NULL
  • plan — ENUM('FREE', 'PRO') — NOT NULL
  • payment_provider — ENUM('GOOGLE_PLAY', 'APPLE', 'PG') — NOT NULL
  • external_receipt — VARCHAR(255) — 영수증 토큰 또는 외부 결제 식별값
  • amount — DECIMAL(10, 2) — NOT NULL
  • currency — VARCHAR(10) — NOT NULL
  • status — ENUM('PAID', 'FAILED', 'CANCELED', 'REFUNDED') — NOT NULL
  • paid_at — DATETIME
  • canceled_at — DATETIME
  • refunded_at — DATETIME
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

reset_tokens

  • reset_token_id — BIGINT — Primary key — NOT NULL
  • user_uuid — CHAR(36) — Foreign key → user_information.user_uuid — NOT NULL
  • email — VARCHAR(255) — NOT NULL
  • purpose — ENUM('RESET_PW') — NOT NULL
  • reset_token — VARCHAR(255) — NOT NULL
  • expires_at — DATETIME — NOT NULL
  • used — TINYINT(1) — NOT NULL
  • used_at — DATETIME
  • created_at — DATETIME — NOT NULL

room_participants

  • room_participant_id — BIGINT — Primary key — NOT NULL
  • room_id — BIGINT — Foreign key → rooms.room_id — NOT NULL
  • user_uuid — CHAR(36) — Foreign key → user_information.user_uuid — NOT NULL
  • role — ENUM('HOST','GUEST') — NOT NULL
  • share_location_agreed — TINYINT(1) — NOT NULL
  • participant_status — ENUM('JOINED','LEFT','KICKED') — NOT NULL
  • joined_at — DATETIME — NOT NULL
  • left_at — DATETIME

rooms

  • room_id — BIGINT — Primary key — NOT NULL
  • host_user_uuid — CHAR(36) — Foreign key → user_information.user_uuid — NOT NULL
  • invite_code — VARCHAR(20) — NOT NULL
  • room_title — VARCHAR(100)
  • start_name — VARCHAR(150)
  • start_lat — DECIMAL(10,7)
  • start_lng — DECIMAL(10,7)
  • destination_name — VARCHAR(150) — NOT NULL
  • destination_lat — DECIMAL(10,7) — NOT NULL
  • destination_lng — DECIMAL(10,7) — NOT NULL
  • member_limit — INT — NOT NULL
  • room_status — ENUM('WAITING','DRIVING','ENDED','CANCELED') — NOT NULL
  • created_at — DATETIME — NOT NULL
  • started_at — DATETIME
  • ended_at — DATETIME

saved_places

  • saved_place_id — BIGINT — Primary key — NOT NULL
  • category_id — BIGINT — Foreign key → my_place_category.category_id — NOT NULL
  • user_uuid — CHAR(36) — Foreign key → user_information.user_uuid — NOT NULL
  • poi_id — VARCHAR(100) — 외부 POI 식별값
  • place_name — VARCHAR(150) — NOT NULL
  • category_name — VARCHAR(100) — 업종 또는 분류명
  • road_address — VARCHAR(255)
  • jibun_address — VARCHAR(255)
  • latitude — DECIMAL(10, 7) — NOT NULL
  • longitude — DECIMAL(10, 7) — NOT NULL
  • memo — VARCHAR(255)
  • created_at — DATETIME — NOT NULL

sessions

  • session_id — CHAR(64) — Primary key — NOT NULL — 서버 발급 세션 ID
  • user_uuid — CHAR(36) — Foreign key → user_information.user_uuid — NOT NULL — 세션 사용자 UUID
  • status — ENUM('ACTIVE', 'LOGGED_OUT', 'EXPIRED', 'REVOKED') — NOT NULL — 세션 상태
  • issued_at — DATETIME — NOT NULL — 세션 발급 시각
  • expires_at — DATETIME — NOT NULL — 세션 만료 시각
  • last_seen_at — DATETIME — 마지막 활동 시각
  • logout_at — DATETIME — 로그아웃 시각

social_accounts

  • social_account_id — BIGINT — Primary key — NOT NULL
  • user_uuid — CHAR(36) — Foreign key → user_information.user_uuid — NOT NULL
  • provider — ENUM('GOOGLE', 'KAKAO', 'NAVER') — NOT NULL
  • provider_user_id — VARCHAR(255) — NOT NULL — 소셜 제공자 사용자 식별값
  • provider_email — VARCHAR(255) — 소셜 제공자가 준 이메일
  • linked_at — DATETIME — NOT NULL
  • last_login_at — DATETIME
  • updated_at — DATETIME — NOT NULL

social_accounts1

  • social_account_id — BIGINT — NOT NULL
  • user_uuid — CHAR(36) — NOT NULL
  • provider — ENUM('GOOGLE', 'KAKAO', 'NAVER') — NOT NULL
  • provider_user_id — VARCHAR(255) — NOT NULL — 소셜 제공자 사용자 식별값
  • provider_email — VARCHAR(255) — 소셜 제공자가 준 이메일
  • linked_at — DATETIME — NOT NULL
  • last_login_at — DATETIME
  • updated_at — DATETIME — NOT NULL

terms_agreement

  • agreement_id — BIGINT — Primary key — NOT NULL
  • user_uuid — CHAR(36) — Foreign key → user_information.user_uuid — NOT NULL
  • service_terms — TINYINT(1) — NOT NULL
  • privacy_terms — TINYINT(1) — NOT NULL
  • location_terms — TINYINT(1) — NOT NULL
  • payment_terms — TINYINT(1) — NOT NULL
  • marketing_opt_in — TINYINT(1) — NOT NULL
  • consented_at — DATETIME — NOT NULL — 약관 동의 시각
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

trip_history

  • trip_id — BIGINT — Primary key — NOT NULL
  • user_uuid — CHAR(36) — Foreign key → user_information.user_uuid — NOT NULL
  • room_id — BIGINT — Foreign key → rooms.room_id — 그룹 주행이면 room_id 연결, 개인주행이면 NULL
  • mode — ENUM('SINGLE', 'GROUP') — NOT NULL
  • start_name — VARCHAR(150)
  • destination_name — VARCHAR(150)
  • distance_m — INT — 총 거리(m)
  • duration_sec — INT — 총 시간(sec)
  • ranking — INT — 그룹 주행 순위
  • saved_time_sec — INT — 절약 시간
  • result_status — ENUM('COMPLETED', 'CANCELED', 'FAILED') — NOT NULL
  • started_at — DATETIME
  • ended_at — DATETIME
  • created_at — DATETIME — NOT NULL

user_information

  • user_uuid — CHAR(36) — Primary key — NOT NULL — 사용자 UUID
  • user_id — VARCHAR(12) — 로컬 로그인용 아이디. 소셜 전용 계정은 NULL 가능
  • email — VARCHAR(255) — NOT NULL — 대표 이메일
  • nickname — VARCHAR(10) — NOT NULL — 닉네임
  • password_hash — VARCHAR(255) — bcrypt 해시 비밀번호. 소셜 전용 계정은 NULL 가능
  • account_type — ENUM('LOCAL', 'SOCIAL', 'HYBRID') — NOT NULL — 계정 유형
  • status — ENUM('ACTIVE', 'WITHDRAWAL_PENDING', 'SUSPENDED') — NOT NULL — 계정 상태
  • email_verified_at — DATETIME — 이메일 인증 완료 시각
  • last_login_at — DATETIME — 마지막 로그인 시각
  • password_changed_at — DATETIME — 마지막 비밀번호 변경 시각
  • withdrawal_requested_at — DATETIME — 탈퇴 요청 시각
  • deletion_reserved_until — DATETIME — 탈퇴 확정 예정 시각
  • created_at — DATETIME — NOT NULL — 계정 생성 시각
  • updated_at — DATETIME — NOT NULL — 계정 수정 시각

user_profile

  • user_uuid — CHAR(36) — Foreign key → user_information.user_uuid — NOT NULL
  • profile_image_url — VARCHAR(500) — 프로필 이미지 URL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

user_settings

  • user_uuid — CHAR(36) — Foreign key → user_information.user_uuid — NOT NULL
  • default_navi — ENUM('KAKAO','NAVER','TMAP','NONE') — NOT NULL
  • location_share_enabled — TINYINT(1) — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL