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:54 PM |
| Last Modified | 3/6/2025 6:55:56 PM |
Columns
25| Key | Name | Data Type | Length | Precision | Scale | Not Null | Identity | Rule | Default | Computed | Persisted | Description |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| id_resultado | int | 4 | 10 | 0 | True |
1 - 1 | False |
False |
||||
| cuit | varchar | 20 | 0 | 0 | False |
False |
False |
|||||
| nombre_persona | varchar | 100 | 0 | 0 | False |
False |
False |
|||||
| id_padron | int | 4 | 10 | 0 | False |
False |
False |
|||||
| webservice | varchar | 20 | 0 | 0 | False |
False |
False |
|||||
| 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 |
||||
| modified | datetime | 8 | 23 | 3 | False |
False |
False |
|||||
| visible | bit | 1 | 1 | 0 | False |
(1) | False |
False |
||||
| fidecheck | char | 1 | 0 | 0 | False |
False |
False |
SQL Script
Copy
CREATE TABLE dbo.LN_Fidecheck_ws (
id_resultado int IDENTITY,
cuit varchar(20) NULL,
nombre_persona varchar(100) NULL,
id_padron int NULL,
webservice varchar(20) NULL,
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 LN_Fidecheck_ws_created DEFAULT (getdate()),
modified datetime NULL,
visible bit NULL CONSTRAINT LN_Fidecheck_ws_visible DEFAULT (1),
fidecheck char(1) NULL
)
ON [PRIMARY]
GO
id_resultado int IDENTITY,
cuit varchar(20) NULL,
nombre_persona varchar(100) NULL,
id_padron int NULL,
webservice varchar(20) NULL,
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 LN_Fidecheck_ws_created DEFAULT (getdate()),
modified datetime NULL,
visible bit NULL CONSTRAINT LN_Fidecheck_ws_visible DEFAULT (1),
fidecheck char(1) NULL
)
ON [PRIMARY]
GO
Depends On
1- FideDoc
Used By
No items found