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 (~) | 296 |
| Created | 6/5/2016 5:33:47 PM |
| Last Modified | 6/5/2016 5:33:47 PM |
Columns
21| Key | Name | Data Type | Length | Precision | Scale | Not Null | Identity | Rule | Default | Computed | Persisted | Description |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| CUIT | varchar | 50 | 0 | 0 | False |
False |
False |
|||||
| NRODOC | varchar | 50 | 0 | 0 | False |
False |
False |
|||||
| NOMBRECOMPLETO | varchar | 150 | 0 | 0 | False |
False |
False |
|||||
| TIPOCUIT | varchar | 50 | 0 | 0 | False |
False |
False |
|||||
| CUIT2 | varchar | 50 | 0 | 0 | False |
False |
False |
|||||
| TIPODOC | varchar | 50 | 0 | 0 | False |
False |
False |
|||||
| DOCUMENTO | varchar | 50 | 0 | 0 | False |
False |
False |
|||||
| APELLIDO | varchar | 150 | 0 | 0 | False |
False |
False |
|||||
| NOMBRE | varchar | 150 | 0 | 0 | False |
False |
False |
|||||
| FECHANACIMIENTO | varchar | 50 | 0 | 0 | False |
False |
False |
|||||
| ANIONACIMIENTO | varchar | 50 | 0 | 0 | False |
False |
False |
|||||
| SEXO | varchar | 50 | 0 | 0 | False |
False |
False |
|||||
| ESTADOCIVIL | varchar | 50 | 0 | 0 | False |
False |
False |
|||||
| NACIONALIDAD | varchar | 50 | 0 | 0 | False |
False |
False |
|||||
| FECHADEFUNCION | varchar | 50 | 0 | 0 | False |
False |
False |
|||||
| DOMICILIO | varchar | 150 | 0 | 0 | False |
False |
False |
|||||
| CP | varchar | 50 | 0 | 0 | False |
False |
False |
|||||
| LOCALIDAD | varchar | 150 | 0 | 0 | False |
False |
False |
|||||
| PROVINCIA | varchar | 150 | 0 | 0 | False |
False |
False |
|||||
| TELEFONO | varchar | 150 | 0 | 0 | False |
False |
False |
|||||
| SCORE | varchar | 50 | 0 | 0 | False |
False |
False |
SQL Script
Copy
CREATE TABLE dbo.contravenciones_score (
CUIT varchar(50) NULL,
[NRODOC ] varchar(50) NULL,
NOMBRECOMPLETO varchar(150) NULL,
TIPOCUIT varchar(50) NULL,
CUIT2 varchar(50) NULL,
[TIPODOC ] varchar(50) NULL,
DOCUMENTO varchar(50) NULL,
APELLIDO varchar(150) NULL,
NOMBRE varchar(150) NULL,
FECHANACIMIENTO varchar(50) NULL,
ANIONACIMIENTO varchar(50) NULL,
SEXO varchar(50) NULL,
ESTADOCIVIL varchar(50) NULL,
NACIONALIDAD varchar(50) NULL,
FECHADEFUNCION varchar(50) NULL,
DOMICILIO varchar(150) NULL,
CP varchar(50) NULL,
LOCALIDAD varchar(150) NULL,
PROVINCIA varchar(150) NULL,
TELEFONO varchar(150) NULL,
SCORE varchar(50) NULL
)
ON [PRIMARY]
GO
CUIT varchar(50) NULL,
[NRODOC ] varchar(50) NULL,
NOMBRECOMPLETO varchar(150) NULL,
TIPOCUIT varchar(50) NULL,
CUIT2 varchar(50) NULL,
[TIPODOC ] varchar(50) NULL,
DOCUMENTO varchar(50) NULL,
APELLIDO varchar(150) NULL,
NOMBRE varchar(150) NULL,
FECHANACIMIENTO varchar(50) NULL,
ANIONACIMIENTO varchar(50) NULL,
SEXO varchar(50) NULL,
ESTADOCIVIL varchar(50) NULL,
NACIONALIDAD varchar(50) NULL,
FECHADEFUNCION varchar(50) NULL,
DOMICILIO varchar(150) NULL,
CP varchar(50) NULL,
LOCALIDAD varchar(150) NULL,
PROVINCIA varchar(150) NULL,
TELEFONO varchar(150) NULL,
SCORE varchar(50) NULL
)
ON [PRIMARY]
GO
Depends On
1- Fidelitas