dbo.productos

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 (~)	115
Created	1/12/2015 10:11:19 AM
Last Modified	6/9/2020 8:46:59 PM

Columns

Name	Data Type	Length	Precision	Not Null	Identity	Computed	Persisted
producto	smallint	2	5	True	1 - 1	False	False
nombre_producto	varchar	100	0	False		False	False
grupo_informes	varchar	20	0	False		False	False
estado_producto	varchar	1	0	False		False	False
sigla	varchar	10	0	False		False	False
iv_candidato	tinyint	1	3	False		False	False
confidencial	tinyint	1	3	False		False	False
inquiro_vitae	tinyint	1	3	False		False	False
modalidad_pago	varchar	2	0	False		False	False
url	varchar	50	0	False		False	False
login_interactivo	bit	1	1	False		False	False
icono	varchar	50	0	False		False	False
url_method	varchar	4	0	False		False	False
orden	tinyint	1	3	False		False	False
nombre_visible	varchar	100	0	False		False	False

Indexes

Key	Name	Columns	Unique	Type	Description
	PK__producto__9D5BAF8C317B648D	producto	True

SQL Script

Copy

CREATE TABLE dbo.productos (
  producto smallint IDENTITY,
  nombre_producto varchar(100) NULL,
  grupo_informes varchar(20) NULL,
  estado_producto varchar(1) NULL,
  sigla varchar(10) NULL,
  iv_candidato tinyint NULL,
  confidencial tinyint NULL,
  inquiro_vitae tinyint NULL,
  modalidad_pago varchar(2) NULL,
  url varchar(50) NULL,
  login_interactivo bit NULL,
  icono varchar(50) NULL,
  url_method varchar(4) NULL,
  orden tinyint NULL,
  nombre_visible varchar(100) NULL,
  PRIMARY KEY CLUSTERED (producto) WITH (FILLFACTOR = 90)
)
ON [PRIMARY]
GO

Depends On

Fidelitas