okayapi_zheng_upms_organization - MySQ Table Design

MySQL Create Table SQL

Table Structure: okayapi_zheng_upms_organization：/tablelist/okayapi_zheng_upms_organization.html


-- MySQL Table okayapi_zheng_upms_organization
-- From: OkayAPI.com
CREATE TABLE `okayapi_zheng_upms_organization` (
    `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    `pid` int(10) NULL COMMENT '所属上级',
    `okayapi_zheng_upms_organization_name` varchar(20) NULL COMMENT '组织名称',
    `description` varchar(1000) NULL COMMENT '组织描述',
    `ctime` bigint(20) NULL COMMENT '创建时间',
    KEY `pid` (`pid`),
    KEY `okayapi_zheng_upms_organization_name` (`okayapi_zheng_upms_organization_name`),
    KEY `description` (`description`),
    KEY `ctime` (`ctime`),
    PRIMARY KEY (`id`)
) ENGINE=InnoDB COMMENT 'zheng敏捷开发-组织';

After replication, you can go to the database to create the database table.

MySQL database table structure design

Displaying 1-4 of 4 results.

Field Name	Field Type	IS NULL	Field Comment
pid	int(10)	是	所属上级
okayapi_zheng_upms_organization_name	varchar(20)	是	组织名称
description	varchar(1000)	是	组织描述
ctime	bigint(20)	是	创建时间