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