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