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