zoop_zoop

Tables (5)

orderWastes (Untitled2)

  • orderWasteId (order_waste_id) — INT4 — Primary key — NOT NULL
  • orderId (order_id) — Foreign key → orders.orderId — NOT NULL

orders (Untitled)

  • orderId (order_id) — Primary key — NOT NULL
  • userId (user_id) — Foreign key → users.userId — NOT NULL

pickerTask (Untitled3)

  • pickerTaskId (picker_task_id) — INT4 — Primary key — NOT NULL
  • userId (user_id) — Foreign key → users.userId — NOT NULL
  • Field

users (Untitled5)

  • userId (user_id) — Primary key — NOT NULL

wastePickerWatch (Untitled4)

  • pickerWatchId (picker_watch_id) — INT4 — Primary key — NOT NULL
  • orderWasteId (order_waste_id2) — INT4 — Foreign key → orderWastes.orderWasteId — NOT NULL
  • pickerTaskId (picker_task_id) — INT4 — Foreign key → pickerTask.pickerTaskId — NOT NULL
  • userId (user_id) — Foreign key → users.userId — NOT NULL
  • viewDate (view_date) — DATETIME