dbo.apocrifas

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 (~)	41816
Created	7/17/2018 4:51:07 PM
Last Modified	11/13/2019 3:28:47 PM

Columns

Name	Data Type	Length	Precision	Scale	Not Null	Identity	Default	Computed	Persisted
id_apocrifas	int	4	10	0	True	1 - 1		False	False
cuit	varchar	20	0	0	True			False	False
detectado	date	3	10	0	False			False	False
publicado	date	3	10	0	False			False	False
observaciones	varchar	512	0	0	False			False	False
visible	bit	1	1	0	True		(1)	False	False
created	datetime	8	23	3	True		(getdate())	False	False

Indexes

Key	Name	Columns	Unique	Type	Description
	IDX_apocrifas_visible_cuit	visible	False
	idxApocrifasCuit	cuit	False

SQL Script

Copy

CREATE TABLE dbo.apocrifas (
  id_apocrifas int IDENTITY,
  cuit varchar(20) NOT NULL,
  detectado date NULL,
  publicado date NULL,
  observaciones varchar(512) NULL,
  visible bit NOT NULL DEFAULT (1),
  created datetime NOT NULL DEFAULT (getdate())
)
ON [PRIMARY]
GO

CREATE INDEX IDX_apocrifas_visible_cuit
  ON dbo.apocrifas (visible)
  INCLUDE (cuit)
  WITH (FILLFACTOR = 80)
  ON [PRIMARY]
GO

CREATE INDEX idxApocrifasCuit
  ON dbo.apocrifas (cuit)
  WITH (FILLFACTOR = 80)
  ON [PRIMARY]
GO

Depends On

Fidelitas