TEST
Tables (9)
CFMSEQPDEF (보전장비설정)
- FACTORY_CODE (기관코드) — NVARCHAR — Primary key — NOT NULL
- EQUIP_CODE (장비코드) — NVARCHAR — Primary key — NOT NULL
CRASEQPPRC (장비-공정 수가)
- FACTORY_CODE (기관코드) — NVARCHAR — Primary key — NOT NULL
- OPER_CODE (공정코드) — NVARCHAR — Primary key — NOT NULL
- EQUIP_CODE (장비코드) — NVARCHAR — Primary key — NOT NULL
- FACTORY_CODE (기관코드2) — NVARCHAR — Foreign key → CRASOPREQP.FACTORY_CODE — NOT NULL
- OPER_CODE (공정코드2) — NVARCHAR — Foreign key → CRASOPREQP.OPER_CODE — NOT NULL
- EQUIP_CODE (장비코드2) — NVARCHAR — Foreign key → CRASOPREQP.EQUIP_CODE — NOT NULL
- FACTORY_CODE (기관코드22) — NVARCHAR — Foreign key → CRASOPREQP.FACTORY_CODE — NOT NULL
- OPER_CODE (공정코드22) — NVARCHAR — Foreign key → CRASOPREQP.OPER_CODE — NOT NULL
- FACTORY_CODE (기관코드3) — NVARCHAR — Foreign key → CRASOPREQP.FACTORY_CODE — NOT NULL
- EQUIP_CODE (장비코드22) — NVARCHAR — Foreign key → CRASOPREQP.EQUIP_CODE — NOT NULL
- VERSION (관리버전) — NUMERIC
- PRICE (수가) — NUMERIC
- APPLY_TIME (적용기간) — NVARCHAR
CRASOPREQP (장비-공정매핑(사이클타임))
- FACTORY_CODE (기관코드) — NVARCHAR — Primary key — NOT NULL
- OPER_CODE (공정코드) — NVARCHAR — Primary key — NOT NULL
- EQUIP_CODE (장비코드) — NVARCHAR — Primary key — NOT NULL
- FACTORY_CODE (기관코드2) — NVARCHAR — Foreign key → MWIPOPRDEF.FACTORY_CODE — NOT NULL
- OPER_CODE (공정코드2) — NVARCHAR — Foreign key → MWIPOPRDEF.OPER_CODE — NOT NULL
- FACTORY_CODE (기관코드3) — NVARCHAR — Foreign key → MRASEQPDEF.FACTORY_CODE — NOT NULL
- EQUIP_CODE (장비코드2) — NVARCHAR — Foreign key → MRASEQPDEF.EQUIP_CODE — NOT NULL
- CYCLE_TIME (사이클타임) — NUMERIC
MQCMISPSPE (장비 공정 별 검사항목)
- FACTORY_CODE (기관코드) — NVARCHAR — Primary key — NOT NULL
- OPER_CODE (공정코드) — NVARCHAR — Primary key — NOT NULL
- EQUIP_CODE (장비코드) — NVARCHAR — Primary key — NOT NULL
- VERSION (버전) — NUMERIC — Primary key — NOT NULL
- INSP_ITEM_CODE (검사항목코드) — NVARCHAR — Primary key — NOT NULL
- FACTORY_CODE (기관코드2) — NVARCHAR — Foreign key → MQCMITMDEF.FACTORY_CODE — NOT NULL
- INSP_ITEM_CODE (검사항목코드2) — NVARCHAR — Foreign key → MQCMITMDEF.INSP_ITEM_CODE — NOT NULL
MQCMITMDEF (검사항목설정)
- FACTORY_CODE (기관코드) — NVARCHAR — Primary key — NOT NULL
- INSP_ITEM_CODE (검사항목코드) — NVARCHAR — Primary key — NOT NULL
MRASEQPDEF (장비설정)
- FACTORY_CODE (기관코드) — NVARCHAR — Primary key — NOT NULL
- EQUIP_CODE (장비코드) — NVARCHAR — Primary key — NOT NULL
MWIPFLWDEF (플로우설정)
- FACTORY_CODE (기관코드) — NVARCHAR — Primary key — NOT NULL
- FLOW_CODE (플로우코드) — NVARCHAR — Primary key — NOT NULL
MWIPFLWOPR (플로우-공정설정)
- FACTORY_CODE (기관코드) — NVARCHAR — Primary key — NOT NULL
- FLOW_CODE (플로우코드) — NVARCHAR — Primary key — NOT NULL
- OPER_CODE (공정코드) — NVARCHAR — Primary key — NOT NULL
- FACTORY_CODE (기관코드2) — NVARCHAR — Foreign key → MWIPFLWDEF.FACTORY_CODE — NOT NULL
- FLOW_CODE (플로우코드2) — NVARCHAR — Foreign key → MWIPFLWDEF.FLOW_CODE — NOT NULL
- FACTORY_CODE (기관코드3) — NVARCHAR — Foreign key → MWIPOPRDEF.FACTORY_CODE — NOT NULL
- OPER_CODE (공정코드2) — NVARCHAR — Foreign key → MWIPOPRDEF.OPER_CODE — NOT NULL
MWIPOPRDEF (공정설정)
- FACTORY_CODE (기관코드) — NVARCHAR — Primary key — NOT NULL
- OPER_CODE (공정코드) — NVARCHAR — Primary key — NOT NULL