dbo.screening_prov

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 (~)	2585657
Created	8/25/2017 1:09:50 PM
Last Modified	3/2/2018 10:23:38 AM

Columns

Key	Name	Data Type	Length	Precision	Scale	Not Null	Identity	Default	Computed	Persisted
	id_screening_prov_out	int	4	10	0	True	1 - 1		False	False
	razon_social	varchar	250	0	0	False			False	False
	cuit	varchar	50	0	0	False			False	False
3	cliente	int	4	10	0	False			False	False
	created	datetime2	7	23	3	True		(getdate())	False	False
	titulo	varchar	250	0	0	False			False	False
	cargo	varchar	250	0	0	False			False	False
	soc_vinculada	varchar	512	0	0	False			False	False
	cuit_soc_vinculada	varchar	50	0	0	False			False	False
	nombre_integrante	varchar	250	0	0	False			False	False
	documento_integrante	varchar	50	0	0	False			False	False
	nrdoc_int	varchar	50	0	0	False			False	False
	cuit_int	varchar	50	0	0	False			False	False
2	cuit_integrante	varchar	50	0	0	False			False	False
	contenido_archivo	text		0	0	False			False	False
	fecha_publicacion	date	3	10	0	False			False	False
	visible	bit	1	1	0	False		(1)	False	False
	tipo_reg	varchar	10	0	0	False			False	False

Indexes

Name	Columns	Unique
idxScreeningClienteCuitInt	cliente	False
idxScreeningClienteCuitIntegrante	cliente	False
idxScreeningEmpOutCliente	cuit_int	False
idxScreeningOut	cliente, cuit_integrante	False
screen_prov_out_cli_cuit	cuit_integrante	False

SQL Script

Copy

CREATE TABLE dbo.screening_prov_out (
  id_screening_prov_out int IDENTITY,
  razon_social varchar(250) NULL,
  cuit varchar(50) NULL,
  cliente int NULL,
  created datetime2(3) NOT NULL DEFAULT (getdate()),
  titulo varchar(250) NULL,
  cargo varchar(250) NULL,
  soc_vinculada varchar(512) NULL,
  cuit_soc_vinculada varchar(50) NULL,
  nombre_integrante varchar(250) NULL,
  documento_integrante varchar(50) NULL,
  nrdoc_int varchar(50) NULL,
  cuit_int varchar(50) NULL,
  cuit_integrante varchar(50) NULL,
  contenido_archivo text NULL,
  fecha_publicacion date NULL,
  visible bit NULL DEFAULT (1),
  tipo_reg varchar(10) NULL
)
ON [PRIMARY]
TEXTIMAGE_ON [PRIMARY]
GO

CREATE INDEX idxScreeningClienteCuitInt
  ON dbo.screening_prov_out (cliente)
  INCLUDE (cuit_integrante)
  WITH (FILLFACTOR = 80)
  ON [PRIMARY]
GO

CREATE INDEX idxScreeningClienteCuitIntegrante
  ON dbo.screening_prov_out (cliente)
  INCLUDE (cuit_int)
  WITH (FILLFACTOR = 80)
  ON [PRIMARY]
GO

CREATE INDEX idxScreeningEmpOutCliente
  ON dbo.screening_prov_out (cuit_int)
  INCLUDE (razon_social, cuit)
  WITH (FILLFACTOR = 80)
  ON [PRIMARY]
GO

CREATE INDEX idxScreeningOut
  ON dbo.screening_prov_out (cliente, cuit_integrante)
  WITH (FILLFACTOR = 80)
  ON [PRIMARY]
GO

CREATE INDEX screen_prov_out_cli_cuit
  ON dbo.screening_prov_out (cuit_integrante)
  INCLUDE (cliente, cuit_int)
  WITH (FILLFACTOR = 80)
  ON [PRIMARY]
GO

Depends On

Fidelitas

dbo.screening_prov_out