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:54 PM |
| Last Modified | 3/6/2025 6:55:54 PM |
Columns
19| Key | Name | Data Type | Length | Precision | Scale | Not Null | Identity | Rule | Default | Computed | Persisted | Description |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| cuil_Activo | varchar | 50 | 0 | 0 | False |
False |
False |
|||||
| cuilRelacionado | varchar | 50 | 0 | 0 | False |
False |
False |
|||||
| DescRelacion | varchar | 100 | 0 | 0 | False |
False |
False |
|||||
| Relacion_Desde | varchar | 50 | 0 | 0 | False |
False |
False |
|||||
| ApeNom | varchar | 100 | 0 | 0 | False |
False |
False |
|||||
| DocTipo | varchar | 50 | 0 | 0 | False |
False |
False |
|||||
| DocNro | varchar | 50 | 0 | 0 | False |
False |
False |
|||||
| FechaNacimiento | varchar | 50 | 0 | 0 | False |
False |
False |
|||||
| CodSexo | varchar | 50 | 0 | 0 | False |
False |
False |
|||||
| CodDomi | varchar | 50 | 0 | 0 | False |
False |
False |
|||||
| Calle | varchar | 150 | 0 | 0 | False |
False |
False |
|||||
| Nro | varchar | 50 | 0 | 0 | False |
False |
False |
|||||
| Piso | varchar | 50 | 0 | 0 | False |
False |
False |
|||||
| Dpto | varchar | 50 | 0 | 0 | False |
False |
False |
|||||
| CodPostal | varchar | 50 | 0 | 0 | False |
False |
False |
|||||
| Localidad | varchar | 150 | 0 | 0 | False |
False |
False |
|||||
| Provincia | varchar | 150 | 0 | 0 | False |
False |
False |
|||||
| _datos_personas_proc | tinyint | 1 | 3 | 0 | False |
False |
False |
|||||
| _domicilios_proc | tinyint | 1 | 3 | 0 | False |
False |
False |
SQL Script
Copy
CREATE TABLE dbo.ObrasSociales (
cuil_Activo varchar(50) NULL,
cuilRelacionado varchar(50) NULL,
DescRelacion varchar(100) NULL,
Relacion_Desde varchar(50) NULL,
ApeNom varchar(100) NULL,
DocTipo varchar(50) NULL,
DocNro varchar(50) NULL,
FechaNacimiento varchar(50) NULL,
CodSexo varchar(50) NULL,
CodDomi varchar(50) NULL,
Calle varchar(150) NULL,
Nro varchar(50) NULL,
Piso varchar(50) NULL,
Dpto varchar(50) NULL,
CodPostal varchar(50) NULL,
Localidad varchar(150) NULL,
Provincia varchar(150) NULL,
_datos_personas_proc tinyint NULL,
_domicilios_proc tinyint NULL
)
ON [PRIMARY]
GO
cuil_Activo varchar(50) NULL,
cuilRelacionado varchar(50) NULL,
DescRelacion varchar(100) NULL,
Relacion_Desde varchar(50) NULL,
ApeNom varchar(100) NULL,
DocTipo varchar(50) NULL,
DocNro varchar(50) NULL,
FechaNacimiento varchar(50) NULL,
CodSexo varchar(50) NULL,
CodDomi varchar(50) NULL,
Calle varchar(150) NULL,
Nro varchar(50) NULL,
Piso varchar(50) NULL,
Dpto varchar(50) NULL,
CodPostal varchar(50) NULL,
Localidad varchar(150) NULL,
Provincia varchar(150) NULL,
_datos_personas_proc tinyint NULL,
_domicilios_proc tinyint NULL
)
ON [PRIMARY]
GO
Depends On
1- FideDoc
Used By
No items found