dbdb

Tables (4)

GeneratedResult (Untitled4)

  • Key — Primary key — NOT NULL
  • ResultID (integer) — pk, increment
  • SearchID (int) — ref: > SearchHistory.SearchID
  • GeneratedText (text) — not null
  • GeneratedDate (datetime) — default: `CURRENT_TIMESTAMP`
  • Key (Key2) — Foreign key → SearchHistory.Key — NOT NULL

Product (Untitled2)

  • Key — Primary key — NOT NULL
  • ProductID (integer) — pk, increment
  • Name (varchar(100)) — not null
  • Description (varchar(500)) — text
  • Price (decimal(10,2)) — not null
  • StockQuantity (int) — not null

SearchHistory (Untitled3)

  • Key — Primary key — NOT NULL
  • SearchID (int) — pk, increment
  • UserID (integer) — ref: > User.UserID
  • SearchTerm (varchar(255)) — not null
  • SearchDate (datetime) — default: `CURRENT_TIMESTAMP`
  • Key (Key2) — Foreign key → User.Key — NOT NULL

User (Untitled)

  • Key — Primary key — NOT NULL
  • UserID (int) — pk, increment
  • Name (varchar_name) — not null
  • Email (varchar_email) — unique, not null
  • Password (varchar_password) — not null
  • RegistrationDate (datetime) — DEFAULT CURRENT_TIMESTAMP()