test

Tables (4)

Buy (Untitled2)

  • TranNumber (Key) — Primary key — NOT NULL
  • ID (Key2) — Foreign key → Consumer.ID — NOT NULL
  • Pnumber (Key3) — Foreign key → Product.ProcNumber — NOT NULL
  • ID (Key4) — Foreign key → Product.ID — NOT NULL
  • Field3

Consumer (Untitled)

  • ID (Key) — Primary key — NOT NULL
  • PW (Field2)
  • NAME (Field)

Manager (CopyOfUntitled)

  • ID (Key) — Primary key — NOT NULL
  • PW (Field2)
  • NAME (Field)

Product (CopyOfCopyOfUntitled)

  • ProcNumber (Key3) — Primary key — NOT NULL
  • ID (Key) — Foreign key → Manager.ID — NOT NULL
  • Name (Field2)
  • Price (Field)
  • Count (Field3)