SHOPBEE
Tables (16)
Untitled (Users)
- Key (UserID) — int — Primary key — NOT NULL
- Field (Username) — varchar
- Field (Email) — varchar
- Field (PasswordHash) — char
- Field (BusinessName) — varchar
- Field (CreationDate) — datetime
- Field (LastLogin) — datetime
Untitled (Channel_Accounts)
- Key (ChannelAccountID) — int — Primary key — NOT NULL
- Field (Status) — varchar
- Field (LastUpdated) — datetime
- Key (UserID) — int — Foreign key → Untitled.Key — NOT NULL
- Key (ChannelID) — int — Foreign key → Untitled.Key — NOT NULL
Untitled (Channels)
- Key (ChannelID) — int — Primary key — NOT NULL
- Field (ChannelName) — varchar
Untitled (Products)
- Key (ProductID) — int — Primary key — NOT NULL
- Field (ProductName) — varchar
- Field (Description) — text
- Field (Season) — varchar
- Field (Category) — varchar
- Field (Price) — decimal
- Field (Status) — varchar
- Key (UserID) — int — Foreign key → Untitled.Key — NOT NULL
- Key (BrandID) — int — Foreign key → Untitled.Key — NOT NULL
Untitled (Inventory)
- Key (InventoryID) — int — Primary key — NOT NULL
- Field (StockQunatity) — int
- Field (LastUpdated) — datetime
- Key (ProductID) — int — Foreign key → Untitled.Key — NOT NULL
Untitled (Brands)
- Key (BrandID) — int — Primary key — NOT NULL
- Field (BrandName) — varchar
- Key (UserID) — int — Foreign key → Untitled.Key — NOT NULL
Untitled (Channel_Products)
- Key (ChannelProductID) — int — Primary key — NOT NULL
- Field (ChannelProductCode) — varchar
- Field (Status) — enum
- Field (LastUpdated) — datetime
- Key (ChannelAccountID) — int — Foreign key → Untitled.Key — NOT NULL
- Key (ProductID2) — int — Foreign key → Untitled.Key — NOT NULL
Untitled (Orders)
- Key (OrderID) — int — Primary key — NOT NULL
- Field (Orderdate) — datetime
- Field (Quantity) — int
- Field (Status) — varchar
- Key (UserID) — int — Foreign key → Untitled.Key — NOT NULL
- Key (ChannelProductID) — int — Foreign key → Untitled.Key — NOT NULL
Untitled (Revenue_Summary)
- Key (SummaryID) — int — Primary key — NOT NULL
- Field (TotalSales) — decimal
- Field (TotalOrders) — int
- Field (SummaryPeriod) — varchar
- Field (CreatedDate) — datetime
- Key (ChannelProductID) — int — Foreign key → Untitled.Key — NOT NULL
Untitled (Documents)
- Key (DocumentID) — int — Primary key — NOT NULL
- Field (Title) — varchar
- Field (Content) — text
- Field (Source) — varchar
- Field (CreationDate) — datetime
- Field (LastUpdated) — datetime
Untitled (Document_Embeddings)
- Key (EmbeddingID) — int — Primary key — NOT NULL
- Field (EmbeddingVector) — json
- Field (Dimension) — int
- Field (EmbeddingType) — varchar
- Field (CreationDate) — datetime
- Key (DocumentID) — int — Foreign key → Untitled.Key — NOT NULL
Untitled (Questions)
- Key (QuestionID) — int — Primary key — NOT NULL
- Field (QuestionText) — text
- Field (CreationDate) — datetime
- Key (UserID) — int — Foreign key → Untitled.Key — NOT NULL
Untitled (Answers)
- Key (AnswerID) — int — Primary key — NOT NULL
- Field (AnswerText) — text
- Field (CreationDate) — datetime
- Key (QuestionID) — int — Foreign key → Untitled.Key — NOT NULL
Untitled (UserFeedback)
- Key (FeedbackID) — int — Primary key — NOT NULL
- Field (Rating) — int
- Field (Comments) — text
- Key (AnswerID) — int — Foreign key → Untitled.Key — NOT NULL
- Key (UserID) — int — Foreign key → Untitled.Key — NOT NULL
Untitled (Model_TrainingData)
- Key (DataID) — int — Primary key — NOT NULL
- Field (UsageFlag) — int
- Key (QuestionID) — int — Foreign key → Untitled.Key — NOT NULL
- Key (AnswerID) — int — Foreign key → Untitled.Key — NOT NULL
- Key (DocumentID) — int — Foreign key → Untitled.Key — NOT NULL
- Key (UserID) — int — Foreign key → Untitled.Key — NOT NULL
Untitled (Model_Performance)
- Key (PerformanceID) — int — Primary key — NOT NULL
- Field (ModelVersion) — varchar
- Field (Accuracy) — decimal
- Field (Loss) — decimal
- Field (EvaluationDate) — datetime
- Key (UserID) — int — Foreign key → Untitled.Key — NOT NULL