simple board
Tables (3)
Board (게시판)
- id (게시판 번호) — int — Primary key — NOT NULL
- name (게시판 이름) — char
- description (게시판 설명) — char
User (계정)
- id (Key) — int — Primary key — NOT NULL
- username (유저명) — char
- email (이메일) — char
- password (비밀번호) — char
posts (게시글)
- id (pk) — int — Primary key — NOT NULL
- author_id (유저명) — char — Foreign key → User.id — NOT NULL
- board_id (게시판번호) — int — Foreign key → Board.id — NOT NULL
- title (제목) — char
- body (내용) — char
- Field