ImHereMSA

Tables (10)

fcm_token

  • id — BIGINT — Primary key — NOT NULL
  • user_id (사용자 id) — BINARY(16) — NOT NULL
  • token — VARCHAR(255) — NOT NULL
  • device_type (기기정보) — ENUM('AOS', 'IOS') — NOT NULL
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP
  • created_by — VARCHAR(255)
  • updated_by — VARCHAR(255)

friend_relationships (확정된 친구 관계)

  • id — UUID — Primary key — NOT NULL
  • owner_user_id (기준 사용자 UUID) — UUID — Foreign key → users.user_id — NOT NULL
  • friend_user_id (대상 친구 UUID) — UUID — Foreign key → users.user_id — NOT NULL
  • friend_alias (내가 설정한 친구의 이름) — VARCHAR(255)
  • created_at (친구 관계 수락 일시) — TIMESTAMP

friend_requests (친구 요청)

  • id — BIGINT — Primary key — NOT NULL
  • requester_id (신청자 UUID) — UUID — Foreign key → users.user_id — NOT NULL
  • receiver_id (수신자 UUID) — UUID — Foreign key → users.user_id — NOT NULL
  • message (요청 메시지) — VARCHAR(255)
  • created_at (신청 일자) — TIMESTAMP

friend_restrictions (거절/차단 친구들)

  • id — BIGINT — Primary key — NOT NULL
  • actor_id (차단/거절을 수행한 사용자) — UUID — Foreign key → users.user_id — NOT NULL
  • target_user (대상 친구 UUID) — UUID — Foreign key → users.user_id — NOT NULL
  • type (타입) — ENUM(BLOCK, REJECT)
  • created_at (차단/거절 일시) — TIMESTAMP

location_logs (위치 기록)

  • id — BIGSERIAL — Primary key — NOT NULL
  • masked_uuid (SHA-256 해싱된 유저 UUID) — VARCHAR(64) — NOT NULL
  • latitude — NUMERIC(10, 8) — NOT NULL
  • longitude — NUMERIC(11, 8) — NOT NULL
  • created_at (수집 시간) — TIMESTAMP

notification_log (발송 결과)

  • id — BIGINT — Primary key — NOT NULL
  • sender_id (발송자) — VARCHAR(255) — NOT NULL
  • receiver (수신자) — VARCHAR(255), UUID 혹은 전화번호 — NOT NULL
  • type (발송 타입) — ENUM('SMS, 'PUSH') — NOT NULL
  • result (결과코드) — VARCHAR(50)
  • created_at (발송 요청 시간) — TIMESTAMP

term_definitions (약관 종류)

  • id — LONG — Primary key — NOT NULL
  • terms_types (약관 종류) — ENUM(SERVICE, PRIVACY, LOCATION)
  • terms_name (약관 이름) — VARCHAR(255)
  • is_required (필수 동의 여부) — boolean

terms_version (약관 상세 버전)

  • version_id (id) — LONG — Primary key — NOT NULL
  • terms_type_id (id2) — LONG — Foreign key → term_definitions.id — NOT NULL
  • version (버전 이름) — VARCHAR(255)
  • content (약관 내용) — TEXT
  • is_active (활성화 여부) — BOOLEAN
  • effective_date (법적 실행일) — TIMESTAMP
  • created_at (생성일) — TIMESTAMP

user_agreement (유저 동의 이력)

  • agreement_id (Key) — UUID — Primary key — NOT NULL
  • user_id — UUID — Foreign key → users.user_id — NOT NULL
  • version_id (id2) — LONG — Foreign key → terms_version.version_id — NOT NULL
  • terms_type_id (id22) — LONG — Foreign key → terms_version.terms_type_id — NOT NULL
  • created_at (동의일시) — TIMESTAMP
  • Field

users (사용자)

  • user_id — UUID — Primary key — NOT NULL
  • email — VARCHAR(255)
  • nickname — VARCHAR(255)
  • role (역할) — ENUM
  • provider (OAtuh2 제공자) — ENUM
  • status (사용자 상태) — ENUM(PENDING, ACTIVE)
  • creaeted_at (가입일) — TIMESTAMP
  • updated_at (업데이트 일자) — TIMESTAMP