게시판 ERD AI 활용
테이블 (4)
boards
- board_id — SERIAL
- board_name — VARCHAR(100) — NOT NULL
- description — TEXT
- created_at — TIMESTAMP
comments
- comment_id — SERIAL
- post_id — INT — NOT NULL
- user_id — INT — NOT NULL
- content — TEXT — NOT NULL
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
posts
- post_id — SERIAL
- board_id — INT — NOT NULL
- user_id — INT — NOT NULL
- title — VARCHAR(255) — NOT NULL
- content — TEXT — NOT NULL
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
users
- user_id — SERIAL
- username — VARCHAR(50) — NOT NULL
- password — VARCHAR(255) — NOT NULL
- email — VARCHAR(100) — NOT NULL
- created_at — TIMESTAMP