dbo.mis_aportes_procesar

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 (~)	181405
Created	10/31/2024 10:11:42 AM
Last Modified	1/7/2025 9:44:00 AM

Columns

Key	Name	Data Type	Length	Precision	Scale	Not Null	Identity	Computed	Persisted
	id	int	4	10	0	True	1 - 1	False	False
	cuil	varchar	20	0	0	False		False	False
2	id_taken	int	4	10	0	False		False	False
	created	datetime	8	23	3	False		False	False
	procesado	int	4	10	0	False		False	False
	procesado_fecha	datetime	8	23	3	False		False	False

Indexes

Name	Columns	Unique
idx_mis_aportes_procesar_padron	id_taken	False
idx_mis_aportes_procesar_padron_2	id	False
idxMisaportesPadron	id_taken	False

SQL Script

Copy

CREATE TABLE dbo.mis_aportes_procesar_padron (
  id int IDENTITY,
  cuil varchar(20) NULL,
  id_taken int NULL,
  created datetime NULL,
  procesado int NULL,
  procesado_fecha datetime NULL
)
ON [PRIMARY]
GO

CREATE INDEX idx_mis_aportes_procesar_padron
  ON dbo.mis_aportes_procesar_padron (id_taken)
  INCLUDE (procesado)
  WITH (FILLFACTOR = 80)
  ON [PRIMARY]
GO

CREATE INDEX idx_mis_aportes_procesar_padron_2
  ON dbo.mis_aportes_procesar_padron (id)
  WITH (FILLFACTOR = 80)
  ON [PRIMARY]
GO

CREATE INDEX idxMisaportesPadron
  ON dbo.mis_aportes_procesar_padron (id_taken)
  INCLUDE (id, cuil, procesado)
  WITH (FILLFACTOR = 80)
  ON [PRIMARY]
GO

Depends On

Fidelitas

dbo.mis_aportes_procesar_padron