dbo.PEP_resultados

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 (~)	0
Created	3/6/2025 6:55:55 PM
Last Modified	3/6/2025 6:55:56 PM

Columns

Name	Data Type	Length	Precision	Scale	Not Null	Identity	Default	Computed	Persisted
StatusCode	int	4	10	0	False			False	False
Status	varchar	20	0	0	False			False	False
Reason	varchar	500	0	0	False			False	False
Id	int	4	10	0	False			False	False
Fuente	varchar	100	0	0	False			False	False
NombreModificado	varchar	200	0	0	False			False	False
DocumentoBuscado	varchar	20	0	0	False			False	False
NombreBuscado	varchar	200	0	0	False			False	False
Documento	varchar	20	0	0	False			False	False
TipoFuente	varchar	100	0	0	False			False	False
Residencia	varchar	100	0	0	False			False	False
DescripcionPais	varchar	100	0	0	False			False	False
PaisNoColaborativo	varchar	100	0	0	False			False	False
Hallazgos	int	4	10	0	False			False	False
ExisteDocumentacion	varchar	10	0	0	False			False	False
PorcentajeSimilitud	int	4	10	0	False			False	False
created	datetime	8	23	3	False		(getdate())	False	False
id_resultado	int	4	10	0	True	1 - 1		False	False

SQL Script

Copy

CREATE TABLE dbo.PEP_resultados_listas (
  StatusCode int NULL,
  Status varchar(20) NULL,
  Reason varchar(500) NULL,
  Id int NULL,
  Fuente varchar(100) NULL,
  NombreModificado varchar(200) NULL,
  DocumentoBuscado varchar(20) NULL,
  NombreBuscado varchar(200) NULL,
  Documento varchar(20) NULL,
  TipoFuente varchar(100) NULL,
  Residencia varchar(100) NULL,
  DescripcionPais varchar(100) NULL,
  PaisNoColaborativo varchar(100) NULL,
  Hallazgos int NULL,
  ExisteDocumentacion varchar(10) NULL,
  PorcentajeSimilitud int NULL,
  created datetime NULL CONSTRAINT DF_PEP_listas_created DEFAULT (getdate()),
  id_resultado int IDENTITY
)
ON [PRIMARY]
GO

Depends On

FideDoc

Used By

No items found