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