travel pjt
Tables (8)
Comment (댓글)
- userId (유저id) — int — Foreign key → User.userId — NOT NULL
- boardId (게시판id) — int — Foreign key → Community.boardId — NOT NULL
- uploadDate (댓글 날짜) — date
- content (내용) — text
- reComment (계층) — int
- bundle (부모댓글id) — int
Community (게시판)
- boardId (게시판id) — int — Primary key — NOT NULL
- uploadDate (게시날짜) — date
- title (제목) — varchar
- content (내용) — text
- click (조회수) — int
- dType (게시판 type) — int
CommunityLike (좋아요)
- userId (유저id) — int — Foreign key → User.userId — NOT NULL
- boardId (게시판id) — int — Foreign key → Community.boardId — NOT NULL
Sound (사운드)
- soundId (사운드id) — Primary key — NOT NULL
- title (사운드제목)
- link (사운드링크)
Total_Camp_List (캠핑장 전체 목록)
- campId (캠핑장id) — int — Primary key — NOT NULL
- facltNm (야영장명) — varchar(200)
- lineIntro (한줄소개) — varchar
- intro (소개) — text
- bizrno (사업자번호) — varchar
- doNm (도) — varchar
- sigunguNm (시군구) — varchar
- addr1 (주소) — varchar
- addr2 (주소상세) — varchar
- mapX (경도(x)) — varchar
- mapY (위도(Y)) — varchar
- tel (전화) — varchar
- hompage (홈페이지) — varchar
- resveUrl (예약페이지) — varchar
- resveCl (예약 구분) — varchar
- firstImageUrl (대표이미지) — varchar
- themaEnvrnCl (테마환경) — varchar
- sbrsCl (부대시설) — varchar
- animalCmgCl (애완동물출입) — varchar
- induty (업종) — varchar
- eqpmnLendCl (캠핑장비대여) — varchar
- tourEraCl (여행시기) — varchar
- lctCl (입지구분) — varchar
User (유저)
- userId (유저id) — int — Primary key — NOT NULL
- userName (이름) — VARCHAR(50)
- email (이메일) — varchar(200)
- nickname (닉네임) — varchar(100)
- tel (전화번호) — varchar(100)
- birth (생년월일) — date
- auth (접근권한) — bool
- password (비밀번호) — varchar
liked_camp_list (저장 캠핑장)
- saveId (저장캠핑장id) — int — Primary key — NOT NULL
- userId (유저id) — int — Foreign key → User.userId — NOT NULL
- campId (캠핑장id) — int — Foreign key → Total_Camp_List.campId — NOT NULL
- startDate (여행시작일) — date
- endDate (여행끝나는일) — date
todolist (Untitled)
- todoId (투두id) — int — Primary key — NOT NULL
- saveId (저장캠핑장id) — int — Foreign key → liked_camp_list.saveId — NOT NULL
- userId (유저id) — int — Foreign key → liked_camp_list.userId — NOT NULL
- task (업무) — varchar
- done (done여부) — boolean