基本字段

ALTER TABLE bt_bs_pm.pm_project_info ADD IS_ENABLED int DEFAULT 1 NULL COMMENT '启用';
ALTER TABLE bt_bs_pm.pm_project_info ADD APP_ID varchar(36) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT '' NULL COMMENT '所属应用';
ALTER TABLE bt_bs_pm.pm_project_info ADD TENANT_ID varchar(36) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT '' NULL COMMENT '所属租户';
ALTER TABLE bt_bs_pm.pm_project_info ADD SYS_ID varchar(1800) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT '' NULL COMMENT '系统ID，关联  BO_SYSTEM';

ALTER TABLE bt_bs_pm.pm_project_info ADD CREATE_TIME datetime DEFAULT CURRENT_TIMESTAMP  NULL COMMENT '新增时间';
ALTER TABLE bt_bs_pm.pm_project_info ADD MODIFY_TIME datetime DEFAULT CURRENT_TIMESTAMP  NULL COMMENT '修改时间';
ALTER TABLE bt_bs_pm.pm_project_info ADD CREATE_USER_ID varchar(36) CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '创建用户';
ALTER TABLE bt_bs_pm.pm_project_info ADD MODIFY_USER_ID varchar(36) CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '修改用户';

ALTER TABLE bt_bs_pm.pm_project_info ADD AUDIT_TIME datetime DEFAULT CURRENT_TIMESTAMP  NULL COMMENT '审核时间';
ALTER TABLE bt_bs_pm.pm_project_info ADD AUDIT_STATUS int DEFAULT 0 NULL COMMENT '审核状态  0=停用，1=正常（审核通过） 2=待审核 3=驳回';
ALTER TABLE bt_bs_pm.pm_project_info ADD AUDIT_USER_ID varchar(36) CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '审核用户';
ALTER TABLE bt_bs_pm.pm_project_info ADD AUDIT_OPINION varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT '' NULL COMMENT '审核意见';