cal_be
Tables (14)
cal1_coil_exist_threshold
- source_channel — varchar(32) — Primary key — NOT NULL
- exist_score_threshold — double precision — NOT NULL
- window_size — integer — NOT NULL
- trigger_count — integer — NOT NULL
- release_count — integer — NOT NULL
cal1_inspection_event
- id — bigint — Primary key — NOT NULL
- product_no — varchar(128) — NOT NULL
- inspection_type — varchar(32) — NOT NULL
- level — varchar(32) — NOT NULL
- result — varchar(32) — NOT NULL
- source_channel — varchar(32) — NOT NULL
- source_session_id — bigint — NOT NULL
- timestamp — bigint — NOT NULL
- score — double precision — NOT NULL
- exist_score — double precision — NOT NULL
- noise_std — double precision — NOT NULL
- hf_energy — double precision — NOT NULL
- edge_density — double precision — NOT NULL
- local_std_mean — double precision — NOT NULL
- model_status — varchar(32) — NOT NULL
- model_message — text — NOT NULL
- inspected_at — timestamptz — NOT NULL
cal1_inspection_image
- id — bigint — Primary key — NOT NULL
- inspection_event_id — bigint — Foreign key → cal1_inspection_event.id — NOT NULL
- path — text — NOT NULL
- captured_at — timestamptz — NOT NULL
cal1_inspection_level_threshold
- inspection_type — varchar(32) — Primary key — NOT NULL
- inspection_level — varchar(32) — Primary key — NOT NULL
- score — double precision — NOT NULL
cal1_inspection_threshold
- inspection_type — varchar(32) — Primary key — NOT NULL
cal2_product_defect_event
- id — bigint — Primary key — NOT NULL
- defect_event_id — bigint — Foreign key → defect_event.id — NOT NULL
- product_id — bigint — Foreign key → product.id — NOT NULL
- status — varchar(32) — NOT NULL
- opened_position_value — numeric(19, 6) — NOT NULL
- closed_position_value — numeric(19, 6)
- opened_at — timestamptz — NOT NULL
- closed_at — timestamptz
- opened_timestamp — bigint — NOT NULL
- closed_timestamp — bigint
defect_event
- id — bigint — Primary key — NOT NULL
- source_session_id — bigint — Foreign key → source_session.id — NOT NULL
- source_line — varchar(16) — NOT NULL
- source_channel — varchar(32) — NOT NULL
- defect_type — varchar(32) — NOT NULL
- status — varchar(32) — NOT NULL
- opened_at — timestamptz — NOT NULL
- closed_at — timestamptz
- opened_timestamp — bigint — NOT NULL
- closed_timestamp — bigint
defect_evidence
- id — bigint — Primary key — NOT NULL
- subject_type — varchar(32) — NOT NULL
- subject_id — bigint — NOT NULL
- status — varchar(32) — NOT NULL
- root_path — text — NOT NULL
- started_at — timestamptz — NOT NULL
- ended_at — timestamptz
- status_detail — text
defect_evidence_asset
- id — bigint — Primary key — NOT NULL
- defect_evidence_id — bigint — Foreign key → defect_evidence.id — NOT NULL
- media_type — varchar(32) — NOT NULL
- path — text — NOT NULL
- display_order — integer — NOT NULL
- original_start_ms — bigint
- original_end_ms — bigint
- duration_ms — bigint
- metadata — jsonb
defect_type_level_threshold
- source_channel — varchar(32) — Primary key — NOT NULL
- defect_type — varchar(32) — Primary key — NOT NULL
- detection_level — varchar(16) — Primary key — NOT NULL
- score — double precision — NOT NULL
defect_type_threshold
- source_channel — varchar(32) — Primary key — NOT NULL
- defect_type — varchar(32) — Primary key — NOT NULL
- window_millis — bigint — NOT NULL
- trigger_millis — bigint — NOT NULL
- release_millis — bigint — NOT NULL
product
- id — bigint — Primary key — NOT NULL
- product_no — varchar(128) — NOT NULL
- created_at — timestamptz — NOT NULL
source_session
- id — bigint — Primary key — NOT NULL
- source_line — varchar(16) — NOT NULL
- source_channel — varchar(32) — NOT NULL
- status — varchar(16) — NOT NULL
- started_at — timestamptz — NOT NULL
- ended_at — timestamptz
- end_reason — varchar(32)
- end_detail — text
speaker_notification_setting
- id — smallint — Primary key — NOT NULL
- enabled — boolean — NOT NULL