필름 QMS

테이블 (7)

MST_PLANT

  • PLANT_ID — dbo.NV_ID — 기본 키 — NOT NULL
  • PLANT_NAME — dbo.NV_NAME
  • PU_ID — dbo.NV_ID
  • NATION — nvarchar(10)
  • NATION_NAME — nvarchar(10)
  • TIME_GAP — int
  • USE_YN — dbo.NV_ID
  • CREATED_BY — dbo.NV_ID
  • CREATED_ON — datetime
  • MODIFIED_BY — dbo.NV_ID
  • MODIFIED_ON — datetime

POLY_ITEM

  • PLANT_ID — dbo.NV_ID — 기본 키 — NOT NULL
  • POLY_ID — dbo.NV_ID — 기본 키 — NOT NULL
  • POLY_NAME — dbo.NV_NAME
  • PRT_ORDER — dbo.NUM_INT
  • PROCESS_ID — dbo.NV_ID
  • USE_YN — dbo.NV_ID
  • CREATED_BY — dbo.NV_ID
  • CREATED_ON — datetime
  • MODIFIED_BY — dbo.NV_ID
  • MODIFIED_ON — datetime

검사 항목 (INSPECT_ITEM)

  • PU_ID — dbo.NV_ID — 기본 키 — NOT NULL
  • INSPECT_ID — dbo.NV_ID — 기본 키 — NOT NULL
  • PU_ID (PU_ID2) — dbo.NV_ID — 외래 키 → 기준정보_단위.PU_ID — NOT NULL
  • UNIT_ID — dbo.NV_ID — 외래 키 → 기준정보_단위.UNIT_ID — NOT NULL
  • INSPECT_NAME — dbo.NV_NAME
  • DATA_TYPE — dbo.NV_ID
  • USE_YN — dbo.NV_ID
  • CREATED_BY — dbo.NV_ID
  • CREATED_ON — datetime
  • MODIFIED_BY — dbo.NV_ID
  • MODIFIED_ON — datetime
  • IMPT_INSPECT — dbo.NV_ID
  • PLANT_ID — dbo.NV_ID — 외래 키 → 중합 시험항목.PLANT_ID — NOT NULL
  • INSPECT_ID (INSPECT_ID2) — dbo.NV_ID — 외래 키 → 중합 시험항목.INSPECT_ID — NOT NULL

기준정보_단위 (MST_UNIT)

  • PU_ID — dbo.NV_ID — 기본 키 — NOT NULL
  • UNIT_ID — dbo.NV_ID — 기본 키 — NOT NULL
  • UNIT_NAME — dbo.NV_ID
  • USE_YN — dbo.NV_ID
  • CREATED_BY — dbo.NV_ID
  • MODIFIED_BY — dbo.NV_ID
  • CREATED_ON — datetime
  • MODIFIED_ON — datetime
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =

중합 시험 결과 (POLY_RESULT)

  • INSPECT_DATE — dbo.CH_DATE — 기본 키 — NOT NULL
  • SAMPLE_DATE — dbo.CH_DATE — 기본 키 — NOT NULL
  • PLANT_ID — dbo.NV_ID — 기본 키 — NOT NULL
  • CLASS_ID — dbo.NV_ID — 기본 키 — NOT NULL
  • INSPECT_ID — dbo.NV_ID — 기본 키 — NOT NULL
  • POLY_TYPE — dbo.NV_ID — 기본 키 — NOT NULL
  • POLY_ID — dbo.NV_ID — 기본 키 — NOT NULL
  • LINE_ID — dbo.NV_ID — 기본 키 — NOT NULL
  • LOT — dbo.NV_ID
  • LOT_SEQ — dbo.NV_ID
  • POS — dbo.NV_ID
  • DOFF — dbo.NUM_INT
  • END_ID — dbo.NV_ID
  • INSPECT_TYPE — dbo.NV_ID
  • DECISION_ID — dbo.NV_ID
  • VALUE — dbo.NUM_VALUE
  • RANGE — dbo.NUM_VALUE
  • STDDEV — dbo.NUM_VALUE
  • MAX_VAL — dbo.NUM_VALUE
  • MIN_VAL — dbo.NUM_VALUE
  • REPEAT — dbo.NUM_INT
  • INSPECTOR — dbo.NV_ID
  • SAMPLE_TIME — nvarchar(10)
  • SPEC_COLOR — dbo.NV_ID
  • USE_YN — dbo.NV_ID
  • USL — dbo.NUM_VALUE
  • SL — dbo.NUM_VALUE
  • LSL — dbo.NUM_VALUE
  • UCL — dbo.NUM_VALUE
  • CL — dbo.NUM_VALUE
  • LCL — dbo.NUM_VALUE
  • MARK — dbo.NV_ID
  • TOLERANCE — dbo.NUM_VALUE
  • CREATED_BY — dbo.NV_ID
  • CREATED_ON — datetime
  • MODIFIED_BY — dbo.NV_ID
  • MODIFIED_ON — datetime

중합 시험 스펙 (POLY_SPEC)

  • PLANT_ID — dbo.NV_ID — 기본 키 — NOT NULL
  • CLASS_ID — dbo.NV_ID — 기본 키 — NOT NULL
  • POLY_ID — dbo.NV_ID — 기본 키 — NOT NULL
  • POLY_TYPE — dbo.NV_ID — 기본 키 — NOT NULL
  • INSPECT_ID — dbo.NV_ID — 기본 키 — NOT NULL
  • LINE_ID — dbo.NV_ID — 기본 키 — NOT NULL
  • APPLY_DATE — dbo.CH_DATE — 기본 키 — NOT NULL
  • USL — dbo.NUM_VALUE
  • SL — dbo.NUM_VALUE
  • LSL — dbo.NUM_VALUE
  • UCL — dbo.NUM_VALUE
  • CL — dbo.NUM_VALUE
  • LCL — dbo.NUM_VALUE
  • MARK — dbo.NV_ID
  • TOLERANCE — dbo.NUM_VALUE
  • CL_TOLERANCE — dbo.NUM_VALUE
  • LEVEL — dbo.NV_ID
  • CIPHER — dbo.NUM_INT
  • APPROVE_YN — dbo.NV_ID
  • CREATED_BY — dbo.NV_ID
  • CREATED_ON — datetime
  • MODIFIED_BY — dbo.NV_ID
  • MODIFIED_ON — datetime
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =
  • PU_ID — dbo.NV_ID — 외래 키 → 검사 항목.PU_ID — NOT NULL
  • INSPECT_ID (INSPECT_ID2) — dbo.NV_ID — 외래 키 → 검사 항목.INSPECT_ID — NOT NULL
  • PU_ID (PU_ID2) — dbo.NV_ID — 외래 키 → 검사 항목.PU_ID — NOT NULL
  • UNIT_ID — dbo.NV_ID — 외래 키 → 검사 항목.UNIT_ID — NOT NULL

중합 시험항목 (POLY_PLANT_INSPECT)

  • PLANT_ID — dbo.NV_ID — 기본 키 — NOT NULL
  • INSPECT_ID — dbo.NV_ID — 기본 키 — NOT NULL
  • PRT_ORDER — dbo.NUM_INT
  • DATA_TYPE — dbo.NV_ID
  • CIPHER — dbo.NUM_INT
  • PRT_NAME — dbo.NV_NAME
  • UNIT_ID — dbo.NV_ID
  • UNIT_NAME — dbo.NV_NAME
  • PAFS_RATE — dbo.NUM_INT
  • INSPECT_CYCLE — dbo.NUM_INT
  • MNG_MARK — dbo.NV_ID
  • MNG_TOLERANCE — dbo.NUM_VALUE
  • USE_YN — dbo.NV_ID
  • CREATED_BY — dbo.NV_ID
  • CREATED_ON — datetime
  • MODIFIED_BY — dbo.NV_ID
  • MODIFIED_ON — datetime