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 (~)	0
Created	3/6/2025 6:55:55 PM
Last Modified	3/6/2025 6:55:55 PM

Columns

Name	Data Type	Length	Precision	Scale	Not Null	Identity	Computed	Persisted
id_score	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	5	6	2	False		False	False
cant_hasta	decimal	5	6	2	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		False	False
killer	bit	1	1	0	False		False	False

SQL Script

Copy

CREATE TABLE dbo.score_temp (
  id_score 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(6, 2) NULL,
  cant_hasta decimal(6, 2) NULL,
  dias_desde int NULL,
  dias_hasta int NULL,
  valor decimal(5, 2) NOT NULL,
  created smalldatetime NOT NULL,
  killer bit NULL
)
ON [PRIMARY]
GO

Depends On

FideDoc

Used By

No items found