dbo.led_score

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 (~)	2272
Created	1/14/2016 7:52:27 PM
Last Modified	1/14/2016 7:58:33 PM

Columns

Name	Data Type	Length	Precision	Scale	Not Null	Computed	Persisted
grupo_doc	int	4	10	0	False	False	False
peso_doc_ci	decimal	5	5	2	False	False	False
peso_doc_cc	decimal	5	5	2	False	False	False
periodo	int	4	10	0	False	False	False
compliance_doc	varchar	1	0	0	True	False	False
cliente	int	4	10	0	True	False	False
ci_killer_cont	tinyint	1	3	0	True	False	False
cc_killer_cont	tinyint	1	3	0	True	False	False
ci_killer_emp	tinyint	1	3	0	True	False	False
cc_killer_emp	tinyint	1	3	0	True	False	False
ci_killer_veh	tinyint	1	3	0	True	False	False
cc_killer_veh	tinyint	1	3	0	True	False	False
contratista	int	4	10	0	False	False	False

SQL Script

Copy

CREATE TABLE dbo.led_score_temp (
  grupo_doc int NULL,
  peso_doc_ci decimal(5, 2) NULL,
  peso_doc_cc decimal(5, 2) NULL,
  periodo int NULL,
  compliance_doc varchar(1) NOT NULL,
  cliente int NOT NULL,
  ci_killer_cont tinyint NOT NULL,
  cc_killer_cont tinyint NOT NULL,
  ci_killer_emp tinyint NOT NULL,
  cc_killer_emp tinyint NOT NULL,
  ci_killer_veh tinyint NOT NULL,
  cc_killer_veh tinyint NOT NULL,
  contratista int NULL
)
ON [PRIMARY]
GO

Depends On

Fidelitas

Used By

No items found