33 lines
1.2 KiB
Python
33 lines
1.2 KiB
Python
# 模型,数据库
|
|
from App.exts import db
|
|
|
|
class User(db.Model):
|
|
#表名
|
|
__tablename__ = 'sys_user'
|
|
# 定义字段
|
|
id = db.Column(db.Integer, primary_key=True)
|
|
username = db.Column(db.String(255),unique=True,index=True)
|
|
password = db.Column(db.String(255),unique=True,index=True)
|
|
create_time = db.Column(db.String,unique=True,index=True)
|
|
|
|
class CityCode(db.Model):
|
|
#表名
|
|
__tablename__ = 'city_code'
|
|
# 定义字段
|
|
code = db.Column(db.Integer, primary_key=True)
|
|
name = db.Column(db.String(255),unique=True,index=True)
|
|
pinyin = db.Column(db.String(255),unique=True,index=True)
|
|
class jam(db.Model):
|
|
#表名
|
|
__tablename__ = 'jam'
|
|
# 定义字段
|
|
id = db.Column(db.Integer, primary_key=True)
|
|
freeFlowSpeed = db.Column(db.String(255))
|
|
realSpeed = db.Column(db.String(255),unique=True,index=True)
|
|
idxRatio = db.Column(db.Integer,unique=True,index=True)
|
|
idxRatioState = db.Column(db.String(255),unique=True,index=True)
|
|
idx = db.Column(db.String(255),unique=True,index=True)
|
|
label = db.Column(db.String(255),unique=True,index=True)
|
|
name = db.Column(db.Integer,unique=True,index=True)
|
|
create_time = db.Column(db.String(255),unique=True,index=True)
|