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