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 (~) | 27645 |
| Created | 7/4/2018 3:09:01 PM |
| Last Modified | 7/12/2018 3:19:24 PM |
Columns
16| Key | Name | Data Type | Length | Precision | Scale | Not Null | Identity | Rule | Default | Computed | Persisted | Description |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| ID | varchar | 50 | 0 | 0 | False |
False |
False |
|||||
| DESDISTRIT | varchar | 50 | 0 | 0 | False |
False |
False |
|||||
| DISTRITO | varchar | 50 | 0 | 0 | False |
False |
False |
|||||
| SECCION | varchar | 50 | 0 | 0 | False |
False |
False |
|||||
| CIRCUITO | varchar | 50 | 0 | 0 | False |
False |
False |
|||||
| ESTALECIMIENTO | varchar | 50 | 0 | 0 | False |
False |
False |
|||||
| DOMICILIO | varchar | 50 | 0 | 0 | False |
False |
False |
|||||
| BARRIO | varchar | 50 | 0 | 0 | False |
False |
False |
|||||
| DESSECCION | varchar | 50 | 0 | 0 | False |
False |
False |
|||||
| LOCALIDAD | varchar | 50 | 0 | 0 | False |
False |
False |
|||||
| CP | varchar | 50 | 0 | 0 | False |
False |
False |
|||||
| MESADESDE | varchar | 50 | 0 | 0 | False |
False |
False |
|||||
| MESAHASTA | varchar | 50 | 0 | 0 | False |
False |
False |
|||||
| CANTMESAS | varchar | 50 | 0 | 0 | False |
False |
False |
|||||
| ANIO_PADRON | int | 4 | 10 | 0 | False |
False |
False |
|||||
| VISIBLE | bit | 1 | 1 | 0 | False |
False |
False |
SQL Script
Copy
CREATE TABLE dbo.padron_electoral_relacion (
ID varchar(50) NULL,
DESDISTRIT varchar(50) NULL,
DISTRITO varchar(50) NULL,
SECCION varchar(50) NULL,
CIRCUITO varchar(50) NULL,
ESTALECIMIENTO varchar(50) NULL,
DOMICILIO varchar(50) NULL,
BARRIO varchar(50) NULL,
DESSECCION varchar(50) NULL,
LOCALIDAD varchar(50) NULL,
CP varchar(50) NULL,
MESADESDE varchar(50) NULL,
MESAHASTA varchar(50) NULL,
CANTMESAS varchar(50) NULL,
ANIO_PADRON int NULL,
VISIBLE bit NULL
)
ON [PRIMARY]
GO
ID varchar(50) NULL,
DESDISTRIT varchar(50) NULL,
DISTRITO varchar(50) NULL,
SECCION varchar(50) NULL,
CIRCUITO varchar(50) NULL,
ESTALECIMIENTO varchar(50) NULL,
DOMICILIO varchar(50) NULL,
BARRIO varchar(50) NULL,
DESSECCION varchar(50) NULL,
LOCALIDAD varchar(50) NULL,
CP varchar(50) NULL,
MESADESDE varchar(50) NULL,
MESAHASTA varchar(50) NULL,
CANTMESAS varchar(50) NULL,
ANIO_PADRON int NULL,
VISIBLE bit NULL
)
ON [PRIMARY]
GO
Depends On
1- Fidelitas