sss
Tables (8)
api_logs
- log_id — INT
- user_id — INT
- endpoint — VARCHAR(100) — NOT NULL
- method — ENUM('GET', 'POST', 'PUT', 'DELETE', 'PATCH') — NOT NULL
- request_data — JSON
- response_code — INT
- response_time — INT
- created_at — TIMESTAMP
comments
- comment_id — INT
- post_id — INT — NOT NULL
- user_id — INT — NOT NULL
- content — TEXT — NOT NULL
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
post_tags
- post_id — INT — Primary key — NOT NULL
- tag_id — INT — Primary key — NOT NULL
posts
- post_id — INT
- title — VARCHAR(200) — NOT NULL
- content — TEXT
- user_id — INT — NOT NULL
- status — ENUM('draft', 'published', 'archived')
- view_count — INT
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
roles
- role_id — INT
- name — VARCHAR(50) — NOT NULL
- description — VARCHAR(255)
tags
- tag_id — INT
- name — VARCHAR(50) — NOT NULL
- created_at — TIMESTAMP
user_roles
- user_id — INT — Primary key — NOT NULL
- role_id — INT — Primary key — NOT NULL
users
- user_id — INT
- username — VARCHAR(50) — NOT NULL
- email — VARCHAR(100) — NOT NULL
- password — VARCHAR(255) — NOT NULL
- full_name — VARCHAR(100)
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
- last_login — TIMESTAMP
- is_active — BOOLEAN