ㄷ
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