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