dbo.LN_demo

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 (~)	53202
Created	1/23/2019 1:09:43 PM
Last Modified	12/3/2023 8:46:43 AM

Columns

Name	Data Type	Length	Precision	Scale	Not Null	Identity	Default	Computed	Persisted
contraparte	int	4	10	0	True			False	False
gestion	int	4	10	0	True			False	False
inicio_actividades	date	3	10	0	False			False	False
empleados	int	4	10	0	False			False	False
resenia	text		0	0	False			False	False
status_formales	varchar	1	0	0	False			False	False
status_relaciones	varchar	1	0	0	False			False	False
status_comerciales	varchar	1	0	0	False			False	False
status_fiscales	varchar	1	0	0	False			False	False
status_legales	varchar	1	0	0	False			False	False
status_bancos	varchar	1	0	0	False			False	False
status_comex	varchar	1	0	0	False			False	False
status_contables	varchar	1	0	0	False			False	False
status_prensa	varchar	1	0	0	False			False	False
status_peps	varchar	1	0	0	False			False	False
analisis	text		0	0	False			False	False
pep_html	text		0	0	False			False	False
visible	bit	1	1	0	False		(0)	False	False
producto	int	4	10	0	True			False	False
informe	int	4	10	0	False			False	False
id_dossier	int	4	10	0	True	1 - 1		False	False
created	datetime	8	23	3	True		(getdate())	False	False
prensa	text		0	0	False			False	False
fecha_publicacion	date	3	10	0	False			False	False
integ_carga	tinyint	1	3	0	False			False	False
integ_verif	tinyint	1	3	0	False			False	False
integ_rech	tinyint	1	3	0	False			False	False
docs_ok	bit	1	1	0	False		(0)	False	False
fecha_comprometida	datetime	8	23	3	False			False	False
fin_daga_int	datetime	8	23	3	False			False	False
fin_daga_ext	datetime	8	23	3	False			False	False
uid_daga_int	int	4	10	0	False			False	False
uid_daga_ext	int	4	10	0	False			False	False
idTeam	int	4	10	0	False			False	False
fecha_hora_pub	smalldatetime	4	16	0	False			False	False
TAT_prod	decimal	9	10	2	False		(0)	False	False
TAT_front	decimal	9	10	2	False		(0)	False	False

Indexes

Name	Columns	Unique
idxGestionesIV2	gestion	False
idxLNDEMO2023	docs_ok	False
idxLNDemoInforme	informe	False
idxLNDemoPublicado	fecha_publicacion	False
PK__LN_demo__B1776D835D23BC5A	contraparte, gestion, producto	True

SQL Script

Copy

CREATE TABLE dbo.LN_demo (
  contraparte int NOT NULL,
  gestion int NOT NULL,
  inicio_actividades date NULL,
  empleados int NULL,
  resenia text NULL,
  status_formales varchar(1) NULL,
  status_relaciones varchar(1) NULL,
  status_comerciales varchar(1) NULL,
  status_fiscales varchar(1) NULL,
  status_legales varchar(1) NULL,
  status_bancos varchar(1) NULL,
  status_comex varchar(1) NULL,
  status_contables varchar(1) NULL,
  status_prensa varchar(1) NULL,
  status_peps varchar(1) NULL,
  analisis text NULL,
  pep_html text NULL,
  visible bit NULL DEFAULT (0),
  producto int NOT NULL,
  informe int NULL,
  id_dossier int IDENTITY,
  created datetime NOT NULL DEFAULT (getdate()),
  prensa text NULL,
  fecha_publicacion date NULL,
  integ_carga tinyint NULL,
  integ_verif tinyint NULL,
  integ_rech tinyint NULL,
  docs_ok bit NULL DEFAULT (0),
  fecha_comprometida datetime NULL,
  fin_daga_int datetime NULL,
  fin_daga_ext datetime NULL,
  uid_daga_int int NULL,
  uid_daga_ext int NULL,
  idTeam int NULL,
  fecha_hora_pub smalldatetime NULL,
  TAT_prod decimal(10, 2) NULL DEFAULT (0),
  TAT_front decimal(10, 2) NULL DEFAULT (0),
  PRIMARY KEY NONCLUSTERED (contraparte, gestion, producto) WITH (FILLFACTOR = 80)
)
ON [PRIMARY]
TEXTIMAGE_ON [PRIMARY]
GO

CREATE INDEX idxGestionesIV2
  ON dbo.LN_demo (gestion)
  INCLUDE (visible)
  WITH (FILLFACTOR = 80)
  ON [PRIMARY]
GO

CREATE INDEX idxLNDEMO2023
  ON dbo.LN_demo (docs_ok)
  INCLUDE (contraparte, gestion, visible, producto, informe, integ_carga, integ_verif, integ_rech, fecha_comprometida)
  WITH (FILLFACTOR = 80)
  ON [PRIMARY]
GO

CREATE INDEX idxLNDemoInforme
  ON dbo.LN_demo (informe)
  WITH (FILLFACTOR = 80)
  ON [PRIMARY]
GO

CREATE INDEX idxLNDemoPublicado
  ON dbo.LN_demo (fecha_publicacion)
  INCLUDE (contraparte, gestion, visible, producto, informe, integ_carga, integ_verif, integ_rech, docs_ok, fecha_comprometida)
  WITH (FILLFACTOR = 80)
  ON [PRIMARY]
GO

Depends On

Fidelitas