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