dbo.constantes

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:52 PM
Last Modified	3/6/2025 6:55:57 PM

Columns

Name	Data Type	Length	Precision	Not Null	Computed	Persisted
tipo_constante	int	4	10	True	False	False
clave_constante	varchar	100	0	True	False	False
valor1	varchar	100	0	False	False	False
valor2	varchar	100	0	False	False	False
valor3	varchar	100	0	False	False	False
valor4	varchar	100	0	False	False	False
valor5	varchar	100	0	False	False	False
valor_texto	text		0	False	False	False

Indexes

Key	Name	Columns	Unique	Type	Description
	PK__constant__6B20C262794E190C	tipo_constante, clave_constante	True

Foreign Keys

Name	Columns	Description
FK__constante__tipo___2DFCAC08	tipo_constante

SQL Script

Copy

CREATE TABLE dbo.constantes (
  tipo_constante int NOT NULL,
  clave_constante varchar(100) NOT NULL,
  valor1 varchar(100) NULL,
  valor2 varchar(100) NULL,
  valor3 varchar(100) NULL,
  valor4 varchar(100) NULL,
  valor5 varchar(100) NULL,
  valor_texto text NULL,
  PRIMARY KEY NONCLUSTERED (tipo_constante, clave_constante) WITH (FILLFACTOR = 90)
)
ON [PRIMARY]
TEXTIMAGE_ON [PRIMARY]
GO

ALTER TABLE dbo.constantes
  ADD FOREIGN KEY (tipo_constante) REFERENCES dbo.tipos_constante (tipo_constante)
GO

Depends On

FideDoc
dbo.tipos_constante

Used By

No items found