+ Use This Table All Design

MySQL Create Table SQL

Table Structure: okayapi_shopxo_s_article:/tablelist/okayapi_shopxo_s_article.html


-- MySQL Table okayapi_shopxo_s_article
-- From: OkayAPI.com
CREATE TABLE `okayapi_shopxo_s_article` (
    `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    `title` char(60) NOT NULL COMMENT '标题',
    `article_category_id` int(11) NOT NULL DEFAULT '0' COMMENT '文章分类',
    `title_color` char(7) NOT NULL COMMENT '标题颜色',
    `jump_url` char(255) NOT NULL COMMENT '跳转url地址',
    `is_enable` tinyint(1) NOT NULL DEFAULT '1' COMMENT '是否启用(0否,1是)',
    `content` text NOT NULL COMMENT '内容',
    `image` text NOT NULL COMMENT '图片数据(一维数组json)',
    `image_count` tinyint(3) NOT NULL DEFAULT '0' COMMENT '文章图片数量',
    `access_count` int(11) NOT NULL DEFAULT '0' COMMENT '访问次数',
    `is_home_recommended` tinyint(2) NOT NULL DEFAULT '0' COMMENT '是否首页推荐(0否, 1是)',
    `seo_title` char(100) NOT NULL COMMENT 'SEO标题',
    `seo_keywords` char(130) NOT NULL COMMENT 'SEO关键字',
    `seo_desc` char(230) NOT NULL COMMENT 'SEO描述',
    `upd_time` int(11) NOT NULL DEFAULT '0' COMMENT '更新时间',
    KEY `title` (`title`),
    KEY `article_category_id` (`article_category_id`),
    KEY `title_color` (`title_color`),
    KEY `jump_url` (`jump_url`),
    KEY `is_enable` (`is_enable`),
    KEY `content` (`content`),
    KEY `image` (`image`),
    KEY `image_count` (`image_count`),
    KEY `access_count` (`access_count`),
    KEY `is_home_recommended` (`is_home_recommended`),
    KEY `seo_title` (`seo_title`),
    KEY `seo_keywords` (`seo_keywords`),
    KEY `seo_desc` (`seo_desc`),
    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-14 of 14 results.
Field NameField TypeDefaultIS NULLField CommentIndexDemo Data
titlechar(60)标题Normal Index
article_category_idint(11)0文章分类Normal Index0
title_colorchar(7)标题颜色
jump_urlchar(255)跳转url地址
is_enabletinyint(1)1是否启用(0否,1是)Normal Index1
contenttext内容
imagetext图片数据(一维数组json)
image_counttinyint(3)0文章图片数量Normal Index0
access_countint(11)0访问次数Normal Index0
is_home_recommendedtinyint(2)0是否首页推荐(0否, 1是)0
seo_titlechar(100)SEO标题
seo_keywordschar(130)SEO关键字
seo_descchar(230)SEO描述
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_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_custom_view

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 ↑