popcorn1-1
Tables (5)
Like
- like_id — BIGINT — Primary key — NOT NULL
- user_id — BIGINT — Foreign key → User.user_id — NOT NULL
- popup_id — BIGINT — Foreign key → Popup.popup_id — NOT NULL
Popup
- popup_id — BIGINT — Primary key — NOT NULL
- title — VARCHAR
- contents — VARCHAR
- started_at — DATETIME
- ended_at — DATETIME
- business_time — VARCHAR
- latitude — FLOAR
- longitude — FLOAT
- location — VARCHAR
- organizer_url — VARCHAR
- reservation_url — VARCHAR
- popup_image — ImageURL(str)
- confirm — BOOLEAN
PopupInterest
- popup_interest_id — BIGINT — Primary key — NOT NULL
- popup_id — BIGINT — Foreign key → Popup.popup_id — NOT NULL
- category_name — ENUM
User
- user_id — BIGINT — Primary key — NOT NULL
- password — VARCHAR
- nickname — VARCHAR
- user_name — VARCHAR
- email — VARCHAR
- role — VARCHAR
UserInterest
- interest_id — BIGINT — Primary key — NOT NULL
- user_id — BIGINT — Foreign key → User.user_id — NOT NULL
- category_name — ENUM