okayapi_f_sample_task - MySQ Table Design

MySQL Create Table SQL

Table Structure: okayapi_f_sample_task：/tablelist/okayapi_f_sample_task.html


-- MySQL Table okayapi_f_sample_task
-- From: OkayAPI.com
CREATE TABLE `okayapi_f_sample_task` (
    `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    `title` varchar(64) NULL COMMENT '标题',
    `content` varchar(256) NULL COMMENT '内容',
    `okayapi_f_sample_task_level` varchar(64) NULL COMMENT '等级',
    `user_id` bigint(20) NULL COMMENT '创建人',
    `create_time` datetime NULL COMMENT '创建时间',
    KEY `title` (`title`),
    KEY `content` (`content`),
    KEY `okayapi_f_sample_task_level` (`okayapi_f_sample_task_level`),
    KEY `user_id` (`user_id`),
    KEY `create_time` (`create_time`),
    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-5 of 5 results.

Field Name	Field Type	IS NULL	Field Comment	Index
title	varchar(64)	否	标题
content	varchar(256)	是	内容
okayapi_f_sample_task_level	varchar(64)	否	等级
user_id	bigint(20)	否	创建人	Normal Index
create_time	datetime	是	创建时间