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 설명