SEED
Tables (9)
Board
- board_id — INT
- user_id — INT — NOT NULL
- title — VARCHAR(100) — NOT NULL
- content — TEXT — NOT NULL
- created_at — DATETIME
- updated_at — DATETIME
Code_post
- post_id — INT
- user_id — INT — NOT NULL
- title — VARCHAR(50) — NOT NULL
- content — TEXT — NOT NULL
- file_url — LONGTEXT
- created_at — DATETIME
- updated_at — DATETIME
Comment
- comment_id — INT
- idea_id — INT — NOT NULL
- user_id — INT — NOT NULL
- author_id — INT — NOT NULL
- content — TEXT — NOT NULL
- created_at — DATETIME
- updated_at — DATETIME
Event
- event_id — INT
- title — VARCHAR(50) — NOT NULL
- content — TEXT
- start_date — DATETIME — NOT NULL
- end_date — DATETIME — NOT NULL
- file_url — LONGTEXT
- created_at — DATETIME
- updated_at — DATETIME
Event_apply
- apply_id — INT
- user_id — INT — NOT NULL
- event_id — INT — NOT NULL
Idea_post
- idea_id — INT
- user_id — INT — NOT NULL
- title — VARCHAR(50) — NOT NULL
- content — TEXT — NOT NULL
- file_url — LONGTEXT
- created_at — DATETIME
- updated_at — DATETIME
Model_post
- post_id — INT
- user_id — INT — NOT NULL
- title — VARCHAR(50) — NOT NULL
- content — TEXT — NOT NULL
- file_url — LONGTEXT
- created_at — DATETIME
- updated_at — DATETIME
Token_blacklist
- id — INT
- token — VARCHAR(255) — NOT NULL
- expiration_time — DATETIME — NOT NULL
User
- user_id — INT
- username — VARCHAR(50) — NOT NULL
- password — VARCHAR(255) — NOT NULL
- email — VARCHAR(60) — NOT NULL
- role — ENUM('admin', 'user', 'pending') — NOT NULL
- created_at — DATETIME
- updated_at — DATETIME