O!Mykase

Tables (8)

Admin

  • admin_id (Key) — Long — Primary key — NOT NULL
  • store_id (Key2) — Long — Foreign key → Store.store_id — NOT NULL
  • id (Field) — String
  • password (Field2) — String

Booking

  • book_id (Key) — Long — Primary key — NOT NULL
  • menu_id (Key2) — Long — Foreign key → Menu.menu_id — NOT NULL
  • store_id (Key22) — Long — Foreign key → Menu.store_id — NOT NULL
  • date (Field) — LocalDate
  • time (Field2) — LocalTime
  • name (Field3) — String
  • phone (Field4) — String
  • customer_count (Field5) — int

Location_Tag

  • location_id (Key) — Long — Primary key — NOT NULL
  • name (Field) — String

Menu

  • menu_id (Key) — Long — Primary key — NOT NULL
  • store_id (Key2) — Long — Foreign key → Store.store_id — NOT NULL
  • name (Field) — String
  • price (Field2) — Long
  • menu_count (Field3) — int

Review

  • review_id (Key) — Long — Primary key — NOT NULL
  • store_id (Key2) — Long — Foreign key → Store.store_id — NOT NULL
  • location_id (Key22) — Long — Foreign key → Store.location_id — NOT NULL
  • customer_name (Field4) — String
  • content (Field) — String
  • visited_date (Field3) — LocalDate
  • ratings (Field2) — float
  • image_url (Field5) — String

Store

  • store_id (Key) — Long — Primary key — NOT NULL
  • location_id (Key2) — Long — Foreign key → Location_Tag.location_id — NOT NULL
  • name (Field) — String
  • image_url (Field2) — String
  • rating_avg (Field3) — float
  • lunch_price (Field4) — String
  • dinner_price (Field5) — String
  • address (Field6) — String
  • telephone (Field7) — String
  • closed_day (Field8) — String
  • business_hours (Field9) — String

Store_Tag

  • store_id (Key3) — Long — Foreign key → Store.store_id — NOT NULL
  • tag_id (Key4) — Long — Foreign key → Tag.tag_id — NOT NULL

Tag

  • tag_id (Key) — Long — Primary key — NOT NULL
  • name (Field) — String