CatDB
Tables (3)
Board (게시판)
- board_id (게시글 id) — Primary key — NOT NULL
- title (제목)
- content (내용)
- category (카테고리)
- reg_date (작성일)
- img_url (이미지)
- member_id (회원 id) — Foreign key → Member.member_id — NOT NULL
Comment (댓글)
- comment_id (댓글 id) — Primary key — NOT NULL
- content (내용)
- reg_date (작성일)
- board_id (게시글 id) — Foreign key → Board.board_id — NOT NULL
- member_id (회원 id) — Foreign key → Member.member_id — NOT NULL
Member (회원)
- member_id (회원 id) — Primary key — NOT NULL
- email (이메일)
- password (비밀번호)
- nickname (닉네임)
- role (관리자또는 유저)