spring_advanced_board-ERD
Tables (4)
board
- id — BIGINT — Primary key
- name — VARCHAR(255) — NOT NULL
- description — VARCHAR(255)
- status — VARCHAR(20) — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
- Field — VARCHAR(20)
comment
- id — BIGINT — Primary key
- post_id — BIGINT — NOT NULL
- user_id — BIGINT — NOT NULL
- content — TEXT — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
- status — VARCHAR(20)
- id (id2) — BIGINT — Foreign key → user.id — NOT NULL
- id (id3) — BIGINT — Foreign key → post.id
post
- id — BIGINT — Primary key
- board_id — BIGINT — NOT NULL
- user_id — BIGINT — NOT NULL
- title — VARCHAR(255) — NOT NULL
- content — TEXT — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
- status — VARCHAR(20)
- id (id2) — BIGINT — Foreign key → user.id — NOT NULL
- board_id (id3) — BIGINT — Foreign key → board.id
user
- id — BIGINT — Primary key — NOT NULL
- username — VARCHAR(255) — NOT NULL
- password — VARCHAR(255) — NOT NULL
- email — VARCHAR(255) — NOT NULL
- role — VARCHAR(50) — NOT NULL
- status — VARCHAR(20) — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL