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