dbo.solicitud_informes

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 (~)	284
Created	5/8/2012 1:21:21 PM
Last Modified	8/8/2017 3:35:39 PM

Columns

Name	Data Type	Length	Precision	Not Null	Computed	Persisted
solicitud	int	4	10	True	False	False
item	smallint	2	5	True	False	False
razon_social	varchar	100	0	False	False	False
identificador	varchar	10	0	False	False	False
numero	varchar	50	0	False	False	False
contacto	varchar	50	0	False	False	False
cargo	varchar	50	0	False	False	False
telefono	varchar	30	0	False	False	False
email	varchar	50	0	False	False	False
estado_item	varchar	1	0	False	False	False
usuario_contacto	int	4	10	False	False	False
asignado	int	4	10	False	False	False
notas	text		0	False	False	False
country_code	varchar	2	0	False	False	False
id_tipo_informe	int	4	10	False	False	False
idioma	smallint	2	5	False	False	False

Indexes

Key	Name	Columns	Unique	Type	Description
	PK__solicitu__F999A54B71BDA4CF	solicitud, item	True

SQL Script

Copy

CREATE TABLE dbo.solicitud_informes (
  solicitud int NOT NULL,
  item smallint NOT NULL,
  razon_social varchar(100) NULL,
  identificador varchar(10) NULL,
  numero varchar(50) NULL,
  contacto varchar(50) NULL,
  cargo varchar(50) NULL,
  telefono varchar(30) NULL,
  email varchar(50) NULL,
  estado_item varchar(1) NULL,
  usuario_contacto int NULL,
  asignado int NULL,
  notas text NULL,
  country_code varchar(2) NULL,
  id_tipo_informe int NULL,
  idioma smallint NULL,
  PRIMARY KEY CLUSTERED (solicitud, item) WITH (FILLFACTOR = 90)
)
ON [PRIMARY]
TEXTIMAGE_ON [PRIMARY]
GO

Depends On

Fidelitas

Used By

No items found