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)
