3DPrinterFactory
Tables (17)
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
customer_order
- order_id — text — Primary key — NOT NULL
- customer — text — NOT NULL
- due_at — timestamptz
- status — text — NOT NULL
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
- 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
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
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
- 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
- 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