Side
Tables (8)
admin_activity_logs
- log_id — BIGINT
- user_id — VARCHAR(16) — Foreign key → users.user_id
- action_type — VARCHAR(50) — NOT NULL
- before_value — TEXT
- created_at — TIMESTAMP
duplicate_reports
- duplicate_id — BIGINT
- report_id2 — BIGINT
- user_id — VARCHAR(16) — Foreign key → users.user_id
- original_report_id — BIGINT — NOT NULL
- report_reason — TEXT
- created_at — TIMESTAMP
email_verification_tokens
- token_id — BIGINT
- user_id — VARCHAR(16) — Foreign key → users.user_id
- token — VARCHAR(255) — NOT NULL
- expires_at — TIMESTAMP — NOT NULL
- is_used — BOOLEAN
- created_at — TIMESTAMP
report_attachments
- attachment_id — BIGINT
- report_id — BIGINT
- user_id2 — VARCHAR(16)
- file_type — ENUM('IMAGE', 'AUDIO') — NOT NULL
- file_path — VARCHAR(500) — NOT NULL
- file_name — VARCHAR(255) — NOT NULL
- file_size — INT
- weight_score — INT
report_evaluations
- evaluation_id — BIGINT
- report_id — BIGINT
- user_id — VARCHAR(16) — Foreign key → users.user_id
- evaluation_type — ENUM('LIKE', 'DISLIKE') — NOT NULL
- created_at — TIMESTAMP
report_restrictions
- restriction_id — BIGINT
- user_id — VARCHAR(16) — Foreign key → users.user_id
- phone_number — VARCHAR(20) — NOT NULL
- restricted_until — TIMESTAMP — NOT NULL
- created_at — TIMESTAMP
spam_types
- spam_type_id — INT
- type_name — VARCHAR(50) — NOT NULL
- description — TEXT
- created_at — TIMESTAMP
users
- user_id — VARCHAR(16)
- email — VARCHAR(255) — NOT NULL
- password — VARCHAR(255)
- name — VARCHAR(100) — NOT NULL
- nickname — VARCHAR(50) — NOT NULL
- phone — VARCHAR(20)
- provider — VARCHAR(20)
- provider_id — VARCHAR(255)
- email_verified — BOOLEAN
- login_fail_count — INT
- last_login_attempt — TIMESTAMP
- login_blocked_until — TIMESTAMP
- created_at — TIMESTAMP
- updated_at — TIMESTAMP