BMSMES

Tables (4)

jodfix (작업계획)

  • - (refno) — TEXT — Primary key — NOT NULL

jorders (작업(모델/유닛))

  • - (recseq) — INT — Primary key — NOT NULL
  • - (refno) — TEXT — Foreign key → jodfix.- — NOT NULL
  • - (seq) — TEXT

jproceach (공정 시작/합격/불량)

  • recseq (-) — INT — Primary key — NOT NULL

jprocess (공정)

  • - (recseq) — INT — Primary key — NOT NULL
  • - (refno) — TEXT
  • - (seq) — TEXT
  • - (useq) — TEXT
  • - (procsq) — TEXT