festa-pick
Tables (5)
Festival
- festival_id — bigint — Primary key — NOT NULL
- user_id — bigint — Foreign key → users.user_id — NOT NULL
- homePage — varchar(5000)
- overView — varchar(5000)
- addr1 — varchar(255)
- addr2 — varchar(255)
- areaCode — varchar(255)
- contentId — varchar(255)
- endDate — varchar(255)
- imageUrl — varchar(255)
- startDate — varchar(255)
- title — varchar(255)
- state — enum
RefreshToken
- refresh_id — bigint — Primary key — NOT NULL
- user_id — bigint — Foreign key → users.user_id — NOT NULL
- createdDate — datetime(6)
- token — varchar(255) — NOT NULL
Review
- review_id — BIGINT — Primary key — NOT NULL
- user_id — bigint — Foreign key → users.user_id — NOT NULL
- festival_id — bigint — Foreign key → Festival.festival_id — NOT NULL
- content — TEXT
- score — INT
Wish
- wish_id — bigint — Primary key — NOT NULL
- user_id — bigint — Foreign key → users.user_id — NOT NULL
- festival_id — bigint — Foreign key → Festival.festival_id — NOT NULL
users
- user_id — bigint — Primary key — NOT NULL
- createdDate — datetime(6)
- updatedDate — datetime(6)
- email — varchar(255) — NOT NULL
- identifier — varchar(255) — NOT NULL
- username — varchar(255) — NOT NULL
- roleType — enum — NOT NULL
- socialType — enum — NOT NULL