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:53 PM |
| Last Modified | 3/6/2025 6:55:53 PM |
Columns
21| Key | Name | Data Type | Length | Precision | Scale | Not Null | Identity | Rule | Default | Computed | Persisted | Description |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| ID | varchar | 50 | 0 | 0 | False |
False |
False |
|||||
| FECHAINICIODEMANDA | varchar | 50 | 0 | 0 | False |
False |
False |
|||||
| ACTOR | varchar | 150 | 0 | 0 | False |
False |
False |
|||||
| EXPEDIENTE | varchar | 50 | 0 | 0 | False |
False |
False |
|||||
| CARATULA | varchar | 250 | 0 | 0 | False |
False |
False |
|||||
| JUZGADO | varchar | 50 | 0 | 0 | False |
False |
False |
|||||
| SECRETARIA | varchar | 50 | 0 | 0 | False |
False |
False |
|||||
| ANIO | varchar | 50 | 0 | 0 | False |
False |
False |
|||||
| DEMANDADO | varchar | 150 | 0 | 0 | False |
False |
False |
|||||
| FECHACARGA | varchar | 50 | 0 | 0 | False |
False |
False |
|||||
| OBJETO | varchar | 150 | 0 | 0 | False |
False |
False |
|||||
| AUXEXPEDIENTE | varchar | 50 | 0 | 0 | False |
False |
False |
|||||
| IDLOTE | varchar | 50 | 0 | 0 | False |
False |
False |
|||||
| fecha_causa | date | 3 | 10 | 0 | False |
False |
False |
|||||
| fecha_alta | date | 3 | 10 | 0 | False |
False |
False |
|||||
| cuit_demandado | varchar | 20 | 0 | 0 | False |
False |
False |
|||||
| id_padron_demandado | int | 4 | 10 | 0 | False |
False |
False |
|||||
| cuit_actor | varchar | 20 | 0 | 0 | False |
False |
False |
|||||
| id_padron_actor | int | 4 | 10 | 0 | False |
False |
False |
|||||
| id_tipo_causa | int | 4 | 10 | 0 | False |
False |
False |
|||||
| CAU_CODIGO | varchar | 4 | 0 | 0 | False |
False |
False |
SQL Script
Copy
CREATE TABLE dbo.juicios_txt_2023 (
ID varchar(50) NULL,
FECHAINICIODEMANDA varchar(50) NULL,
ACTOR varchar(150) NULL,
EXPEDIENTE varchar(50) NULL,
CARATULA varchar(250) NULL,
JUZGADO varchar(50) NULL,
SECRETARIA varchar(50) NULL,
ANIO varchar(50) NULL,
DEMANDADO varchar(150) NULL,
FECHACARGA varchar(50) NULL,
OBJETO varchar(150) NULL,
AUXEXPEDIENTE varchar(50) NULL,
IDLOTE varchar(50) NULL,
fecha_causa date NULL,
fecha_alta date NULL,
cuit_demandado varchar(20) NULL,
id_padron_demandado int NULL,
cuit_actor varchar(20) NULL,
id_padron_actor int NULL,
id_tipo_causa int NULL,
CAU_CODIGO varchar(4) NULL
)
ON [PRIMARY]
GO
ID varchar(50) NULL,
FECHAINICIODEMANDA varchar(50) NULL,
ACTOR varchar(150) NULL,
EXPEDIENTE varchar(50) NULL,
CARATULA varchar(250) NULL,
JUZGADO varchar(50) NULL,
SECRETARIA varchar(50) NULL,
ANIO varchar(50) NULL,
DEMANDADO varchar(150) NULL,
FECHACARGA varchar(50) NULL,
OBJETO varchar(150) NULL,
AUXEXPEDIENTE varchar(50) NULL,
IDLOTE varchar(50) NULL,
fecha_causa date NULL,
fecha_alta date NULL,
cuit_demandado varchar(20) NULL,
id_padron_demandado int NULL,
cuit_actor varchar(20) NULL,
id_padron_actor int NULL,
id_tipo_causa int NULL,
CAU_CODIGO varchar(4) NULL
)
ON [PRIMARY]
GO
Depends On
1- FideDoc
Used By
No items found