FBPR
Tables (3)
Comment (댓글)
- id (댓글_id) — Primary key — NOT NULL
- comment (내용)
- createdDate (생성날짜)
- modifiedDate (수정날짜)
- id (사용자_id) — Foreign key → Member.id — NOT NULL
- id (게시판_id) — Foreign key → FreeBoard.id — NOT NULL
FreeBoard (게시판)
- id (게시판_id) — Primary key — NOT NULL
- content (내용)
- title (제목)
- createdDate (생성날짜)
- modifiedDate (수정날짜)
- id (사용자_id) — Foreign key → Member.id — NOT NULL
Member (멤버)
- id (사용자_id) — Primary key — NOT NULL
- name (이름)
- email (이메일)
- password (비밀번호)
- memberRole (사용자/관리자)