dbo.deuda_previsional

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 (~)	8995817
Created	3/5/2021 5:22:13 PM
Last Modified	11/7/2021 1:35:59 PM

Columns

Key	Name	Data Type	Length	Precision	Not Null	Identity	Default	Computed	Persisted
	id_deuda	int	4	10	True	1 - 1		False	False
	cuit	varchar	30	0	True			False	False
	codigo	varchar	3	0	True			False	False
	periodo	int	4	10	True			False	False
	fecha_info	date	3	10	True			False	False
	created	date	3	10	True		(getdate())	False	False
2	visible	bit	1	1	False		(1)	False	False

Indexes

Key	Name	Columns	Unique	Type	Description
	id_dp	cuit, visible	False
	idxDeudaExigible	visible	False

SQL Script

Copy

CREATE TABLE dbo.deuda_previsional (
  id_deuda int IDENTITY,
  cuit varchar(30) NOT NULL,
  codigo varchar(3) NOT NULL,
  periodo int NOT NULL,
  fecha_info date NOT NULL,
  created date NOT NULL DEFAULT (getdate()),
  visible bit NULL DEFAULT (1)
)
ON [PRIMARY]
GO

CREATE INDEX id_dp
  ON dbo.deuda_previsional (cuit, visible)
  INCLUDE (id_deuda, codigo, periodo, fecha_info, created)
  WITH (FILLFACTOR = 80)
  ON [PRIMARY]
GO

CREATE INDEX idxDeudaExigible
  ON dbo.deuda_previsional (visible)
  INCLUDE (fecha_info)
  WITH (FILLFACTOR = 80)
  ON [PRIMARY]
GO

Depends On

Fidelitas