sesac logistics

Tables (17)

command_outbox

  • command_id — TEXT — Primary key — NOT NULL
  • operation_id — TEXT — NOT NULL
  • robot_id — TEXT — NOT NULL
  • command_type — TEXT — NOT NULL
  • payload_json — TEXT — NOT NULL
  • status — TEXT — NOT NULL
  • last_error — TEXT
  • created_at — TEXT — NOT NULL
  • sent_at — TEXT

fleet_event_outbox

  • event_id — TEXT — Primary key — NOT NULL
  • event_type — TEXT — NOT NULL
  • occurred_at — TEXT — NOT NULL
  • payload_json — TEXT — NOT NULL
  • attempt_count — INTEGER — NOT NULL
  • next_attempt_at — TEXT — NOT NULL
  • last_error — TEXT
  • delivered_at — TEXT

inventory_event_outbox

  • event_id — TEXT — Primary key — NOT NULL
  • event_type — TEXT — NOT NULL
  • occurred_at — TEXT — NOT NULL
  • payload_json — TEXT — NOT NULL
  • attempt_count — INTEGER — NOT NULL
  • next_attempt_at — TEXT — NOT NULL
  • last_error — TEXT
  • delivered_at — TEXT

inventory_events

  • event_id — TEXT — Primary key — NOT NULL
  • idempotency_key — TEXT — NOT NULL
  • operation_id — TEXT — Foreign key → transport_operations.operation_id
  • robot_id — TEXT
  • event_type — TEXT — NOT NULL
  • zone_id — TEXT — Foreign key → zones.zone_id — NOT NULL
  • payload_type — TEXT — Foreign key → payload_types.payload_type — NOT NULL
  • quantity_delta — INTEGER — NOT NULL
  • occurred_at — TEXT — NOT NULL
  • created_at — TEXT — NOT NULL

operation_recoveries

  • operation_id — TEXT — Primary key — NOT NULL
  • robot_id — TEXT — NOT NULL
  • marked_at — TEXT — NOT NULL

orchestrator_errors

  • error_key — TEXT — Primary key — NOT NULL
  • message — TEXT — NOT NULL
  • updated_at — TEXT — NOT NULL

orchestrator_inbox

  • source — TEXT — Primary key — NOT NULL
  • event_id — TEXT — Primary key — NOT NULL
  • event_type — TEXT — NOT NULL
  • occurred_at — TEXT — NOT NULL
  • payload_json — TEXT — NOT NULL
  • received_at — TEXT — NOT NULL

orchestrator_steps

  • operation_id — TEXT — Primary key — NOT NULL
  • robot_id — TEXT — NOT NULL
  • phase — TEXT — NOT NULL
  • source_zone_id — TEXT — NOT NULL
  • destination_zone_id — TEXT — NOT NULL
  • payload_type — TEXT — NOT NULL
  • updated_at — TEXT — NOT NULL

pallet_stocks

  • zone_id — TEXT — Foreign key → zones.zone_id — NOT NULL
  • payload_type — TEXT — Foreign key → payload_types.payload_type — NOT NULL
  • quantity — INTEGER — NOT NULL
  • reserved_quantity — INTEGER — NOT NULL
  • version — INTEGER — NOT NULL
  • updated_at — TEXT — NOT NULL

payload_types

  • payload_type — TEXT — Primary key — NOT NULL
  • enabled — INTEGER — NOT NULL
  • created_at — TEXT — NOT NULL

robot_battery

  • robot_id — TEXT — Primary key — NOT NULL
  • battery_raw — INTEGER — NOT NULL
  • received_at — TEXT — NOT NULL

robot_pallet_states

  • robot_id — TEXT — Primary key — NOT NULL
  • has_pallet — INTEGER — NOT NULL
  • payload_type — TEXT — Foreign key → payload_types.payload_type
  • version — INTEGER — NOT NULL
  • reported_at — TEXT — NOT NULL
  • updated_at — TEXT — NOT NULL

robot_pose

  • robot_id — TEXT — Primary key — NOT NULL
  • x_m — REAL — NOT NULL
  • y_m — REAL — NOT NULL
  • yaw_rad — REAL — NOT NULL
  • observed_at — TEXT
  • received_at — TEXT — NOT NULL

transport_operations

  • operation_id — TEXT — Primary key — NOT NULL
  • robot_id — TEXT
  • payload_type — TEXT — Foreign key → payload_types.payload_type — NOT NULL
  • source_zone_id — TEXT — Foreign key → zones.zone_id — NOT NULL
  • destination_zone_id — TEXT — Foreign key → zones.zone_id — NOT NULL
  • status — TEXT — NOT NULL
  • priority — INTEGER — NOT NULL
  • failure_code — TEXT
  • version — INTEGER — NOT NULL
  • created_at — TEXT — NOT NULL
  • updated_at — TEXT — NOT NULL
  • completed_at — TEXT

vehicle_state_logs

  • id — INTEGER — Primary key — NOT NULL
  • robot_id — TEXT — NOT NULL
  • state — TEXT — NOT NULL
  • previous_state — TEXT
  • operation_id — TEXT
  • attempt_id — TEXT
  • source — TEXT — NOT NULL
  • detail — TEXT — NOT NULL
  • observed_at — TEXT — NOT NULL
  • created_at — TEXT — NOT NULL

vehicle_states

  • robot_id — TEXT — Primary key — NOT NULL
  • state — TEXT — NOT NULL
  • previous_state — TEXT
  • operation_id — TEXT
  • attempt_id — TEXT
  • source — TEXT — NOT NULL
  • detail — TEXT — NOT NULL
  • observed_at — TEXT — NOT NULL
  • updated_at — TEXT — NOT NULL

zones

  • zone_id — TEXT — Primary key — NOT NULL
  • name — TEXT — NOT NULL
  • map_name — TEXT — NOT NULL
  • nav_x — REAL — NOT NULL
  • nav_y — REAL — NOT NULL
  • nav_yaw — REAL — NOT NULL
  • capacity — INTEGER
  • enabled — INTEGER — NOT NULL
  • created_at — TEXT — NOT NULL
  • updated_at — TEXT — NOT NULL