dbo.IV_busquedas

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 (~)	29059
Created	8/20/2015 4:05:30 PM
Last Modified	2/27/2023 9:31:33 PM

Columns

Name	Data Type	Length	Precision	Scale	Not Null	Identity	Default	Computed	Persisted
iv_busqueda	int	4	10	0	True	1 - 1		False	False
cliente	int	4	10	0	True			False	False
informe	int	4	10	0	False			False	False
item_contrato	int	4	10	0	True			False	False
consumo	int	4	10	0	False			False	False
ref	varchar	20	0	0	False			False	False
ref_nombre	varchar	100	0	0	False			False	False
ref_seccion	varchar	100	0	0	False			False	False
ref_cargo	varchar	100	0	0	False			False	False
ref_confidencial	tinyint	1	3	0	False			False	False
creado_por	int	4	10	0	False			False	False
creado	datetime	8	23	3	False			False	False
modificado_por	int	4	10	0	False			False	False
modificado	datetime	8	23	3	False			False	False
id_padron	int	4	10	0	True			False	False
verif_padron	tinyint	1	3	0	False			False	False
identificador	varchar	10	0	0	False			False	False
numero	varchar	50	0	0	False			False	False
nombre_candidato	varchar	100	0	0	False			False	False
email_candidato	varchar	100	0	0	False			False	False
telefono_candidato	varchar	100	0	0	False			False	False
notas_candidato	text		0	0	False			False	False
ant_acad_status	varchar	1	0	0	False			False	False
ant_lab_status	varchar	1	0	0	False			False	False
ant_leg_status	varchar	1	0	0	False			False	False
bg_check_status	varchar	1	0	0	False			False	False
ant_acad_score	decimal	5	5	2	False			False	False
ant_lab_score	decimal	5	5	2	False			False	False
ant_leg_score	decimal	5	5	2	False			False	False
bg_check_score	decimal	5	5	2	False			False	False
score_general	decimal	5	5	2	False			False	False
sexo_candidato	varchar	1	0	0	False			False	False
cv_existe	tinyint	1	3	0	False		(0)	False	False

Indexes

Key	Name	Columns	Unique	Type	Description
	idxBusquedaInforme	informe	False
	PK__IV_busqu__40558C7F6766F498	iv_busqueda	True

SQL Script

Copy

CREATE TABLE dbo.IV_busquedas (
  iv_busqueda int IDENTITY,
  cliente int NOT NULL,
  informe int NULL,
  item_contrato int NOT NULL,
  consumo int NULL,
  ref varchar(20) NULL,
  ref_nombre varchar(100) NULL,
  ref_seccion varchar(100) NULL,
  ref_cargo varchar(100) NULL,
  ref_confidencial tinyint NULL,
  creado_por int NULL,
  creado datetime NULL,
  modificado_por int NULL,
  modificado datetime NULL,
  id_padron int NOT NULL,
  verif_padron tinyint NULL,
  identificador varchar(10) NULL,
  numero varchar(50) NULL,
  nombre_candidato varchar(100) NULL,
  email_candidato varchar(100) NULL,
  telefono_candidato varchar(100) NULL,
  notas_candidato text NULL,
  ant_acad_status varchar(1) NULL,
  ant_lab_status varchar(1) NULL,
  ant_leg_status varchar(1) NULL,
  bg_check_status varchar(1) NULL,
  ant_acad_score decimal(5, 2) NULL,
  ant_lab_score decimal(5, 2) NULL,
  ant_leg_score decimal(5, 2) NULL,
  bg_check_score decimal(5, 2) NULL,
  score_general decimal(5, 2) NULL,
  sexo_candidato varchar(1) NULL,
  cv_existe tinyint NULL DEFAULT (0),
  PRIMARY KEY CLUSTERED (iv_busqueda) WITH (FILLFACTOR = 90)
)
ON [PRIMARY]
TEXTIMAGE_ON [PRIMARY]
GO

CREATE INDEX idxBusquedaInforme
  ON dbo.IV_busquedas (informe)
  INCLUDE (ref, ref_nombre, ref_seccion, ref_cargo)
  WITH (FILLFACTOR = 80)
  ON [PRIMARY]
GO

Depends On

Fidelitas