dbo.gdl_alertas

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	False
Full Text Catalog
Full Text
Compression	NONE
Row Count (~)	10
Created	7/15/2014 4:55:03 PM
Last Modified	4/3/2016 12:31:43 AM

Columns

Name	Data Type	Length	Precision	Scale	Not Null	Identity	Default	Computed	Persisted
alerta	int	4	10	0	True	1 - 1		False	False
entidad_juridica	int	4	10	0	True			False	False
ingresada	datetime	8	23	3	True			False	False
ingresada_por	int	4	10	0	False			False	False
fecha_vigencia	datetime	8	23	3	False			False	False
descripcion	text		0	0	False			False	False
tipo_alerta	tinyint	1	3	0	False			False	False
valoracion_ic	varchar	1	0	0	False			False	False
notifica	tinyint	1	3	0	False			False	False
notificado	datetime	8	23	3	False			False	False
activa	tinyint	1	3	0	True		(1)	False	False
notificado_nombre	varchar	100	0	0	False			False	False
notificado_email	varchar	60	0	0	False			False	False
notificado_contacto	int	4	10	0	False			False	False

Indexes

Key	Name	Columns	Unique	Type	Description
	PK__gdl_aler__5C0FA03075BB8041	alerta	True

SQL Script

Copy

CREATE TABLE dbo.gdl_alertas (
  alerta int IDENTITY,
  entidad_juridica int NOT NULL,
  ingresada datetime NOT NULL,
  ingresada_por int NULL,
  fecha_vigencia datetime NULL,
  descripcion text NULL,
  tipo_alerta tinyint NULL,
  valoracion_ic varchar(1) NULL,
  notifica tinyint NULL,
  notificado datetime NULL,
  activa tinyint NOT NULL CONSTRAINT DF__gdl_alert__activ__7F44EA7B DEFAULT (1),
  notificado_nombre varchar(100) NULL,
  notificado_email varchar(60) NULL,
  notificado_contacto int NULL,
  CONSTRAINT PK__gdl_aler__5C0FA03075BB8041 PRIMARY KEY CLUSTERED (alerta) WITH (FILLFACTOR = 90)
)
ON [PRIMARY]
TEXTIMAGE_ON [PRIMARY]
GO

Depends On

Fidelitas

Used By

No items found