class Space(db.Model):
"""
空间表
"""
id = db.Column(db.Integer, primary_key=True)
name = db.Column(db.String(80), nullable=False)
avatar = db.Column(db.String(256), nullable=True)
belongUserId = db.Column(db.Integer, nullable=True)
belongGroupId = db.Column(db.Integer, nullable=True)
isPublic = db.Column(db.SmallInteger, default=0, nullable=False)
isDisable = db.Column(db.SmallInteger, default=0, nullable=False)
createdAt = db.Column(db.DateTime, nullable=True)
updatedAt = db.Column(db.DateTime, nullable=True)
def __repr__(self):
return '<Space %r>' % self.name
class Goods(db.Model):
"""
物品表
"""
id = db.Column(db.Integer, primary_key=True)
name = db.Column(db.String(80), nullable=False)
avatar = db.Column(db.String(256), nullable=True)
belongUserId = db.Column(db.Integer, nullable=True)
belongGroupId = db.Column(db.Integer, nullable=True)
spaceId = db.Column(db.Integer, nullable=True)
positionId = db.Column(db.Integer, nullable=True)
type = db.Column(db.SmallInteger, default=0, nullable=False)
isPublic = db.Column(db.SmallInteger, default=0, nullable=False)
coordinate = db.Column(db.String(256), nullable=True)
isDisable = db.Column(db.SmallInteger, default=0, nullable=False)
createdAt = db.Column(db.DateTime, nullable=True)
updatedAt = db.Column(db.DateTime, nullable=True)
def __repr__(self):
return '<Goods %r>' % self.name
class News(db.Model):
"""
动态表
"""
id = db.Column(db.Integer, primary_key=True)
title = db.Column(db.String(80), nullable=False)
content = db.Column(db.String(1024), nullable=False)
type = db.Column(db.Integer, nullable=False)
belongUserId = db.Column(db.Integer, nullable=True)
belongGroupId = db.Column(db.Integer, nullable=True)
spaceId = db.Column(db.Integer, nullable=True)
positionId = db.Column(db.Integer, nullable=True)
avatar = db.Column(db.String(80), nullable=False)
goodsId = db.Column(db.Integer, nullable=True)
isPublic = db.Column(db.SmallInteger, default=0, nullable=False)
isDisable = db.Column(db.SmallInteger, default=0, nullable=False)
createdAt = db.Column(db.DateTime, nullable=True)
updatedAt = db.Column(db.DateTime, nullable=True)
def __repr__(self):
return '<News %r>' % self.id
class User(db.Model):
"""
用户表
"""
id = db.Column(db.Integer, primary_key=True)
firstName = db.Column(db.String(80), nullable=True)
lastName = db.Column(db.String(80), nullable=True)
username = db.Column(db.String(80), unique=True, nullable=False)
email = db.Column(db.String(120), unique=True, nullable=False)
checkCode = db.Column(db.String(4), nullable=True)
password = db.Column(db.String(256), nullable=True)
defaultGroupId = db.Column(db.Integer, nullable=True)
avatar = db.Column(db.String(256), nullable=True)
sessionToken = db.Column(db.String(256), nullable=True)
isDisable = db.Column(db.SmallInteger, default=0, nullable=False)
createdAt = db.Column(db.DateTime, nullable=True)
updatedAt = db.Column(db.DateTime, nullable=True)
def __repr__(self):
return '<User %r>' % self.username