CVS

Tables (3)

Products (products)

  • Product ID (product_id) — INT(13) — Primary key — NOT NULL
  • Name (name) — VARCHAR(255)
  • Kind (kind) — VARCHAR(255)
  • Price (price) — VARCHAR(255)

Stock (stock)

  • Stock ID (quantity_id) — INT(13) — Primary key — NOT NULL
  • Product ID (product_id) — INT(13) — Foreign key → Products.Product ID — NOT NULL
  • Store ID (sotre_id) — INT(13) — Foreign key → Store.Store ID — NOT NULL
  • quantity — VARCHAR(255)
  • Created At (created_at) — VARCHAR(255)
  • Valid Date (valid_date) — VARCHAR(255)

Store (store)

  • Store ID (sotre_id) — INT(13) — Primary key — NOT NULL
  • Location (location) — VARCHAR(255)
  • Phone (phone) — VARCHAR(255)
  • Budget (budget) — VARCHAR(255)