database
Tables (3)
comments
- comment_id — INT — Primary key — NOT NULL
- post_id — INT — Foreign key → posts.post_id — NOT NULL
- user_id — INT — Foreign key → users.user_id — NOT NULL
- content — TEXT
- created_at — TIMESTAMP
posts
- post_id — INT — Primary key — NOT NULL
- user_id — INT — Foreign key → users.user_id — NOT NULL
- title — VARCHAR(100)
- content — TEXT
- created_at — TIMESTAMP
users
- user_id — INT — Primary key — NOT NULL
- email — VARCHAR(100)
- password — VARCHAR(255)
- nickname — VARCHAR(50)
- created_at — DATETIME