+ Use This Table All Design

MySQL Create Table SQL

Table Structure: okayapi_kite_document_category:/tablelist/okayapi_kite_document_category.html


-- MySQL Table okayapi_kite_document_category
-- From: OkayAPI.com
CREATE TABLE `okayapi_kite_document_category` (
    `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    `pid` int(11) NULL DEFAULT '0' COMMENT '上级父ID',
    `site_id` int(11) NULL COMMENT '模型归属站点',
    `model_id` int(11) NULL COMMENT '模型ID',
    `sort` int(11) NULL DEFAULT '0' COMMENT '权重排序',
    `title` varchar(64) NULL COMMENT '文档标题',
    `keywords` varchar(255) NULL COMMENT '文档关键词',
    `description` varchar(255) NULL COMMENT '描述',
    `content` text NULL COMMENT '文档内容',
    `list_rows` int(11) NULL DEFAULT '10' COMMENT '列表显示条数',
    `list_tpl` varchar(255) NULL COMMENT '栏目模板',
    `detail_tpl` varchar(255) NULL COMMENT '内容模板',
    `status` tinyint(1) NULL DEFAULT '0' COMMENT '0 隐藏 1 显示',
    `create_at` int(11) NULL COMMENT '创建时间',
    `update_at` int(11) NULL COMMENT '更新时间',
    KEY `pid` (`pid`),
    KEY `site_id` (`site_id`),
    KEY `model_id` (`model_id`),
    KEY `sort` (`sort`),
    KEY `title` (`title`),
    KEY `keywords` (`keywords`),
    KEY `description` (`description`),
    KEY `content` (`content`),
    KEY `list_rows` (`list_rows`),
    KEY `list_tpl` (`list_tpl`),
    KEY `detail_tpl` (`detail_tpl`),
    KEY `status` (`status`),
    KEY `create_at` (`create_at`),
    KEY `update_at` (`update_at`),
    PRIMARY KEY (`id`)
) ENGINE=InnoDB COMMENT '建站系统-档案目录表';

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
pidint(11)0上级父ID0
site_idint(11)模型归属站点
model_idint(11)模型ID
sortint(11)0权重排序0
titlevarchar(64)文档标题
keywordsvarchar(255)文档关键词
descriptionvarchar(255)描述
contenttext文档内容
list_rowsint(11)10列表显示条数10
list_tplvarchar(255)栏目模板
detail_tplvarchar(255)内容模板
statustinyint(1)00 隐藏 1 显示0
create_atint(11)创建时间
update_atint(11)更新时间

Guess You Like

MySQL Table Design okayapi_kite_addons

MySQL Table Design okayapi_kite_auth_role

MySQL Table Design okayapi_kite_auth_rule

MySQL Table Design okayapi_kite_auth_user

MySQL Table Design okayapi_kite_block

MySQL Table Design okayapi_kite_document_comments

MySQL Table Design okayapi_kite_document_comments_like

MySQL Table Design okayapi_kite_document_content

MySQL Table Design okayapi_kite_document_content_extra

MySQL Table Design okayapi_kite_document_content_like

MySQL Table Design okayapi_kite_document_field

MySQL Table Design okayapi_kite_document_model

MySQL Table Design okayapi_kite_document_model_field

MySQL Table Design okayapi_kite_feedback

MySQL Table Design okayapi_kite_hooks

MySQL Table Design okayapi_kite_language

MySQL Table Design okayapi_kite_link

MySQL Table Design okayapi_kite_log

MySQL Table Design okayapi_kite_message

MySQL Table Design okayapi_kite_navigation

TOP ↑