dbo.ai_batch_process

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

False

Full Text Catalog
Full Text
Compression NONE
Row Count (~) 0
Created 3/6/2025 6:55:52 PM
Last Modified 3/6/2025 6:55:55 PM

Columns

11
Key Name Data Type Length Precision Scale Not Null Identity Rule Default Computed Persisted Description
id int 4 10 0

True

1 - 1

False

False

id_batch varchar 150 0 0

True

False

False

response_api text 0 0

False

False

False

id_model int 4 10 0

True

False

False

id_prompt int 4 10 0

True

False

False

status varchar 30 0 0

True

('pending')

False

False

created datetime 8 23 3

True

(getdate())

False

False

created_by int 4 10 0

False

False

False

fecha_consultado date 3 10 0

False

False

False

id_input varchar 150 0 0

False

False

False

batch_type varchar 10 0 0

False

False

False

Indexes

1
Key Name Columns Unique Type Description
PK__ai_batch__3213E83F30A929DB id

True

SQL Script

Copy
CREATE TABLE dbo.ai_batch_process (
  id int IDENTITY,
  id_batch varchar(150) NOT NULL,
  response_api text NULL,
  id_model int NOT NULL,
  id_prompt int NOT NULL,
  status varchar(30) NOT NULL DEFAULT ('pending'),
  created datetime NOT NULL DEFAULT (getdate()),
  created_by int NULL,
  fecha_consultado date NULL,
  id_input varchar(150) NULL,
  batch_type varchar(10) NULL,
  PRIMARY KEY CLUSTERED (id) WITH (FILLFACTOR = 80)
)
ON [PRIMARY]
TEXTIMAGE_ON [PRIMARY]
GO

Depends On

1
  • FideDoc

Used By

No items found