PathFinder

Tables (3)

board (게시판테이블)

  • 게시글아이디 (id) — PK, AI — Primary key — NOT NULL
  • 멤버닉네임 (memberNickName) — PK, FK, NOT NULL — Foreign key → members.멤버닉네임 — NOT NULL
  • 게시판종류 (boardType) — NOT NULL
  • 게시글제목 (boardTitle) — NOT NULL
  • 게시글내용 (boardContent) — NOT NULL
  • 이미지 (boardImage)
  • 생성날짜 (createDate) — NOT NULL
  • 분류명 (classifiName) — NOT NULL
  • 물건명 (propertyName) — NOT NULL
  • 물건색 (propertyColor) — NOT NULL
  • 분실지역 (area)
  • 분실장소 (place)
  • 장소분류 (placeClassfi) — NOT NULL
  • 휴대폰번호 (phone) — NOT NULL
  • 반려동물명 (petName)
  • 반려동물특징 (petChar)
  • 반려동물종류 (petType)
  • 현상금 (requestCost)
  • 날짜 (Field)
  • 지도좌표 (address)

comment (댓글테이블)

  • 댓글아이디 (id) — PK, AI — Primary key — NOT NULL
  • 게시글아이디 (board_id) — PK, AI — Foreign key → board.게시글아이디 — NOT NULL
  • 멤버닉네임 (memberNickName) — PK, FK, NOT NULL — Foreign key → board.멤버닉네임 — NOT NULL
  • 댓글내용 (content) — NOT NULL
  • 생성날짜 (createdAt) — NOT NULL

members (멤버테이블)

  • 고유아이디 (id) — PK, AI — Primary key — NOT NULL
  • 멤버닉네임 (memberNickName) — PK, FK, NOT NULL — Primary key — NOT NULL
  • 멤버아이디 (memberId) — NOT NULL
  • 멤버비밀번호 (memberPw) — NOT NULL