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 (~) | 18093 |
| Created | 6/29/2016 12:54:47 PM |
| Last Modified | 11/11/2016 4:30:56 PM |
Columns
24| Key | Name | Data Type | Length | Precision | Scale | Not Null | Identity | Rule | Default | Computed | Persisted | Description |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| id_solicitud | int | 4 | 10 | 0 | True |
1 - 1 | False |
False |
||||
| nombre | varchar | 100 | 0 | 0 | True |
False |
False |
|||||
| apellido | varchar | 100 | 0 | 0 | True |
False |
False |
|||||
| dni | varchar | 10 | 0 | 0 | True |
False |
False |
|||||
| edad | tinyint | 1 | 3 | 0 | False |
False |
False |
|||||
| fecha_nacimiento | smalldatetime | 4 | 16 | 0 | False |
False |
False |
|||||
| domicilio | varchar | 100 | 0 | 0 | False |
False |
False |
|||||
| altura | varchar | 10 | 0 | 0 | False |
False |
False |
|||||
| piso | varchar | 10 | 0 | 0 | False |
False |
False |
|||||
| depto | varchar | 10 | 0 | 0 | False |
False |
False |
|||||
| localidad | varchar | 100 | 0 | 0 | False |
False |
False |
|||||
| provincia | varchar | 100 | 0 | 0 | False |
False |
False |
|||||
| varchar | 150 | 0 | 0 | True |
False |
False |
||||||
| created | datetime | 8 | 23 | 3 | True |
(getdate()) | False |
False |
||||
| modified | datetime | 8 | 23 | 3 | False |
False |
False |
|||||
| modified_by | int | 4 | 10 | 0 | False |
False |
False |
|||||
| log_intercambio | text | 0 | 0 | False |
False |
False |
||||||
| id_persona | int | 4 | 10 | 0 | False |
False |
False |
|||||
| answered | datetime | 8 | 23 | 3 | False |
False |
False |
|||||
| activo | bit | 1 | 1 | 0 | True |
(1) | False |
False |
||||
| observaciones | text | 0 | 0 | False |
False |
False |
||||||
| telefono | varchar | 50 | 0 | 0 | False |
False |
False |
|||||
| celular | varchar | 50 | 0 | 0 | False |
False |
False |
|||||
| enviado | bit | 1 | 1 | 0 | False |
(0) | False |
False |
SQL Script
Copy
CREATE TABLE dbo.solicitudes_legales (
id_solicitud int IDENTITY,
nombre varchar(100) NOT NULL,
apellido varchar(100) NOT NULL,
dni varchar(10) NOT NULL,
edad tinyint NULL,
fecha_nacimiento smalldatetime NULL,
domicilio varchar(100) NULL,
altura varchar(10) NULL,
piso varchar(10) NULL,
depto varchar(10) NULL,
localidad varchar(100) NULL,
provincia varchar(100) NULL,
email varchar(150) NOT NULL,
created datetime NOT NULL CONSTRAINT DF_solicitudes_legales_created DEFAULT (getdate()),
modified datetime NULL,
modified_by int NULL,
log_intercambio text NULL,
id_persona int NULL,
answered datetime NULL,
activo bit NOT NULL CONSTRAINT DF_solicitudes_legales_activo DEFAULT (1),
observaciones text NULL,
telefono varchar(50) NULL,
celular varchar(50) NULL,
enviado bit NULL DEFAULT (0)
)
ON [PRIMARY]
TEXTIMAGE_ON [PRIMARY]
GO
id_solicitud int IDENTITY,
nombre varchar(100) NOT NULL,
apellido varchar(100) NOT NULL,
dni varchar(10) NOT NULL,
edad tinyint NULL,
fecha_nacimiento smalldatetime NULL,
domicilio varchar(100) NULL,
altura varchar(10) NULL,
piso varchar(10) NULL,
depto varchar(10) NULL,
localidad varchar(100) NULL,
provincia varchar(100) NULL,
email varchar(150) NOT NULL,
created datetime NOT NULL CONSTRAINT DF_solicitudes_legales_created DEFAULT (getdate()),
modified datetime NULL,
modified_by int NULL,
log_intercambio text NULL,
id_persona int NULL,
answered datetime NULL,
activo bit NOT NULL CONSTRAINT DF_solicitudes_legales_activo DEFAULT (1),
observaciones text NULL,
telefono varchar(50) NULL,
celular varchar(50) NULL,
enviado bit NULL DEFAULT (0)
)
ON [PRIMARY]
TEXTIMAGE_ON [PRIMARY]
GO
Depends On
1- Fidelitas