dbo.usuarios_consumos_11

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 (~)	960909
Created	11/30/2024 6:41:06 PM
Last Modified	11/30/2024 6:41:06 PM

Columns

Name	Data Type	Length	Precision	Scale	Not Null	Computed	Persisted
user_id	int	4	10	0	True	False	False
cuit_consultado	varchar	20	0	0	True	False	False
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	False	False
url	varchar	250	0	0	False	False	False
created2	datetime2	7	23	3	False	False	False

SQL Script

Copy

CREATE TABLE dbo.usuarios_consumos_11_IPLAN (
  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 NOT NULL,
  url varchar(250) NULL,
  created2 datetime2(3) NULL
)
ON [PRIMARY]
GO

Depends On

Fidelitas

Used By

No items found