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