catchfood

Tables (9)

MealSession (MealPoll)

  • Key (ID) — BIGINT — Primary key — NOT NULL

MealSessionInteraction (RecommendStore)

  • Key (POLL_ID) — BIGINT — Foreign key → MealSession.Key — NOT NULL
  • Key (STORE_ID) — BIGINT — Foreign key → Store.Key — NOT NULL

Party

  • Key (ID) — BIGINT — Primary key — NOT NULL
  • Field (NAME) — VARCHAR(100)

PartyMember

  • Key (USER_ID) — BIGINT — Foreign key → User.Key — NOT NULL
  • Key (PARTY_ID) — BIGINT — Foreign key → Party.Key — NOT NULL

Preference (PollPreference)

  • Key (USER_ID) — BIGINT — Foreign key → User.Key — NOT NULL
  • Key (POLL_ID) — BIGINT — Foreign key → MealSession.Key — NOT NULL
  • Field (CONTENT) — VARCHAR(200) — NOT NULL

Store

  • Key (ID) — BIGINT — Primary key — NOT NULL
  • Field (NAME) — VARCHAR(100) — NOT NULL
  • Field2 (CATEGORY) — VARCHAR(30)
  • Field (DISTANCE_IN_MINUTES_BY_WALK) — INT
  • Field (BUSINESS_OPEN_HOUR) — TIME
  • Field (BUSINESS_CLOSE_HOUR) — TIME
  • Field (ADDRESS) — VARCHAR(200)
  • Field2 (CONTACT) — VARCHAR(30)
  • Field (RATING_STARS) — DECIMAL(2,1)

Untitled (Vote)

  • Key (POLL_ID) — BIGINT — Foreign key → MealSessionInteraction.Key — NOT NULL
  • Key (STORE_ID) — BIGINT — Foreign key → MealSessionInteraction.Key — NOT NULL
  • Key (USER_ID) — BIGINT — Foreign key → User.Key — NOT NULL

Untitled (Menu)

  • Key (ID) — BIGINT — Primary key — NOT NULL
  • Field (NAME) — VARCHAR(50) — NOT NULL
  • Field (PRICE) — INT
  • Field (IMAGE_URL) — VARCHAR(2000)

User

  • Key (ID) — BIGINT — Primary key — NOT NULL
  • Field (NAME) — VARCHAR(20) — NOT NULL
  • Field (PREF_LIKES) — VARCHAR(200)
  • Field2 (PREF_DISLIKES) — VARCHAR(200)
  • Field3 (PREF_ETC) — VARCHAR(200)