darak
Tables (8)
friendships
- user_id — CHAR(36) — Primary key — NOT NULL
- friend_id — CHAR(36) — Primary key — NOT NULL
- status — ENUM('PENDING', 'ACCEPTED', 'BLOCKED') — NOT NULL
- created_at — DATETIME — NOT NULL
images
- id — CHAR(36)
- owner_id — CHAR(36) — NOT NULL
- url — TEXT — NOT NULL
- is_profile_photo — BOOLEAN — NOT NULL
- uploaded_at — DATETIME — NOT NULL
match_requests
- id — CHAR(36)
- requester_id — CHAR(36) — NOT NULL
- target_id — CHAR(36) — NOT NULL
- status — ENUM('PENDING', 'ACCEPTED', 'REJECTED', 'EXPIRED') — NOT NULL
- requested_at — DATETIME — NOT NULL
matches
- id — CHAR(36)
- user_a — CHAR(36) — NOT NULL
- user_b — CHAR(36) — NOT NULL
- matched_at — DATETIME — NOT NULL
- CHECK — (user_a <> user_b)
phone_verifications
- id — CHAR(36)
- user_id — CHAR(36) — NOT NULL
- phone — VARCHAR(20) — NOT NULL
- otp_code — VARCHAR(10) — NOT NULL
- verified — BOOLEAN — NOT NULL
- requested_at — DATETIME — NOT NULL
profiles
- user_id — CHAR(36)
- nickname — VARCHAR(50) — NOT NULL
- real_name — VARCHAR(50)
- intro — TEXT
- updated_at — DATETIME — NOT NULL
sessions
- id — CHAR(36)
- user_id — CHAR(36) — NOT NULL
- jwt_id — VARCHAR(64) — NOT NULL
- ip_addr — VARCHAR(45)
- expires_at — DATETIME — NOT NULL
users
- id — CHAR(36)
- email — VARCHAR(255) — NOT NULL
- password_hash — VARCHAR(255) — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
- is_deleted — BOOLEAN — NOT NULL