dbo.score_personalizado

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 (~)	2
Created	12/27/2018 12:19:27 PM
Last Modified	12/27/2018 12:19:40 PM

Columns

Name	Data Type	Length	Precision	Scale	Not Null	Identity	Default	Computed	Persisted
user_id	int	4	10	0	True			False	False
client_id	int	4	10	0	True			False	False
id_score_personalizado	int	4	10	0	True	1 - 1		False	False
id_formula	int	4	10	0	True			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			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			False	False

SQL Script

Copy

CREATE TABLE dbo.score_personalizado (
  user_id int NOT NULL,
  client_id int NOT NULL,
  id_score_personalizado int IDENTITY,
  id_formula int NOT NULL,
  id_grupo int NOT NULL,
  nombre_grupo varchar(200) NULL,
  afecta_directo bit NULL,
  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_personalizado_created DEFAULT (getdate()),
  killer bit NULL
)
ON [PRIMARY]
GO

Depends On

Fidelitas