coffee-order

Tables (4)

Address (addresses)

  • address_id — Long — Primary key — NOT NULL
  • address (Field) — String
  • zipcode (Field2) — String

Menu (Menus)

  • menu_id — Long — Primary key — NOT NULL
  • name — String
  • price — Long

Order (orders)

  • order_id — Long — Primary key — NOT NULL
  • address_id — Long — Foreign key → Address.address_id — NOT NULL
  • email — String
  • created_at — LocalDateTime
  • order_status — String

OrderItem (order_itmes)

  • order_item_id — Long — Primary key — NOT NULL
  • order_id — Long — Foreign key → Order.order_id — NOT NULL
  • menu_id — Long — Foreign key → Menu.menu_id — NOT NULL
  • qunatity — Long