s

Tables (3)

Memo (memo_table)

  • Memo ID (id) — NOT NULL — Primary key — NOT NULL
  • Title of Memo (title) — NOT NULL — NOT NULL
  • Content of Memo (content) — NOT NULL — NOT NULL
  • Create time of Memo (createdDate)

Photo (photo_table)

  • Photo ID (photoId) — NOT NULL — Primary key — NOT NULL
  • Restaurant ID (restaurantReferId) — NOT NULL — Foreign key → Restaurant.Restaurant ID — NOT NULL
  • Photo URI (photoReference) — NOT NULL — NOT NULL
  • Width (width) — NOT NULL — NOT NULL
  • Height (height) — NOT NULL — NOT NULL

Restaurant (restaurant_table)

  • Restaurant ID (restaurantId) — NOT NULL — Primary key — NOT NULL
  • Business Status (businessStatus) — NOT NULL — NOT NULL
  • Name (name) — NOT NULL — NOT NULL
  • Place ID (placeId) — NOT NULL — NOT NULL
  • Rating of Restaurant (rating) — NOT NULL — NOT NULL
  • Number of user ratings (userRatingsTotal) — NOT NULL — NOT NULL
  • Vicinity (vicinity) — NOT NULL — NOT NULL
  • Selected flag (selected) — NOT NULL — NOT NULL