travel pjt

Tables (11)

CampTag

  • tagId — int — Primary key — NOT NULL
  • campId — int — Foreign key → Total_Camp_List.campId — NOT NULL
  • hashtag — varchar(20)

Comment

  • commentId — int — Primary key — NOT NULL
  • userId — int — Foreign key → User.userId — NOT NULL
  • boardId — int — Foreign key → Community.boardId — NOT NULL
  • uploadDate — date
  • content — text
  • depth — int
  • bundle — int

Community

  • boardId — int — Primary key — NOT NULL
  • userId — int — Foreign key → User.userId — NOT NULL
  • uploadDate — date
  • title — varchar(30)
  • content — text
  • click — int
  • dType — int

CommunityFile

  • fileId — int — Primary key — NOT NULL
  • boardId — int — Foreign key → Community.boardId — NOT NULL
  • name — varchar(100)
  • filePath — varchar(200)
  • fileType — varchar(10)
  • fileSize — INT
  • saveName — varchar(200)

CommunityLike

  • userId — int — Foreign key → User.userId — NOT NULL
  • boardId — int — Foreign key → Community.boardId — NOT NULL

CommunityTag

  • tagId — int — Primary key — NOT NULL
  • boardId — int — Foreign key → Community.boardId — NOT NULL
  • tagWord — varchar(20)

Sound

  • soundId — Primary key — NOT NULL
  • title — varchar(50)
  • link — varchar(200)

Total_Camp_List (TotalCampList)

  • campId — int — Primary key — NOT NULL
  • facltNm — varchar(100)
  • lineIntro — text
  • intro — text
  • bizrno — varchar(100)
  • doNm — varchar(20)
  • sigunguNm — varchar(20)
  • addr1 — varchar(400)
  • addr2 — varchar(400)
  • mapX — varchar(20)
  • mapY — varchar(20)
  • tel — varchar(300)
  • homepage — varchar(300)
  • resveUrl — text
  • resveCl — varchar(40)
  • firstImageUrl — text

User

  • userId — int — Primary key — NOT NULL
  • userName — VARCHAR(20)
  • email — varchar(100)
  • nickname — varchar(30)
  • tel — varchar(30)
  • birth — date
  • auth — boolean
  • password — varchar(30)
  • profileImg — varchar(200)

liked_camp_list (LikedCampList)

  • saveId — int — Primary key — NOT NULL
  • userId — int — Foreign key → User.userId — NOT NULL
  • campId — int — Foreign key → Total_Camp_List.campId — NOT NULL
  • startDate — date
  • endDate — date

todolist (TodoList)

  • todoId — int — Primary key — NOT NULL
  • userId — int — Foreign key → liked_camp_list.userId — NOT NULL
  • saveId — int — Foreign key → liked_camp_list.saveId — NOT NULL
  • task — varchar(100)
  • done — boolean