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