dbo.solicitudes

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:55 PM
Last Modified	3/6/2025 6:55:55 PM

Columns

Name	Data Type	Length	Precision	Not Null	Identity	Computed	Persisted
solicitud	int	4	10	True	1 - 1	False	False
cliente	int	4	10	False		False	False
fecha_solicitud	smalldatetime	4	16	False		False	False
fecha_estimada	smalldatetime	4	16	False		False	False
idioma	smallint	2	5	False		False	False
formato_entrega	tinyint	1	3	False		False	False
tipo_contraparte	varchar	2	0	False		False	False
modo_analisis	varchar	2	0	False		False	False
tipo_analisis	varchar	2	0	False		False	False
user_id	int	4	10	False		False	False
observaciones	text		0	False		False	False
empresa_solicitante	varchar	50	0	False		False	False
contacto_solicitante	varchar	50	0	False		False	False
email_solicitante	varchar	50	0	False		False	False
cliente3	int	4	10	False		False	False

Indexes

Key	Name	Columns	Unique	Type	Description
	PK__solicitu__50022D69B82BDF6A	solicitud	True

SQL Script

Copy

CREATE TABLE dbo.solicitudes (
  solicitud int IDENTITY,
  cliente int NULL,
  fecha_solicitud smalldatetime NULL,
  fecha_estimada smalldatetime NULL,
  idioma smallint NULL,
  formato_entrega tinyint NULL,
  tipo_contraparte varchar(2) NULL,
  modo_analisis varchar(2) NULL,
  tipo_analisis varchar(2) NULL,
  user_id int NULL,
  observaciones text NULL,
  empresa_solicitante varchar(50) NULL,
  contacto_solicitante varchar(50) NULL,
  email_solicitante varchar(50) NULL,
  cliente3 int NULL,
  PRIMARY KEY CLUSTERED (solicitud) WITH (FILLFACTOR = 90)
)
ON [PRIMARY]
TEXTIMAGE_ON [PRIMARY]
GO

Depends On

FideDoc

Used By

No items found