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