NewMPS
Tables (11)
BOM
- Key — Primary key — NOT NULL
- Field
- Field2
Calendar (달력)
- CalendarId (CarendarId) — LONG — Primary key — NOT NULL
- CaMon (CalMon) — LONG
- Field2
FinalGoods (제품)
- MatCode — VARCHAR — Primary key — NOT NULL
- Plant — LONG — Foreign key → Plant.Plant — NOT NULL
- MatName — VARCHAR
- MinStock — LONG
- Stock — LONG
- MaxStock — LONG
Machine (설비)
- MachCode — VARCHAR — Primary key — NOT NULL
- Plant — LONG — Foreign key → Plant.Plant — NOT NULL
- MachName — VARCHAR
- AutoFlag — VARCHAR
Plan (계획)
- Key — Primary key — NOT NULL
- Field
- Field2
Plant (플랜트)
- Plant — LONG — Primary key — NOT NULL
PrdResource (설비별 제품 목록)
- MachCode — VARCHAR — Foreign key → Machine.MachCode — NOT NULL
- Plant — LONG — Foreign key → Machine.Plant — NOT NULL
- MatCode — VARCHAR — Foreign key → FinalGoods.MatCode — NOT NULL
- Unit — VARCHAR
- PrdUPH — LONG
ResCalendar (달력별 설비 목록)
- Key (Key2) — Foreign key → Calendar.CalendarId — NOT NULL
- Key — Foreign key → Machine.MachCode — NOT NULL
- Plant — LONG — Foreign key → Machine.Plant — NOT NULL
- Field
- Field2
SemiGoods (반제품)
- Key — Primary key — NOT NULL
- Field
- Field2
SemiPlan (예비계획)
- Key — Primary key — NOT NULL
- MachCode — VARCHAR — Foreign key → PrdResource.MachCode — NOT NULL
- Plant — LONG — Foreign key → PrdResource.Plant — NOT NULL
- MatCode — VARCHAR — Foreign key → PrdResource.MatCode — NOT NULL
- Field
- Field2
Stock (재고)
- Key — Primary key — NOT NULL
- Field
- Field2