ㄴㅇㅁㄴㅇㅁㄴㅇ

Tables (18)

anomaly_window_score

  • id — BIGSERIAL — Primary key — NOT NULL
  • component_id — BIGINT — Foreign key → component.component_id — NOT NULL
  • window_start_ts — TIMESTAMPTZ — NOT NULL
  • window_end_ts — TIMESTAMPTZ — NOT NULL
  • window_sec — DOUBLE PRECISION — NOT NULL
  • stride_sec — DOUBLE PRECISION — NOT NULL
  • sampling_hz — DOUBLE PRECISION — NOT NULL
  • sample_count — INTEGER — NOT NULL
  • expected_sample_count — INTEGER
  • fill_ratio — DOUBLE PRECISION
  • model_version — TEXT — NOT NULL
  • feature_set_version — TEXT — NOT NULL
  • actual_anomaly_score — DOUBLE PRECISION — NOT NULL
  • alarm_level — TEXT — NOT NULL
  • features_json — JSONB — NOT NULL
  • data_quality_flag — TEXT — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL

anomaly_window_score_sensor_source

  • anomaly_score_id — BIGINT — Foreign key → anomaly_window_score.id — NOT NULL
  • sample_count — INTEGER
  • fill_ratio — DOUBLE PRECISION

collection_run

  • run_id — UUID — Primary key — NOT NULL
  • machine_id — BIGINT — Foreign key → machine.machine_id
  • requested_at — TIMESTAMPTZ — NOT NULL
  • started_at — TIMESTAMPTZ
  • ended_at — TIMESTAMPTZ
  • last_seen_at — TIMESTAMPTZ
  • status — TEXT — NOT NULL
  • source — TEXT — NOT NULL
  • expected_session_count — INTEGER — NOT NULL
  • daq_version — TEXT
  • config_hash — TEXT
  • end_reason — TEXT
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL

collection_run_sensor

  • collection_run_sensor_id — BIGINT — Primary key — NOT NULL
  • run_id — UUID — Foreign key → collection_run.run_id — NOT NULL
  • sensor_id (sensor_id2) — BIGINT — Foreign key → sensor.sensor_id — NOT NULL
  • sensor_name_snapshot — TEXT
  • sensor_type_snapshot — TEXT
  • sensor_options_snapshot — JSONB
  • unit_snapshot — TEXT
  • sample_rate_snapshot — DOUBLE PRECISION
  • display_order_snapshot — INTEGER
  • snapshot_source — TEXT — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL

collection_session

  • session_id — TEXT — Primary key — NOT NULL
  • run_id — UUID — Foreign key → collection_run.run_id
  • status — TEXT — NOT NULL
  • source — TEXT — NOT NULL
  • started_at — TIMESTAMPTZ
  • ended_at — TIMESTAMPTZ
  • last_seen_at — TIMESTAMPTZ
  • end_reason — TEXT
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL

company

  • company_id — BIGINT — Primary key — NOT NULL
  • company_code — TEXT — NOT NULL
  • company_name — TEXT — NOT NULL
  • company_role — TEXT — NOT NULL
  • is_active — BOOLEAN — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL

component

  • component_id — BIGINT — Primary key — NOT NULL
  • machine_id — BIGINT — Foreign key → machine.machine_id — NOT NULL
  • component_kind_id — BIGINT — Foreign key → component_kind.component_kind_id
  • component_name — TEXT — NOT NULL
  • component_options — JSONB — NOT NULL
  • display_order — INTEGER — NOT NULL
  • is_active — BOOLEAN — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL

component_category

  • category_id — BIGINT — Primary key — NOT NULL
  • category_code — TEXT — NOT NULL
  • category_name — TEXT — NOT NULL
  • description — TEXT
  • display_order — INTEGER
  • is_active — BOOLEAN — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL

component_kind

  • component_kind_id — BIGINT — Primary key — NOT NULL
  • component_type_id — BIGINT — Foreign key → component_type.component_type_id — NOT NULL
  • kind_code — TEXT — NOT NULL
  • kind_name — TEXT — NOT NULL
  • description — TEXT
  • display_order — INTEGER
  • is_active — BOOLEAN — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL

component_type

  • component_type_id — BIGINT — Primary key — NOT NULL
  • category_id — BIGINT — Foreign key → component_category.category_id — NOT NULL
  • type_code — TEXT — NOT NULL
  • type_name — TEXT — NOT NULL
  • description — TEXT
  • display_order — INTEGER
  • is_active — BOOLEAN — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL

machine

  • machine_id — BIGINT — Primary key — NOT NULL
  • machine — TEXT — NOT NULL
  • company_id — BIGINT — Foreign key → company.company_id
  • is_active — BOOLEAN — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL

rate_log

  • time — TIMESTAMPTZ — NOT NULL
  • sensor_id — BIGINT — Foreign key → sensor.sensor_id — NOT NULL
  • rate — REAL — NOT NULL

rul_window_prediction

  • id — BIGSERIAL — Primary key — NOT NULL
  • component_id — BIGINT — Foreign key → component.component_id — NOT NULL
  • scenario — TEXT — NOT NULL
  • model_version — TEXT — NOT NULL
  • feature_set_version — TEXT — NOT NULL
  • window_start_ts — TIMESTAMPTZ — NOT NULL
  • window_end_ts — TIMESTAMPTZ — NOT NULL
  • stride_sec — DOUBLE PRECISION — NOT NULL
  • sampling_hz — DOUBLE PRECISION
  • sample_count — INTEGER — NOT NULL
  • expected_sample_count — INTEGER
  • fill_ratio — DOUBLE PRECISION
  • status — TEXT — NOT NULL
  • status_message — TEXT
  • hi_score — DOUBLE PRECISION
  • progress_hat — DOUBLE PRECISION
  • raw_pred_rul_s — DOUBLE PRECISION
  • pred_rul_s — DOUBLE PRECISION
  • cap_s — DOUBLE PRECISION
  • features_json — JSONB — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL

rul_window_prediction_sensor_source

  • rul_prediction_id — BIGINT — Foreign key → rul_window_prediction.id — NOT NULL
  • sample_count — INTEGER
  • fill_ratio — DOUBLE PRECISION

sensor

  • sensor_id — BIGINT — Primary key — NOT NULL
  • component_id — BIGINT — Foreign key → component.component_id — NOT NULL
  • sensor_name — TEXT — NOT NULL
  • sensor_type — TEXT — NOT NULL
  • sensor_options — JSONB — NOT NULL
  • display_order — INTEGER — NOT NULL
  • is_active — BOOLEAN — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL

sensor_data_v2

  • time — TIMESTAMPTZ — NOT NULL
  • sensor_id — BIGINT — Foreign key → sensor.sensor_id — NOT NULL
  • value — REAL — NOT NULL
  • storage_epoch — SMALLINT — NOT NULL

sensor_gap_log

  • session_id — TEXT — Primary key — NOT NULL
  • sequence_no — BIGINT — Primary key — NOT NULL
  • sensor_id — BIGINT — Foreign key → sensor.sensor_id — NOT NULL
  • gap_start — TIMESTAMPTZ — NOT NULL
  • gap_end — TIMESTAMPTZ — NOT NULL
  • gap_sec — DOUBLE PRECISION — NOT NULL
  • prev_session_id — TEXT
  • prev_sequence_no — BIGINT
  • detected_at — TIMESTAMPTZ — NOT NULL

sensor_ingest_log_v2

  • server_received_at — TIMESTAMPTZ — Primary key — NOT NULL
  • sequence_no — BIGINT — Primary key — NOT NULL
  • session_id — TEXT — Foreign key → collection_session.session_id — NOT NULL
  • sensor_id — BIGINT — Foreign key → sensor.sensor_id — NOT NULL
  • batch_start_time — TIMESTAMPTZ — NOT NULL
  • batch_duration — DOUBLE PRECISION — NOT NULL
  • sample_rate — DOUBLE PRECISION — NOT NULL
  • sample_count — INTEGER — NOT NULL
  • payload_fingerprint — TEXT
  • storage_epoch — SMALLINT — NOT NULL