主机销售-客户订单

-- 数据库大全：主机销售-客户订单
-- 来源：YesApi.cn
CREATE TABLE `yesapi_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`),
    PRIMARY KEY (`id`)
) ENGINE=InnoDB COMMENT '主机销售-客户订单';

复制后，到数据库执行，即可创建此数据库表。