yogiyong_in
Tables (7)
aiReviewSummaries (AiReviewSummaries)
- summaryId — INT — Primary key — NOT NULL
- model — VARCHAR(50)
- summaryCont — TEXT
- festivalId — INT — Foreign key → festival.festivalId — NOT NULL
bookmark (Bookmark)
- bookmarkId — INT — Primary key — NOT NULL
- userId — VARCHAR(20) — Foreign key → user.userId — NOT NULL
- festivalId — INT — Foreign key → festival.festivalId — NOT NULL
festival (Festival)
- festivalId — INT — Primary key — NOT NULL
- festivalName — VARCHAR(100)
- festivalDesc — TEXT
- festivalStart — DATE
- festivalEnd — DATE
- festivalLoca — VARCHAR(50)
- imagePath — VARCHAR(255) — NOT NULL
keyword (Keyword)
- keywordId — INT — Primary key — NOT NULL
- keywordName — String
- imagePath — String
review (Review)
- reviewId — INT — Primary key — NOT NULL
- reviewTitle — VARCHAR(100)
- reviewCont — TEXT
- createdAt — timestamp
- userId — VARCHAR(20) — Foreign key → user.userId — NOT NULL
- festivalId — INT — Foreign key → festival.festivalId — NOT NULL
user (User)
- userId — String — Primary key — NOT NULL
- password — String
- nickname — String
- birthYear — INT
userKeyword (UserKeyword)
- userKeywordId — INT — Primary key — NOT NULL
- isSelected — BOOLEAN
- userId — String — Foreign key → user.userId — NOT NULL
- keywordId — INT — Foreign key → keyword.keywordId — NOT NULL