+ Use This Table All Design

MySQL Create Table SQL

Table Structure: okayapi_lvyou_jee_article:/tablelist/okayapi_lvyou_jee_article.html


-- MySQL Table okayapi_lvyou_jee_article
-- From: OkayAPI.com
CREATE TABLE `okayapi_lvyou_jee_article` (
    `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    `publish_id` int(11) NOT NULL COMMENT '',
    `cid` int(11) NOT NULL COMMENT '',
    `title` varchar(255) NOT NULL COMMENT '',
    `pic` varchar(200) NOT NULL COMMENT '',
    `okayapi_lvyou_jee_article_type` tinyint(1) NOT NULL DEFAULT '1' COMMENT '',
    `link` varchar(255) NOT NULL COMMENT '',
    `okayapi_lvyou_jee_article_source` varchar(100) NOT NULL DEFAULT '本站' COMMENT '',
    `source_url` varchar(255) NOT NULL DEFAULT '#' COMMENT '',
    `content` text NOT NULL COMMENT '',
    `hits` int(11) NOT NULL DEFAULT '0' COMMENT '',
    `sort` int(11) NOT NULL DEFAULT '0' COMMENT '',
    `okayapi_lvyou_jee_article_status` tinyint(1) NOT NULL DEFAULT '1' COMMENT '',
    KEY `publish_id` (`publish_id`),
    KEY `cid` (`cid`),
    KEY `title` (`title`),
    KEY `pic` (`pic`),
    KEY `okayapi_lvyou_jee_article_type` (`okayapi_lvyou_jee_article_type`),
    KEY `link` (`link`),
    KEY `okayapi_lvyou_jee_article_source` (`okayapi_lvyou_jee_article_source`),
    KEY `source_url` (`source_url`),
    KEY `content` (`content`),
    KEY `hits` (`hits`),
    KEY `sort` (`sort`),
    KEY `okayapi_lvyou_jee_article_status` (`okayapi_lvyou_jee_article_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-12 of 12 results.
Field NameField TypeDefaultIS NULLField CommentIndexDemo Data
publish_idint(11)
cidint(11)
titlevarchar(255)
picvarchar(200)
okayapi_lvyou_jee_article_typetinyint(1)11
linkvarchar(255)
okayapi_lvyou_jee_article_sourcevarchar(100)本站本站
source_urlvarchar(255)##
contenttext
hitsint(11)00
sortint(11)00
okayapi_lvyou_jee_article_statustinyint(1)11

Guess You Like

MySQL Table Design okayapi_opentrip_travel_admin

MySQL Table Design okayapi_opentrip_travel_category

MySQL Table Design okayapi_opentrip_travel_order

MySQL Table Design okayapi_opentrip_travel_product

MySQL Table Design okayapi_opentrip_travel_shopcart

MySQL Table Design okayapi_opentrip_travel_user

MySQL Table Design okayapi_travel_agents

MySQL Table Design okayapi_travel_agent_users

MySQL Table Design okayapi_travel_categories

MySQL Table Design okayapi_travel_depots

MySQL Table Design okayapi_travel_depot_annuals

MySQL Table Design okayapi_travel_depot_logs

MySQL Table Design okayapi_travel_depot_staffs

MySQL Table Design okayapi_travel_depot_vouchers

MySQL Table Design okayapi_travel_devices

MySQL Table Design okayapi_travel_exist_statistics

MySQL Table Design okayapi_travel_features

MySQL Table Design okayapi_travel_groups

MySQL Table Design okayapi_travel_orders

MySQL Table Design okayapi_travel_staff_exchanges

TOP ↑