47 lines
1.6 KiB
Python
47 lines
1.6 KiB
Python
# 模型
|
|
from datetime import datetime
|
|
|
|
from sqlalchemy.dialects.mysql import LONGTEXT
|
|
|
|
from .exts import db
|
|
|
|
|
|
# 模型
|
|
class User(db.Model):
|
|
# 表名
|
|
__tablename__ = "tb_user"
|
|
id = db.Column(db.Integer, primary_key=True, autoincrement=True)
|
|
role = db.Column(db.Integer, autoincrement=True)
|
|
username = db.Column(db.String(80), unique=True, nullable=False)
|
|
password = db.Column(db.String(128), nullable=False)
|
|
|
|
|
|
class JobPosition(db.Model):
|
|
__tablename__ = 'tb_companies'
|
|
id = db.Column(db.BigInteger, primary_key=True, autoincrement=True, comment='主键ID')
|
|
company_name = db.Column(db.String(50))
|
|
industry = db.Column(db.String(200))
|
|
registered_capital = db.Column(db.String(200))
|
|
establishment_date = db.Column(db.String(200))
|
|
registration_addres = db.Column(db.String(200))
|
|
def to_dict(self):
|
|
"""将模型转换为字典"""
|
|
return {
|
|
'id': self.id,
|
|
'companyName': self.company_name,
|
|
'industry': self.industry,
|
|
'registeredCapital': self.registered_capital,
|
|
'establishmentDate': self.establishment_date,
|
|
'registrationAddres': self.registration_addres,
|
|
}
|
|
|
|
|
|
class Config(db.Model):
|
|
# 表名
|
|
__tablename__ = "tb_sysconfig"
|
|
id = db.Column(db.Integer, primary_key=True, autoincrement=True) # 主键
|
|
name = db.Column(db.String(50), nullable=False)
|
|
key = db.Column(db.String(50), unique=True, nullable=False) # 配置键
|
|
value = db.Column(db.String(255), nullable=False) # 配置值
|
|
description = db.Column(db.String(255)) # 描述
|