NoticeBoard
Tables (4)
Board (게시판)
- board_id (게시판ID) — INT — Primary key — NOT NULL
- writer (작성자) — VARCHAR(50)
- title (제목) — VARCHAR(50)
- content (내용) — VARCHAR(1000)
- registration_date (등록날짜) — DATETIME
- update_date (수정일자) — DATETIME
- member_id (멤버ID) — INT — Foreign key → Member.member_id
Member (유저)
- member_id (멤버ID) — INT — Primary key — NOT NULL
- id (아이디) — VARCHAR(50)
- password (비밀번호) — VARCHAR(50)
Photo (사진)
- photo_id (사진ID) — INT — Primary key — NOT NULL
- URL (사진URL) — VARCHAR(255)
- board_id (게시판ID) — INT — Foreign key → Board.board_id — NOT NULL
Reply (댓글)
- reply_id (댓글ID) — INT — Primary key — NOT NULL
- writer (작성자) — VARCHAR(50)
- content (내용) — VARCHAR(300)
- registration_date (등록일자) — DATETIME
- update_date (수정일자) — DATETIME
- board_id (게시판ID) — INT — Foreign key → Board.board_id — NOT NULL