mm

Tables (9)

CUSTOMER (CopyOfUntitled)

  • CNO (Field) — Primary key
  • CName (Field2)
  • CAddress (Field3)
  • CPhone (Field4)

F_WH (CopyOfCopyOfMM)

  • FNO (자재 이름) — Primary key
  • MNO (자재 이름2) — Foreign key → MM.MNO
  • RNO (Field2)
  • CNO (Field3)
  • Ord (Field4)
  • avail (Field5)

MM

  • MNO (자재 이름) — Primary key
  • MType (Field)
  • MName (Field2)
  • MPrice (Field3)
  • Mlocation (Field4)

PLANT (Untitled3)

  • PNO (Field) — Primary key
  • RNO (자재 이름) — Foreign key → R_WH.RNO
  • MNO (자재 이름2) — Foreign key → R_WH.MNO

PrO (CopyOfCopyOfUntitled2)

  • PrNO (Field) — Primary key
  • RNO (Field2)

PuO (Untitled2)

  • PuNO (Field) — Primary key
  • MNO (Field2)
  • VNO (Field3)

R_WH (CopyOfMM)

  • RNO (자재 이름) — Primary key
  • MNO (자재 이름2) — Foreign key → MM.MNO
  • VNO (Field2)
  • Ord (Field3)
  • avail (Field4)

SaO (CopyOfUntitled2)

  • SaNO (Field) — Primary key
  • FNO (Field2)
  • CNO (Field3)

VENDOR (Untitled)

  • VNO (Field) — Primary key
  • VName (Field2)
  • VAddress (Field3)
  • VPhone (Field4)