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