20251209

Tables (15)

_TPDBOM (BOM 정보)

  • ItemSeq (품목내부코드) — NOT NULL — Primary key — NOT NULL
  • ItemBomRev (제품차수) — NOT NULL — Primary key — NOT NULL

_TPDBOMProc (BOM공정정보)

  • GoodSeq (품목코드) — NOT NULL — Primary key — NOT NULL
  • GoodBomRev (품목차수) — NOT NULL — Primary key — NOT NULL
  • ProcRev (공정흐름차수) — NOT NULL — Primary key — NOT NULL
  • ItemSeq (모품목내부코드) — NOT NULL — Foreign key → _TPDBOM.ItemSeq — NOT NULL
  • ItemBomRev (모품목차수) — NOT NULL — Foreign key → _TPDBOM.ItemBomRev — NOT NULL
  • ProcSeq (공정내부코드) — NOT NULL — Foreign key → _TPDBaseProcess.ProcSeq — NOT NULL
  • WorkCentSeq (워크센터내부코드) — NOT NULL — Foreign key → _TPDBaseWorkCenter.WorkCentSeq — NOT NULL

_TPDBaseProcess (공정)

  • ProcSeq (공정내부코드) — NOT NULL — Primary key — NOT NULL

_TPDBaseWorkCenter (워크센터)

  • WorkCentSeq (워크센터내부코드) — NOT NULL — Primary key — NOT NULL

_TPDMPSDailyProdPlan (주간생산계획)

  • ProdPlanSeq (주간생산계획내부코드) — NOT NULL — Primary key — NOT NULL
  • ProdReqNo (생산의뢰번호) — NULL — Foreign key → _TPDMPSProdReq.ProdReqNo
  • WorkCentSeq (워크센터내부코드) — NOT NULL — Foreign key → _TPDBaseWorkCenter.WorkCentSeq — NOT NULL

_TPDMPSProdReq (생산의뢰)

  • ProdReqSeq (생산의뢰내부코드) — NOT NULL — Primary key — NOT NULL
  • ProdReqNo (생산의뢰번호) — NULL — Primary key

_TPDMPSProdReqItem (생산의뢰품목)

  • ProdReqSeq (생산의뢰내부코드) — NOT NULL — Foreign key → _TPDMPSProdReq.ProdReqSeq — NOT NULL
  • ItemSeq (품목내부코드) — NOT NULL

_TPDProcType (공정흐름유형)

  • ProcTypeSeq (공정흐름유형내부코드) — NOT NULL — Primary key — NOT NULL

_TPDProcTypeITem (공정흐름유형공정)

  • ProcTypeSeq (공정흐름유형내부코드) — NOT NULL — Foreign key → _TPDProcType.ProcTypeSeq — NOT NULL
  • ProcSeq (공정내부코드) — NOT NULL — Foreign key → _TPDBaseProcess.ProcSeq — NOT NULL

_TPDROUItemProc (제품별공정)

  • ItemSeq (품목내부코드) — NOT NULL — Primary key — NOT NULL
  • ProcSeq (공정내부코드) — NOT NULL — Foreign key → _TPDBaseProcess.ProcSeq — NOT NULL

_TPDROUItemProcMat (제품별 공정별 소요자재)

  • ItemSeq (품목내부코드) — NOT NULL — Primary key — NOT NULL
  • ProcSeq (공정내부코드) — NOT NULL — Foreign key → _TPDBaseProcess.ProcSeq — NOT NULL
  • WorkCentSeq (워크센터내부코드) — NOT NULL — Foreign key → _TPDBaseWorkCenter.WorkCentSeq — NOT NULL
  • ItemSeq (품목내부코드2) — NOT NULL — Foreign key → _TPDBOM.ItemSeq — NOT NULL
  • ItemBomRev (제품차수) — NOT NULL — Foreign key → _TPDBOM.ItemBomRev — NOT NULL

_TPDROUItemProcType (품목별공정흐름)

  • ItemSeq (품목내부코드) — NOT NULL — Primary key — NOT NULL
  • ProcTypeSeq (공정흐름유형내부코드) — NOT NULL — Foreign key → _TPDProcTypeITem.ProcTypeSeq — NOT NULL

_TPDSFCGoodIn (생산입고)

  • GoodInSeq (입고내부코드) — NOT NULL — Primary key — NOT NULL
  • WorkReportSeq (작업실적내부코드) — NOT NULL — Foreign key → _TPDSFCWorkReport.WorkReportSeq — NOT NULL
  • WorkOrderSeq (작업지시내부코드) — NOT NULL — Foreign key → _TPDSFCWorkOrder.WorkOrderSeq — NOT NULL

_TPDSFCWorkOrder (작업지시)

  • WorkOrderSeq (작업지시내부코드) — NOT NULL — Primary key — NOT NULL
  • WorkOrderSerl (작업지시내부순번) — NOT NULL — Primary key — NOT NULL
  • ProdPlanSeq (주간생산계획내부코드) — NOT NULL — Foreign key → _TPDMPSDailyProdPlan.ProdPlanSeq — NOT NULL
  • WorkCentSeq (워크센터내부코드) — NOT NULL — Foreign key → _TPDBaseWorkCenter.WorkCentSeq — NOT NULL

_TPDSFCWorkReport (생산실적)

  • WorkReportSeq (작업실적내부코드) — NOT NULL — Primary key — NOT NULL
  • WorkOrderSeq (작업지시내부코드) — NOT NULL — Foreign key → _TPDSFCWorkOrder.WorkOrderSeq — NOT NULL
  • WorkOrderSerl (작업지시내부순번) — NOT NULL — Foreign key → _TPDSFCWorkOrder.WorkOrderSerl — NOT NULL
  • WorkCentSeq (워크센터내부코드) — NOT NULL — Foreign key → _TPDBaseWorkCenter.WorkCentSeq — NOT NULL