dbo.LN_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 (~)	106
Created	10/16/2018 3:33:04 PM
Last Modified	3/12/2024 10:37:30 AM

Columns

Name	Data Type	Length	Precision	Not Null	Identity	Default	Computed	Persisted
producto	int	4	10	True	1 - 1		False	False
nombre_producto	varchar	100	0	False			False	False
country_code	varchar	2	0	False			False	False
visible	tinyint	1	3	True			False	False
created	smalldatetime	4	16	False			False	False
created_by	int	4	10	False			False	False
modified	smalldatetime	4	16	False			False	False
modified_by	int	4	10	False			False	False
etiqueta	varchar	30	0	False			False	False
class_icon	varchar	30	0	False			False	False
descripcion	text		0	False			False	False
visible_brief	tinyint	1	3	False			False	False
producto_id	varchar	50	0	False			False	False
balance	tinyint	1	3	True			False	False
balance_carga	tinyint	1	3	True			False	False
balance_analisis	tinyint	1	3	True			False	False
balance_score	tinyint	1	3	True			False	False
balance_valoracion	tinyint	1	3	True			False	False
documentos	tinyint	1	3	True		(0)	False	False
subcontratistas	tinyint	1	3	False		(0)	False	False
control_ingreso	tinyint	1	3	False			False	False
dossier	tinyint	1	3	True		(0)	False	False
producto_consumos	int	4	10	False			False	False
suscribe_indicadores	bit	1	1	False		(0)	False	False
servicio_contratado	int	4	10	False		(0)	False	False
todas_familias	bit	1	1	True		(0)	False	False
principal	bit	1	1	True		(1)	False	False
visible_home	bit	1	1	True		(0)	False	False

Indexes

Key	Name	Columns	Unique	Type	Description
	PK_LN_productos	producto	True

SQL Script

Copy

CREATE TABLE dbo.LN_productos (
  producto int IDENTITY,
  nombre_producto varchar(100) NULL,
  country_code varchar(2) NULL,
  visible tinyint NOT NULL,
  created smalldatetime NULL,
  created_by int NULL,
  modified smalldatetime NULL,
  modified_by int NULL,
  etiqueta varchar(30) NULL,
  class_icon varchar(30) NULL,
  descripcion text NULL,
  visible_brief tinyint NULL,
  producto_id varchar(50) NULL,
  balance tinyint NOT NULL,
  balance_carga tinyint NOT NULL,
  balance_analisis tinyint NOT NULL,
  balance_score tinyint NOT NULL,
  balance_valoracion tinyint NOT NULL,
  documentos tinyint NOT NULL DEFAULT (0),
  subcontratistas tinyint NULL DEFAULT (0),
  control_ingreso tinyint NULL,
  dossier tinyint NOT NULL DEFAULT (0),
  producto_consumos int NULL,
  suscribe_indicadores bit NULL DEFAULT (0),
  servicio_contratado int NULL DEFAULT (0),
  todas_familias bit NOT NULL DEFAULT (0),
  principal bit NOT NULL DEFAULT (1),
  visible_home bit NOT NULL DEFAULT (0),
  CONSTRAINT PK_LN_productos PRIMARY KEY CLUSTERED (producto) WITH (FILLFACTOR = 80)
)
ON [PRIMARY]
TEXTIMAGE_ON [PRIMARY]
GO

Depends On

Fidelitas

Used By

178