한빛마트
테이블 (4)
DeletedPosts
- deleted_post_id — INT
- post_id — INT — NOT NULL
- deleted_by_user_id — INT — NOT NULL
- deleted_at — DATETIME
- reason — TEXT — NOT NULL
- is_notified — TINYINT(1) — NOT NULL
Notifications
- notification_id — INT
- user_id — INT — NOT NULL
- type — VARCHAR(50) — NOT NULL
- title — VARCHAR(255) — NOT NULL
- message — TEXT — NOT NULL
- related_id — INT
- is_read — TINYINT(1) — NOT NULL
- created_at — DATETIME
Posts
- post_id — INT
- user_id — INT — NOT NULL
- title — VARCHAR(255) — NOT NULL
- content — TEXT — NOT NULL
- created_at — DATETIME
- updated_at — DATETIME
- view_count — INT
- is_deleted — TINYINT(1) — NOT NULL
- deleted_type — VARCHAR(10)
Users
- user_id — INT
- username — VARCHAR(50) — NOT NULL
- password — VARCHAR(255) — NOT NULL
- email — VARCHAR(100) — NOT NULL
- nickname — VARCHAR(50) — NOT NULL
- created_at — DATETIME
- updated_at — DATETIME
- role — VARCHAR(20) — NOT NULL