SqlDatabaseVectorSearch/Scripts.sql at master · marcominerva/SqlDatabaseVectorSearch · GitHub

33 lines (29 loc) · 983 Bytes

CREATE TABLE [dbo].[Documents](

[Id] [uniqueidentifier] NOT NULL,

[Name] [nvarchar](255) NOT NULL,

[CreationDate] [datetimeoffset](7) NOT NULL,

CONSTRAINT [PK_Documents] PRIMARY KEY CLUSTERED

(

[Id] ASC

))

CREATE TABLE [dbo].[DocumentChunks](

[Id] [uniqueidentifier] NOT NULL,

[DocumentId] [uniqueidentifier] NOT NULL,

[Index] [int] NOT NULL,

[Content] [nvarchar](max) NOT NULL,

-- Set the size of the vector to the same size of the your embedding model.

[Embedding] [vector](1536) NOT NULL,

CONSTRAINT [PK_DocumentChunks] PRIMARY KEY CLUSTERED

(

[Id] ASC

))

ALTER TABLE [dbo].[DocumentChunks] WITH CHECK ADD CONSTRAINT [FK_DocumentChunks_Documents] FOREIGN KEY([DocumentId])

REFERENCES [dbo].[Documents] ([Id])

ON DELETE CASCADE

ALTER TABLE [dbo].[Documents] ADD CONSTRAINT [DF_Documents_Id] DEFAULT (newsequentialid()) FOR [Id]

ALTER TABLE [dbo].[DocumentChunks] ADD CONSTRAINT [DF_DocumentChunks_Id] DEFAULT (newsequentialid()) FOR [Id]

Expand file tree