class casePrecondition(mysqlpool.Model): __tablename__ = "casePrecondition" # 定义column id = mysqlpool.Column( name="id", type_=INTEGER, autoincrement=True, nullable=False, unique=True, primary_key=True ) content = mysqlpool.Column( name="content", type_=TEXT(1000), nullable=True ) caseId = mysqlpool.Column( name="caseId", type_=TINYINT(4), nullable=False ) createTime = mysqlpool.Column( name="createTime", type_=DATETIME, nullable=False, default=datetime.datetime.now ) updateTime = mysqlpool.Column( name="updateTime", type_=DATETIME, nullable=False, default=datetime.datetime.now )
class TableSnap(mysqlpool.Model): __tablename__ = "tableSnap" # 定义column id = mysqlpool.Column( name="id", type_=INTEGER, autoincrement=True, nullable=False, unique=True, primary_key=True ) status = mysqlpool.Column( name="status", type_=TINYINT, nullable=False ) snapAddTime = mysqlpool.Column( name="snapAddTime", type_=DATETIME, nullable=False ) planId = mysqlpool.Column( name="planId", type_=INTEGER, nullable=False ) table = mysqlpool.Column( name="table", type_=MEDIUMTEXT, nullable=True )
class subject(mysqlpool.Model): __tablename__ = "subject" # 定义column subjectId = mysqlpool.Column(name="subjectId", type_=INTEGER, autoincrement=True, nullable=False, unique=True, primary_key=True) userId = mysqlpool.Column(name="userId", type_=INTEGER, nullable=False) subjectStatus = mysqlpool.Column(name="subjectStatus", type_=TINYINT(4), nullable=False) subjectOpenLevel = mysqlpool.Column(name="subjectOpenLevel", type_=TINYINT(4), nullable=False) subjectName = mysqlpool.Column(name="subjectName", type_=VARCHAR(50), nullable=False) subjectDescription = mysqlpool.Column(name="subjectDescription", type_=TEXT, nullable=True) subjectLogoPath = mysqlpool.Column(name="subjectLogoPath", type_=TEXT, nullable=True) subjectCreateTime = mysqlpool.Column(name="subjectCreateTime", type_=DATETIME, nullable=False, default=datetime.datetime.now) subjectUpdateTime = mysqlpool.Column(name="subjectUpdateTime", type_=DATETIME, nullable=False, default=datetime.datetime.now, onupdate=datetime.datetime.now)
class subjectCaseStep(mysqlpool.Model): __tablename__ = "subjectCaseStep" # 定义column stepId = mysqlpool.Column(name="stepId", type_=INTEGER, autoincrement=True, nullable=False, unique=True, primary_key=True) caseId = mysqlpool.Column(name="caseId", type_=INTEGER, nullable=False) catalogueId = mysqlpool.Column(name="catalogueId", type_=INTEGER, nullable=False) subjectId = mysqlpool.Column(name="subjectId", type_=INTEGER, nullable=False) sequence = mysqlpool.Column(name="sequence", type_=INTEGER, nullable=False) stepContent = mysqlpool.Column(name="stepContent", type_=VARCHAR(255), nullable=False) stepExpectation = mysqlpool.Column(name="stepExpectation", type_=VARCHAR(255), nullable=False) stepCreateTime = mysqlpool.Column(name="stepCreateTime", type_=DATETIME, nullable=False, default=datetime.datetime.now) setpUpdateTime = mysqlpool.Column(name="setpUpdateTime", type_=DATETIME, nullable=False, default=datetime.datetime.now, onupdate=datetime.datetime.now)
class TaskAssign(mysqlpool.Model): __tablename__ = "taskAssign" # 定义column assignId = mysqlpool.Column(name="assignId", type_=INTEGER, autoincrement=True, nullable=False, unique=True, primary_key=True) taskId = mysqlpool.Column(name="taskId", type_=INTEGER, nullable=False) workerId = mysqlpool.Column(name="workerId", type_=INTEGER, nullable=False) vuser = mysqlpool.Column(name="vuser", type_=INTEGER, nullable=False) status = mysqlpool.Column(name="status", type_=TINYINT, nullable=False) startTime = mysqlpool.Column(name="startTime", type_=DATETIME, nullable=True) finishTime = mysqlpool.Column(name="finishTime", type_=DATETIME, nullable=True) createTime = mysqlpool.Column(name="createTime", type_=DATETIME, nullable=False) updateTime = mysqlpool.Column(name="updateTime", type_=DATETIME, nullable=True)
class projectReviewRecord(mysqlpool.Model): __tablename__ = "projectReviewRecord" # 定义column id = mysqlpool.Column(name="id", type_=INTEGER, autoincrement=True, nullable=False, unique=True, primary_key=True) caseId = mysqlpool.Column(name="caseId", type_=TINYINT(4), nullable=False) projectId = mysqlpool.Column(name="projectId", type_=TINYINT(4), nullable=False) initiatorId = mysqlpool.Column(name="initiatorId", type_=TINYINT(4), nullable=False) reviewerId = mysqlpool.Column(name="reviewerId", type_=TINYINT(4), nullable=False) result = mysqlpool.Column(name="result", type_=TINYINT(4), nullable=False) createTime = mysqlpool.Column(name="createTime", type_=DATETIME, nullable=False, default=datetime.datetime.now) finishTime = mysqlpool.Column(name="finishTime", type_=DATETIME, nullable=True, default=datetime.datetime.now)
class projectArchivePendingCase(mysqlpool.Model): __tablename__ = "projectArchivePendingCase" # 定义column id = mysqlpool.Column(name="id", type_=INTEGER, autoincrement=True, nullable=False, unique=True, primary_key=True) projectId = mysqlpool.Column(name="projectId", type_=INTEGER, nullable=False) originalCaseId = mysqlpool.Column(name="originalCaseId", type_=TINYINT(4), nullable=False) projectIdCaseId = mysqlpool.Column(name="projectIdCaseId", type_=TINYINT(4), nullable=False) otherCaseId = mysqlpool.Column(name="otherCaseId", type_=TINYINT(4), nullable=False) status = mysqlpool.Column(name="status", type_=TINYINT(4), nullable=False) createTime = mysqlpool.Column(name="createTime", type_=DATETIME, nullable=False, default=datetime.datetime.now) updateTime = mysqlpool.Column(name="updateTime", type_=DATETIME, nullable=False, default=datetime.datetime.now, onupdate=datetime.datetime.now)
class UserOperationRecord(mysqlpool.Model): __tablename__ = "userOperationRecord" # 定义column recordId = mysqlpool.Column(name="recordId", type_=INTEGER, autoincrement=True, nullable=False, unique=True, primary_key=True) userId = mysqlpool.Column(name="userId", type_=INTEGER, nullable=False) operationId = mysqlpool.Column(name="operationId", type_=INTEGER, nullable=False) recordCode = mysqlpool.Column(name="recordCode", type_=VARCHAR(200), nullable=False) recordStatus = mysqlpool.Column(name="recordStatus", type_=TINYINT(1), nullable=False) recordValidTime = mysqlpool.Column(name="recordValidTime", type_=DATETIME, nullable=False) recordAddTime = mysqlpool.Column(name="recordAddTime", type_=DATETIME, nullable=False, default=datetime.datetime.now) recordUpdateTime = mysqlpool.Column(name="recordUpdateTime", type_=DATETIME, nullable=False, default=datetime.datetime.now, onupdate=datetime.datetime.now)
class subjectCasePrecondition(mysqlpool.Model): __tablename__ = "subjectCasePrecondition" # 定义column preconditionId = mysqlpool.Column(name="preconditionId", type_=INTEGER, autoincrement=True, nullable=False, unique=True, primary_key=True) caseId = mysqlpool.Column(name="caseId", type_=INTEGER, nullable=False) catalogueId = mysqlpool.Column(name="catalogueId", type_=INTEGER, nullable=False) subjectId = mysqlpool.Column(name="subjectId", type_=INTEGER, nullable=False) preconditionContent = mysqlpool.Column(name="preconditionContent", type_=VARCHAR(255), nullable=False) preconditionCreateTime = mysqlpool.Column(name="preconditionCreateTime", type_=DATETIME, nullable=False, default=datetime.datetime.now) preconditionUpdateTime = mysqlpool.Column(name="preconditionUpdateTime", type_=DATETIME, nullable=False, default=datetime.datetime.now, onupdate=datetime.datetime.now)
class projectMember(mysqlpool.Model): __tablename__ = "projectMember" # 定义column id = mysqlpool.Column(name="id", type_=INTEGER, autoincrement=True, nullable=False, unique=True, primary_key=True) projectId = mysqlpool.Column(name="projectId", type_=INTEGER, nullable=False) userId = mysqlpool.Column(name="userId", type_=INTEGER, nullable=False) type = mysqlpool.Column(name="type", type_=TINYINT(2), nullable=False) status = mysqlpool.Column(name="status", type_=TINYINT(2), nullable=False) createTime = mysqlpool.Column(name="createTime", type_=DATETIME, nullable=False, default=datetime.datetime.now) updateTime = mysqlpool.Column(name="updateTime", type_=DATETIME, nullable=False, default=datetime.datetime.now)
class RoleInfo(mysqlpool.Model): __tablename__ = "roleInfo" # 定义column roleId = mysqlpool.Column(name="roleId", type_=INTEGER, autoincrement=True, nullable=False, unique=True, primary_key=True) roleName = mysqlpool.Column(name="roleName", type_=VARCHAR(20), nullable=False) roleDescription = mysqlpool.Column(name="roleDescription", type_=TEXT, nullable=True) roleIsAdmin = mysqlpool.Column(name="roleIsAdmin", type_=TINYINT(1), nullable=False) roleStatus = mysqlpool.Column(name="roleStatus", type_=TINYINT(1), nullable=False) roleAddTime = mysqlpool.Column(name="roleAddTime", type_=DATETIME, nullable=False, default=datetime.datetime.now) roleUpdateTime = mysqlpool.Column(name="roleUpdateTime", type_=DATETIME, nullable=False, default=datetime.datetime.now, onupdate=datetime.datetime.now)
class caseFile(mysqlpool.Model): __tablename__ = "caseFile" # 定义column id = mysqlpool.Column(name="id", type_=INTEGER, autoincrement=True, nullable=False, unique=True, primary_key=True) caseId = mysqlpool.Column(name="caseId", type_=TINYINT(4), nullable=False) ossPath = mysqlpool.Column(name="ossPath", type_=VARCHAR(200), nullable=False) fileAlias = mysqlpool.Column(name="fileAlias", type_=VARCHAR(200), nullable=True) status = mysqlpool.Column(name="status", type_=TINYINT(4), nullable=False) userId = mysqlpool.Column(name="userId", type_=TINYINT(4), nullable=False) createTime = mysqlpool.Column(name="createTime", type_=DATETIME, nullable=False, default=datetime.datetime.now)
class OperationInfo(mysqlpool.Model): __tablename__ = "operationInfo" # 定义column operationId = mysqlpool.Column(name="operationId", type_=INTEGER, autoincrement=True, nullable=False, unique=True, primary_key=True) operationAlias = mysqlpool.Column(name="operationAlias", type_=VARCHAR(100), nullable=False) operationDescription = mysqlpool.Column(name="operationDescription", type_=TEXT, nullable=True) operationAddTime = mysqlpool.Column(name="operationAddTime", type_=DATETIME, nullable=False, default=datetime.datetime.now)
class RolePermission(mysqlpool.Model): __tablename__ = "rolePermission" # 定义column permissionId = mysqlpool.Column(name="permissionId", type_=INTEGER, autoincrement=True, nullable=False, unique=True, primary_key=True) roleId = mysqlpool.Column(name="roleId", type_=INTEGER, nullable=False) functionId = mysqlpool.Column(name="functionId", type_=INTEGER, nullable=False) hasPermission = mysqlpool.Column(name="hasPermission", type_=TINYINT(1), nullable=False) permissionAddTime = mysqlpool.Column(name="permissionAddTime", type_=DATETIME, nullable=False, default=datetime.datetime.now) permissionUpdateTime = mysqlpool.Column(name="permissionUpdateTime", type_=DATETIME, nullable=False, default=datetime.datetime.now, onupdate=datetime.datetime.now)
class FunctionOrg(mysqlpool.Model): __tablename__ = "functionOrg" # 定义column orgId = mysqlpool.Column(name="orgId", type_=INTEGER, autoincrement=True, nullable=False, unique=True, primary_key=True) functionId = mysqlpool.Column(name="functionId", type_=INTEGER, nullable=False) apiId = mysqlpool.Column(name="apiId", type_=INTEGER, nullable=False) orgStatus = mysqlpool.Column(name="orgStatus", type_=TINYINT(1), nullable=False) orgAddTime = mysqlpool.Column(name="orgAddTime", type_=DATETIME, nullable=False, default=datetime.datetime.now) orgUpdateTime = mysqlpool.Column(name="orgUpdateTime", type_=DATETIME, nullable=False, default=datetime.datetime.now, onupdate=datetime.datetime.now)
class GroupInfo(mysqlpool.Model): __tablename__ = "groupInfo" __bind_key__ = "userUi" # 定义column groupId = mysqlpool.Column(name="groupId", type_=INTEGER, autoincrement=True, nullable=False, unique=True, primary_key=True) groupName = mysqlpool.Column(name="groupName", type_=VARCHAR(100), nullable=False) groupDescription = mysqlpool.Column(name="groupDescription", type_=TEXT, nullable=True) groupStatus = mysqlpool.Column(name="groupStatus", type_=TINYINT(1), nullable=False) groupAddTime = mysqlpool.Column(name="groupAddTime", type_=DATETIME, nullable=False, default=datetime.datetime.now) groupUpdateTime = mysqlpool.Column(name="groupUpdateTime", type_=DATETIME, nullable=False, default=datetime.datetime.now, onupdate=datetime.datetime.now)
class ApiInfo(mysqlpool.Model): __tablename__ = "apiInfo" # 定义column apiId = mysqlpool.Column(name="apiId", type_=INTEGER, autoincrement=True, nullable=False, unique=True, primary_key=True) apiName = mysqlpool.Column(name="apiName", type_=VARCHAR(100), nullable=False) apiUrl = mysqlpool.Column(name="apiUrl", type_=VARCHAR(200), nullable=False) apiDescription = mysqlpool.Column(name="apiDescription", type_=TEXT, nullable=True) apiAddTime = mysqlpool.Column(name="apiAddTime", type_=DATETIME, nullable=False, default=datetime.datetime.now)
class PlanType(mysqlpool.Model): __tablename__ = "planType" # 定义column typeId = mysqlpool.Column(name="typeId", type_=INTEGER, autoincrement=True, nullable=False, unique=True, primary_key=True) typeName = mysqlpool.Column(name="typeName", type_=VARCHAR(50), nullable=False) typeDescription = mysqlpool.Column(name="typeDescription", type_=VARCHAR(200), nullable=True) typeAddTime = mysqlpool.Column(name="typeAddTime", type_=DATETIME, nullable=False, default=datetime.datetime.now) typeUpdateTime = mysqlpool.Column(name="typeUpdateTime", type_=DATETIME, nullable=False, default=datetime.datetime.now)
class depositoryProjectFiledOrg(mysqlpool.Model): __tablename__ = "depositoryProjectFiledOrg" # 定义column id = mysqlpool.Column( name="id", type_=INTEGER, autoincrement=True, nullable=False, unique=True, primary_key=True ) projectId = mysqlpool.Column( name="projectId", type_=INTEGER, nullable=False ) depositoryId = mysqlpool.Column( name="depositoryId", type_=TINYINT(4), nullable=False ) result = mysqlpool.Column( name="result", type_=TINYINT(4), nullable=False ) createTime = mysqlpool.Column( name="createTime", type_=DATETIME, nullable=False, default=datetime.datetime.now ) startTime = mysqlpool.Column( name="startTime", type_=DATETIME, nullable=False, default=datetime.datetime.now ) finishTime = mysqlpool.Column( name="finishTime", type_=DATETIME, nullable=False, default=datetime.datetime.now, onupdate=datetime.datetime.now )
class WorkerInfo(mysqlpool.Model): __tablename__ = "workerInfo" # 定义column workerId = mysqlpool.Column(name="workerId", type_=INTEGER, autoincrement=True, nullable=False, unique=True, primary_key=True) uniqueId = mysqlpool.Column(name="uniqueId", type_=VARCHAR(50), nullable=False) ip = mysqlpool.Column(name="ip", type_=VARCHAR(50), nullable=False) port = mysqlpool.Column(name="port", type_=SMALLINT, nullable=False) status = mysqlpool.Column(name="status", type_=TINYINT, nullable=False) createTime = mysqlpool.Column(name="createTime", type_=DATETIME, nullable=False) updateTime = mysqlpool.Column(name="updateTime", type_=DATETIME, nullable=True)
class caseEditLog(mysqlpool.Model): __tablename__ = "caseEditLog" # 定义column id = mysqlpool.Column(name="id", type_=INTEGER, autoincrement=True, nullable=False, unique=True, primary_key=True) caseId = mysqlpool.Column(name="caseId", type_=TINYINT(4), nullable=False) type = mysqlpool.Column(name="type", type_=TINYINT(4), nullable=False) before = mysqlpool.Column(name="before", type_=TEXT(1000), nullable=True) after = mysqlpool.Column(name="after", type_=TEXT(1000), nullable=True) createTime = mysqlpool.Column(name="createTime", type_=DATETIME, nullable=False, default=datetime.datetime.now)
class subjectCaseCatalogue(mysqlpool.Model): __tablename__ = "subjectCaseCatalogue" # 定义column catalogueId = mysqlpool.Column( name="catalogueId", type_=INTEGER, autoincrement=True, nullable=False, unique=True, primary_key=True ) catalogueName = mysqlpool.Column( name="catalogueName", type_=VARCHAR(255), nullable=False ) subjectId = mysqlpool.Column( name="subjectId", type_=INTEGER, nullable=False ) catalogueStatus = mysqlpool.Column( name="catalogueStatus", type_=TINYINT(4), nullable=False ) catalogueCreateTime = mysqlpool.Column( name="catalogueCreateTime", type_=DATETIME, nullable=False, default=datetime.datetime.now ) catalogueUpdateTime = mysqlpool.Column( name="catalogueUpdateTime", type_=DATETIME, nullable=False, default=datetime.datetime.now, onupdate=datetime.datetime.now )
class depository(mysqlpool.Model): __tablename__ = "depository" # 定义column id = mysqlpool.Column(name="id", type_=INTEGER, autoincrement=True, nullable=False, unique=True, primary_key=True) baseProjectId = mysqlpool.Column(name="baseProjectId", type_=INTEGER, nullable=False) userId = mysqlpool.Column(name="userId", type_=TINYINT(4), nullable=False) name = mysqlpool.Column(name="name", type_=VARCHAR(50), nullable=False) description = mysqlpool.Column(name="description", type_=VARCHAR(250), nullable=True) createTime = mysqlpool.Column(name="createTime", type_=DATETIME, nullable=False, default=datetime.datetime.now)
class UserOrg(mysqlpool.Model): __tablename__ = "userOrg" __bind_key__ = "userUi" # 定义column orgId = mysqlpool.Column(name="orgId", type_=INTEGER, autoincrement=True, nullable=False, unique=True, primary_key=True) userId = mysqlpool.Column(name="userId", type_=INTEGER, nullable=False) groupId = mysqlpool.Column(name="groupId", type_=INTEGER, nullable=False) orgStatus = mysqlpool.Column(name="orgStatus", type_=TINYINT(1), nullable=False) orgAddTime = mysqlpool.Column(name="orgAddTime", type_=DATETIME, nullable=False, default=datetime.datetime.now) orgUpdateTime = mysqlpool.Column(name="orgAddTime", type_=DATETIME, nullable=False, default=datetime.datetime.now, onupdate=datetime.datetime.now)
class TaskInfo(mysqlpool.Model): __tablename__ = "taskInfo" # 定义column taskId = mysqlpool.Column(name="taskId", type_=INTEGER, autoincrement=True, nullable=False, unique=True, primary_key=True) planId = mysqlpool.Column(name="planId", type_=INTEGER, nullable=False) snap = mysqlpool.Column(name="snap", type_=MEDIUMTEXT, nullable=False) taskType = mysqlpool.Column(name="taskType", type_=TINYINT, nullable=False) taskDescription = mysqlpool.Column(name="taskDescription", type_=VARCHAR(200), nullable=True) startTime = mysqlpool.Column(name="startTime", type_=DATETIME, nullable=True) endTime = mysqlpool.Column(name="endTime", type_=DATETIME, nullable=True) startType = mysqlpool.Column(name="startType", type_=TINYINT, nullable=False) endType = mysqlpool.Column(name="endType", type_=TINYINT, nullable=False) excuteTimes = mysqlpool.Column(name="excuteTimes", type_=INTEGER, nullable=True) errorType = mysqlpool.Column(name="errorType", type_=TINYINT, nullable=False) createTime = mysqlpool.Column(name="createTime", type_=DATETIME, nullable=False) createUser = mysqlpool.Column(name="createUser", type_=INTEGER, nullable=False) vUser = mysqlpool.Column(name="vUser", type_=INTEGER, nullable=False) rampUpPeriod = mysqlpool.Column(name="rampUpPeriod", type_=INTEGER, nullable=False)
class Case(mysqlpool.Model): __tablename__ = "case" # 定义column id = mysqlpool.Column(name="id", type_=INTEGER, autoincrement=True, nullable=False, unique=True, primary_key=True) title = mysqlpool.Column(name="title", type_=VARCHAR(200), nullable=False) depositoryId = mysqlpool.Column(name="depositoryId", type_=INTEGER, nullable=False) projectId = mysqlpool.Column(name="projectId", type_=INTEGER, nullable=True) columnId = mysqlpool.Column(name="columnId", type_=INTEGER, nullable=False) index = mysqlpool.Column(name="index", type_=INTEGER, nullable=False) columnLevel = mysqlpool.Column(name="columnLevel", type_=INTEGER, nullable=False) level = mysqlpool.Column(name="level", type_=TINYINT(2), nullable=False) type = mysqlpool.Column(name="type", type_=TINYINT(2), nullable=False) status = mysqlpool.Column(name="status", type_=TINYINT(2), nullable=False) userId = mysqlpool.Column(name="userId", type_=INTEGER, nullable=False) createTime = mysqlpool.Column(name="createTime", type_=DATETIME, nullable=False, default=datetime.datetime.now) updateUserId = mysqlpool.Column(name="updateUserId", type_=INTEGER, nullable=True) updateTime = mysqlpool.Column(name="updateTime", type_=DATETIME, nullable=True, default=datetime.datetime.now) veri = mysqlpool.Column(name="veri", type_=TINYINT(4), nullable=True) arch = mysqlpool.Column(name="arch", type_=TINYINT(4), nullable=True) originalCaseId = mysqlpool.Column( name="originalCaseId", type_=INTEGER, nullable=False, )
class UserInfo(mysqlpool.Model): __tablename__ = "userInfo" # 定义column userId = mysqlpool.Column( name="userId", type_=INTEGER, autoincrement=True, nullable=False, unique=True, primary_key=True ) userLoginName = mysqlpool.Column( name="userLoginName", type_=VARCHAR(100), unique=True, nullable=True ) userNickName = mysqlpool.Column( name="userNickName", type_=VARCHAR(100), nullable=True ) userEmail = mysqlpool.Column( name="userEmail", type_=VARCHAR(100), nullable=True ) userPassword = mysqlpool.Column( name="userPassword", type_=VARCHAR(100), nullable=True ) userStatus = mysqlpool.Column( name="userStatus", type_=TINYINT(1), nullable=False ) userRoleId = mysqlpool.Column( name="userRoleId", type_=INTEGER, nullable=True ) userIntroduction = mysqlpool.Column( name="userIntroduction", type_=VARCHAR(200), nullable=True ) userAddTime = mysqlpool.Column( name="userAddTime", type_=DATETIME, nullable=False, default=datetime.datetime.now ) userRegisterTime = mysqlpool.Column( name="userRegisterTime", type_=DATETIME, nullable=True ) userUpdateTime = mysqlpool.Column( name="userUpdateTime", type_=DATETIME, nullable=False, default=datetime.datetime.now, onupdate=datetime.datetime.now ) userNewEmail = mysqlpool.Column( name="userNewEmail", type_=VARCHAR(100), nullable=True ) userHeadIconUrl = mysqlpool.Column( name="userHeadIconUrl", type_=VARCHAR(200), nullable=True )
class PlanInfo(mysqlpool.Model): __tablename__ = "planInfo" # 定义column planId = mysqlpool.Column(name="planId", type_=INTEGER, autoincrement=True, nullable=False, unique=True, primary_key=True) ownerId = mysqlpool.Column(name="ownerId", type_=INTEGER, nullable=False) planType = mysqlpool.Column(name="planType", type_=TINYINT, nullable=False) planTitle = mysqlpool.Column(name="planTitle", type_=VARCHAR(50), nullable=False) planDescription = mysqlpool.Column(name="planDescription", type_=VARCHAR(200), nullable=True) planOpenLevel = mysqlpool.Column(name="planOpenLevel", type_=TINYINT, nullable=False) planOwnerType = mysqlpool.Column(name="planOwnerType", type_=TINYINT, nullable=False) forkFrom = mysqlpool.Column(name="forkFrom", type_=INTEGER, nullable=True) planAddTime = mysqlpool.Column(name="planAddTime", type_=DATETIME, nullable=False, default=datetime.datetime.now) planUpdateTime = mysqlpool.Column(name="planUpdateTime", type_=DATETIME, nullable=False, default=datetime.datetime.now) status = mysqlpool.Column(name="status", type_=TINYINT, nullable=False, default=1)