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)