32 lines
812 B
SQL
32 lines
812 B
SQL
CREATE TABLE IF NOT EXISTS "payment_entry"
|
|
(
|
|
"id" uuid NOT NULL,
|
|
"created" timestamp NOT NULL,
|
|
"modified" timestamp DEFAULT NULL,
|
|
|
|
"gateway" varchar(255) NOT NULL,
|
|
"state" varchar(255) NOT NULL,
|
|
|
|
"lang" varchar(16) DEFAULT NULL,
|
|
"error" varchar(255) DEFAULT NULL,
|
|
|
|
"amount" int DEFAULT NULL,
|
|
"total_amount" int NOT NULL,
|
|
|
|
"eci" varchar(255) DEFAULT NULL,
|
|
|
|
"payment_intent_id" varchar(255) DEFAULT NULL,
|
|
|
|
"ws_pay_order_id" varchar(255) DEFAULT '',
|
|
"shopping_card_id" varchar(255) DEFAULT NULL,
|
|
"stan" varchar(255) DEFAULT NULL,
|
|
"success" int DEFAULT NULL,
|
|
"approval_code" varchar(255) DEFAULT NULL,
|
|
|
|
"order_id" varchar(255) DEFAULT NULL,
|
|
"transaction_id" uuid DEFAULT NULL,
|
|
"event_id" varchar(255) DEFAULT NULL,
|
|
|
|
PRIMARY KEY (id)
|
|
);
|