whs
Tables (5)
auth_tokens
- id — INT
- user_id — INT — NOT NULL
- token — VARCHAR(512) — NOT NULL
- issued_at — TIMESTAMP
- expires_at — TIMESTAMP
files
- id — INT
- filename — VARCHAR(255)
- stored_path — VARCHAR(255)
- uploaded_by — INT
- uploaded_at — TIMESTAMP
flag
- id — INT
- value — VARCHAR(255) — NOT NULL
posts
- id — INT
- title — VARCHAR(255) — NOT NULL
- content — TEXT — NOT NULL
- author_id — INT
- created_at — TIMESTAMP
users
- id — INT
- username — VARCHAR(50) — NOT NULL
- password — VARCHAR(100) — NOT NULL
- role — ENUM('USER', 'ADMIN')