dbo.tipos_subinformes

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:57 PM

Columns

Name	Data Type	Length	Precision	Scale	Not Null	Computed	Persisted
id_tipo_subinforme	int	4	10	0	True	False	False
opcional	tinyint	1	3	0	False	False	False
id_tipo_informe	int	4	10	0	True	False	False
orden	tinyint	1	3	0	False	False	False
avance	decimal	5	6	2	False	False	False
f_est_dias_urgente	smallint	2	5	0	False	False	False
f_est_dias_normal	smallint	2	5	0	False	False	False
f_est_dias_demo	smallint	2	5	0	False	False	False
f_comp_dias_urgente	smallint	2	5	0	False	False	False
f_comp_dias_normal	smallint	2	5	0	False	False	False
f_comp_dias_demo	smallint	2	5	0	False	False	False

Indexes

Key	Name	Columns	Unique	Type	Description
	PK__tipos_su__5C130CB8B59641BD	id_tipo_informe, id_tipo_subinforme	True

Foreign Keys

Name	Columns	Description
FK__tipos_sub__id_ti__0E4EF685	id_tipo_informe

SQL Script

Copy

CREATE TABLE dbo.tipos_subinformes (
  id_tipo_subinforme int NOT NULL,
  opcional tinyint NULL,
  id_tipo_informe int NOT NULL,
  orden tinyint NULL,
  avance decimal(6, 2) NULL,
  f_est_dias_urgente smallint NULL,
  f_est_dias_normal smallint NULL,
  f_est_dias_demo smallint NULL,
  f_comp_dias_urgente smallint NULL,
  f_comp_dias_normal smallint NULL,
  f_comp_dias_demo smallint NULL,
  PRIMARY KEY NONCLUSTERED (id_tipo_informe, id_tipo_subinforme) WITH (FILLFACTOR = 90)
)
ON [PRIMARY]
GO

ALTER TABLE dbo.tipos_subinformes
  ADD FOREIGN KEY (id_tipo_informe) REFERENCES dbo.tipos_informe (id_tipo_informe)
GO

Depends On

dbo.tipos_informe

Used By

No items found