class Transport(db.Model):
__tablename__ = 'transport'
number = db.Column(db.String(10), primary_key=True)
type = db.Column(db.Integer)
start = db.Column(db.String(10))
end = db.Column(db.String(10))
time = db.Column(db.Date)
class User(db.Model, UserMixin):
id = db.Column(db.Integer, primary_key=True)
username = db.Column(db.String(30), unique=True, nullable=False)
password = db.Column(db.String(60), nullable=False)
favorite_countries = db.relationship("Favorite", backref="favorite_user", lazy=True)
def __repr__(self):
return f"User('{self.username}')"
class Admin(UserMixin, db.Model):
__tablename__ = 'admin'
id = db.Column(db.Integer, primary_key=True)
name = db.Column(db.String(40), unique=True, nullable=False)
pwd = db.Column(db.String(20), unique=False, nullable=False)
email = db.Column(db.String(50), unique=True, index=True)
province = db.Column(db.String(150), nullable=True)
auth = db.Column(db.Integer, unique=True, nullable=True)
system = db.Column(db.Integer, unique=True, nullable=False)
def is_admin(self):
'''检查是否为管理员'''
return self.can(Permission.ADMINISTER)
def get_id(self):
return str(self.id)
def verify_password(self, password):
return check_password_hash(generate_password_hash(self.pwd), password)
def is_authenticated(self):
return True
def is_active(self):
return True
def is_anonymous(self):
return False
class Favorite(db.Model):
id = db.Column(db.Integer, primary_key=True)
slug = db.Column(db.String(20), nullable=False)
watchlevel = db.Column(db.String(20), nullable=False)
user_id = db.Column(db.Integer, db.ForeignKey("user.id"), nullable=False)
def __repr__(self):
return f"Post('{self.slug}', '{self.watchlevel}', '{self.user_id}')"
class Popflow(db.Model):
__tablename__ = 'population_flow'
popflow_ID = db.Column(db.String(50), default=gen_id, primary_key=True)
people_province = db.Column(db.String(150)) #与用户管理子系统协商
people_inflow = db.Column(db.Integer)
people_outflow = db.Column(db.Integer)
people_time = db.Column(db.DateTime,
default=datetime.datetime.now,
onupdate=datetime.datetime.now)
class GoodsInfo(db.Model):
__tablename__ = 'GoodsInfo'
id = db.Column(db.String(32), default=gen_id, primary_key=True)
Goodsname = db.Column(db.String(30))
OrderLimit = db.Column(db.Integer, nullable=False)
OrderLimitPerPerson = db.Column(db.Integer, nullable=False)
DDL = db.Column(db.Date, nullable=False)
def __repr__(self):
return '<Goods %r>' % self.GoodsName
class Comment(db.Model):
__tablename__ = 'comment'
comment_ID = db.Column(db.String(50), default=gen_id,
primary_key=True) #这个是作为主键标记每一条记录的，用户用的是user_ID
user_name = db.Column(db.String(50))
info_ID = db.Column(db.String(50), db.ForeignKey('information.info_ID'))
comment_text = db.Column(db.String(100))
comment_time = db.Column(db.DateTime,
default=datetime.datetime.now,
onupdate=datetime.datetime.now)
class Information(db.Model):
__tablename__ = 'information'
info_ID = db.Column(db.String(50), default=gen_id, primary_key=True)
info_province = db.Column(db.String(150)) #与用户管理子系统协商
info_type = db.Column(db.Integer)
info_title = db.Column(db.String(50))
info_text = db.Column(db.String(1000))
info_time = db.Column(db.DateTime,
default=datetime.datetime.now,
onupdate=datetime.datetime.now)
class WareHouse(db.Model):
__tablename__ = 'WareHouse'
Goodsname = db.Column(db.String(30),
primary_key=True,
nullable=False,
unique=True)
number = db.Column(db.Integer, nullable=False, unique=False)
usage = db.Column(db.String(50), nullable=False)
def __repr__(self):
return '<Goods %r>' % self.Goodsname
class Complaint(db.Model):
__tablename__ = 'Complaint'
id = db.Column(db.String(20), default=gen_id, primary_key=True)
Orderid = db.Column(db.String(32),
db.ForeignKey('OrderInfo.id'),
nullable=False)
Goodsname = db.Column(db.String(30))
Content = db.Column(db.Text, nullable=False)
ComplaintReason = db.Column(db.Integer, nullable=False) #0: 物流问题; 1: 物资问题
ComplaintState = db.Column(db.Integer, nullable=False) #0: 未处理; 1: 已处理
def __repr__(self):
return '<Complaint %r>' % self.id
class User(db.Model, UserMixin):
id = db.Column(db.Integer, primary_key=True) # User ID: primary key
username = db.Column(db.String(30), unique=True,
nullable=False) # username: UNIQUE, NOT NULL
password = db.Column(
db.String(60), nullable=False
) # password: NOT NULL, stored as a hashed password, not plaintext that the user inputs
favorite_countries = db.relationship(
"Favorite", backref="favorite_user", lazy=True
) # User has one-to-many relationship with Favorite: one(User) to many(Favorite)
def __repr__(self):
return f"User('{self.username}')"
class Favorite(db.Model):
id = db.Column(db.Integer, primary_key=True) # Favorite ID: primary key
slug = db.Column(
db.String(20), nullable=False
) # slug code for countries (e.g., united-kingdom, japan), NOT NULL
watchlevel = db.Column(
db.String(20),
nullable=False) # watchlevel of the country (priority for the user)
user_id = db.Column(
db.Integer, db.ForeignKey("user.id"), nullable=False
) # user_id of the user who has relation with the Favorite
def __repr__(self):
return f"Post('{self.slug}', '{self.watchlevel}', '{self.user_id}')"
class USER(db.Model):
__tablename__ = "users"
identity_number = db.Column(db.String(30), primary_key=True)
email = db.Column(db.String(30))
address = db.Column(db.String(30))
name = db.Column(db.String(20))
phone_number = db.Column(db.String(11), unique=True)
transport_number = db.Column(db.String(10),
db.ForeignKey('transport.number'))
transport = db.relationship('Transport', backref='User')
class Users(db.Model):
__tablename__ = 'user'
name = db.Column(db.String(40), nullable=False)
pwd = db.Column(db.String(20), nullable=False)
phone = db.Column(db.String(20), unique=True, index=True)
email = db.Column(db.String(50), unique=True, index=True)
idcard = db.Column(db.String(20),
unique=True,
index=True,
primary_key=True)
address = db.Column(db.String(100), index=True)
province = db.Column(db.String(10), index=True)
username = db.Column(db.String(20), index=True)
def __init__(self, name, pwd, phone, email, idcard, address, province,
username):
self.name = name
self.pwd = pwd
self.phone = phone
self.email = email
self.idcard = idcard
self.address = address
self.province = province
self.username = username
def verify_password(self, password):
return check_password_hash(generate_password_hash(self.pwd), password)
def __repr__(self):
return "%s/%s/%s/%s/%s/%s" % (self.name, self.pwd, self.phone,
self.email, self.idcard, self.address)
def is_authenticated(self):
return True
def is_active(self):
return True
def is_anonymous(self):
return False
class OrderInfo(db.Model):
__tablename__ = 'OrderInfo'
id = db.Column(db.String(32), default=gen_id, primary_key=True)
userid = db.Column(
db.String(19),
db.ForeignKey('user.idcard')) # The IDNumber of the applicant
GoodsID = db.Column(db.String(32), db.ForeignKey('GoodsInfo.id'))
Goodsname = db.Column(db.String(30))
OrderNum = db.Column(db.Integer, nullable=False)
idcards = db.Column(db.String(32), nullable=False)
username = db.Column(db.String(30), nullable=False)
address = db.Column(db.String(30), nullable=False)
CreateTime = db.Column(db.Date, nullable=False)
DeliveryTime = db.Column(db.Date, nullable=True)
ReceiveTime = db.Column(db.Date, nullable=True)
CancelTime = db.Column(db.Date, nullable=True)
OrderState = db.Column(
db.Integer, nullable=False) # 0:等待抽签; 1:未发货; 2:已发货; 3:已送达; 4:已取消
def __repr__(self):
return '<Goods %r>' % self.id