dbo.copyle

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 (~)	3854
Created	4/9/2018 2:59:39 PM
Last Modified	4/9/2018 3:16:35 PM

Columns

Name	Data Type	Length	Precision	Scale	Not Null	Computed	Persisted
id_cendeu	int	4	10	0	True	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
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	decimal	9	12	1	False	False	False
particip	decimal	9	12	1	False	False	False
garotor	decimal	9	12	1	False	False	False
o_cptos	decimal	9	12	1	False	False	False
garprefa	decimal	9	12	1	False	False	False
garprefb	decimal	9	12	1	False	False	False
singarpref	decimal	9	12	1	False	False	False
cgarprefa	decimal	9	12	1	False	False	False
cgarprefb	decimal	9	12	1	False	False	False
sincgarpre	decimal	9	12	1	False	False	False
previ	decimal	9	12	1	False	False	False
deuda_cubr	decimal	5	1	0	False	False	False
proc_jud	decimal	5	1	0	False	False	False
refinanc	decimal	5	1	0	False	False	False
rec_oblig	decimal	5	1	0	False	False	False
sit_juridi	decimal	5	1	0	False	False	False
irre_dispt	decimal	5	1	0	False	False	False
dia_atraso	decimal	5	4	0	False	False	False
id_fuente	int	4	10	0	False	False	False
vigente	bit	1	1	0	False	False	False
created	datetime2	7	23	3	False	False	False
created_by	int	4	10	0	False	False	False
modified	datetime2	7	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	decimal	9	12	1	True	False	False
observaciones	varchar	1024	0	0	False	False	False

Indexes

Key	Name	Columns	Unique	Type	Description
	idxCopyLE	iden	False

SQL Script

Copy

CREATE TABLE dbo.copyle (
  id_cendeu int NOT NULL,
  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 decimal(12, 1) NULL,
  particip decimal(12, 1) NULL,
  garotor decimal(12, 1) NULL,
  o_cptos decimal(12, 1) NULL,
  garprefa decimal(12, 1) NULL,
  garprefb decimal(12, 1) NULL,
  singarpref decimal(12, 1) NULL,
  cgarprefa decimal(12, 1) NULL,
  cgarprefb decimal(12, 1) NULL,
  sincgarpre decimal(12, 1) NULL,
  previ decimal(12, 1) NULL,
  deuda_cubr decimal(1) NULL,
  proc_jud decimal(1) NULL,
  refinanc decimal(1) NULL,
  rec_oblig decimal(1) NULL,
  sit_juridi decimal(1) NULL,
  irre_dispt decimal(1) NULL,
  dia_atraso decimal(4) NULL,
  id_fuente int NULL,
  vigente bit NULL,
  created datetime2(3) NULL,
  created_by int NULL,
  modified datetime2(3) NULL,
  modified_by int NULL,
  dbf_filename varchar(15) NULL,
  deuda_total decimal(12, 1) NOT NULL,
  observaciones varchar(1024) NULL
)
ON [PRIMARY]
GO

CREATE INDEX idxCopyLE
  ON dbo.copyle (iden)
  INCLUDE (situacion)
  WITH (FILLFACTOR = 80)
  ON [PRIMARY]
GO

Depends On

Fidelitas

Used By

No items found