Amp

Tables (7)

admin_action

  • action_id — BIGINT
  • admin_id — BIGINT — NOT NULL
  • target_type — ENUM('POST', 'COMMENT', 'USER', 'REPORT') — NOT NULL
  • target_id — BIGINT — NOT NULL
  • action_type — ENUM('APPROVE', 'REJECT', 'HIDE', 'DELETE', 'SUSPEND') — NOT NULL
  • reason — TEXT
  • created_at — DATETIME — NOT NULL

attachment

  • attachment_id — BIGINT
  • post_id — BIGINT — NOT NULL
  • uploader_id — BIGINT — NOT NULL
  • file_url — VARCHAR(500) — NOT NULL
  • file_type — VARCHAR(50) — NOT NULL
  • created_at — DATETIME — NOT NULL

comment

  • comment_id — BIGINT
  • post_id — BIGINT — NOT NULL
  • author_id — BIGINT — NOT NULL
  • parent_comment_id — BIGINT
  • content — TEXT — NOT NULL
  • status — ENUM('NORMAL', 'HIDDEN', 'DELETED') — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

post

  • post_id — BIGINT
  • author_id — BIGINT — NOT NULL
  • title — VARCHAR(255) — NOT NULL
  • content — TEXT — NOT NULL
  • status — ENUM( 'DRAFT', 'SUBMITTED', 'APPROVED', 'REJECTED', 'PUBLISHED', 'HIDDEN', 'DELETED' ) — NOT NULL
  • visibility — ENUM('PUBLIC', 'PRIVATE') — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

post_history

  • history_id — BIGINT
  • post_id — BIGINT — NOT NULL
  • changed_by — BIGINT — NOT NULL
  • prev_status — ENUM( 'DRAFT', 'SUBMITTED', 'APPROVED', 'REJECTED', 'PUBLISHED', 'HIDDEN', 'DELETED' ) — NOT NULL
  • new_status — ENUM( 'DRAFT', 'SUBMITTED', 'APPROVED', 'REJECTED', 'PUBLISHED', 'HIDDEN', 'DELETED' ) — NOT NULL
  • reason — TEXT
  • created_at — DATETIME — NOT NULL

report

  • report_id — BIGINT
  • reporter_id — BIGINT — NOT NULL
  • target_type — ENUM('POST', 'COMMENT') — NOT NULL
  • target_id — BIGINT — NOT NULL
  • reason — TEXT — NOT NULL
  • status — ENUM('RECEIVED', 'IN_REVIEW', 'RESOLVED', 'REJECTED') — NOT NULL
  • created_at — DATETIME — NOT NULL

user

  • user_id — BIGINT
  • email — VARCHAR(255) — NOT NULL
  • nickname — VARCHAR(100) — NOT NULL
  • role — ENUM('USER', 'ADMIN') — NOT NULL
  • status — ENUM('ACTIVE', 'SUSPENDED', 'DELETED') — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL