dbo.usuarios_consumos

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 (~)	38159944
Created	12/2/2016 4:22:53 PM
Last Modified	2/5/2025 6:27:35 PM

Columns

Key	Name	Data Type	Length	Precision	Scale	Not Null	Identity	Default	Computed	Persisted
	user_id	int	4	10	0	True			False	False
	cuit_consultado	varchar	20	0	0	True			False	False
2	id_producto	int	4	10	0	True			False	False
	created	smalldatetime	4	16	0	True			False	False
	nro_consulta	int	4	10	0	False			False	False
	respuesta	char	1	0	0	False			False	False
	bcra	smallint	2	5	0	False			False	False
	cheques	smallint	2	5	0	False			False	False
	arba	smallint	2	5	0	False			False	False
	juicios	smallint	2	5	0	False			False	False
	morosidad	smallint	2	5	0	False			False	False
	agip	smallint	2	5	0	False			False	False
	consulta_informix	char	1	0	0	False			False	False
	ip	varchar	15	0	0	False			False	False
	usuario_externo	varchar	20	0	0	False			False	False
	id_transaccion	int	4	10	0	True	1 - 1		False	False
	url	varchar	250	0	0	False			False	False
	created2	datetime	8	23	3	False		(getdate())	False	False
	ARREGLO_DATOS_POR_FALLAS	varchar	100	0	0	False			False	False

Indexes

Key	Name	Columns	Unique	Type	Description
	idxUsuariosConsumosProducto	user_id, id_producto, created	False
	idxUusariosConsumosCuitConsultado	cuit_consultado, id_producto	False

SQL Script

Copy

CREATE TABLE dbo.usuarios_consumos (
  user_id int NOT NULL,
  cuit_consultado varchar(20) NOT NULL,
  id_producto int NOT NULL,
  created smalldatetime NOT NULL,
  nro_consulta int NULL,
  respuesta char(1) NULL,
  bcra smallint NULL,
  cheques smallint NULL,
  arba smallint NULL,
  juicios smallint NULL,
  morosidad smallint NULL,
  agip smallint NULL,
  consulta_informix char(1) NULL,
  ip varchar(15) NULL,
  usuario_externo varchar(20) NULL,
  id_transaccion int IDENTITY,
  url varchar(250) NULL,
  created2 datetime NULL DEFAULT (getdate()),
  ARREGLO_DATOS_POR_FALLAS varchar(100) NULL
)
ON [PRIMARY]
GO

CREATE INDEX idxUsuariosConsumosProducto
  ON dbo.usuarios_consumos (user_id, id_producto, created)
  INCLUDE (cuit_consultado)
  WITH (FILLFACTOR = 80)
  ON [PRIMARY]
GO

CREATE INDEX idxUusariosConsumosCuitConsultado
  ON dbo.usuarios_consumos (cuit_consultado, id_producto)
  WITH (FILLFACTOR = 80)
  ON [PRIMARY]
GO

Depends On

Fidelitas