MySQL Create Table SQL
Table Structure: okayapi_opms_pms_projects_test:/tablelist/okayapi_opms_pms_projects_test.html
-- MySQL Table okayapi_opms_pms_projects_test
-- From: OkayAPI.com
CREATE TABLE `okayapi_opms_pms_projects_test` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`taskid` bigint(20) NULL COMMENT '',
`needsid` bigint(20) NULL COMMENT '',
`userid` bigint(20) NULL COMMENT '创建人',
`projectid` bigint(20) NULL COMMENT '项目ID',
`acceptid` bigint(20) NULL COMMENT '任务接受人ID',
`completeid` bigint(20) NULL COMMENT '完成者uid',
`ccid` varchar(100) NULL COMMENT '抄送者',
`okayapi_opms_pms_projects_test_name` varchar(100) NULL COMMENT 'bug名称',
`okayapi_opms_pms_projects_test_desc` text NULL COMMENT '描述',
`okayapi_opms_pms_projects_test_level` tinyint(1) NULL DEFAULT '4' COMMENT '优先级1,2,3,4',
`os` varchar(20) NULL COMMENT '操作系统',
`browser` varchar(20) NULL COMMENT '浏览器',
`attachment` varchar(255) NULL COMMENT '附件',
`completed` int(10) NULL COMMENT '解决日期',
`created` int(10) NULL COMMENT '',
`okayapi_opms_pms_projects_test_changed` int(10) NULL COMMENT '',
`okayapi_opms_pms_projects_test_status` tinyint(1) NULL DEFAULT '0' COMMENT '解决方案:1设计如此,2重复Bug,3外部原因,4已解决,5无法重现,6延期处理,7不予解决',
KEY `taskid` (`taskid`),
KEY `needsid` (`needsid`),
KEY `userid` (`userid`),
KEY `projectid` (`projectid`),
KEY `acceptid` (`acceptid`),
KEY `completeid` (`completeid`),
KEY `ccid` (`ccid`),
KEY `okayapi_opms_pms_projects_test_name` (`okayapi_opms_pms_projects_test_name`),
KEY `okayapi_opms_pms_projects_test_desc` (`okayapi_opms_pms_projects_test_desc`),
KEY `okayapi_opms_pms_projects_test_level` (`okayapi_opms_pms_projects_test_level`),
KEY `os` (`os`),
KEY `browser` (`browser`),
KEY `attachment` (`attachment`),
KEY `completed` (`completed`),
KEY `created` (`created`),
KEY `okayapi_opms_pms_projects_test_changed` (`okayapi_opms_pms_projects_test_changed`),
KEY `okayapi_opms_pms_projects_test_status` (`okayapi_opms_pms_projects_test_status`),
PRIMARY KEY (`id`)
) ENGINE=InnoDB COMMENT 'OPMS和OA管理-项目任务bug表';
After replication, you can go to the database to create the database table.
MySQL database table structure design
Displaying 1-17 of 17 results.
Field Name | Field Type | Default | IS NULL | Field Comment | Index | Demo Data |
---|---|---|---|---|---|---|
taskid | bigint(20) | 是 | ||||
needsid | bigint(20) | 是 | ||||
userid | bigint(20) | 是 | 创建人 | |||
projectid | bigint(20) | 是 | 项目ID | |||
acceptid | bigint(20) | 是 | 任务接受人ID | |||
completeid | bigint(20) | 是 | 完成者uid | |||
ccid | varchar(100) | 是 | 抄送者 | |||
okayapi_opms_pms_projects_test_name | varchar(100) | 是 | bug名称 | |||
okayapi_opms_pms_projects_test_desc | text | 是 | 描述 | |||
okayapi_opms_pms_projects_test_level | tinyint(1) | 4 | 是 | 优先级1,2,3,4 | 4 | |
os | varchar(20) | 是 | 操作系统 | |||
browser | varchar(20) | 是 | 浏览器 | |||
attachment | varchar(255) | 是 | 附件 | |||
completed | int(10) | 是 | 解决日期 | |||
created | int(10) | 否 | ||||
okayapi_opms_pms_projects_test_changed | int(10) | 是 | ||||
okayapi_opms_pms_projects_test_status | tinyint(1) | 0 | 是 | 解决方案:1设计如此,2重复Bug,3外部原因,4已解决,5无法重现,6延期处理,7不予解决 | 0 |