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 (~)	0
Created	3/6/2025 6:55:55 PM
Last Modified	3/6/2025 6:55:57 PM

Columns

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
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

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

Depends On

FideDoc

Used By

No items found