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 (~)	2531715
Created	9/4/2019 3:19:16 PM
Last Modified	9/9/2019 4:52:46 PM

Columns

Key	Name	Data Type	Length	Precision	Scale	Not Null	Identity	Default	Computed	Persisted
	ACTA	varchar	150	0	0	False			False	False
	MARCA	varchar	250	0	0	False			False	False
	TMARCA	varchar	150	0	0	False			False	False
	TIPO	varchar	150	0	0	False			False	False
	CLASE	varchar	150	0	0	False			False	False
	NBOL	varchar	150	0	0	False			False	False
	TEXP	varchar	150	0	0	False			False	False
	PALABUS	varchar	150	0	0	False			False	False
	FPRE	date	3	10	0	False			False	False
	FPUBLI	date	3	10	0	False			False	False
	TRESO	varchar	150	0	0	False			False	False
	NRESO	varchar	150	0	0	False			False	False
	FRESO	date	3	10	0	False			False	False
	RENU_DE	varchar	150	0	0	False			False	False
	RENU_POR	varchar	150	0	0	False			False	False
2	TITULAR	varchar	250	0	0	False			False	False
	CODAGE	varchar	150	0	0	False			False	False
3	PAIS	varchar	150	0	0	False			False	False
	COBERTURA	text		0	0	False			False	False
	DISPCONCE	varchar	150	0	0	False			False	False
	DISPBOLE	varchar	150	0	0	False			False	False
	DISPFBOLE	date	3	10	0	False			False	False
	PRIORIDAD	varchar	150	0	0	False			False	False
	FPRIORIDAD	date	3	10	0	False			False	False
	PPRIORIDAD	varchar	150	0	0	False			False	False
	FVTO	date	3	10	0	False			False	False
	Column 26	varchar	150	0	0	False			False	False
	flag	char	1	0	0	False			False	False
	modified	smalldatetime	4	16	0	False			False	False
3	cuit	varchar	30	0	0	False			False	False
	directorio	bit	1	1	0	False			False	False
	web	bit	1	1	0	False			False	False
	web_fecha_modificacion	nchar	30	0	0	False			False	False
	html	bit	1	1	0	False			False	False
	idMarca	int	4	10	0	True	1 - 1		False	False
	created	datetime	8	23	3	False		(getdate())	False	False
	filename	varchar	100	0	0	False			False	False
	domicilio_legal	varchar	250	0	0	False			False	False
	dni	varchar	11	0	0	False			False	False
	territorio_legal	varchar	100	0	0	False			False	False
	domicilio_real_direccion	varchar	200	0	0	False			False	False
	domicilio_real_piso	varchar	5	0	0	False			False	False
	domicilio_real_depto	varchar	5	0	0	False			False	False
	localidad	varchar	50	0	0	False			False	False
	codigo_postal	varchar	10	0	0	False			False	False
	proteccion	varchar	50	0	0	False			False	False
	limitacion	varchar		0	0	False			False	False
	porcentaje_titularidad	varchar	10	0	0	False			False	False

Indexes

Name	Columns	Unique
idx_marcas_pais_cuit	PAIS, cuit	False
idx_marcas_pais_flag_cuit	PAIS, flag, cuit	False
idx_marcas_pais_titular	PAIS, TITULAR	False
idx_marcas_test_acta_titular	ACTA, TITULAR	False
marcas_test_acta	cuit	False

SQL Script

Copy

CREATE TABLE dbo.marcas_actas (
  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 date NULL,
  FPUBLI date NULL,
  TRESO varchar(150) NULL,
  NRESO varchar(150) NULL,
  FRESO date 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 date NULL,
  PRIORIDAD varchar(150) NULL,
  FPRIORIDAD date NULL,
  PPRIORIDAD varchar(150) NULL,
  FVTO date 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,
  created datetime NULL CONSTRAINT DF_marcas_test_acta_created DEFAULT (getdate()),
  filename varchar(100) NULL,
  domicilio_legal varchar(250) NULL,
  dni varchar(11) NULL,
  territorio_legal varchar(100) NULL,
  domicilio_real_direccion varchar(200) NULL,
  domicilio_real_piso varchar(5) NULL,
  domicilio_real_depto varchar(5) NULL,
  localidad varchar(50) NULL,
  codigo_postal varchar(10) NULL,
  proteccion varchar(50) NULL,
  limitacion varchar(max) NULL,
  porcentaje_titularidad varchar(10) NULL
)
ON [PRIMARY]
TEXTIMAGE_ON [PRIMARY]
GO

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

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

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

CREATE INDEX idx_marcas_test_acta_titular
  ON dbo.marcas_actas (ACTA, TITULAR)
  WITH (FILLFACTOR = 80)
  ON [PRIMARY]
GO

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

Depends On

Fidelitas

dbo.marcas_actas