3DPrinterFactory
Tables (22)
command_log
- cmd_id — bigserial — Primary key — NOT NULL
- ts — timestamptz — NOT NULL
- actor — text — NOT NULL
- kind — text — NOT NULL
- target — text
- payload — jsonb
- result — text
container
- container_id — text — Primary key — NOT NULL
- node_id — text — Foreign key → node.node_id
- capacity — int — NOT NULL
- entered_at — timestamptz — NOT NULL
customer_order
- order_id — text — Primary key — NOT NULL
- customer — text — NOT NULL
- due_at — timestamptz
- status — text — NOT NULL
id_counter
- node_type — text — Foreign key → node_type.node_type — NOT NULL
- prefix — text — NOT NULL
- next_val — bigint — NOT NULL
judgement
- judgement_id — bigserial — Primary key — NOT NULL
- ts — timestamptz — NOT NULL
- unit_id — uuid — Foreign key — NOT NULL
- node_id — text — Foreign key — 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
- is_active — boolean — NOT NULL
node
- node_id — text — Primary key — NOT NULL
- node_type — text — Foreign key → node_type.node_type — NOT NULL
- label — text — NOT NULL
- capacity — int — NOT NULL
- std_cycle_s — int
- container_based — boolean — NOT NULL
- container_capacity — int
- is_active — boolean — NOT NULL
- draining — boolean — NOT NULL
- ui_group — text
node_slot
- slot_no — int — Primary key — NOT NULL
- node_id — text — Foreign key — NOT NULL
- capacity — int — NOT NULL
node_type
- node_type — text — Primary key — NOT NULL
- node_kind — text — NOT NULL
- id_prefix — text
- default_capacity — int — NOT NULL
- default_cycle_s — int
- post_delay_s — int — NOT NULL
- container_based — boolean — NOT NULL
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 — NOT NULL
- part_no — text — Foreign key → part.part_no — NOT NULL
- qty — int — NOT NULL
- node_id — text — Foreign key
- reason — text — NOT NULL
- source — text — NOT NULL
- msg — text
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
- topology_version — int
- msg — text
product_state
- unit_id — uuid — Foreign key → unit.unit_id — NOT NULL
- node_id — text — Foreign key → node.node_id — NOT NULL
- container_id — text — Foreign key → container.container_id
- 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
route_handler
- line_id — text — Foreign key → route.line_id — NOT NULL
- from_node — text — Foreign key → route.from_node — NOT NULL
- to_node — text — Foreign key → route.to_node — NOT NULL
- transporter_id — text — Foreign key → transporter.transporter_id — NOT NULL
topology_sync_log
- topology_version — int — Primary key — NOT NULL
- applied_at — timestamptz — NOT NULL
- source_hash — text — NOT NULL
- summary — jsonb
transporter
- transporter_id — text — Primary key — NOT NULL
- kind — text — NOT NULL
- label — text — NOT NULL
- auto_dispatch — boolean — NOT NULL
- 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
- display_id — text — NOT NULL
- born_at — timestamptz — NOT NULL
unit_alias
- alias — text — Primary key — NOT NULL
- unit_id — uuid — Foreign key → unit.unit_id — NOT NULL
- node_id — text — Foreign key → node.node_id
- valid_from — timestamptz — NOT NULL
unit_content
- unit_id — uuid — Foreign key — NOT NULL
- part_no — text — Foreign key → part.part_no — NOT NULL
- qty — int — NOT NULL
- qty_scrapped — int — NOT NULL