class Course(db.Model): id = db.Column(BIGINT(20, unsigned=True), nullable=False, primary_key=True) serial_no = db.Column(VARCHAR(16), nullable=False) course_name = db.Column(VARCHAR(128), nullable=False) teacher_id = db.Column(VARCHAR(64), nullable=False) used = db.Column(BIGINT(20, unsigned=True), nullable=False) capacity = db.Column(BIGINT(20, unsigned=True), nullable=False) course_time = db.Column(VARCHAR(64), nullable=False) course_length = db.Column(BIGINT(20, unsigned=True), nullable=False) course_exam_time = db.Column(VARCHAR(64), nullable=False) course_position = db.Column(VARCHAR(64), nullable=False) major = db.Column(VARCHAR(64), nullable=False) credit = db.Column(BIGINT(20, unsigned=True), nullable=False) chosen_true = db.Column(BIGINT(20, unsigned=True), nullable=False) chosen_false = db.Column(BIGINT(20, unsigned=True), nullable=False) def __init__(self, id, serial_no, course_name, teacher_id, used, capacity, course_time, course_length, course_exam_time, course_position, major, credit, chosen_true, chosen_false): self.id = id self.serial_no = serial_no self.course_name = course_name self.teacher_id = teacher_id self.used = used self.capacity = capacity self.course_time = course_time self.course_length = course_length self.course_exam_time = course_exam_time self.course_position = course_position self.major = major self.credit = credit self.chosen_true = chosen_true self.chosen_false = chosen_false
class DriverDevices(BASE):
"""Class defining the mdl_driversdevices table of the database."""
__tablename__ = 'mdl_driversdevices'
__table_args__ = (UniqueConstraint('id_driverdevice'), {
'mysql_engine': 'InnoDB'
})
idx_driverdevice = Column(BIGINT(unsigned=True),
primary_key=True,
autoincrement=True,
nullable=False)
idx_driver = Column(BIGINT(unsigned=True),
ForeignKey('mdl_drivers.idx_driver'),
nullable=False,
server_default='1')
idx_route = Column(BIGINT(unsigned=True),
ForeignKey('mdl_routes.idx_route'),
nullable=False,
server_default='1')
idx_devicemodel = Column(BIGINT(unsigned=True),
ForeignKey('mdl_devicemodels.idx_devicemodel'),
nullable=False,
server_default='1')
idx_creditcard = Column(BIGINT(unsigned=True),
ForeignKey('mdl_creditcards.idx_creditcard'),
nullable=False,
server_default='1')
id_driverdevice = Column(VARBINARY(512), nullable=True, default=None)
serial_driverdevice = Column(VARBINARY(50), nullable=True, default=None)
enabled = Column(INTEGER(unsigned=True), server_default='1')
ts_modified = Column(
DATETIME,
server_default=text('CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP'),
)
ts_created = Column(DATETIME, server_default=text('CURRENT_TIMESTAMP'))
class Article(Base):
__tablename__ = 'article'
id = Column(BIGINT(20), primary_key=True)
category_id = Column(BIGINT(20), comment='文章分类ID')
lang = Column(
String(10),
server_default=text("'cn'"),
comment=
'默认语言：cn zh-CN中文(简体) id d-ID 印度尼西亚语 en en-US 英语(美国) en-PH 英语(菲律宾)')
user_id = Column(BIGINT(20),
nullable=False,
server_default=text("'0'"),
comment='发布用户')
title = Column(String(80),
nullable=False,
server_default=text("''"),
comment='文章标题')
author = Column(String(20),
nullable=False,
server_default=text("''"),
comment='作者')
source = Column(String(20),
nullable=False,
server_default=text("''"),
comment='来源')
external_url = Column(String(255),
nullable=False,
server_default=text("''"),
comment='外链地址')
thumb = Column(String(255),
nullable=False,
server_default=text("''"),
comment='缩略图')
keyword = Column(String(255),
nullable=False,
server_default=text("''"),
comment='SEO关键词')
description = Column(String(255),
nullable=False,
server_default=text("''"),
comment='文章摘要 SEO描述')
publish_date = Column(BIGINT(13),
nullable=False,
comment='发布日期Unix时间戳毫秒单位')
hits = Column(BIGINT(20), server_default=text("'0'"), comment='点击数量')
content = Column(LONGTEXT, comment='文章内容（如果是产品的话，为json格式数据）')
ip = Column(String(40), comment='添加记录的IP地址')
updated_at = Column(BIGINT(13),
nullable=False,
server_default=text("'0'"),
comment='更新记录Unix时间戳毫秒单位')
created_at = Column(BIGINT(13),
nullable=False,
server_default=text("'0'"),
comment='创建记录Unix时间戳毫秒单位')
status = Column(TINYINT(1),
nullable=False,
server_default=text("'1'"),
comment='状态:( 0 禁用；1 启用, 默认1)')
class Drivers(BASE):
"""Class defining the mdl_drivers table of the database."""
__tablename__ = 'mdl_drivers'
__table_args__ = ({'mysql_engine': 'InnoDB'})
idx_driver = Column(BIGINT(unsigned=True),
primary_key=True,
autoincrement=True,
nullable=False)
idx_drivercompany = Column(
BIGINT(unsigned=True),
ForeignKey('mdl_drivercompanies.idx_drivercompany'),
nullable=False,
server_default='1')
idx_address = Column(BIGINT(unsigned=True),
ForeignKey('mdl_addresses.idx_address'),
nullable=False,
server_default='1')
idx_billaddress = Column(BIGINT(unsigned=True),
ForeignKey('mdl_billaddresses.idx_billaddress'),
nullable=False,
server_default='1')
first_name = Column(VARBINARY(50), nullable=True, default=None)
last_name = Column(VARBINARY(50), nullable=True, default=None)
password = Column(VARBINARY(512), nullable=True, default=None)
rating_value = Column(FLOAT, server_default='0')
off_duty = Column(INTEGER(unsigned=True), server_default='0')
enabled = Column(INTEGER(unsigned=True), server_default='1')
ts_modified = Column(
DATETIME,
server_default=text('CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP'),
)
ts_created = Column(DATETIME, server_default=text('CURRENT_TIMESTAMP'))
class TableGrantGroupMember(global_db.DB_BASE_AUTH):
__tablename__ = "r_user_group"
groupId = Column(BIGINT(unsigned=True), nullable=False, primary_key=True)
userUin = Column(BIGINT(unsigned=True), nullable=False, primary_key=True)
addTime = Column(DateTime, nullable=False)
def __init__(self, groupId, userUin, addTime):
self.groupId = groupId
self.userUin = userUin
self.addTime = addTime
def to_json(self):
return {
"groupId": self.groupId,
"userUin": self.userUin,
"addTime": str(self.addTime)
}
class BillCoin(Base):
__tablename__ = 'bill_coin'
id = Column(BIGINT(20), primary_key=True)
timestamp = Column(BIGINT(20), server_default=text("'0'"), comment='time')
userid = Column(VARCHAR(32))
type = Column(INTEGER(11), server_default=text("'0'"), comment='1、充币 2、提币 3、购买基金 4、取出本金、5、收益转入')
coin = Column(Float(20, True), server_default=text("'0'"), comment='数量')
usdt = Column(Float(20, True), server_default=text("'0.000000'"), comment='usdt 数量')
fee = Column(Float(20, True), server_default=text("'0.000000'"), comment='手续费')
price = Column(Float(20, True), server_default=text("'0'"), comment='当时价格')
ordernum = Column(String(32))
fromaccount = Column(String(42))
toaccount = Column(String(42))
txhash = Column(String(66))
status = Column(TINYINT(1), comment='0待审核，1已审核，2已转账，3取消')
checkedtime = Column(BIGINT(20))
sendtime = Column(BIGINT(20))
class User(Base):
__tablename__ = 'user'
name = Column(String(20), comment='username ')
phone = Column(String(32), nullable=False, comment='phone number')
email = Column(String(32), comment='email address')
password = Column(String(64), comment='md5 of password')
code = Column(String(10), comment='invitation code')
mycode = Column(String(10), comment='my invitation code')
id = Column(INTEGER(11), primary_key=True)
paypassword = Column(String(64), comment='pay password')
status = Column(TINYINT(4), comment='account status')
registertime = Column(BIGINT(20), comment='register time')
countryCode = Column(String(8))
signtime = Column(BIGINT(20))
locked = Column(TINYINT(4),
server_default=text("'0'"),
comment='用户是否被锁定，锁定用户无法提现及转让')
class AlarmAll(Base):
__tablename__ = 'alarm_all'
id = Column(BIGINT(20), primary_key=True)
source_id = Column(BIGINT(20))
event_id = Column(BIGINT(20))
flow_type = Column(VARCHAR(32))
md5 = Column(VARCHAR(1024))
hit_information = Column(VARCHAR(1024))
attachment_detail = Column(LONGTEXT)
alarm_detail = Column(LONGTEXT)
last_alarm_time = Column(DATETIME)
finish_time = Column(DATETIME)
finished = Column(TINYINT)
d_time = Column(DATETIME)
remark = Column(LONGTEXT)
title = Column(LONGTEXT)
establish_time = Column(DATETIME)
class UserOperationLog(Base):
__tablename__ = 'user_operation_log'
id = Column(BIGINT(20), primary_key=True, comment='主键')
user_id = Column(BIGINT(20),
nullable=False,
server_default=text("'0'"),
comment='用户唯一标识')
account = Column(String(40),
nullable=False,
server_default=text("''"),
comment='用户账号： email or mobile or username')
action = Column(
String(20),
comment='会员操作类型： email_reset_pwd mobile_reset_pwd activate_email')
ip = Column(String(40), comment='登录IP')
client = Column(String(20), comment='客户端：web wechat android ios ')
created_at = Column(BIGINT(13), comment='创建记录UTC时间')
class Mute(Base):
__tablename__ = 'mutes'
id = Column(Integer, primary_key=True)
server_id = Column(BIGINT(unsigned=True))
muted_id = Column(Integer)
muter_id = Column(Integer)
channel_id = Column(Integer)
expiration_time = Column(DateTime)
class Tritiumsampleryear(Base):
__tablename__ = 'tritiumsampleryear'
recordId = db.Column(INTEGER(11), primary_key=True)
At = db.Column(BIGINT(20))
stationId = db.Column(db.String(50))
Avg = db.Column(db.Float)
Max = db.Column(db.Float)
Min = db.Column(db.Float)
class Largeasday(Base):
__tablename__ = 'largeasday'
recordId = db.Column(INTEGER(11), primary_key=True)
At = db.Column(BIGINT(20))
stationId = db.Column(db.String(50))
Avg = db.Column(db.Float)
Max = db.Column(db.Float)
Min = db.Column(db.Float)
class Naidoseraterecordyear(Base):
__tablename__ = 'naidoseraterecordyear'
recordId = db.Column(INTEGER(11), primary_key=True)
At = db.Column(BIGINT(20))
stationId = db.Column(db.String(50))
Avg = db.Column(db.Float)
Max = db.Column(db.Float)
Min = db.Column(db.Float)
class Iodinesampler5m(Base):
__tablename__ = 'iodinesampler5m'
recordId = db.Column(INTEGER(11), primary_key=True)
At = db.Column(BIGINT(20))
stationId = db.Column(db.String(50))
Avg = db.Column(db.Float)
Max = db.Column(db.Float)
Min = db.Column(db.Float)
class Hpicrecord1h(Base):
__tablename__ = 'hpicrecord1h'
recordId = db.Column(INTEGER(11), primary_key=True)
At = db.Column(BIGINT(20))
stationId = db.Column(db.String(50))
Avg = db.Column(db.Float)
Max = db.Column(db.Float)
Min = db.Column(db.Float)
class TProFile(Base):
__tablename__ = 't_pro_file'
id = Column(BIGINT(20), primary_key=True)
pro_code = Column(ForeignKey('t_project.id'), index=True, comment='外键:引用项目表t_project(id)')
f_id = Column(ForeignKey('t_program_file.id'), index=True, comment='外键:引用程序文件表t_program_file(id)')
f = relationship('TProgramFile')
t_project = relationship('TProject')
class Result(db.Model, MySQLMixin):
id = db.Column(BIGINT(unsigned=True), primary_key=True)
project_id = db.Column(BIGINT(unsigned=True))
flag = db.Column(VARCHAR(1))
socket = db.Column(VARCHAR(5))
process = db.Column(VARCHAR(5))
memory = db.Column(VARCHAR(5))
db_connection = db.Column(VARCHAR(5))
file_handler = db.Column(VARCHAR(5))
thread = db.Column(VARCHAR(5))
available = db.Column(VARCHAR(1))
version_num = db.Column(BIGINT(unsigned=True))
def to_json(self):
_dict = self.__dict__
if "_sa_instance_state" in _dict:
del _dict["_sa_instance_state"]
return _dict
class raw_packet(db.Model):
__tablename__ = 'raw_packet'
packet_id = db.Column(BIGINT(20), primary_key=True)
packet_time = db.Column(db.DATETIME)
raw_packet_data = db.Column(MEDIUMBLOB)
def __repr__(self):
return '<packet_id: {0}, packet_time: {1}, raw_pakcet_data: {2} >'.format(
self.packet_id, self.packet_time, self.raw_packet_data)
class Tactic(Base):
__tablename__ = 'tactics'
__table_args__ = {'comment': '策略表'}
id = Column(BIGINT(20), primary_key=True)
owner = Column(String(50), comment='拥有者')
name = Column(String(50), comment='名称')
source = Column(String(50), comment='源码路径')
doc = Column(String(50), comment='文档路径')
class UsersRole(Base):
__tablename__ = 'users_roles'
id = Column(BIGINT(20), primary_key=True)
user_id = Column(ForeignKey('users.id'), nullable=False, index=True)
role_id = Column(ForeignKey('roles.id'), nullable=False, index=True)
role = relationship('Role')
user = relationship('User')
class Carbonsamplermonth(Base):
__tablename__ = 'carbonsamplermonth'
recordId = db.Column(INTEGER(11), primary_key=True)
At = db.Column(BIGINT(20))
stationId = db.Column(db.String(50))
Avg = db.Column(db.Float)
Max = db.Column(db.Float)
Min = db.Column(db.Float)
class Server(Base):
__tablename__ = 'servers'
id = Column(Integer, primary_key=True)
server_id = Column(BIGINT(unsigned=True), unique=True)
# if your server name has more than 100 chars tough luck
name = Column(String(100))
muted_role_id = Column(Integer)
unmuted_role_id = Column(Integer)
class AgentsModule(Base):
__tablename__ = 'agents_modules'
id = Column(BIGINT(20), primary_key=True, unique=True)
agent_id = Column(ForeignKey('agents.id'), index=True)
module_id = Column(ForeignKey('modules.id'), index=True)
agent = relationship('Agent')
module = relationship('Module')
class Carbonsamplerrecord(Base):
__tablename__ = 'carbonsamplerrecord'
recordId = db.Column(INTEGER(11), primary_key=True)
stationId = db.Column(db.String(50))
At = db.Column(BIGINT(20), index=True)
WorkID = db.Column(db.String(50))
BeginTime = db.Column(BIGINT(20))
EndTime = db.Column(BIGINT(20))
RealtimeFlow = db.Column(db.Float)
TotalFlow = db.Column(db.Float)
StandardVolume = db.Column(db.Float)
WorkingVolume = db.Column(db.Float)
AmbientTemp = db.Column(db.Float)
AmbientHumi = db.Column(db.Float)
Pressure = db.Column(db.Float)
FaultAlarm = db.Column(db.String(10))
UpdateFlag = db.Column(TINYINT(1))
class shiftlog(Base):
__tablename__ = 'ompshiftlog'
__table_args__ = {'schema': 'omp'}
shiftid = Column(BIGINT(20), primary_key=True, unique=True)
date = Column(DateTime, nullable=False)
author = Column(String(32), nullable=False)
telescope = Column(String(32), nullable=False)
text = Column(LONGTEXT, nullable=False)
class User(db.Model, MySQLMixin, UserMixin):
id = db.Column(BIGINT(unsigned=True), primary_key=True)
name = db.Column(VARCHAR(255), nullable=False)
username = db.Column(VARCHAR(255), nullable=False)
password = db.Column(VARCHAR(255), nullable=False)
record_status = db.Column(TINYINT(unsigned=True),
default=0) # 0---CODE_SUCCESS 1---delete
create_time = db.Column(DATETIME, default=datetime.now)
update_time = db.Column(DATETIME, default=datetime.now)
class BilibiliComment(Base):
__tablename__ = 'bilibili_comments'
id = Column(BIGINT(20), primary_key=True)
comment_date = Column(INTEGER(11))
member_name = Column(String(100))
member_id = Column(String(50))
comment_text = Column(VARCHAR(10000))
comment_id = Column(String(50))
class DailyAggregate(Base):
__tablename__ = "daily_aggregates"
transaction_date = Column(BIGINT(unsigned=True),
nullable=False,
primary_key=True)
difficulty = Column(NUMERIC(32, unsigned=False), nullable=False)
transactions = Column(INTEGER(unsigned=True), nullable=False)
block = Column(INTEGER(unsigned=True), nullable=False)
class ShortUrl(Base):
__tablename__ = 'short_url'
id = Column(BIGINT(20), primary_key=True)
short_url = Column(String(255), nullable=False, server_default=text("''"))
original_url = Column(String(255), nullable=False, server_default=text("''"))
createdTime = Column(DateTime, nullable=False)
updatedTime = Column(DateTime, nullable=False)
removedTime = Column(DateTime, nullable=False)
class UserStory(db.Model):
__tablename__ = 'user_story'
id = Column(BIGINT(20), primary_key=True)
user_id = Column(BIGINT(20), nullable=False)
title = Column(String(450), nullable=False)
content = Column(LONGTEXT, nullable=False)
status = Column(INTEGER(11))
created_time = Column(BIGINT(20))
number_of_like = Column(INTEGER(11),
nullable=False,
server_default=text("'0'"))
number_of_dislike = Column(INTEGER(11),
nullable=False,
server_default=text("'0'"))
number_of_comment = Column(INTEGER(11),
nullable=False,
server_default=text("'0'"))
