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:55 PM |
| Last Modified | 3/6/2025 6:55:56 PM |
Columns
13| Key | Name | Data Type | Length | Precision | Scale | Not Null | Identity | Rule | Default | Computed | Persisted | Description |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| id | int | 4 | 10 | 0 | False |
False |
False |
|||||
| fecha | date | 3 | 10 | 0 | True |
(getdate()) | False |
False |
||||
| nombre | varchar | 250 | 0 | 0 | True |
False |
False |
|||||
| tax_id | varchar | 50 | 0 | 0 | True |
False |
False |
|||||
| tipodevia | varchar | 100 | 0 | 0 | False |
False |
False |
|||||
| nombredevia | varchar | 100 | 0 | 0 | False |
False |
False |
|||||
| codigodezona | varchar | 100 | 0 | 0 | False |
False |
False |
|||||
| tipodezona | varchar | 100 | 0 | 0 | False |
False |
False |
|||||
| numero | varchar | 30 | 0 | 0 | False |
False |
False |
|||||
| interior | varchar | 30 | 0 | 0 | False |
False |
False |
|||||
| lote | varchar | 30 | 0 | 0 | False |
False |
False |
|||||
| departamento | varchar | 30 | 0 | 0 | False |
False |
False |
|||||
| manzana | varchar | 30 | 0 | 0 | False |
False |
False |
SQL Script
Copy
CREATE TABLE dbo.peru_worldsys_resultado (
id int NULL,
fecha date NOT NULL CONSTRAINT DF_peru_worldsys_resultado_fecha DEFAULT (getdate()),
nombre varchar(250) NOT NULL,
tax_id varchar(50) NOT NULL,
tipodevia varchar(100) NULL,
nombredevia varchar(100) NULL,
codigodezona varchar(100) NULL,
tipodezona varchar(100) NULL,
numero varchar(30) NULL,
interior varchar(30) NULL,
lote varchar(30) NULL,
departamento varchar(30) NULL,
manzana varchar(30) NULL
)
ON [PRIMARY]
GO
id int NULL,
fecha date NOT NULL CONSTRAINT DF_peru_worldsys_resultado_fecha DEFAULT (getdate()),
nombre varchar(250) NOT NULL,
tax_id varchar(50) NOT NULL,
tipodevia varchar(100) NULL,
nombredevia varchar(100) NULL,
codigodezona varchar(100) NULL,
tipodezona varchar(100) NULL,
numero varchar(30) NULL,
interior varchar(30) NULL,
lote varchar(30) NULL,
departamento varchar(30) NULL,
manzana varchar(30) NULL
)
ON [PRIMARY]
GO
Depends On
1- FideDoc
Used By
No items found