dbo.consumos

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 (~)	477
Created	10/1/2007 3:29:33 PM
Last Modified	10/29/2016 10:25:08 PM

Columns

Key	Name	Data Type	Length	Precision	Scale	Not Null	Identity	Computed	Persisted
	identificador	varchar	10	0	0	False		False	False
	id	int	4	10	0	True	1 - 1	False	False
	numero	varchar	50	0	0	False		False	False
	identificador_consulta	varchar	10	0	0	False		False	False
	numero_consulta	varchar	50	0	0	False		False	False
	fecha_hora	datetime	8	23	3	False		False	False
2	id_tipo_informe	int	4	10	0	False		False	False
	creditos	money	8	19	4	False		False	False
	lista_creditos	tinyint	1	3	0	False		False	False
2	user_id	int	4	10	0	False		False	False
2	cliente	int	4	10	0	False		False	False
	informe	int	4	10	0	False		False	False
	observaciones	text		0	0	False		False	False

Indexes

Name	Columns	Unique
PK__consumos__0425A276	id	True
XIE1consumos	identificador, numero, id_tipo_informe	False
XIE2consumos	identificador_consulta, numero_consulta, id_tipo_informe	False
XIE3consumos	cliente, user_id	False
XIE4consumos	user_id, cliente	False

SQL Script

Copy

CREATE TABLE dbo.consumos (
  identificador varchar(10) NULL,
  id int IDENTITY,
  numero varchar(50) NULL,
  identificador_consulta varchar(10) NULL,
  numero_consulta varchar(50) NULL,
  fecha_hora datetime NULL,
  id_tipo_informe int NULL,
  creditos money NULL,
  lista_creditos tinyint NULL,
  user_id int NULL,
  cliente int NULL,
  informe int NULL,
  observaciones text NULL,
  PRIMARY KEY CLUSTERED (id) WITH (FILLFACTOR = 90)
)
ON [PRIMARY]
TEXTIMAGE_ON [PRIMARY]
GO

CREATE INDEX XIE1consumos
  ON dbo.consumos (identificador, numero, id_tipo_informe)
  WITH (FILLFACTOR = 90)
  ON [PRIMARY]
GO

CREATE INDEX XIE2consumos
  ON dbo.consumos (identificador_consulta, numero_consulta, id_tipo_informe)
  WITH (FILLFACTOR = 90)
  ON [PRIMARY]
GO

CREATE INDEX XIE3consumos
  ON dbo.consumos (cliente, user_id)
  WITH (FILLFACTOR = 90)
  ON [PRIMARY]
GO

CREATE INDEX XIE4consumos
  ON dbo.consumos (user_id, cliente)
  WITH (FILLFACTOR = 90)
  ON [PRIMARY]
GO

Depends On

Fidelitas