aaaaaa

Tables (4)

omc_eq_category

  • eq_model_cd — nvarchar(20) — Primary key — NOT NULL
  • item_id — varchar(10) — Primary key — NOT NULL
  • routing_seq — numeric(5,0) — Primary key — NOT NULL
  • mgmt_item_cd — nvarchar(20) — Foreign key → omc_mgmt_item.mgmt_item_cd — NOT NULL

omc_mgmt_item

  • mgmt_item_cd — nvarchar(20) — Primary key — NOT NULL
  • mgmt_item_nm — nvarchar(100)
  • input_type — varchar(2)

omc_qc_category

  • item_id — varchar(10) — Primary key — NOT NULL
  • start_dt — varchar(8) — Primary key — NOT NULL
  • mgmt_item_cd — nvarchar(20) — Foreign key → omc_mgmt_item.mgmt_item_cd — NOT NULL
  • seq — numeric(5,0)
  • qc_spec_std — numeric(20,8)
  • qc_spec_min — numeric(20,8)
  • qc_spec_max — numeric(20,8)

oqm_eq_result

  • seq — bigint — Primary key — NOT NULL
  • eq_model_cd2 — nvarchar(20) — Foreign key → omc_eq_category.eq_model_cd — NOT NULL
  • measure_value — nvarchar(200)
  • create_dt — datetime