Popcorn
Tables (11)
Popup
- popup_id — BIGINT — Primary key — NOT NULL
- title — VARCHAR
- contents — VARCHAR
- statred_at (started_at) — DATETIME
- ended_at — DATETIME
- latitude — FLOAR
- longitude — FLOAT
- Field (organizer_url) — VARCHAR
- Field (reservation_url) — VARCHAR
- Key (category_id) — BIGINT — Foreign key → Untitled.Key — NOT NULL
- Field (popup_image) — ImageURL(str)
Untitled (Interest)
- Key (interest_id) — BIGINT — Primary key — NOT NULL
- user_id — BIGINT — Foreign key → User.user_id — NOT NULL
- Key (category_id) — BIGINT — Foreign key → Untitled.Key — NOT NULL
Untitled (Review)
- Key (review_id) — BIGINT — Primary key — NOT NULL
- popup_id — BIGINT — Foreign key → Popup.popup_id — NOT NULL
- Field (post) — VARCHAR
- Field (posted_at)
Untitled (Category)
- Key (category_id) — BIGINT — Primary key — NOT NULL
- Field (category_name) — VARCHAR
Untitled (Chattingroom)
- Key (room_id) — BIGINT — Primary key — NOT NULL
- popup_id — BIGINT — Foreign key → Popup.popup_id — NOT NULL
- Field (room_name) — VARCHAR
Untitled (Chatpart)
- user_id — BIGINT — Foreign key → User.user_id — NOT NULL
- Key (room_id) — BIGINT — Foreign key → Untitled.Key — NOT NULL
- popup_id — BIGINT — Foreign key → Untitled.popup_id — NOT NULL
Untitled (Message)
- Key (message_id) — BIGINT — Primary key — NOT NULL
- user_id — BIGINT — Foreign key → Untitled.user_id — NOT NULL
- Key (room_id) — BIGINT — Foreign key → Untitled.Key — NOT NULL
- Field (type)
- Field (message_contents) — VARCHAR
- Field (message_image) — ImageURL(str)
- popup_id — BIGINT — Foreign key → Untitled.popup_id — NOT NULL
Untitled (ReviewImage)
- Key (image_id) — BIGINT — Primary key — NOT NULL
- Key (review_id) — BIGINT — Foreign key → Untitled.Key — NOT NULL
- popup_id — BIGINT — Foreign key → Untitled.popup_id — NOT NULL
- Field (data) — ImageURL(str)
Untitled (store)
- Key (store_id) — BIGINT — Primary key — NOT NULL
- Key (room_id) — BIGINT — Foreign key → Untitled.Key — NOT NULL
- user_id — BIGINT — Foreign key → User.user_id — NOT NULL
- popup_id — BIGINT — Foreign key → Untitled.popup_id — NOT NULL
Untitled3 (Like)
- Key (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
User
- user_id — BIGINT — Primary key — NOT NULL
- password — VARCHAR(255)
- nickname — VARCHAR
- user_name — VARCHAR
- email — VARCHAR
- Field (role) — VARCHAR