bbb
Tables (7)
Attachment
- file_id — INT — Primary key
- post_id — INT — Foreign key → Post.post_id
- user_id — INT — Foreign key → Post.user_id
- board_id — INT — Foreign key → Post.board_id
- file_name — VARCHAR(255) — NOT NULL
- file_url — VARCHAR(255) — NOT NULL
Board
- board_id — INT — Primary key
- board_name — VARCHAR(100) — NOT NULL
- description — TEXT
Comment
- comment_id — INT — Primary key
- user_id — INT — Foreign key → User.user_id
- post_id — INT — Foreign key → Post.post_id
- board_id — INT — Foreign key → Post.board_id
- content — TEXT — NOT NULL
- created_at — TIMESTAMP
Like
- like_id — INT — Primary key
- comment_id — INT — Foreign key → Comment.comment_id
- user_id — INT — Foreign key → Comment.user_id
- post_id — INT — Foreign key → Comment.post_id
- board_id — INT — Foreign key → Comment.board_id
- target_id — INT
Post
- post_id — INT — Primary key
- user_id — INT — Foreign key → User.user_id
- board_id — INT — Foreign key → Board.board_id
- title — VARCHAR(255) — NOT NULL
- content — TEXT — NOT NULL
- view_count — INT
- created_at — TIMESTAMP
Recommendation
- rec_id — INT — Primary key
- user_id — INT — Foreign key → User.user_id
- post_id — INT — Foreign key → Post.post_id
- board_id — INT — Foreign key → Post.board_id
- created_at — TIMESTAMP
User
- user_id — INT — Primary key
- username — VARCHAR(50) — NOT NULL
- email — VARCHAR(100) — NOT NULL
- password — VARCHAR(255) — NOT NULL
- created_at — TIMESTAMP