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 (~)	0
Created	3/6/2025 6:55:55 PM
Last Modified	3/6/2025 6:55:56 PM

Columns

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
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

Key	Name	Columns	Unique	Type	Description
	PK__pagos_tr__482E81D2848A5C92	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

Depends On

FideDoc

Used By

No items found