okayapi_box_client_order - MySQ Table Design

MySQL Create Table SQL

Table Structure: okayapi_box_client_order：/tablelist/okayapi_box_client_order.html


-- MySQL Table okayapi_box_client_order
-- From: OkayAPI.com
CREATE TABLE `okayapi_box_client_order` (
    `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    `client_id` bigint(20) NULL COMMENT '',
    `product_id` bigint(20) NULL COMMENT '',
    `form_id` bigint(20) NULL COMMENT '',
    `promo_id` bigint(20) NULL COMMENT '',
    `promo_recurring` tinyint(1) NULL COMMENT '',
    `promo_used` bigint(20) NULL COMMENT '',
    `group_id` varchar(255) NULL COMMENT '',
    `group_master` tinyint(1) NULL DEFAULT '0' COMMENT '',
    `invoice_option` varchar(255) NULL COMMENT '',
    `title` varchar(255) NULL COMMENT '',
    `currency` varchar(20) NULL COMMENT '',
    `unpaid_invoice_id` bigint(20) NULL COMMENT '',
    `service_id` bigint(20) NULL COMMENT '',
    `service_type` varchar(100) NULL COMMENT '',
    `period` varchar(20) NULL COMMENT '',
    `quantity` bigint(20) NULL DEFAULT '1' COMMENT '',
    `unit` varchar(100) NULL COMMENT '',
    `price` double(18,2) NULL COMMENT '',
    `discount` double(18,2) NULL COMMENT 'first invoice discount',
    `status` varchar(50) NULL COMMENT '',
    `reason` varchar(255) NULL COMMENT 'suspend/cancel reason',
    `notes` text NULL COMMENT '',
    `config` text NULL COMMENT '',
    `referred_by` varchar(255) NULL COMMENT '',
    `expires_at` datetime NULL COMMENT '',
    `activated_at` datetime NULL COMMENT '',
    `suspended_at` datetime NULL COMMENT '',
    `unsuspended_at` datetime NULL COMMENT '',
    `canceled_at` datetime NULL COMMENT '',
    KEY `client_id` (`client_id`),
    KEY `product_id` (`product_id`),
    KEY `form_id` (`form_id`),
    KEY `promo_id` (`promo_id`),
    KEY `promo_recurring` (`promo_recurring`),
    KEY `promo_used` (`promo_used`),
    KEY `group_id` (`group_id`),
    KEY `group_master` (`group_master`),
    KEY `invoice_option` (`invoice_option`),
    KEY `title` (`title`),
    KEY `currency` (`currency`),
    KEY `unpaid_invoice_id` (`unpaid_invoice_id`),
    KEY `service_id` (`service_id`),
    KEY `service_type` (`service_type`),
    KEY `period` (`period`),
    KEY `quantity` (`quantity`),
    KEY `unit` (`unit`),
    KEY `price` (`price`),
    KEY `discount` (`discount`),
    KEY `status` (`status`),
    KEY `reason` (`reason`),
    KEY `notes` (`notes`),
    KEY `config` (`config`),
    KEY `referred_by` (`referred_by`),
    KEY `expires_at` (`expires_at`),
    KEY `activated_at` (`activated_at`),
    KEY `suspended_at` (`suspended_at`),
    KEY `unsuspended_at` (`unsuspended_at`),
    KEY `canceled_at` (`canceled_at`),
    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-29 of 29 results.

Field Name	Field Type	Default	IS NULL	Field Comment	Index	Demo Data
client_id	bigint(20)		是		Normal Index
product_id	bigint(20)		是		Normal Index
form_id	bigint(20)		是		Normal Index
promo_id	bigint(20)		是		Normal Index
promo_recurring	tinyint(1)		是
promo_used	bigint(20)		是
group_id	varchar(255)		是
group_master	tinyint(1)	0	是			0
invoice_option	varchar(255)		是
title	varchar(255)		是
currency	varchar(20)		是
unpaid_invoice_id	bigint(20)		是
service_id	bigint(20)		是
service_type	varchar(100)		是
period	varchar(20)		是
quantity	bigint(20)	1	是			1
unit	varchar(100)		是
price	double(18,2)		是
discount	double(18,2)		是	first invoice discount
status	varchar(50)		是
reason	varchar(255)		是	suspend/cancel reason
notes	text		是
config	text		是
referred_by	varchar(255)		是
expires_at	datetime		是
activated_at	datetime		是
suspended_at	datetime		是
unsuspended_at	datetime		是
canceled_at	datetime		是