dbo.led_control

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 (~)	175432
Created	5/30/2016 12:42:00 PM
Last Modified	7/20/2017 3:45:31 PM

Columns

Name	Data Type	Length	Precision	Scale	Not Null	Identity	Computed	Persisted
control_id	int	4	10	0	True	1 - 1	False	False
tipo_acceso	varchar	1	0	0	False		False	False
horario	datetime	8	23	3	False		False	False
usuario_control	int	4	10	0	False		False	False
cliente	int	4	10	0	False		False	False
contratista	int	4	10	0	False		False	False
empleado	int	4	10	0	False		False	False
vehiculo	int	4	10	0	False		False	False
autorizante	int	4	10	0	False		False	False
detalle_control	text		0	0	False		False	False
excepcion	tinyint	1	3	0	False		False	False
locacion	int	4	10	0	False		False	False
estado_autorizacion	varchar	1	0	0	False		False	False
vigencia_excepcion	datetime	8	23	3	False		False	False
autoriza_rechaza	datetime	8	23	3	False		False	False
whitelist_id_padron	int	4	10	0	False		False	False

Indexes

Key	Name	Columns	Unique	Type	Description
	idxDigicardExcepciones	tipo_acceso, estado_autorizacion, excepcion, vigencia_excepcion	False
	XPKled_control_ingreso	control_id	True

SQL Script

Copy

CREATE TABLE dbo.led_control_ingreso (
  control_id int IDENTITY,
  tipo_acceso varchar(1) NULL,
  horario datetime NULL,
  usuario_control int NULL,
  cliente int NULL,
  contratista int NULL,
  empleado int NULL,
  vehiculo int NULL,
  autorizante int NULL,
  detalle_control text NULL,
  excepcion tinyint NULL,
  locacion int NULL,
  estado_autorizacion varchar(1) NULL,
  vigencia_excepcion datetime NULL,
  autoriza_rechaza datetime NULL,
  whitelist_id_padron int NULL,
  CONSTRAINT XPKled_control_ingreso PRIMARY KEY CLUSTERED (control_id) WITH (FILLFACTOR = 80)
)
ON [PRIMARY]
TEXTIMAGE_ON [PRIMARY]
GO

CREATE INDEX idxDigicardExcepciones
  ON dbo.led_control_ingreso (tipo_acceso, estado_autorizacion, excepcion, vigencia_excepcion)
  INCLUDE (cliente, contratista, empleado)
  WITH (FILLFACTOR = 80)
  ON [PRIMARY]
GO

Depends On

Fidelitas

dbo.led_control_ingreso