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