필름 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