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