dbo.cendeu

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	False
Full Text Catalog
Full Text
Compression	NONE
Row Count (~)	919236702
Created	11/18/2024 5:18:58 PM
Last Modified	11/30/2024 8:33:40 PM

Columns

Key	Name	Data Type	Length	Precision	Scale	Not Null	Identity	Default	Computed	Persisted
	id_cendeu	bigint	8	19	0	True	1 - 1		False	False
	codigo_ent	varchar	5	0	0	False			False	False
	fec_inf	varchar	6	0	0	False			False	False
	tipo	varchar	2	0	0	False			False	False
3	iden	varchar	11	0	0	False			False	False
	id_persona	int	4	10	0	False			False	False
	actividad	varchar	3	0	0	False			False	False
	situacion	varchar	2	0	0	False			False	False
	prestamos	numeric	9	12	1	False			False	False
	particip	numeric	9	12	1	False			False	False
	garotor	numeric	9	12	1	False			False	False
	o_cptos	numeric	9	12	1	False			False	False
	garprefa	numeric	9	12	1	False			False	False
	garprefb	numeric	9	12	1	False			False	False
	singarpref	numeric	9	12	1	False			False	False
	cgarprefa	numeric	9	12	1	False			False	False
	cgarprefb	numeric	9	12	1	False			False	False
	sincgarpre	numeric	9	12	1	False			False	False
	previ	numeric	9	12	1	False			False	False
	deuda_cubr	numeric	5	1	0	False			False	False
	proc_jud	numeric	5	1	0	False			False	False
	refinanc	numeric	5	1	0	False			False	False
	rec_oblig	numeric	5	1	0	False			False	False
	sit_juridi	numeric	5	1	0	False			False	False
	irre_dispt	numeric	5	1	0	False			False	False
	dia_atraso	numeric	5	4	0	False			False	False
	id_fuente	int	4	10	0	False		(1)	False	False
2	vigente	bit	1	1	0	False		(1)	False	False
	created	datetime	8	23	3	False		(getdate())	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
	dbf_filename	varchar	15	0	0	False			False	False
	deuda_total	numeric	9	12	1	True		(0)	False	False
	observaciones	varchar	1024	0	0	False			False	False

Indexes

Name	Columns	Unique
idx_cendeubrief_codent122024	iden, created	False
idxCendeu122024	iden, id_fuente, vigente	False
idxCendeuIdenVigente122024	iden, vigente, fec_inf	False
PK__cendeu__5475B992EE4E00E6	id_cendeu	True

SQL Script

Copy

CREATE TABLE dbo.cendeu (
  id_cendeu bigint IDENTITY,
  codigo_ent varchar(5) NULL,
  fec_inf varchar(6) NULL,
  tipo varchar(2) NULL,
  iden varchar(11) NULL,
  id_persona int NULL,
  actividad varchar(3) NULL,
  situacion varchar(2) NULL,
  prestamos numeric(12, 1) NULL,
  particip numeric(12, 1) NULL,
  garotor numeric(12, 1) NULL,
  o_cptos numeric(12, 1) NULL,
  garprefa numeric(12, 1) NULL,
  garprefb numeric(12, 1) NULL,
  singarpref numeric(12, 1) NULL,
  cgarprefa numeric(12, 1) NULL,
  cgarprefb numeric(12, 1) NULL,
  sincgarpre numeric(12, 1) NULL,
  previ numeric(12, 1) NULL,
  deuda_cubr numeric(1) NULL,
  proc_jud numeric(1) NULL,
  refinanc numeric(1) NULL,
  rec_oblig numeric(1) NULL,
  sit_juridi numeric(1) NULL,
  irre_dispt numeric(1) NULL,
  dia_atraso numeric(4) NULL,
  id_fuente int NULL CONSTRAINT DF_cendeu_fuente DEFAULT (1),
  vigente bit NULL CONSTRAINT DF_cendeu_vigente DEFAULT (1),
  created datetime NULL CONSTRAINT DF_cendeu_created DEFAULT (getdate()),
  created_by int NULL,
  modified datetime NULL,
  modified_by int NULL,
  dbf_filename varchar(15) NULL,
  deuda_total numeric(12, 1) NOT NULL DEFAULT (0),
  observaciones varchar(1024) NULL,
  PRIMARY KEY CLUSTERED (id_cendeu)
)
ON [PRIMARY]
GO

CREATE INDEX idx_cendeubrief_codent122024
  ON dbo.cendeu (iden, created)
  INCLUDE (codigo_ent)
  WITH (FILLFACTOR = 80)
  ON [PRIMARY]
GO

CREATE INDEX idxCendeu122024
  ON dbo.cendeu (iden, id_fuente, vigente)
  INCLUDE (fec_inf)
  WITH (FILLFACTOR = 80)
  ON [PRIMARY]
GO

CREATE INDEX idxCendeuIdenVigente122024
  ON dbo.cendeu (iden, vigente, fec_inf)
  INCLUDE (id_cendeu, codigo_ent, situacion, prestamos, particip, garotor, o_cptos, id_fuente, deuda_total)
  WITH (FILLFACTOR = 80)
  ON [PRIMARY]
GO

Depends On

Fidelitas

Used By

121