okayapi_box_product - MySQ Table Design

MySQL Create Table SQL

Table Structure: okayapi_box_product：/tablelist/okayapi_box_product.html


-- MySQL Table okayapi_box_product
-- From: OkayAPI.com
CREATE TABLE `okayapi_box_product` (
    `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    `product_category_id` bigint(20) NULL COMMENT '',
    `product_payment_id` bigint(20) NULL COMMENT '',
    `form_id` bigint(20) NULL COMMENT '',
    `title` varchar(255) NULL COMMENT '',
    `slug` varchar(255) NULL COMMENT '',
    `description` text NULL COMMENT '',
    `unit` varchar(50) NULL DEFAULT 'product' COMMENT '',
    `active` tinyint(1) NULL DEFAULT '1' COMMENT '',
    `status` varchar(50) NULL DEFAULT 'enabled' COMMENT 'enabled, disabled',
    `hidden` tinyint(1) NULL DEFAULT '0' COMMENT '',
    `is_addon` tinyint(1) NULL DEFAULT '0' COMMENT '',
    `setup` varchar(50) NULL DEFAULT 'after_payment' COMMENT '',
    `addons` text NULL COMMENT '',
    `icon_url` varchar(255) NULL COMMENT '',
    `allow_quantity_select` tinyint(1) NULL DEFAULT '0' COMMENT '',
    `stock_control` tinyint(1) NULL DEFAULT '0' COMMENT '',
    `quantity_in_stock` int(11) NULL DEFAULT '0' COMMENT '',
    `plugin` varchar(255) NULL COMMENT '',
    `plugin_config` text NULL COMMENT '',
    `upgrades` text NULL COMMENT '',
    `priority` bigint(20) NULL COMMENT '',
    `config` text NULL COMMENT '',
    `type` varchar(255) NULL COMMENT '',
    KEY `product_category_id` (`product_category_id`),
    KEY `product_payment_id` (`product_payment_id`),
    KEY `form_id` (`form_id`),
    KEY `title` (`title`),
    KEY `slug` (`slug`),
    KEY `description` (`description`),
    KEY `unit` (`unit`),
    KEY `active` (`active`),
    KEY `status` (`status`),
    KEY `hidden` (`hidden`),
    KEY `is_addon` (`is_addon`),
    KEY `setup` (`setup`),
    KEY `addons` (`addons`),
    KEY `icon_url` (`icon_url`),
    KEY `allow_quantity_select` (`allow_quantity_select`),
    KEY `stock_control` (`stock_control`),
    KEY `quantity_in_stock` (`quantity_in_stock`),
    KEY `plugin` (`plugin`),
    KEY `plugin_config` (`plugin_config`),
    KEY `upgrades` (`upgrades`),
    KEY `priority` (`priority`),
    KEY `config` (`config`),
    KEY `type` (`type`),
    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-23 of 23 results.

Field Name	Field Type	Default	IS NULL	Field Comment	Index	Demo Data
product_category_id	bigint(20)		是		Normal Index
product_payment_id	bigint(20)		是		Normal Index
form_id	bigint(20)		是		Normal Index
title	varchar(255)		是
slug	varchar(255)		是		Unique Index
description	text		是
unit	varchar(50)	product	是			product
active	tinyint(1)	1	是			1
status	varchar(50)	enabled	是	enabled, disabled		enabled
hidden	tinyint(1)	0	是			0
is_addon	tinyint(1)	0	是			0
setup	varchar(50)	after_payment	是			after_payment
addons	text		是
icon_url	varchar(255)		是
allow_quantity_select	tinyint(1)	0	是			0
stock_control	tinyint(1)	0	是			0
quantity_in_stock	int(11)	0	是			0
plugin	varchar(255)		是
plugin_config	text		是
upgrades	text		是
priority	bigint(20)		是
config	text		是
type	varchar(255)		是		Normal Index