order_table

Tables (9)

FavoritePlace (Untitled8)

  • Pk (Key) — Long — Primary key — NOT NULL
  • PK (Key2) — Long — Foreign key → USER.PK — NOT NULL
  • Field — User
  • Field2 — Shop

MENU (Untitled3)

  • PK (Key) — Long — Primary key — NOT NULL
  • Fk (shop) — Long — Foreign key → SHOP.Key — NOT NULL
  • Pk (Key2) — Long — Foreign key → ORDER.Pk — NOT NULL
  • Key (Key3) — Long — Foreign key → ORDER.Key — NOT NULL
  • Key (Key4) — Long — Foreign key → order_menu.Key — NOT NULL
  • Pk (Key22) — Long — Foreign key → order_menu.Pk — NOT NULL
  • Key (Key32) — Long — Foreign key → order_menu.Key — NOT NULL
  • Field — Shop
  • Field2 — String(Unique)
  • Field3 — int
  • Field4 — String

ORDER (Untitled4)

  • Pk (Key) — Long — Primary key — NOT NULL
  • Key (Key3) — Long — Foreign key → SHOP.Key — NOT NULL
  • Field — List<orderMenu>
  • Field2 — Shop
  • Field3 — int
  • Field4 (t) — Table
  • Field4 — LocalDateTime
  • Field5 — Status(Enum)

REVIEW (Untitled5)

  • PK (Key) — Long — Primary key — NOT NULL
  • PK (Key2) — Long — Foreign key → USER.PK — NOT NULL
  • Key (Key3) — Long — Foreign key → SHOP.Key — NOT NULL
  • Field — Shop
  • Field2 — User
  • Field3 — String
  • Field4 — int
  • Field5 — LocalDateTime

SHOP (Untitled2)

  • Key — Long — Primary key — NOT NULL
  • Field — String
  • Field2 — String
  • Field3 — Address
  • Field4 — List<Menu>
  • Field5 — List<Table>
  • Field6 — int
  • Field7 — List<Review>
  • Field8 — List<Order>
  • Field9 — List<visited>

Table (Untitled6)

  • PK (Key) — Long — Primary key — NOT NULL
  • Key (Key2) — Long — Foreign key → SHOP.Key — NOT NULL
  • Pk (Key3) — Long — Foreign key → ORDER.Pk — NOT NULL
  • Key (Key32) — Long — Foreign key → ORDER.Key — NOT NULL
  • Field — Shop
  • Field2 — List<User>
  • Field3 — Order
  • Field4 — int
  • Field5 — Enum(status

USER (Untitled)

  • PK (Key) — Long — Primary key — NOT NULL
  • (Field) — List<favoritePlace>
  • Field2 — String
  • Field3 — Address
  • Field4 — String
  • Field6 — List<visited>
  • Field7 — List<Review>
  • Field8 — String(Unique

Visited (Untitled7)

  • Pk (Key) — Long — Primary key — NOT NULL
  • PK (Key2) — Long — Foreign key → USER.PK — NOT NULL
  • Key (Key3) — Long — Foreign key → SHOP.Key — NOT NULL
  • Field — Shop
  • Field2 — User
  • Field3 — LocalDateTime

order_menu (Untitled9)

  • Key — Long — Primary key — NOT NULL
  • Pk (Key2) — Long — Foreign key → ORDER.Pk — NOT NULL
  • Key (Key3) — Long — Foreign key → ORDER.Key — NOT NULL
  • Field — menu
  • Field2 — order
  • Field3 — int