+ Use This Table All Design

MySQL Create Table SQL

Table Structure: okayapi_fie_slide:/tablelist/okayapi_fie_slide.html


-- MySQL Table okayapi_fie_slide
-- From: OkayAPI.com
CREATE TABLE `okayapi_fie_slide` (
    `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    `okayapi_fie_slide_status` tinyint(3) NOT NULL DEFAULT '1' COMMENT '状态,1:显示,0不显示',
    `delete_time` int(10) NOT NULL DEFAULT '0' COMMENT '删除时间',
    `okayapi_fie_slide_name` varchar(50) NOT NULL COMMENT '幻灯片分类',
    `remark` varchar(255) NOT NULL COMMENT '分类备注',
    KEY `okayapi_fie_slide_status` (`okayapi_fie_slide_status`),
    KEY `delete_time` (`delete_time`),
    KEY `okayapi_fie_slide_name` (`okayapi_fie_slide_name`),
    KEY `remark` (`remark`),
    PRIMARY KEY (`id`)
) ENGINE=InnoDB COMMENT 'fie内容管理-幻灯片表';

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 NameField TypeDefaultIS NULLField CommentIndexDemo Data
okayapi_fie_slide_statustinyint(3)1状态,1:显示,0不显示1
delete_timeint(10)0删除时间0
okayapi_fie_slide_namevarchar(50)幻灯片分类
remarkvarchar(255)分类备注

Guess You Like

MySQL Table Design okayapi_message

MySQL Table Design okayapi_article

MySQL Table Design okayapi_fie_admin_menu

MySQL Table Design okayapi_fie_asset

MySQL Table Design okayapi_fie_auth_access

MySQL Table Design okayapi_fie_auth_rule

MySQL Table Design okayapi_fie_comment

MySQL Table Design okayapi_fie_hook

MySQL Table Design okayapi_fie_hook_plugin

MySQL Table Design okayapi_fie_link

MySQL Table Design okayapi_fie_nav

MySQL Table Design okayapi_fie_nav_menu

MySQL Table Design okayapi_fie_option

MySQL Table Design okayapi_fie_plugin

MySQL Table Design okayapi_fie_portal_category

MySQL Table Design okayapi_fie_portal_category_post

MySQL Table Design okayapi_fie_portal_post

MySQL Table Design okayapi_fie_portal_tag

MySQL Table Design okayapi_fie_portal_tag_post

MySQL Table Design okayapi_fie_recycle_bin

TOP ↑