3DPrinterFactory
Tables (29)
automation_log
- id — BIGINT — Primary key — NOT NULL
- log_type — INTEGER — NOT NULL
- source — VARCHAR(64) — NOT NULL
- cmd_id — VARCHAR(36) — Foreign key → print_command.cmd_id
- message — VARCHAR(2048) — NOT NULL
- created_at — DATETIME — NOT NULL
binpick_detections
- id — VARCHAR(36) — Primary key — NOT NULL
- scene_pk — VARCHAR(36) — Foreign key → binpick_scenes.id — NOT NULL
- idx — INTEGER — NOT NULL
- label — VARCHAR(60)
- x — FLOAT
- y — FLOAT
- z — FLOAT
- angle — FLOAT
- confidence — FLOAT
- gripper_width_mm — FLOAT
- created_at — DATETIME
binpick_scenes
- id — VARCHAR(36) — Primary key — NOT NULL
- scene_id — VARCHAR(120)
- schema_version — VARCHAR(20) — NOT NULL
- module — VARCHAR(30) — NOT NULL
- n_detections — INTEGER — NOT NULL
- n_unique_labels — INTEGER — NOT NULL
- recognition_track — VARCHAR(30)
- latency_ms — FLOAT
- gate_verdict — VARCHAR(30) — NOT NULL
- gate_trusted — BOOLEAN
- gate_valid_ratio_pct — FLOAT
- gate_note — TEXT
- gate_n_dropped_by_size — INTEGER — NOT NULL
- reported_at — VARCHAR(40)
- created_at — DATETIME
cell_state
- id — INTEGER — Primary key — NOT NULL
- running — INTEGER — NOT NULL
- paused — INTEGER — NOT NULL
- simul_mode — INTEGER — NOT NULL
- queue_state — JSON
- updated_at — DATETIME — NOT NULL
command_log
- log_id — bigserial — Primary key — NOT NULL
- ts — timestamptz — NOT NULL
- actor — text — NOT NULL
- kind — text — NOT NULL
- target — text
- payload — jsonb
- result — text
customer_order
- order_id — text — Primary key — NOT NULL
- customer — text — NOT NULL
- due_at — timestamptz
- status — text — NOT NULL
group_close
- group_id — text — Primary key — NOT NULL
- node_id — text — Foreign key → node.node_id
- closed_at — timestamptz — NOT NULL
- actor — text
id_counter
- prefix — text — Primary key — NOT NULL
- next_val — bigint — NOT NULL
judgement
- judgement_id — bigserial — Primary key — NOT NULL
- ts — timestamptz — NOT NULL
- unit_id — uuid — Foreign key → unit.unit_id — NOT NULL
- node_id — text — Foreign key → node.node_id — NOT NULL
- verdict — text — NOT NULL
- value — jsonb
- note — text
- source — text — NOT NULL
line
- line_id — text — Primary key — NOT NULL
- label — text — NOT NULL
- process_family — text — NOT NULL
- plate_count — int — NOT NULL
- is_active — boolean — NOT NULL
node
- node_id — text — Primary key — NOT NULL
- node_kind — text — NOT NULL
- node_type — text — NOT NULL
- label — text — NOT NULL
- capacity — int — NOT NULL
- std_cycle_s — int
- id_prefix — text
- post_delay_s — int — NOT NULL
- slot_access — text — NOT NULL
- slot_fill — text — NOT NULL
- count_by_group — boolean — NOT NULL
- splits_batch — boolean — NOT NULL
- ui_kind — text — NOT NULL
- group_label — text
- transporter_id — text — Foreign key → transporter.transporter_id
- attrs — jsonb
- external_ref — jsonb
- is_active — boolean — NOT NULL
- draining — boolean — NOT NULL
node_slot
- slot_no — int — Primary key — NOT NULL
- node_id — text — Foreign key → node.node_id — NOT NULL
- capacity — int — NOT NULL
notification_events
- id — VARCHAR(36) — Primary key — NOT NULL
- event_type — VARCHAR(30) — NOT NULL
- printer_serial — VARCHAR(100) — NOT NULL
- printer_name — VARCHAR(100)
- job_name — VARCHAR(255)
- message — TEXT
- is_read — INTEGER
- created_at — DATETIME
order_line
- order_id — text — Foreign key → customer_order.order_id — NOT NULL
- part_no — text — Foreign key → part.part_no — NOT NULL
- qty — int — NOT NULL
part
- part_no — text — Primary key — NOT NULL
- name — text — NOT NULL
- revision — text
- cad_ref — text
- attrs — jsonb
- is_active — boolean — NOT NULL
part_scrap
- scrap_id — bigserial — Primary key — NOT NULL
- ts — timestamptz — NOT NULL
- unit_id — uuid — Foreign key → unit.unit_id — NOT NULL
- part_no — text — Foreign key → part.part_no — NOT NULL
- qty — int — NOT NULL
- node_id — text — Foreign key → node.node_id
- reason — text — NOT NULL
- source — text — NOT NULL
- msg — text
presets
- id — VARCHAR(36) — Primary key — NOT NULL
- name — VARCHAR(100) — NOT NULL
- part_type — VARCHAR(50) — NOT NULL
- description — TEXT
- printer_serial — VARCHAR(100)
- settings — JSON — NOT NULL
- stl_filename — VARCHAR(255)
- print_count — INTEGER
- created_at — DATETIME
- updated_at — DATETIME
print_command
- cmd_id — VARCHAR(36) — Primary key — NOT NULL
- file_path — VARCHAR(1024) — NOT NULL
- file_name — VARCHAR(255) — NOT NULL
- cmd_status — INTEGER — NOT NULL
- post_proc_stage — INTEGER — NOT NULL
- washing_time — INTEGER — NOT NULL
- curing_time — INTEGER — NOT NULL
- use_yn — VARCHAR(1) — NOT NULL
- target_printer — INTEGER
- allocated_data — JSON
- progress — INTEGER — NOT NULL
- message — VARCHAR(1024)
- claimed_by — VARCHAR(64)
- locked_at — DATETIME
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
print_jobs
- id — VARCHAR(36) — Primary key — NOT NULL
- preset_id — VARCHAR(36) — Foreign key → presets.id
- stl_filename — VARCHAR(255) — NOT NULL
- printer_serial — VARCHAR(100) — NOT NULL
- status — VARCHAR(20)
- error_message — TEXT
- scene_id — VARCHAR(100)
- settings — JSON — NOT NULL
- estimated_print_time_ms — INTEGER
- estimated_material_ml — FLOAT
- scheduled_at — DATETIME
- created_at — DATETIME
- updated_at — DATETIME
print_notes
- id — VARCHAR(36) — Primary key — NOT NULL
- print_guid — VARCHAR(100) — NOT NULL
- content — TEXT — NOT NULL
- created_at — DATETIME
- updated_at — DATETIME
product_event
- event_id — bigserial — Primary key — NOT NULL
- ts — timestamptz — NOT NULL
- unit_id — uuid — Foreign key → unit.unit_id — NOT NULL
- node_id — text — Foreign key → node.node_id
- status — text
- duration_s — int
- ready_at — timestamptz
- source — text — NOT NULL
- confidence — real
- transporter_id — text
- msg — text
product_state
- unit_id — uuid — Foreign key → unit.unit_id — NOT NULL
- node_id — text — Foreign key → node.node_id — NOT NULL
- group_id — text
- slot_no — int
- pos_no — int
- status — text — NOT NULL
- entered_at — timestamptz — NOT NULL
- eta — timestamptz
- ready_at — timestamptz
- updated_at — timestamptz — NOT NULL
route
- line_id — text — Foreign key → line.line_id — NOT NULL
- from_node — text — Foreign key → node.node_id — NOT NULL
- to_node — text — Foreign key → node.node_id — NOT NULL
- priority — int — NOT NULL
- edge_kind — text — NOT NULL
transporter
- transporter_id — text — Primary key — NOT NULL
- kind — text — NOT NULL
- label — text — NOT NULL
- auto_dispatch — boolean — NOT NULL
- attrs — jsonb
- is_active — boolean — NOT NULL
transporter_state
- transporter_id — text — Foreign key → transporter.transporter_id — NOT NULL
- status — text — NOT NULL
- unit_id — uuid
- from_node — text
- to_node — text
- started_at — timestamptz
- updated_at — timestamptz — NOT NULL
unit
- unit_id — uuid — Primary key — NOT NULL
- line_id — text — Foreign key → line.line_id — NOT NULL
- order_id — text — Foreign key → customer_order.order_id
- cmd_id — text
- unit_kind — text — NOT NULL
- display_id — text — NOT NULL
- parent_unit_id — uuid — Foreign key → unit.unit_id
- named_at — text
- born_at — timestamptz — NOT NULL
- consumed_at — timestamptz
unit_content
- unit_id — uuid — Foreign key → unit.unit_id — NOT NULL
- part_no — text — Foreign key → part.part_no — NOT NULL
- qty — int — NOT NULL
- qty_scrapped — int — NOT NULL
vision_cameras
- camera_id — VARCHAR(20) — Primary key — NOT NULL
- device_type — VARCHAR(10) — NOT NULL
- device_id — INTEGER — NOT NULL
- name — VARCHAR(50) — NOT NULL
- status — VARCHAR(20)
- confidence — FLOAT
- is_online — INTEGER
- firmware_version — VARCHAR(20)
- model_name — VARCHAR(100)
- ip_address — VARCHAR(15)
- wifi_rssi — INTEGER
- last_seen — DATETIME
- last_status_change — DATETIME
- created_at — DATETIME
vision_events
- id — VARCHAR(36) — Primary key — NOT NULL
- camera_id — VARCHAR(20) — Foreign key → vision_cameras.camera_id — NOT NULL
- device_type — VARCHAR(10) — NOT NULL
- device_id — INTEGER — NOT NULL
- previous_status — VARCHAR(20)
- new_status — VARCHAR(20) — NOT NULL
- confidence — FLOAT
- created_at — DATETIME