Board
Tables (5)
Board (게시판)
- board_id (아이디) — NOTNULL — Primary key — NOT NULL
- image_id (아이디2) — NOT NULL — Foreign key → upload_image.image_id — NOT NULL
- Member_id (아이디3) — NOT NULL — Foreign key → member.Member_id — NOT NULL
- title (제목) — NULL
- like_cnt (좋아요 수) — NULL
- comment_cnt (댓글 수) — NULL
- body (내용) — NULL
comment (댓글)
- comment_id (아이디) — NOT NULL — Primary key — NOT NULL
- Member_id (아이디2) — NOT NULL — Foreign key → member.Member_id — NOT NULL
- board_id (아이디3) — NOTNULL — Foreign key → Board.board_id — NOT NULL
- image_id (아이디22) — NOT NULL — Foreign key → Board.image_id — NOT NULL
- Member_id (아이디32) — NOT NULL — Foreign key → Board.Member_id — NOT NULL
- body (내용) — NULL
- last_modified_at (마지막 수정일시) — NULL
- created_at (만든날짜) — NULL
like (좋아요)
- like_id (아이디) — NOT NULL — Primary key — NOT NULL
- Member_id (아이디2) — NOT NULL — Foreign key → member.Member_id — NOT NULL
- board_id (아이디3) — NOTNULL — Foreign key → Board.board_id — NOT NULL
- image_id (아이디22) — NOT NULL — Foreign key → Board.image_id — NOT NULL
- Member_id (아이디32) — NOT NULL — Foreign key → Board.Member_id — NOT NULL
- name (이름) — NULL
member (사용자)
- Member_id (아이디) — NOT NULL — Primary key — NOT NULL
- name (이름) — NULL
- password (비밀번호) — NULL
- phone (전화번호) — NULL
- email (이메일) — NULL
- registered_at (가입일시) — NULL
upload_image (사진 첨부)
- image_id (아이디) — NOT NULL — Primary key — NOT NULL
- original_filename (원본파일명) — NULL
- saved_filename (서버저장파일명) — NULL