Pharmacy_vendingMachine

Tables (6)

Machine (Untitled)

  • Machine_Number (Key) — number — Primary key — NOT NULL
  • Medicine_number (Field3)
  • Machine_Name (Field)
  • Machine_Location (Field2) — NOT NULL

Machine_medicine (Untitled6)

  • Machine_Number (Key) — number — Primary key — NOT NULL
  • Medicine_number (Field3)
  • Machine_Name (Field)
  • Machine_Location (Field2) — NOT NULL

Medicine (Untitled2)

  • Medicine_Number (Key) — Primary key — NOT NULL

Pharmacist1 (Untitled3)

  • Pharmacist_Number (Key) — number — Primary key — NOT NULL
  • Pharmacist_Name (Field)
  • ID (Field2)
  • Passoword (Field3)
  • PhoneNumber (Field4)
  • Pharmacy_Location (Field5)

Pharmacist2 (Untitled4)

  • Pharmacist_Number (Key) — Number — Primary key — NOT NULL
  • Pharmacist_Name (Field)
  • ID (Field2)
  • Passoword (Field3)
  • PhoneNumber (Field4)
  • Pharmacy_Location (Field5)

Pharmacist3 (Untitled5)

  • Pharmacist_Number (Key) — Number — Primary key — NOT NULL
  • Pharmacist_Name (Field)
  • ID (Field2)
  • Passoword (Field3)
  • PhoneNumber (Field4)
  • Pharmacy_Location (Field5)