Skip to content

Table Structure vs Code #1

@lb-79

Description

@lb-79

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

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions