dbo.RENAPER_FACE

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 (~)	2637417
Created	7/7/2021 1:21:20 PM
Last Modified	8/6/2024 6:09:30 PM

Columns

Name	Data Type	Length	Precision	Scale	Not Null	Identity	Default	Computed	Persisted
Id	int	4	10	0	True	1 - 1		False	False
dni	varchar	20	0	0	False			False	False
sexo	varchar	1	0	0	False			False	False
created	datetime	8	23	3	False		(getdate())	False	False
codigo_http	varchar		0	0	False			False	False
mensaje_http	varchar		0	0	False			False	False
data_codigo	varchar		0	0	False			False	False
data_mensaje	varchar		0	0	False			False	False
transactionControlNumber	varchar		0	0	False			False	False
typeOfTransaction	varchar		0	0	False			False	False
dateOfTransaction	varchar		0	0	False			False	False
error_code	varchar		0	0	False			False	False
error_description	varchar		0	0	False			False	False
error_name	varchar		0	0	False			False	False
person	varchar		0	0	False			False	False
final_codigo_http	varchar		0	0	False			False	False
final_mensaje_http	varchar		0	0	False			False	False
final_TCN	varchar		0	0	False			False	False
final_status	varchar		0	0	False			False	False
final_score	varchar		0	0	False			False	False
final_matchtype	varchar		0	0	False			False	False
final_comments	varchar		0	0	False			False	False
final_fechanoti	varchar		0	0	False			False	False
final_horanoti	varchar		0	0	False			False	False
final_codigo	varchar		0	0	False			False	False
final_mensaje	varchar		0	0	False			False	False

Indexes

Key	Name	Columns	Unique	Type	Description
	idxFaceMatchConsumos	dni, created	False
	PK__RENAPER_FACE__3214EC07E0F7D6DC	Id	True

SQL Script

Copy

CREATE TABLE dbo.RENAPER_FACE_INFO (
  Id int IDENTITY,
  dni varchar(20) NULL,
  sexo varchar(1) NULL,
  created datetime NULL CONSTRAINT DF_RENAPER_FACE_INFO_created DEFAULT (getdate()),
  codigo_http varchar(max) NULL,
  mensaje_http varchar(max) NULL,
  data_codigo varchar(max) NULL,
  data_mensaje varchar(max) NULL,
  transactionControlNumber varchar(max) NULL,
  typeOfTransaction varchar(max) NULL,
  dateOfTransaction varchar(max) NULL,
  error_code varchar(max) NULL,
  error_description varchar(max) NULL,
  error_name varchar(max) NULL,
  person varchar(max) NULL,
  final_codigo_http varchar(max) NULL,
  final_mensaje_http varchar(max) NULL,
  final_TCN varchar(max) NULL,
  final_status varchar(max) NULL,
  final_score varchar(max) NULL,
  final_matchtype varchar(max) NULL,
  final_comments varchar(max) NULL,
  final_fechanoti varchar(max) NULL,
  final_horanoti varchar(max) NULL,
  final_codigo varchar(max) NULL,
  final_mensaje varchar(max) NULL,
  CONSTRAINT PK__RENAPER_FACE__3214EC07E0F7D6DC PRIMARY KEY CLUSTERED (Id) WITH (FILLFACTOR = 80)
)
ON [PRIMARY]
TEXTIMAGE_ON [PRIMARY]
GO

CREATE INDEX idxFaceMatchConsumos
  ON dbo.RENAPER_FACE_INFO (dni, created)
  INCLUDE (transactionControlNumber, final_TCN)
  WITH (FILLFACTOR = 80)
  ON [PRIMARY]
GO

Depends On

Fidelitas

dbo.RENAPER_FACE_INFO