ㄴㅇㅁㄴㅇㅁㄴㅇ
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