Spaces:
Running
Running
Download chainlit_sqlalchemy/schema.sql from TI-America/ComercialChatbot: direct link, hf CLI and curl.
- Browser
- Download file 1.59 kB
-
https://huggingface.co/spaces/TI-America/ComercialChatbot/resolve/main/chainlit_sqlalchemy/schema.sql
- Command line
-
hf download hf://spaces/TI-America/ComercialChatbot/chainlit_sqlalchemy/schema.sql
-
curl -L -o schema.sql https://huggingface.co/spaces/TI-America/ComercialChatbot/resolve/main/chainlit_sqlalchemy/schema.sql
1.59 kB
| CREATE TABLE users ( | |
| "id" UUID PRIMARY KEY, | |
| "identifier" TEXT NOT NULL UNIQUE, | |
| "metadata" JSONB NOT NULL, | |
| "createdAt" TEXT | |
| ); | |
| CREATE TABLE IF NOT EXISTS threads ( | |
| "id" UUID PRIMARY KEY, | |
| "createdAt" TEXT, | |
| "name" TEXT, | |
| "userId" UUID, | |
| "userIdentifier" TEXT, | |
| "tags" TEXT[], | |
| "metadata" JSONB, | |
| FOREIGN KEY ("userId") REFERENCES users("id") ON DELETE CASCADE | |
| ); | |
| CREATE TABLE IF NOT EXISTS steps ( | |
| "id" UUID PRIMARY KEY, | |
| "name" TEXT NOT NULL, | |
| "type" TEXT NOT NULL, | |
| "threadId" UUID NOT NULL, | |
| "parentId" UUID, | |
| "streaming" BOOLEAN NOT NULL, | |
| "waitForAnswer" BOOLEAN, | |
| "isError" BOOLEAN, | |
| "metadata" JSONB, | |
| "tags" TEXT[], | |
| "input" TEXT, | |
| "output" TEXT, | |
| "createdAt" TEXT, | |
| "start" TEXT, | |
| "end" TEXT, | |
| "generation" JSONB, | |
| "showInput" TEXT, | |
| "language" TEXT, | |
| "indent" INT, | |
| FOREIGN KEY ("threadId") REFERENCES threads("id") ON DELETE CASCADE | |
| ); | |
| CREATE TABLE IF NOT EXISTS elements ( | |
| "id" UUID PRIMARY KEY, | |
| "threadId" UUID, | |
| "type" TEXT, | |
| "url" TEXT, | |
| "chainlitKey" TEXT, | |
| "name" TEXT NOT NULL, | |
| "display" TEXT, | |
| "objectKey" TEXT, | |
| "size" TEXT, | |
| "page" INT, | |
| "language" TEXT, | |
| "forId" UUID, | |
| "mime" TEXT, | |
| "props" JSONB, | |
| FOREIGN KEY ("threadId") REFERENCES threads("id") ON DELETE CASCADE | |
| ); | |
| CREATE TABLE IF NOT EXISTS feedbacks ( | |
| "id" UUID PRIMARY KEY, | |
| "forId" UUID NOT NULL, | |
| "threadId" UUID NOT NULL, | |
| "value" INT NOT NULL, | |
| "comment" TEXT, | |
| FOREIGN KEY ("threadId") REFERENCES threads("id") ON DELETE CASCADE | |
| ); | |