Spaces:
Sleeping
Sleeping
File size: 1,113 Bytes
f53fbd9 | 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 | :setvar DemoDatabase "CustomerAIDemo2022"
USE [$(DemoDatabase)];
GO
IF OBJECT_ID(N'dbo.RealFeedbackEmbedding', N'U') IS NOT NULL
DROP TABLE dbo.RealFeedbackEmbedding;
GO
IF OBJECT_ID(N'dbo.RealEmbeddingMetadata', N'U') IS NOT NULL
DROP TABLE dbo.RealEmbeddingMetadata;
GO
CREATE TABLE dbo.RealEmbeddingMetadata
(
ModelName NVARCHAR(200) NOT NULL,
DimensionCount INT NOT NULL,
CreatedAt DATETIME2(0) NOT NULL DEFAULT SYSUTCDATETIME(),
EmbeddingRowCount INT NOT NULL,
CONSTRAINT PK_RealEmbeddingMetadata
PRIMARY KEY CLUSTERED (ModelName)
);
GO
CREATE TABLE dbo.RealFeedbackEmbedding
(
FeedbackId INT NOT NULL,
DimensionIndex INT NOT NULL,
Value FLOAT NOT NULL,
CONSTRAINT PK_RealFeedbackEmbedding
PRIMARY KEY CLUSTERED (FeedbackId, DimensionIndex),
CONSTRAINT FK_RealFeedbackEmbedding_CustomerFeedback
FOREIGN KEY (FeedbackId)
REFERENCES dbo.CustomerFeedback (FeedbackId)
);
GO
CREATE INDEX IX_RealFeedbackEmbedding_Dimension
ON dbo.RealFeedbackEmbedding (DimensionIndex, FeedbackId)
INCLUDE (Value);
GO
|