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