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