festapick

Tables (10)

ChatMessage

  • chatMessageId — BIGINT — Primary key — NOT NULL
  • content — VARCHAR(255) — NOT NULL
  • roomId — BIGINT — Foreign key → ChatRoom.roomId — NOT NULL
  • user_id — BIGINT — Foreign key → users.user_id — NOT NULL

ChatParticipant

  • chatParticipantId — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → users.user_id — NOT NULL
  • roomId — BIGINT — Foreign key → ChatRoom.roomId — NOT NULL

ChatRoom

  • roomId — BIGINT — Primary key — NOT NULL
  • roomName — VARCHAR(255) — NOT NULL
  • festivalId — BIGINT — Foreign key → Festival.id — NOT NULL

Festival

  • id — BIGINT — Primary key — NOT NULL
  • manager_id — BIGINT — Foreign key → users.user_id
  • areaCode — INT — NOT NULL
  • startDate — DATE — NOT NULL
  • endDate — DATE — NOT NULL
  • homePage — VARCHAR(500)
  • overView — VARCHAR(5000) — NOT NULL
  • addr1 — VARCHAR(255) — NOT NULL
  • addr2 — VARCHAR(255)
  • contentId — VARCHAR(255)
  • posterInfo — VARCHAR(255) — NOT NULL
  • title — VARCHAR(255) — NOT NULL
  • state — ENUM — NOT NULL

FileEntity

  • file_id — BIGINT — Primary key — NOT NULL
  • domainId — BIGINT — NOT NULL
  • url — VARCHAR(255) — NOT NULL
  • createdDate — DATETIME(6)
  • domainType — ENUM — NOT NULL
  • fileType — ENUM — NOT NULL

RefreshToken

  • refresh_id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → users.user_id — NOT NULL
  • token — VARCHAR(255) — NOT NULL
  • createdDate — DATETIME(6)

Review

  • review_id — BIGINT — Primary key — NOT NULL
  • festival_id — BIGINT — Foreign key → Festival.id — NOT NULL
  • user_id — BIGINT — NOT NULL
  • score — INT — NOT NULL
  • content — VARCHAR(500) — NOT NULL
  • createdDate — DATETIME(6)
  • updatedDate — DATETIME(6)

TemporalFile

  • id — BIGINT — Primary key — NOT NULL
  • url — VARCHAR(255) — NOT NULL
  • createdDate — DATETIME(6)

Wish

  • wish_id — BIGINT — Primary key — NOT NULL
  • festival_id — BIGINT — Foreign key → Festival.id — NOT NULL
  • user_id — BIGINT — NOT NULL
  • createdDate — DATETIME(6)

users

  • user_id — BIGINT — Primary key — NOT NULL
  • email — VARCHAR(255) — NOT NULL
  • identifier — VARCHAR(255) — NOT NULL
  • profileImageUrl — VARCHAR(255) — NOT NULL
  • username — VARCHAR(255) — NOT NULL
  • roleType — ENUM — NOT NULL
  • socialType — ENUM — NOT NULL
  • createdDate — DATETIME(6)
  • updatedDate — DATETIME(6)