okayapi_lvyou_jee_file_manager - MySQ Table Design

MySQL Create Table SQL

Table Structure: okayapi_lvyou_jee_file_manager：/tablelist/okayapi_lvyou_jee_file_manager.html


-- MySQL Table okayapi_lvyou_jee_file_manager
-- From: OkayAPI.com
CREATE TABLE `okayapi_lvyou_jee_file_manager` (
    `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    `okayapi_lvyou_jee_file_manager_names` varchar(100) NOT NULL COMMENT '',
    `suffix` varchar(50) NOT NULL COMMENT '',
    `mime` varchar(30) NOT NULL COMMENT '',
    `path` varchar(255) NOT NULL COMMENT '',
    `size` int(11) NOT NULL COMMENT '',
    `sort` int(11) NOT NULL COMMENT '',
    `okayapi_lvyou_jee_file_manager_status` tinyint(1) NOT NULL COMMENT '',
    KEY `okayapi_lvyou_jee_file_manager_names` (`okayapi_lvyou_jee_file_manager_names`),
    KEY `suffix` (`suffix`),
    KEY `mime` (`mime`),
    KEY `path` (`path`),
    KEY `size` (`size`),
    KEY `sort` (`sort`),
    KEY `okayapi_lvyou_jee_file_manager_status` (`okayapi_lvyou_jee_file_manager_status`),
    PRIMARY KEY (`id`)
) ENGINE=InnoDB COMMENT 'lvyou旅游-文件管理';

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

MySQL database table structure design

Displaying 1-7 of 7 results.

Field Name	Field Type	IS NULL
okayapi_lvyou_jee_file_manager_names	varchar(100)	否
suffix	varchar(50)	否
mime	varchar(30)	否
path	varchar(255)	否
size	int(11)	是
sort	int(11)	否
okayapi_lvyou_jee_file_manager_status	tinyint(1)	否