tripbook
Tables (10)
courseMedia
- mediaIdx — int unsigned — Primary key — NOT NULL
- courseIdx — int unsigned — Foreign key → tripCourse.courseIdx — NOT NULL
- mediaUrl — text
- createAt — TIMESTAMP DEFAULT CURRENT_TIMESTAMP
- updateAt — TIMESTAMP DEFAULT CURRENT_TIMESTAMP
- status — varchar(10)
hashtag
- hashtagIdx — int unsigned — Primary key — NOT NULL
- tagName — varchar(30)
- tagType — VARCHAR(255)
- createAt — TIMESTAMP DEFAULT CURRENT_TIMESTAMP
- updateAt — TIMESTAMP DEFAULT CURRENT_TIMESTAMP
- status — varchar(10)
region
- regionIdx — int unsigned — Primary key — NOT NULL
- courseIdx — int unsigned — Foreign key → tripCourse.courseIdx — NOT NULL
- region1 — varchar(100)
- region2 — varchar(100)
- createAt — TIMESTAMP DEFAULT CURRENT_TIMESTAMP
- updateAt — TIMESTAMP DEFAULT CURRENT_TIMESTAMP
- status — varchar(10)
tagCourseIdxRelationships
- relationIdx — int unsigned — Primary key — NOT NULL
- courseIdx — int unsigned — Foreign key → tripCourse.courseIdx — NOT NULL
- hashtagIdx — int unsigned — Foreign key → hashtag.hashtagIdx — NOT NULL
- createAt — TIMESTAMP DEFAULT CURRENT_TIMESTAMP
- updateAt — TIMESTAMP DEFAULT CURRENT_TIMESTAMP
- status — varchar(10)
themaUserRelationships
- relationIdx — int unsigned — Primary key — NOT NULL
- userIdx — int unsigned — Foreign key → user.userIdx — NOT NULL
- themeIdx — int unsigned — Foreign key → theme.themeIdx — NOT NULL
- Field
theme
- themeIdx — int unsigned — Primary key — NOT NULL
- themeName — varchar(30)
- themeImg — text
- createAt — TIMESTAMP DEFAULT CURRENT_TIMESTAMP
- updateAt — TIMESTAMP DEFAULT CURRENT_TIMESTAMP
- status — varchar(10)
trip
- tripIdx — int unsigned — Primary key — NOT NULL
- userIdx — int unsigned — Foreign key → user.userIdx — NOT NULL
- themeIdx — int unsigned — Foreign key → theme.themeIdx — NOT NULL
- tripTitle — varchar(100)
- departureDate — date
- arrivalDate — date
- tripImg — text
- createAt — TIMESTAMP DEFAULT CURRENT_TIMESTAMP
- updateAt — TIMESTAMP DEFAULT CURRENT_TIMESTAMP
- status — varchar(10)
tripCourse
- courseIdx — int unsigned — Primary key — NOT NULL
- tripIdx — int unsigned — Foreign key → trip.tripIdx — NOT NULL
- courseTitle — varchar(100)
- comment — varchar(255)
- courseDate — date
- time — int
- createAt — TIMESTAMP DEFAULT CURRENT_TIMESTAMP
- updateAt — TIMESTAMP DEFAULT CURRENT_TIMESTAMP
- status — varchar(10)
user (tb_user)
- userIdx — int unsigned — Primary key — NOT NULL
- email — varchar(100)
- password — varchar(200)
- createAt — TIMESTAMP DEFAULT CURRENT_TIMESTAMP
- updateAt — TIMESTAMP DEFAULT CURRENT_TIMESTAMP
- status — varchar(10)
userProfile
- userProfileIdx — int unsigned — Primary key — NOT NULL
- userIdx — int unsigned — Foreign key → user.userIdx — NOT NULL
- nickName — varchar(30)
- userImg — text — 유저 프로필 이미지
- comment — varchar(255)
- snsId — varchar(100)
- createAt — TIMESTAMP DEFAULT CURRENT_TIMESTAMP
- updateAt — TIMESTAMP DEFAULT CURRENT_TIMESTAMP
- status — varchar(10)