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