dbo.LN_contrapartes

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 (~)	89919
Created	6/7/2019 5:06:23 PM
Last Modified	2/24/2023 10:53:09 PM

Columns

Key	Name	Data Type	Length	Precision	Scale	Not Null	Identity	Default	Computed	Persisted
	queue_id	int	4	10	0	True	1 - 1		False	False
	contraparte	int	4	10	0	True			False	False
	created	datetime	8	23	3	True		(getdate())	False	False
3	processed	bit	1	1	0	True		(0)	False	False
	finished	datetime	8	23	3	False			False	False
	id_taken	int	4	10	0	True		(0)	False	False

Indexes

Name	Columns	Unique
idxContrapartesQueue23	processed, id_taken	False
idxQueueProcesado	contraparte, processed	False
IX_processed	processed	False
PK__LN_contr__2294FA6E9E7B4DB3	queue_id	True

SQL Script

Copy

CREATE TABLE dbo.LN_contrapartes_queue (
  queue_id int IDENTITY,
  contraparte int NOT NULL,
  created datetime NOT NULL DEFAULT (getdate()),
  processed bit NOT NULL DEFAULT (0),
  finished datetime NULL,
  id_taken int NOT NULL DEFAULT (0),
  PRIMARY KEY CLUSTERED (queue_id) WITH (FILLFACTOR = 80)
)
ON [PRIMARY]
GO

CREATE INDEX idxContrapartesQueue23
  ON dbo.LN_contrapartes_queue (processed, id_taken)
  INCLUDE (contraparte, created)
  WITH (FILLFACTOR = 80)
  ON [PRIMARY]
GO

CREATE INDEX idxQueueProcesado
  ON dbo.LN_contrapartes_queue (contraparte, processed)
  WITH (FILLFACTOR = 80)
  ON [PRIMARY]
GO

CREATE INDEX IX_processed
  ON dbo.LN_contrapartes_queue (processed)
  WITH (FILLFACTOR = 80)
  ON [PRIMARY]
GO

Depends On

No items found

dbo.LN_contrapartes_queue