dbo.marcas

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 (~)	2178237
Created	7/31/2017 5:56:40 PM
Last Modified	2/19/2019 6:57:42 PM

Columns

Key	Name	Data Type	Length	Precision	Not Null	Identity	Computed	Persisted
	ACTA	varchar	150	0	False		False	False
	MARCA	varchar	250	0	False		False	False
	TMARCA	varchar	150	0	False		False	False
	TIPO	varchar	150	0	False		False	False
	CLASE	varchar	150	0	False		False	False
	NBOL	varchar	150	0	False		False	False
	TEXP	varchar	150	0	False		False	False
	PALABUS	varchar	150	0	False		False	False
	FPRE	varchar	150	0	False		False	False
	FPUBLI	varchar	150	0	False		False	False
	TRESO	varchar	150	0	False		False	False
	NRESO	varchar	150	0	False		False	False
	FRESO	varchar	150	0	False		False	False
	RENU_DE	varchar	150	0	False		False	False
	RENU_POR	varchar	150	0	False		False	False
	TITULAR	varchar	250	0	False		False	False
	CODAGE	varchar	150	0	False		False	False
3	PAIS	varchar	150	0	False		False	False
	COBERTURA	text		0	False		False	False
	DISPCONCE	varchar	150	0	False		False	False
	DISPBOLE	varchar	150	0	False		False	False
	DISPFBOLE	varchar	150	0	False		False	False
	PRIORIDAD	varchar	150	0	False		False	False
	FPRIORIDAD	varchar	150	0	False		False	False
	PPRIORIDAD	varchar	150	0	False		False	False
	FVTO	varchar	150	0	False		False	False
	Column 26	varchar	150	0	False		False	False
	flag	char	1	0	False		False	False
	modified	smalldatetime	4	16	False		False	False
3	cuit	varchar	30	0	False		False	False
	directorio	bit	1	1	False		False	False
	web	bit	1	1	False		False	False
	web_fecha_modificacion	nchar	30	0	False		False	False
	html	bit	1	1	False		False	False
	idMarca	int	4	10	True	1 - 1	False	False

Indexes

Name	Columns	Unique
IDX_marcas	ACTA	True
idx_marcas_cuit	cuit	False
idx_marcas_pais_cuit	PAIS, cuit	False
idx_marcas_pais_flag_cuit	PAIS, flag, cuit	False
idx_marcas_pais_titular	PAIS, TITULAR	False

SQL Script

Copy

CREATE TABLE dbo.marcas (
  ACTA varchar(150) NULL,
  MARCA varchar(250) NULL,
  TMARCA varchar(150) NULL,
  TIPO varchar(150) NULL,
  CLASE varchar(150) NULL,
  NBOL varchar(150) NULL,
  TEXP varchar(150) NULL,
  PALABUS varchar(150) NULL,
  FPRE varchar(150) NULL,
  FPUBLI varchar(150) NULL,
  TRESO varchar(150) NULL,
  NRESO varchar(150) NULL,
  FRESO varchar(150) NULL,
  RENU_DE varchar(150) NULL,
  RENU_POR varchar(150) NULL,
  TITULAR varchar(250) NULL,
  CODAGE varchar(150) NULL,
  PAIS varchar(150) NULL,
  COBERTURA text NULL,
  DISPCONCE varchar(150) NULL,
  DISPBOLE varchar(150) NULL,
  DISPFBOLE varchar(150) NULL,
  PRIORIDAD varchar(150) NULL,
  FPRIORIDAD varchar(150) NULL,
  PPRIORIDAD varchar(150) NULL,
  FVTO varchar(150) NULL,
  [Column 26] varchar(150) NULL,
  flag char(1) NULL,
  modified smalldatetime NULL,
  cuit varchar(30) NULL,
  directorio bit NULL,
  web bit NULL,
  web_fecha_modificacion nchar(30) NULL,
  html bit NULL,
  idMarca int IDENTITY
)
ON [PRIMARY]
TEXTIMAGE_ON [PRIMARY]
GO

CREATE UNIQUE INDEX IDX_marcas
  ON dbo.marcas (ACTA)
  WITH (FILLFACTOR = 80)
  ON [PRIMARY]
GO

CREATE INDEX idx_marcas_cuit
  ON dbo.marcas (cuit)
  INCLUDE (ACTA, MARCA, TMARCA, CLASE, NBOL, FPUBLI, directorio, web)
  WITH (FILLFACTOR = 80)
  ON [PRIMARY]
GO

CREATE INDEX idx_marcas_pais_cuit
  ON dbo.marcas (PAIS, cuit)
  WITH (FILLFACTOR = 80)
  ON [PRIMARY]
GO

CREATE INDEX idx_marcas_pais_flag_cuit
  ON dbo.marcas (PAIS, flag, cuit)
  WITH (FILLFACTOR = 80)
  ON [PRIMARY]
GO

CREATE INDEX idx_marcas_pais_titular
  ON dbo.marcas (PAIS, TITULAR)
  INCLUDE (ACTA, MARCA, NBOL, FPUBLI)
  WITH (FILLFACTOR = 80)
  ON [PRIMARY]
GO

Depends On

Fidelitas