dbo.pagos_transacciones

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 (~)	1906
Created	12/12/2019 3:08:59 PM
Last Modified	11/12/2023 9:08:57 AM

Columns

Key	Name	Data Type	Length	Precision	Scale	Not Null	Identity	Default	Computed	Persisted
	transact_id	int	4	10	0	True	1 - 1		False	False
	id_pago	int	4	10	0	True			False	False
	plataforma_pago	varchar	10	0	0	True			False	False
	merchant_id	bigint	8	19	0	False			False	False
	contraparte	int	4	10	0	False			False	False
	saas_usuario	int	4	10	0	False			False	False
	user_id	int	4	10	0	False			False	False
	producto	int	4	10	0	True			False	False
	vigencia	datetime	8	23	3	True			False	False
	fecha_transaccion	datetime	8	23	3	False			False	False
	fecha_confirmacion	datetime	8	23	3	False			False	False
	created	datetime	8	23	3	True		(getdate())	False	False
	valor	decimal	9	18	2	False			False	False
	moneda	varchar	3	0	0	False			False	False
3	status	varchar	20	0	0	True			False	False
	motivo	varchar	100	0	0	False			False	False
	preference_id	varchar	200	0	0	False			False	False
	payment_id	bigint	8	19	0	False			False	False
	facturado	bit	1	1	0	False		(0)	False	False
	fecha_facturado	date	3	10	0	False			False	False

Indexes

Name	Columns	Unique
idxContrapartePrepagos	contraparte, status	False
idxPagosStatus	plataforma_pago, fecha_transaccion, status	False
idxPagoTransacciones	status, preference_id	False
PK__pagos_tr__482E81D2B9356C95	transact_id	True

SQL Script

Copy

CREATE TABLE dbo.pagos_transacciones (
  transact_id int IDENTITY,
  id_pago int NOT NULL,
  plataforma_pago varchar(10) NOT NULL,
  merchant_id bigint NULL,
  contraparte int NULL,
  saas_usuario int NULL,
  user_id int NULL,
  producto int NOT NULL,
  vigencia datetime NOT NULL,
  fecha_transaccion datetime NULL,
  fecha_confirmacion datetime NULL,
  created datetime NOT NULL CONSTRAINT DF_pagos_transacciones_created DEFAULT (getdate()),
  valor decimal(18, 2) NULL,
  moneda varchar(3) NULL,
  status varchar(20) NOT NULL,
  motivo varchar(100) NULL,
  preference_id varchar(200) NULL,
  payment_id bigint NULL,
  facturado bit NULL DEFAULT (0),
  fecha_facturado date NULL,
  PRIMARY KEY CLUSTERED (transact_id) WITH (FILLFACTOR = 80)
)
ON [PRIMARY]
GO

CREATE INDEX idxContrapartePrepagos
  ON dbo.pagos_transacciones (contraparte, status)
  WITH (FILLFACTOR = 80)
  ON [PRIMARY]
GO

CREATE INDEX idxPagosStatus
  ON dbo.pagos_transacciones (plataforma_pago, fecha_transaccion, status)
  WITH (FILLFACTOR = 80)
  ON [PRIMARY]
GO

CREATE INDEX idxPagoTransacciones
  ON dbo.pagos_transacciones (status, preference_id)
  INCLUDE (contraparte)
  WITH (FILLFACTOR = 80)
  ON [PRIMARY]
GO

Depends On

Fidelitas