You can not select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
28 lines
1.1 KiB
28 lines
1.1 KiB
-- Adminer 4.6.3 MySQL dump
|
|
|
|
SET NAMES utf8;
|
|
SET time_zone = '+00:00';
|
|
SET foreign_key_checks = 0;
|
|
SET sql_mode = 'NO_AUTO_VALUE_ON_ZERO';
|
|
|
|
DROP TABLE IF EXISTS `event_payment`;
|
|
CREATE TABLE `event_payment` (
|
|
`id` int(11) NOT NULL AUTO_INCREMENT,
|
|
`event_id` int(11) NOT NULL,
|
|
`user_id` int(11) NOT NULL,
|
|
`login_id` int(11) NOT NULL,
|
|
`stripe_client_secret` varchar(64) NOT NULL COMMENT 'stripe payment intent client secret key to used to retrieve stripe paymentIntent object',
|
|
`event_rate` int(11) NOT NULL,
|
|
`seats_reserved` int(11) NOT NULL,
|
|
`service_charge` double NOT NULL,
|
|
`total_amount` int(11) NOT NULL COMMENT '(event_rate * seats_reserved) + service_charge',
|
|
`date` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
|
|
`billing_details` json NOT NULL COMMENT 'JSON contains billing email, name, address, zip, etc...',
|
|
PRIMARY KEY (`id`),
|
|
KEY `event_rate` (`event_rate`),
|
|
KEY `event_id` (`event_id`),
|
|
CONSTRAINT `event_payment_ibfk_2` FOREIGN KEY (`event_id`) REFERENCES `event` (`event_id`)
|
|
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
|
|
|
|
|
|
-- 2021-09-07 08:13:34
|
|
|