MySQL Create Table SQL
Table Structure: okayapi_openant_category_option：/tablelist/okayapi_openant_category_option.html
-- MySQL Table okayapi_openant_category_option
-- From: OkayAPI.com
CREATE TABLE `okayapi_openant_category_option` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`category_id` int(11) NOT NULL COMMENT '',
`okayapi_openant_category_option_type` varchar(32) NOT NULL COMMENT '',
`okayapi_openant_category_option_value` int(11) NOT NULL COMMENT '',
`required` varchar(11) NOT NULL COMMENT '',
KEY `category_id` (`category_id`),
KEY `okayapi_openant_category_option_type` (`okayapi_openant_category_option_type`),
KEY `okayapi_openant_category_option_value` (`okayapi_openant_category_option_value`),
KEY `required` (`required`),
PRIMARY KEY (`id`)
) ENGINE=InnoDB COMMENT 'openant电商-分类选项';
After replication, you can go to the database to create the database table.
MySQL database table structure design
Displaying 1-4 of 4 results.
| Field Name | Field Type | Default | IS NULL | Field Comment | Index | Demo Data |
|---|---|---|---|---|---|---|
| category_id | int(11) | 否 | ||||
| okayapi_openant_category_option_type | varchar(32) | 否 | ||||
| okayapi_openant_category_option_value | int(11) | 否 | ||||
| required | varchar(11) | 否 |
