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