Qality

Tables (11)

QA_Collection_Plan

  • Plan_ID — Number — Primary key — NOT NULL
  • Org_ID — Number — Primary key
  • Plan_Name — Varchar2(200)
  • Description — Varchar2(1000)
  • Plan_Type — Varchar2(50)
  • Import_View — Varchar2(200)
  • View_Name — Varchar2(200)
  • Start_Date — Date — NOT NULL — 적용시작
  • End_Date — Date — 적용종료

QA_Element

  • Element_ID — Number — Primary key — NOT NULL
  • Element_Name — Varchar2(200)
  • Description — Varchar2(1000)
  • Prompt — Varchar2(200) — 화면에 표시 명칭
  • Element_Type — Varchar2(50) — NOT NULL — 입력값 유형
  • Value_Length — Number
  • LOV_ID — Number — 공통코드 ID, 해당 Element에 Plan_Results가 있으면 변경 안된다.
  • Defalut_Value — Varchar2(250)
  • Start_Date — Date — NOT NULL — 적용시작일
  • End_Date — Date — 적용종료

QA_Element_Action

  • Action_ID — Number — Primary key — NOT NULL
  • Element_ID — Number — Foreign key → QA_Element.Element_ID — NOT NULL
  • Action_Type — Number — Action_Type LOV Creat WO, Creat WR, Creat PR, Send MSG, Error Popup 등
  • Action_Detail — Action의 세부내용

QA_Plan_Element

  • Plan_ID — Number — Foreign key → QA_Collection_Plan.Plan_ID — NOT NULL
  • Element_ID (Element_ID2) — Number — Foreign key → QA_Element.Element_ID — NOT NULL
  • Org_ID — Number — Foreign key → QA_Collection_Plan.Org_ID
  • Element_Sequence — Numbert — 나타내는 순서
  • Element_Name — Varchar2(200)
  • Description — Varchar2(1000)
  • Prompt — Varchar2(200) — 화면에 표시 명칭
  • Element_Type — Varchar2(50) — NOT NULL — 입력값 유형
  • Value_Length — Number
  • LOV_ID — Number — 공통코드 ID, 해당 Element에 Plan_Results가 있으면 변경 안된다.
  • Defalut_Value — Varchar2(250)
  • Start_Date — Date — NOT NULL — 적용시작일
  • End_Date — Date — 적용종료

QA_Plan_Element_SPC

  • SPC_Class — Number — Primary key — SPC_Class LOV 품목,고객,업체,All
  • SPC_Type — Number — Primary key — SPC_Type LOV ID User, Reasonable, Specification 등
  • Plan_ID — Number — Foreign key → QA_Plan_Element.Plan_ID — NOT NULL
  • Element_ID (Element_ID2) — Number — Foreign key → QA_Plan_Element.Element_ID — NOT NULL
  • Org_ID — Number — Foreign key → QA_Plan_Element.Org_ID
  • Center_Value — Numbert
  • Low_Limit — Numbert — 하한 한계값
  • High_Limit — Numbert — 상한 한계값
  • Value_Tolerance_High — Numbert — +공차
  • Value_Tolerance_Low — Numbert — -공차
  • SPC_ID — Number — NOT NULL

QA_Plan_Hierarchy

  • Plan_ID (Plan_ID2) — Number — Foreign key → QA_Collection_Plan.Plan_ID — NOT NULL
  • Org_ID — Number — Foreign key → QA_Collection_Plan.Org_ID
  • Child_Plan_ID — Number — Foreign key → QA_Plan_Hierarchy.Plan_ID — NOT NULL — Child_Plan_ID
  • Relationshipo_Type — Number — Relationshipo_Type LOV
  • Auto_Count — Numbert
  • Entry_Mode — Number — LOV immediate, deferred or history
  • Start_Date — Date — NOT NULL — 적용시작
  • End_Date — Date — 적용종료
  • Hierarchy_ID — Number — NOT NULL

QA_Results_Action

  • Action_ID — Number — Primary key — NOT NULL
  • Plan_ID (Plan_ID2) — Number — Foreign key → QA_Results_Det.Plan_ID — NOT NULL
  • Org_ID (Org_ID2) — Number — Foreign key → QA_Results_Det.Org_ID
  • Trigger_Category — Number — Foreign key → QA_Results_Det.Trigger_Category — Trigger_Category LOV 품목,업체,WO,Move 등
  • Trigger_Sequence — Numbert — Foreign key → QA_Results_Det.Trigger_Sequence — NOT NULL
  • Trigger_ID — Number — Foreign key → QA_Results_Det.Trigger_ID — NOT NULL — Trigger Header ID
  • Action_Type — Number — Action_Type LOV Creat WO, Creat WR, Creat PR, Send MSG, Error Popup 등
  • Action_Detail — Action의 세부내용

QA_Results_Det

  • Plan_ID (Plan_ID2) — Number — Foreign key → QA_Collection_Plan.Plan_ID — NOT NULL
  • Org_ID (Org_ID2) — Number — Foreign key → QA_Collection_Plan.Org_ID
  • Trigger_Category — Number — Foreign key → QA_Trigger.Trigger_Category — Trigger_Category LOV 품목,업체,WO,Move 등
  • Trigger_Sequence — Numbert — Foreign key → QA_Trigger.Trigger_Sequence — NOT NULL
  • Trigger_ID — Number — Foreign key → QA_Trigger.Trigger_ID — NOT NULL — Trigger Header ID
  • Element_Sequence — Numbert
  • Element_Name — Varchar2(200)
  • Description — Varchar2(1000)
  • Prompt — Varchar2(200) — 화면에 표시 명칭
  • Element_Type — Varchar2(50) — NOT NULL — 입력값 유형
  • Value_Length — Number
  • LOV_ID — Number — 공통코드 ID, 해당 Element에 Plan_Results가 있으면 변경 안된다.
  • Defalut_Value — Varchar2(250)
  • Start_Date — Date — NOT NULL — 적용시작일
  • End_Date — Date — 적용종료

QA_SPC

  • SPC_Class — Number — Primary key — SPC_Class LOV 품목,고객,업체,All
  • SPC_Type — Number — Primary key — SPC_Type LOV ID User, Reasonable, Specification 등
  • Element_ID (Element_ID2) — Number — Foreign key → QA_Element.Element_ID — NOT NULL
  • Center_Value — Numbert
  • Low_Limit — Numbert — 하한 한계값
  • High_Limit — Numbert — 상한 한계값
  • Value_Tolerance_High — Numbert — +공차
  • Value_Tolerance_Low — Numbert — -공차
  • SPC_ID — Number — NOT NULL

QA_Trigger

  • Trigger_Category — Number — Primary key — Trigger_Category LOV 품목,업체,WO,Move 등
  • Trigger_Sequence — Numbert — Primary key — NOT NULL
  • Trigger_ID — Number — Foreign key → QA_Trigger_Header.Trigger_ID — NOT NULL — Trigger Header ID
  • Plan_ID — Number — Foreign key → QA_Trigger_Header.Plan_ID — NOT NULL
  • Org_ID — Number — Foreign key → QA_Trigger_Header.Org_ID
  • Trigger_Cat_From — Number — 작업,OSP,입고,공정,Audit 등의 Number
  • Trigger_Cat_To — Number — 작업,OSP,입고,공정,Audit 등의 Number
  • Trigger_Serial_From — From Serial Number
  • Trigger_Serial_To — To Serial Number

QA_Trigger_Header

  • Trigger_ID — Number — Primary key — NOT NULL — Trigger Header ID
  • Plan_ID — Number — Foreign key → QA_Collection_Plan.Plan_ID — NOT NULL
  • Org_ID — Number — Foreign key → QA_Collection_Plan.Org_ID
  • Trigger_Type — Number — Trigger_Type LOV 작업,OSP,입고,공정,Audit 등
  • Trigger_Name — Varchar2(200)
  • Trigger_Description — Varchar2(1000) — Trigger 설명