dbo.ai_prompts

Description

Properties

Name	Value
File Collation
File Group
Filestream File Group
Is Partitioned	False
Partitioned Column
Partition Scheme
File Groups
Filestream Partition Scheme
Filestream File Groups
Heap	True
Full Text Catalog
Full Text
Compression	NONE
Row Count (~)	20
Created	3/13/2024 11:25:16 AM
Last Modified	11/1/2024 3:22:09 PM

Columns

Name	Data Type	Length	Precision	Scale	Not Null	Identity	Default	Computed	Persisted
id_prompt	int	4	10	0	True	1 - 1		False	False
prompt_name	varchar	100	0	0	True			False	False
user_prompt	varchar		0	0	False			False	False
system_prompt	varchar		0	0	False			False	False
ai_endpoint	varchar	200	0	0	False			False	False
ai_provider	varchar	200	0	0	False			False	False
created	datetime	8	23	3	True		(getdate())	False	False
created_by	int	4	10	0	False			False	False
active	bit	1	1	0	True		(1)	False	False
lista_ind_balance	varchar		0	0	False			False	False
type_prompt	varchar	100	0	0	False			False	False
ai_name_provider	varchar	100	0	0	False			False	False
pais_prompt	varchar	3	0	0	False			False	False
tipo_carga	varchar	6	0	0	False			False	False
clae	varchar	100	0	0	False			False	False

SQL Script

Copy

CREATE TABLE dbo.ai_prompts (
  id_prompt int IDENTITY,
  prompt_name varchar(100) NOT NULL,
  user_prompt varchar(max) NULL,
  system_prompt varchar(max) NULL,
  ai_endpoint varchar(200) NULL,
  ai_provider varchar(200) NULL,
  created datetime NOT NULL DEFAULT (getdate()),
  created_by int NULL,
  active bit NOT NULL DEFAULT (1),
  lista_ind_balance varchar(max) NULL,
  type_prompt varchar(100) NULL,
  ai_name_provider varchar(100) NULL,
  pais_prompt varchar(3) NULL,
  tipo_carga varchar(6) NULL,
  clae varchar(100) NULL
)
ON [PRIMARY]
TEXTIMAGE_ON [PRIMARY]
GO

Depends On

Fidelitas