dbo.fide_ws

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:53 PM
Last Modified	3/6/2025 6:55:56 PM

Columns

Name	Data Type	Length	Precision	Scale	Not Null	Identity	Default	Computed	Persisted
id_consulta	int	4	10	0	True	1 - 1		False	False
username	varchar	50	0	0	True			False	False
password	varchar	50	0	0	True			False	False
tipo_identificador	varchar	6	0	0	True			False	False
identificador	varchar	25	0	0	True			False	False
comienzo	varchar	30	0	0	False			False	False
id_cliente	int	4	10	0	False			False	False
nro_consulta_cliente	int	4	10	0	False			False	False
respuesta	varchar	1	0	0	False			False	False
razon_social	varchar	100	0	0	False			False	False
cuit	varchar	25	0	0	False			False	False
dni	varchar	25	0	0	False			False	False
score	decimal	5	6	2	False			False	False
status	varchar	2	0	0	False			False	False
detalle	varchar	512	0	0	False			False	False
fecha_consulta_cliente	datetime	8	23	3	True		(getdate())	False	False
fecha_respuesta_cliente	datetime	8	23	3	False			False	False
remote_address	varchar	50	0	0	False			False	False
country_code	varchar	3	0	0	False			False	False
id_padron	int	4	10	0	False			False	False

SQL Script

Copy

CREATE TABLE dbo.fide_ws_data (
  id_consulta int IDENTITY,
  username varchar(50) NOT NULL,
  password varchar(50) NOT NULL,
  tipo_identificador varchar(6) NOT NULL,
  identificador varchar(25) NOT NULL,
  comienzo varchar(30) NULL,
  id_cliente int NULL,
  nro_consulta_cliente int NULL,
  respuesta varchar(1) NULL,
  razon_social varchar(100) NULL,
  cuit varchar(25) NULL,
  dni varchar(25) NULL,
  score decimal(6, 2) NULL,
  status varchar(2) NULL,
  detalle varchar(512) NULL,
  fecha_consulta_cliente datetime NOT NULL CONSTRAINT DF_fide_ws_data_fecha_consulta_cliente DEFAULT (getdate()),
  fecha_respuesta_cliente datetime NULL,
  remote_address varchar(50) NULL,
  country_code varchar(3) NULL,
  id_padron int NULL
)
ON [PRIMARY]
GO

Depends On

FideDoc

Used By

No items found