class Account(db.Model):
"""記錄使用者資料的資料表"""
__tablename__ = 'account'
id = db.Column(db.Integer, primary_key=True)
username = db.Column(db.String(20), unique=True, nullable=False)
password = db.Column(db.String(20), nullable=False)
_type = db.Column("type", db.String(15), nullable=False)
def __repr__(self):
return 'id:%s, username:%s, type:%s' % (self.id, self.username,
self._type)
class Devices(db.Model):
"""記錄裝置列表的資料表"""
__tablename__ = 'devices'
id = db.Column(db.Integer, primary_key=True, nullable=False)
name = db.Column(db.String(20), unique=True, nullable=False)
# foreign key
inventory = db.relationship('DeviceInventory',
backref='devices',
lazy=True)
def __repr__(self):
return 'id:%s, type:%s' % (self.id, self.name)
class Progress(db.Model):
"""記錄施工進度的資料表"""
__tablename__ = 'progress'
school_id = db.Column(db.Integer,
db.ForeignKey("schools.id"),
primary_key=True,
nullable=False)
_type = db.Column("type", db.String(10), primary_key=True, nullable=False)
expectedDate = db.Column(db.String(10))
actualDate = db.Column(db.String(10))
confirmDate = db.Column(db.String(10))
lastFile = db.Column(db.Text)
remarks = db.Column(db.Text)
finished = db.Column(db.Boolean, default=False)
# def __init__(self, id, _type, exDate, acDate, coDate, lastF, remark, finished):
# self.school_id = id
# self._type = _type
# self.expectedDate = exDate
# self.actualDate = acDate
# self.confirmDate = coDate
# self.lastFile = lastF
# self.remarks = remark
# self.finished = finished
def __repr__(self):
return 'school id:%s, type:%s' % (self.school_id, self._type)
class DeviceInventory(db.Model):
"""記錄裝置列表的資料表"""
__tablename__ = 'deviceInventory'
school_id = db.Column(db.Integer,
db.ForeignKey("schools.id"),
primary_key=True,
nullable=False)
device_id = db.Column(db.Integer,
db.ForeignKey("devices.id"),
primary_key=True,
nullable=False)
total = db.Column(db.Integer, nullable=False)
count = db.Column(
db.Integer) #, server_default=0, default=0) # it f*****g don't work
def __repr__(self):
return 'school id:%s, device id:%s' % (self.school_id, self.device_id)
class Schools(db.Model):
"""記錄學校聯絡資料的資料表"""
__tablename__ = 'schools'
id = db.Column(db.Integer, primary_key=True)
name = db.Column(db.String(10), nullable=False)
district = db.Column(db.String(5), nullable=False)
address = db.Column(db.String(50))
infoGroupName = db.Column(db.String(5))
infoGroupPhone = db.Column(db.String(15))
generalAffairsName = db.Column(db.String(5))
generalAffairsPhone = db.Column(db.String(15))
agentName = db.Column(db.String(5))
agentPhone = db.Column(db.String(15))
workerLeaderName = db.Column(db.String(5))
workerLeaderPhone = db.Column(db.String(15))
workerOneName = db.Column(db.String(5))
workerOnePhone = db.Column(db.String(15))
workerTwoName = db.Column(db.String(5))
workerTwoPhone = db.Column(db.String(15))
# foreign key
progress = db.relationship('Progress', backref='schools', lazy=True)
inventory = db.relationship('DeviceInventory',
backref='schools',
lazy=True)
def __repr__(self):
return 'id:%s, school name:%s, district:%s' % (self.id, self.name,
self.district)