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()