class History(db.Model):
id = db.Column(db.Integer, primary_key=True) #pk
source = db.Column(
db.String(64)) #source of entry... user, or zone that caused change
event = db.Column(
db.String(64)) #type of event, arm, disarm, open, close, etc....
timestamp = db.Column(db.DateTime)
class User(db.Model):
id = db.Column(db.Integer, primary_key=True)
nickname = db.Column(db.String(64), unique=True)
email = db.Column(db.String(120), unique=True)
role = db.Column(db.SmallInteger, default=ROLE_USER)
def is_authenticated(self):
return True
def is_active(self):
return True
def is_anonymous(self):
return False
def get_id(self):
return unicode(self.id)
def __repr__(self):
return '<User %r>' % (self.nickname)
class Email(db.Model):
id = db.Column(db.Integer, primary_key=True)
email = db.Column(db.String(120), unique=True)
html = db.Column(db.Boolean, default=0) #html capable?
class Settings(db.Model):
id = db.Column(db.Integer, primary_key=True)
attribute = db.Column(db.String(64), unique=True)
value = db.Column(db.String(64))
description = db.Column(db.String(128))
class AlarmStatus(db.Model):
id = db.Column(db.Integer, primary_key=True)
attribute = db.Column(db.String(64), unique=True)
value = db.Column(db.String(64))
class Zones(db.Model):
id = db.Column(db.Integer, primary_key=True)
name = db.Column(db.String(64), unique=True)
pin = db.Column(db.SmallInteger, unique=True)
secured = db.Column(db.Boolean)