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