saffy0504
Tables (5)
Untitled (Convenience)
- Key (id) — Integer — Primary key — NOT NULL
- Field (local) — VarChar(10)
- Field2 (address) — VarChar(10)
- Field3 (phone) — VarChar(10)
- Field4 (owner) — VarChar(10)
Untitled (Code)
- Key (id) — Integer — Primary key — NOT NULL
- Field (code) — VarChar(10)
- Field (name) — VarChar(10)
Untitled (discount)
- Key (id) — Integer — Primary key — NOT NULL
- Field (season) — Integer
- Field (rate) — Integer
Untitled (Manage)
- id (pr_id) — Integer — Foreign key → products.id — NOT NULL
- Key (code_id) — Integer — Foreign key → products.Key — NOT NULL
- Key (cv_id) — Integer — Foreign key → Untitled.Key — NOT NULL
- Key (discount_id) — Integer — Foreign key → Untitled.Key — NOT NULL
- Field (amount) — Integer
products (Product)
- id — Integer — Primary key — NOT NULL
- Key (code_id) — Integer — Foreign key → Untitled.Key — NOT NULL
- Field3 (manufacture) — VarChar(10)
- Field (price) — Integer