dbo.vinculaciones

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 (~)	75231
Created	6/29/2016 5:42:25 PM
Last Modified	12/28/2016 5:58:53 PM

Columns

Key	Name	Data Type	Length	Precision	Scale	Not Null	Identity	Default	Computed	Persisted
	id_vinculacion	int	4	10	0	True	1 - 1		False	False
2	cuit_sociedad	varchar	20	0	0	False			False	False
	cuit_vinculada	varchar	20	0	0	False			False	False
	cod_vinculacion	smallint	2	5	0	False			False	False
	periodo_mes	date	3	10	0	False			False	False
	periodo_anio	date	3	10	0	False			False	False
	detalle	varchar	512	0	0	False			False	False
2	visible	bit	1	1	0	False		(1)	False	False
	id_padron_sociedad	int	4	10	0	False			False	False
	id_padron_vinculada	int	4	10	0	False			False	False
	usuario	varchar	8	0	0	False			False	False
	idifx	int	4	10	0	False			False	False
	created	datetime	8	23	3	False			False	False
	created_by	int	4	10	0	False			False	False
	modified	datetime	8	23	3	False			False	False
	modified_by	int	4	10	0	False			False	False

Indexes

Key	Name	Columns	Unique	Type	Description
	idx_vinculaciones_cuit_sociedad	cuit_sociedad, visible	False
	idx_vinculaciones_cuit_vinculada	cuit_vinculada, visible, cuit_sociedad	False

SQL Script

Copy

CREATE TABLE dbo.vinculaciones (
  id_vinculacion int IDENTITY,
  cuit_sociedad varchar(20) NULL,
  cuit_vinculada varchar(20) NULL,
  cod_vinculacion smallint NULL,
  periodo_mes date NULL,
  periodo_anio date NULL,
  detalle varchar(512) NULL,
  visible bit NULL CONSTRAINT DF_vinculaciones_visible DEFAULT (1),
  id_padron_sociedad int NULL,
  id_padron_vinculada int NULL,
  usuario varchar(8) NULL,
  idifx int NULL,
  created datetime NULL,
  created_by int NULL,
  modified datetime NULL,
  modified_by int NULL
)
ON [PRIMARY]
GO

CREATE INDEX idx_vinculaciones_cuit_sociedad
  ON dbo.vinculaciones (cuit_sociedad, visible)
  WITH (FILLFACTOR = 80)
  ON [PRIMARY]
GO

CREATE INDEX idx_vinculaciones_cuit_vinculada
  ON dbo.vinculaciones (cuit_vinculada, visible, cuit_sociedad)
  WITH (FILLFACTOR = 80)
  ON [PRIMARY]
GO

Depends On

Fidelitas