dbo.LN_informe

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

Columns

Name	Data Type	Length	Precision	Scale	Not Null	Identity	Default	Computed	Persisted
id_informe_familia	int	4	10	0	True	1 - 1		False	False
familia	int	4	10	0	True			False	False
producto	int	4	10	0	True			False	False
id_tipo_informe	int	4	10	0	True			False	False
dedicacion	tinyint	1	3	0	False		(5)	False	False
user_id_solicitante	int	4	10	0	False			False	False
user_id_responsable	int	4	10	0	False			False	False
estado_inicial	varchar	1	0	0	False		('X')	False	False
user_id_asignado	int	4	10	0	False			False	False
dias_comprometidos	smallint	2	5	0	False		(15)	False	False
idioma	int	4	10	0	False		(29523)	False	False
informe_tarea	char	1	0	0	False		('I')	False	False
requiere_call_center	bit	1	1	0	False		(0)	False	False
id_tipo_informe_carga_doc	int	4	10	0	False			False	False
informe_default	bit	1	1	0	True		(1)	False	False
enviar_mail_alta	bit	1	1	0	False		(1)	False	False
activo	bit	1	1	0	True		(1)	False	False
created	datetime	8	23	3	True		(getdate())	False	False
created_by	int	4	10	0	False			False	False
modified	datetime	8	23	3	False			False	False
modified_by	int	4	10	0	False			False	False

SQL Script

Copy

CREATE TABLE dbo.LN_informe_familia (
  id_informe_familia int IDENTITY,
  familia int NOT NULL,
  producto int NOT NULL,
  id_tipo_informe int NOT NULL,
  dedicacion tinyint NULL CONSTRAINT DF__LN_inform__dedic__5BA4489B DEFAULT (5),
  user_id_solicitante int NULL,
  user_id_responsable int NULL,
  estado_inicial varchar(1) NULL CONSTRAINT DF__LN_inform__estad__5C986CD4 DEFAULT ('X'),
  user_id_asignado int NULL,
  dias_comprometidos smallint NULL CONSTRAINT DF__LN_inform__dias___5D8C910D DEFAULT (15),
  idioma int NULL CONSTRAINT DF__LN_inform__idiom__5E80B546 DEFAULT (29523),
  informe_tarea char(1) NULL CONSTRAINT DF__LN_inform__infor__5F74D97F DEFAULT ('I'),
  requiere_call_center bit NULL CONSTRAINT DF__LN_inform__requi__6068FDB8 DEFAULT (0),
  id_tipo_informe_carga_doc int NULL,
  informe_default bit NOT NULL CONSTRAINT DF__LN_inform__creat__6251463A DEFAULT (1),
  enviar_mail_alta bit NULL CONSTRAINT DF__LN_inform__activ__615D21F2 DEFAULT (1),
  activo bit NOT NULL CONSTRAINT DF__LN_inform__activ__615D21F1 DEFAULT (1),
  created datetime NOT NULL CONSTRAINT DF__LN_inform__creat__6251462A DEFAULT (getdate()),
  created_by int NULL,
  modified datetime NULL,
  modified_by int NULL
)
ON [PRIMARY]
GO

Depends On

FideDoc

Used By

No items found