-
Notifications
You must be signed in to change notification settings - Fork 3
Description
I have downloaded the database but the structure of the vector tables don't match with the SQL files code (e.g. the insert on vectors.recipe_steps (
recipe_id, chunk, chunk_order,chunk_offset, chunk_length, embedding) cannot match with the structure I've found in the db:
see the insert: https://github.com/SQLBek/Demo-DBs/blob/master/RecipeDemoDB/5_Generate%20vector%20embeddings%20via%20chunks.sql
and the structure below:
CREATE TABLE [vectors].[recipe_steps](
[recipe_steps_id] [int] IDENTITY(1,1) NOT NULL,
[recipe_id] [int] NULL,
[chunk_id] [int] NULL,
[embedding] vector NULL,
CONSTRAINT [CK_recipe_steps] PRIMARY KEY CLUSTERED
(
[recipe_steps_id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [VECTOR_FG],
CONSTRAINT [UNI_recipe_steps] UNIQUE NONCLUSTERED
(
[recipe_id] ASC,
[chunk_id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [VECTOR_FG]
) ON [VECTOR_FG]
GO