Spaces:
Sleeping
Sleeping
File size: 1,512 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 45 46 47 48 49 50 51 52 53 54 55 56 57 58 | :setvar DemoDatabase "CustomerAIDemo"
USE [$(DemoDatabase)];
GO
IF OBJECT_ID(N'dbo.CustomerFeedbackStage', N'U') IS NOT NULL
DROP TABLE dbo.CustomerFeedbackStage;
GO
IF OBJECT_ID(N'dbo.CustomerFeedback', N'U') IS NOT NULL
DROP TABLE dbo.CustomerFeedback;
GO
CREATE TABLE dbo.CustomerFeedback
(
FeedbackId INT IDENTITY(1,1) NOT NULL,
MaskedCustomerId NVARCHAR(30) NOT NULL,
Product NVARCHAR(100) NOT NULL,
CustomerSegment NVARCHAR(50) NOT NULL,
Region NVARCHAR(50) NOT NULL,
Channel NVARCHAR(50) NULL,
RiskLevel NVARCHAR(20) NULL,
CreatedAt DATETIME2(0) NOT NULL,
SourceIssueGroup NVARCHAR(80) NOT NULL,
FeedbackText NVARCHAR(MAX) NOT NULL,
Embedding VECTOR(1024) NULL,
CONSTRAINT PK_CustomerFeedback
PRIMARY KEY CLUSTERED (FeedbackId)
);
GO
CREATE INDEX IX_CustomerFeedback_BusinessFilters
ON dbo.CustomerFeedback
(
CustomerSegment,
RiskLevel,
Product,
CreatedAt
)
INCLUDE (Channel, Region, SourceIssueGroup);
GO
CREATE TABLE dbo.CustomerFeedbackStage
(
MaskedCustomerId NVARCHAR(30) NOT NULL,
Product NVARCHAR(100) NOT NULL,
CustomerSegment NVARCHAR(50) NOT NULL,
Region NVARCHAR(50) NOT NULL,
Channel NVARCHAR(50) NULL,
RiskLevel NVARCHAR(20) NULL,
CreatedAt NVARCHAR(40) NOT NULL,
SourceIssueGroup NVARCHAR(80) NOT NULL,
FeedbackText NVARCHAR(MAX) NOT NULL
);
GO
|