board
Tables (4)
Board (게시판)
- board_id (Key) — Primary key — NOT NULL
- member_id (Key2) — Foreign key → Member.member_id — NOT NULL
- title (Field)
- wirter (Field2)
- content (Field3)
- member_id (Field4)
- likes (Field5)
- views (Field6)
Comments (댓글)
- comment_id (Key) — Primary key — NOT NULL
- board_id (Key2) — Foreign key → Board.board_id — NOT NULL
- member_id (Key3) — Foreign key → Member.member_id — NOT NULL
- text (Field)
- Field2
- Field3
- Field4
Member (사용자)
- member_id (Key) — Primary key — NOT NULL
- username (Field)
- password (Field2)
- role (Field3)
MembmerBoardView (게시판 읽음)
- member_board_view_id (Key) — Primary key — NOT NULL
- board_id (Key2) — Foreign key → Board.board_id — NOT NULL
- member_id (Key3) — Foreign key → Member.member_id — NOT NULL