mes

Tables (5)

SFU3_tag_data_with_material

  • timestamp — TIMESTAMPTZ — Primary key — NOT NULL
  • device_id — VARCHAR(50) — Foreign key → device.device_id — NOT NULL
  • collection_active — BOOLEAN
  • plc_published_ts — TIMESTAMPTZ
  • broker_ts — TIMESTAMPTZ
  • rule_processed_ts — TIMESTAMPTZ
  • db_written_ts — TIMESTAMPTZ
  • sfu3_power_status — BOOLEAN
  • sfu3_auto_mode — BOOLEAN
  • sfu3_man_mode — BOOLEAN
  • sfu3_system_fault — BOOLEAN
  • sfu3_infeed_conv_speed — NUMERIC(10,2)

device

  • device_id — VARCHAR(50) — Primary key — NOT NULL
  • process_id — VARCHAR(20) — Foreign key → process.process_id — NOT NULL
  • device_name — VARCHAR(100) — NOT NULL
  • device_type — VARCHAR(50)
  • vendor — VARCHAR(100)
  • model_no — VARCHAR(100)
  • ip_address — VARCHAR(50)
  • status — VARCHAR(20)
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL

process

  • process_id — VARCHAR(20) — Primary key — NOT NULL
  • shop_id — VARCHAR(20) — Foreign key → shop.shop_id — NOT NULL
  • process_name — VARCHAR(100) — NOT NULL
  • process_seq — INT
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL

region

  • region_id — VARCHAR(20) — Primary key — NOT NULL
  • region_name — VARCHAR(100) — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL

shop

  • shop_id — VARCHAR(20) — Primary key — NOT NULL
  • region_id — VARCHAR(20) — Foreign key → region.region_id — NOT NULL
  • shop_name — VARCHAR(100) — NOT NULL
  • shop_type — VARCHAR(50)
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL