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