+ Use This Table All Design

MySQL Create Table SQL

Table Structure: okayapi_shopxo_s_custom_view:/tablelist/okayapi_shopxo_s_custom_view.html


-- MySQL Table okayapi_shopxo_s_custom_view
-- From: OkayAPI.com
CREATE TABLE `okayapi_shopxo_s_custom_view` (
    `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    `title` char(60) NOT NULL COMMENT '标题',
    `content` text NOT NULL COMMENT '内容',
    `is_enable` tinyint(1) NOT NULL DEFAULT '1' COMMENT '是否启用(0否,1是)',
    `is_header` tinyint(1) NOT NULL DEFAULT '1' COMMENT '是否包含头部(0否, 1是)',
    `is_footer` tinyint(1) NOT NULL DEFAULT '1' COMMENT '是否包含尾部(0否, 1是)',
    `is_full_screen` tinyint(1) NOT NULL DEFAULT '0' COMMENT '是否满屏(0否, 1是)',
    `image` text NOT NULL COMMENT '图片数据(一维数组json)',
    `image_count` tinyint(3) NOT NULL DEFAULT '0' COMMENT '文章图片数量',
    `access_count` int(11) NOT NULL DEFAULT '0' COMMENT '访问次数',
    `upd_time` int(11) NOT NULL DEFAULT '0' COMMENT '更新时间',
    KEY `title` (`title`),
    KEY `content` (`content`),
    KEY `is_enable` (`is_enable`),
    KEY `is_header` (`is_header`),
    KEY `is_footer` (`is_footer`),
    KEY `is_full_screen` (`is_full_screen`),
    KEY `image` (`image`),
    KEY `image_count` (`image_count`),
    KEY `access_count` (`access_count`),
    KEY `upd_time` (`upd_time`),
    PRIMARY KEY (`id`)
) ENGINE=InnoDB COMMENT 'ShopXO商城-自定义页面';

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


MySQL database table structure design

Displaying 1-10 of 10 results.
Field NameField TypeDefaultIS NULLField CommentIndexDemo Data
titlechar(60)标题Normal Index
contenttext内容
is_enabletinyint(1)1是否启用(0否,1是)Normal Index1
is_headertinyint(1)1是否包含头部(0否, 1是)1
is_footertinyint(1)1是否包含尾部(0否, 1是)1
is_full_screentinyint(1)0是否满屏(0否, 1是)0
imagetext图片数据(一维数组json)
image_counttinyint(3)0文章图片数量Normal Index0
access_countint(11)0访问次数Normal Index0
upd_timeint(11)0更新时间0

Guess You Like

MySQL Table Design okayapi_goods

MySQL Table Design okayapi_goods_comment

MySQL Table Design okayapi_shopxo_s_admin

MySQL Table Design okayapi_shopxo_s_answer

MySQL Table Design okayapi_shopxo_s_app_center_nav

MySQL Table Design okayapi_shopxo_s_app_home_nav

MySQL Table Design okayapi_shopxo_s_article

MySQL Table Design okayapi_shopxo_s_article_category

MySQL Table Design okayapi_shopxo_s_attachment

MySQL Table Design okayapi_shopxo_s_brand

MySQL Table Design okayapi_shopxo_s_brand_category

MySQL Table Design okayapi_shopxo_s_cart

MySQL Table Design okayapi_shopxo_s_config

MySQL Table Design okayapi_shopxo_s_express

MySQL Table Design okayapi_shopxo_s_goods

MySQL Table Design okayapi_shopxo_s_goods_browse

MySQL Table Design okayapi_shopxo_s_goods_category

MySQL Table Design okayapi_shopxo_s_goods_category_join

MySQL Table Design okayapi_shopxo_s_goods_comments

MySQL Table Design okayapi_shopxo_s_goods_content_app

TOP ↑