dbo.V1

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 (~)	155
Created	6/14/2016 1:13:23 PM
Last Modified	6/14/2016 1:13:23 PM

Columns

Name	Data Type	Length	Precision	Scale	Not Null	Computed	Persisted
id_fidelitas	int	4	10	0	True	False	False
pedido	smallint	2	5	0	False	False	False
nombre	varchar	150	0	0	False	False	False
apellido	varchar	150	0	0	False	False	False
dni	varchar	10	0	0	False	False	False
dominio	varchar	7	0	0	False	False	False
BA	decimal	9	15	2	False	False	False
CABA	decimal	9	15	2	False	False	False
total	decimal	9	16	2	False	False	False
score1	int	4	10	0	True	False	False
Judiciales	varchar	1	0	0	True	False	False
Bancarios	varchar	1	0	0	True	False	False
score2	varchar	50	0	0	False	False	False
Reincidencia	varchar	1	0	0	True	False	False
score3	int	4	10	0	True	False	False
score_final	int	4	10	0	True	False	False
domicilio	varchar	150	0	0	False	False	False
numero	varchar	10	0	0	False	False	False
piso	varchar	10	0	0	False	False	False
dpto	varchar	10	0	0	False	False	False
localidad	varchar	150	0	0	False	False	False
cp	varchar	10	0	0	False	False	False
pesos_ba	decimal	9	15	2	False	False	False
pesos_caba	decimal	9	15	2	False	False	False
pesos_total	decimal	9	16	2	False	False	False
litros_total	decimal	9	16	2	False	False	False
valor_uf	decimal	5	3	2	True	False	False

SQL Script

Copy

CREATE TABLE dbo.V1 (
  id_fidelitas int NOT NULL,
  pedido smallint NULL,
  nombre varchar(150) NULL,
  apellido varchar(150) NULL,
  dni varchar(10) NULL,
  dominio varchar(7) NULL,
  BA decimal(15, 2) NULL,
  CABA decimal(15, 2) NULL,
  total decimal(16, 2) NULL,
  score1 int NOT NULL,
  Judiciales varchar(1) NOT NULL,
  Bancarios varchar(1) NOT NULL,
  score2 varchar(50) NULL,
  Reincidencia varchar(1) NOT NULL,
  score3 int NOT NULL,
  score_final int NOT NULL,
  domicilio varchar(150) NULL,
  numero varchar(10) NULL,
  piso varchar(10) NULL,
  dpto varchar(10) NULL,
  localidad varchar(150) NULL,
  cp varchar(10) NULL,
  pesos_ba decimal(15, 2) NULL,
  pesos_caba decimal(15, 2) NULL,
  pesos_total decimal(16, 2) NULL,
  litros_total decimal(16, 2) NULL,
  valor_uf decimal(3, 2) NOT NULL
)
ON [PRIMARY]
GO

Depends On

Fidelitas

Used By

No items found