MySQL Create Table SQL
Table Structure: okayapi_opms_pms_projects:/tablelist/okayapi_opms_pms_projects.html
-- MySQL Table okayapi_opms_pms_projects
-- From: OkayAPI.com
CREATE TABLE `okayapi_opms_pms_projects` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`userid` bigint(20) NULL COMMENT '创建人',
`okayapi_opms_pms_projects_name` varchar(100) NULL COMMENT '项目名称',
`aliasname` varchar(100) NULL COMMENT '项目别名代号',
`started` int(10) NULL COMMENT '开始时间',
`ended` int(10) NULL COMMENT '结束时间',
`okayapi_opms_pms_projects_desc` text NULL COMMENT '描述',
`created` int(10) NULL COMMENT '添加日期',
`okayapi_opms_pms_projects_status` tinyint(1) NULL DEFAULT '1' COMMENT '1挂起中,2延期中,3进行中,4结束',
`projuserid` bigint(20) NULL COMMENT '项目负责人',
`produserid` bigint(20) NULL COMMENT '产品负责人',
`testuserid` bigint(20) NULL COMMENT '测试负责人',
`publuserid` bigint(20) NULL COMMENT '发布负责人',
KEY `userid` (`userid`),
KEY `okayapi_opms_pms_projects_name` (`okayapi_opms_pms_projects_name`),
KEY `aliasname` (`aliasname`),
KEY `started` (`started`),
KEY `ended` (`ended`),
KEY `okayapi_opms_pms_projects_desc` (`okayapi_opms_pms_projects_desc`),
KEY `created` (`created`),
KEY `okayapi_opms_pms_projects_status` (`okayapi_opms_pms_projects_status`),
KEY `projuserid` (`projuserid`),
KEY `produserid` (`produserid`),
KEY `testuserid` (`testuserid`),
KEY `publuserid` (`publuserid`),
PRIMARY KEY (`id`)
) ENGINE=InnoDB COMMENT 'OPMS和OA管理-项目表';
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 Name | Field Type | Default | IS NULL | Field Comment | Index | Demo Data |
---|---|---|---|---|---|---|
userid | bigint(20) | 是 | 创建人 | |||
okayapi_opms_pms_projects_name | varchar(100) | 是 | 项目名称 | |||
aliasname | varchar(100) | 是 | 项目别名代号 | |||
started | int(10) | 是 | 开始时间 | |||
ended | int(10) | 是 | 结束时间 | |||
okayapi_opms_pms_projects_desc | text | 是 | 描述 | |||
created | int(10) | 是 | 添加日期 | |||
okayapi_opms_pms_projects_status | tinyint(1) | 1 | 是 | 1挂起中,2延期中,3进行中,4结束 | 1 | |
projuserid | bigint(20) | 是 | 项目负责人 | |||
produserid | bigint(20) | 是 | 产品负责人 | |||
testuserid | bigint(20) | 是 | 测试负责人 | |||
publuserid | bigint(20) | 是 | 发布负责人 |