SpartaErpSystem

Tables (3)

Product

  • Key (id) — INT — Primary key — NOT NULL
  • id (author) — Foreign key → User.id — NOT NULL
  • category — CHAR
  • Field (code) — CHAR
  • Field (name) — CHAR
  • Field (description) — CHAR
  • Field (pirce) — INT
  • Field (size) — CHAR

Untitled (Inventory)

  • Field (id) — INT — Primary key
  • id (author) — Foreign key → User.id — NOT NULL
  • Key (product) — INT — Foreign key → Product.Key — NOT NULL
  • Field (increased_inventory) — INT
  • Field (decreased_inventory) — INT

User (UserModel)

  • id — INT — Primary key — NOT NULL
  • name (username) — CHAR
  • password — CHAR