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