dbo.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 (~)	220
Created	2/11/2017 3:43:10 PM
Last Modified	12/20/2018 1:45:42 PM

Columns

Name	Data Type	Length	Precision	Scale	Not Null	Identity	Default	Computed	Persisted
id_score	int	4	10	0	True	1 - 1		False	False
id_formula	int	4	10	0	True		(1)	False	False
id_grupo	int	4	10	0	True			False	False
nombre_grupo	varchar	200	0	0	False			False	False
afecta_directo	bit	1	1	0	False		(0)	False	False
item	varchar	200	0	0	False			False	False
codigo	varchar	20	0	0	False			False	False
cant_desde	decimal	9	10	5	False			False	False
cant_hasta	decimal	9	10	5	False			False	False
dias_desde	int	4	10	0	False			False	False
dias_hasta	int	4	10	0	False			False	False
valor	decimal	5	5	2	True			False	False
created	smalldatetime	4	16	0	True		(getdate())	False	False
killer	bit	1	1	0	False		(0)	False	False

SQL Script

Copy

CREATE TABLE dbo.score (
  id_score int IDENTITY,
  id_formula int NOT NULL CONSTRAINT DF_score_id_formula DEFAULT (1),
  id_grupo int NOT NULL,
  nombre_grupo varchar(200) NULL,
  afecta_directo bit NULL CONSTRAINT DF_score_afecta_directo DEFAULT (0),
  item varchar(200) NULL,
  codigo varchar(20) NULL,
  cant_desde decimal(10, 5) NULL,
  cant_hasta decimal(10, 5) NULL,
  dias_desde int NULL,
  dias_hasta int NULL,
  valor decimal(5, 2) NOT NULL,
  created smalldatetime NOT NULL CONSTRAINT DF_score_created DEFAULT (getdate()),
  killer bit NULL CONSTRAINT DF_score_killer DEFAULT (0)
)
ON [PRIMARY]
GO

Depends On

Fidelitas