3DPrinterFactory-2

Tables (16)

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

id_counter

  • node_type — text — Foreign key → node_type.node_type — NOT NULL
  • prefix — text — NOT NULL
  • next_val — bigint — 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_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

part

  • part_no — text — Primary key — NOT NULL
  • name — text — NOT NULL
  • revision — text
  • cad_ref — text
  • attrs — jsonb
  • is_active — boolean — NOT NULL

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
  • edge_kind — text — 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 → unit.unit_id — NOT NULL
  • part_no — text — Foreign key → part.part_no — NOT NULL
  • qty — int — NOT NULL