okayapi_box_product_payment - MySQ Table Design

MySQL Create Table SQL

Table Structure: okayapi_box_product_payment：/tablelist/okayapi_box_product_payment.html


-- MySQL Table okayapi_box_product_payment
-- From: OkayAPI.com
CREATE TABLE `okayapi_box_product_payment` (
    `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    `type` varchar(30) NULL COMMENT 'free, once, recurrent',
    `once_price` decimal(18,2) NULL DEFAULT '0.00' COMMENT '',
    `once_setup_price` decimal(18,2) NULL DEFAULT '0.00' COMMENT '',
    `w_price` decimal(18,2) NULL DEFAULT '0.00' COMMENT '',
    `m_price` decimal(18,2) NULL DEFAULT '0.00' COMMENT '',
    `q_price` decimal(18,2) NULL DEFAULT '0.00' COMMENT '',
    `b_price` decimal(18,2) NULL DEFAULT '0.00' COMMENT '',
    `a_price` decimal(18,2) NULL DEFAULT '0.00' COMMENT '',
    `bia_price` decimal(18,2) NULL DEFAULT '0.00' COMMENT '',
    `tria_price` decimal(18,2) NULL DEFAULT '0.00' COMMENT '',
    `w_setup_price` decimal(18,2) NULL DEFAULT '0.00' COMMENT '',
    `m_setup_price` decimal(18,2) NULL DEFAULT '0.00' COMMENT '',
    `q_setup_price` decimal(18,2) NULL DEFAULT '0.00' COMMENT '',
    `b_setup_price` decimal(18,2) NULL DEFAULT '0.00' COMMENT '',
    `a_setup_price` decimal(18,2) NULL DEFAULT '0.00' COMMENT '',
    `bia_setup_price` decimal(18,2) NULL DEFAULT '0.00' COMMENT '',
    `tria_setup_price` decimal(18,2) NULL DEFAULT '0.00' COMMENT '',
    `w_enabled` tinyint(1) NULL DEFAULT '1' COMMENT '',
    `m_enabled` tinyint(1) NULL DEFAULT '1' COMMENT '',
    `q_enabled` tinyint(1) NULL DEFAULT '1' COMMENT '',
    `b_enabled` tinyint(1) NULL DEFAULT '1' COMMENT '',
    `a_enabled` tinyint(1) NULL DEFAULT '1' COMMENT '',
    `bia_enabled` tinyint(1) NULL DEFAULT '1' COMMENT '',
    `tria_enabled` tinyint(1) NULL DEFAULT '1' COMMENT '',
    KEY `type` (`type`),
    KEY `once_price` (`once_price`),
    KEY `once_setup_price` (`once_setup_price`),
    KEY `w_price` (`w_price`),
    KEY `m_price` (`m_price`),
    KEY `q_price` (`q_price`),
    KEY `b_price` (`b_price`),
    KEY `a_price` (`a_price`),
    KEY `bia_price` (`bia_price`),
    KEY `tria_price` (`tria_price`),
    KEY `w_setup_price` (`w_setup_price`),
    KEY `m_setup_price` (`m_setup_price`),
    KEY `q_setup_price` (`q_setup_price`),
    KEY `b_setup_price` (`b_setup_price`),
    KEY `a_setup_price` (`a_setup_price`),
    KEY `bia_setup_price` (`bia_setup_price`),
    KEY `tria_setup_price` (`tria_setup_price`),
    KEY `w_enabled` (`w_enabled`),
    KEY `m_enabled` (`m_enabled`),
    KEY `q_enabled` (`q_enabled`),
    KEY `b_enabled` (`b_enabled`),
    KEY `a_enabled` (`a_enabled`),
    KEY `bia_enabled` (`bia_enabled`),
    KEY `tria_enabled` (`tria_enabled`),
    PRIMARY KEY (`id`)
) ENGINE=InnoDB COMMENT '主机销售-产品付款';

After replication, you can go to the database to create the database table.

MySQL database table structure design

Displaying 1-24 of 24 results.

Field Name	Field Type	Default	IS NULL	Field Comment	Demo Data
type	varchar(30)		是	free, once, recurrent
once_price	decimal(18,2)	0.00	是		0.00
once_setup_price	decimal(18,2)	0.00	是		0.00
w_price	decimal(18,2)	0.00	是		0.00
m_price	decimal(18,2)	0.00	是		0.00
q_price	decimal(18,2)	0.00	是		0.00
b_price	decimal(18,2)	0.00	是		0.00
a_price	decimal(18,2)	0.00	是		0.00
bia_price	decimal(18,2)	0.00	是		0.00
tria_price	decimal(18,2)	0.00	是		0.00
w_setup_price	decimal(18,2)	0.00	是		0.00
m_setup_price	decimal(18,2)	0.00	是		0.00
q_setup_price	decimal(18,2)	0.00	是		0.00
b_setup_price	decimal(18,2)	0.00	是		0.00
a_setup_price	decimal(18,2)	0.00	是		0.00
bia_setup_price	decimal(18,2)	0.00	是		0.00
tria_setup_price	decimal(18,2)	0.00	是		0.00
w_enabled	tinyint(1)	1	是		1
m_enabled	tinyint(1)	1	是		1
q_enabled	tinyint(1)	1	是		1
b_enabled	tinyint(1)	1	是		1
a_enabled	tinyint(1)	1	是		1
bia_enabled	tinyint(1)	1	是		1
tria_enabled	tinyint(1)	1	是		1