workshop

Tables (4)

Category (Untitled)

  • Key — Primary key — NOT NULL
  • Category_id (category) — VARCHAR(255)

P_info (p_info)

  • Key — Primary key — NOT NULL
  • ID (id) — INT — Foreign key → Product_info.ID — NOT NULL
  • ID (id2) — INT — Foreign key → Product_info.ID — NOT NULL
  • Key (Key2) — Foreign key → Product_info.Key — NOT NULL
  • Product_id (product) — VARCHAR(255)

Product_info (product)

  • ID (id) — INT — Primary key — NOT NULL
  • ID (id2) — INT — Foreign key → Store.ID — NOT NULL
  • Key — Foreign key → Category.Key — NOT NULL
  • Date (date) — VARCHAR(255)
  • Name (name) — VARCHAR(255)
  • Price (price) — VARCHAR(255)

Store (stores)

  • ID (id) — INT — Primary key — NOT NULL
  • Location (location) — VARCHAR(255)
  • Name (name) — VARCHAR(255)