+ Use This Table All Design

MySQL Create Table SQL

Table Structure: okayapi_kite_document_field:/tablelist/okayapi_kite_document_field.html


-- MySQL Table okayapi_kite_document_field
-- From: OkayAPI.com
CREATE TABLE `okayapi_kite_document_field` (
    `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    `cid` int(11) NULL COMMENT '字段归类',
    `site_id` int(11) NULL COMMENT '模型归属站点',
    `name` varchar(64) NULL COMMENT '字段名称',
    `variable` varchar(64) NULL COMMENT '字段列名',
    `type` char(20) NULL COMMENT '字段类型',
    `sort` int(11) NULL DEFAULT '0' COMMENT '权重排序',
    `is_require` tinyint(1) NULL DEFAULT '0' COMMENT '0 正常 1必填',
    `is_filter` tinyint(1) NULL COMMENT '0正常 1筛选条件',
    `option` varchar(255) NULL COMMENT '字段内容选项',
    `description` varchar(255) NULL COMMENT '描述',
    `regular` varchar(255) NULL COMMENT '正则表达式',
    `msg` varchar(255) NULL COMMENT '验证失败提示语',
    `create_at` int(11) NULL COMMENT '创建时间',
    `update_at` int(11) NULL COMMENT '更新时间',
    KEY `cid` (`cid`),
    KEY `site_id` (`site_id`),
    KEY `name` (`name`),
    KEY `variable` (`variable`),
    KEY `type` (`type`),
    KEY `sort` (`sort`),
    KEY `is_require` (`is_require`),
    KEY `is_filter` (`is_filter`),
    KEY `option` (`option`),
    KEY `description` (`description`),
    KEY `regular` (`regular`),
    KEY `msg` (`msg`),
    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
cidint(11)字段归类
site_idint(11)模型归属站点
namevarchar(64)字段名称
variablevarchar(64)字段列名
typechar(20)字段类型
sortint(11)0权重排序0
is_requiretinyint(1)00 正常 1必填0
is_filtertinyint(1)0正常 1筛选条件
optionvarchar(255)字段内容选项
descriptionvarchar(255)描述
regularvarchar(255)正则表达式
msgvarchar(255)验证失败提示语
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_category

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_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 ↑