class Annotation(db.Model):
__tablename__ = 'annotations'
annotation_guid = db.Column(db.String(32), primary_key=True)
reading_guid = db.Column(db.ForeignKey('readings.reading_guid'), nullable=False)
annotation = db.Column(db.Text)
reading = db.relationship('Reading', primaryjoin='Annotation.reading_guid == Reading.reading_guid',
backref='annotations')
class SensorParameter(db.Model):
__tablename__ = 'sensor_parameters'
log_session_guid = db.Column(db.ForeignKey('log_sessions.log_session_guid'), primary_key=True, nullable=False)
channel = db.Column(db.SmallInteger, primary_key=True, nullable=False)
parameter_name = db.Column(db.String(128), primary_key=True, nullable=False)
parameter_value = db.Column(db.String(128), nullable=False)
log_session = db.relationship('LogSession', primaryjoin='SensorParameter.log_session_guid == '
'LogSession.log_session_guid', backref='sensor_parameters')
class Location(db.Model):
__tablename__ = 'locations'
__table_args__ = (
db.CheckConstraint("(location_name)::text <> ''::text"),
)
location_guid = db.Column(db.String(32), primary_key=True)
location_name = db.Column(db.String(20), nullable=False, unique=True)
active = db.Column(db.Boolean)
deleted = db.Column(db.Boolean)
notes = db.Column(db.Text)
class LicenseInUse(db.Model):
__tablename__ = 'license_in_use'
license_in_use_guid = db.Column(db.String(32), primary_key=True)
computer_name = db.Column(db.Text, nullable=False)
user_guid = db.Column(db.ForeignKey('users.user_guid'), nullable=False)
license_guid = db.Column(db.ForeignKey('licenses.license_guid'), nullable=False)
time_stamp = db.Column(db.DateTime, nullable=False)
license = db.relationship('License', primaryjoin='LicenseInUse.license_guid == License.license_guid',
backref='license_in_uses')
user = db.relationship('User', primaryjoin='LicenseInUse.user_guid == User.user_guid', backref='license_in_uses')
class License(db.Model):
__tablename__ = 'licenses'
license_guid = db.Column(db.String(32), primary_key=True)
license_type = db.Column(db.SmallInteger, nullable=False)
license_serial = db.Column(db.String(20))
version = db.Column(db.String(20))
date_applied = db.Column(db.DateTime, nullable=False)
logins_remaining = db.Column(db.Integer)
license_id = db.Column(db.Text, nullable=False)
deleted = db.Column(db.Boolean)
class LogSession(db.Model):
__tablename__ = 'log_sessions'
log_session_guid = db.Column(db.String(32), primary_key=True)
session_start = db.Column(db.DateTime, nullable=False)
session_end = db.Column(db.DateTime)
logging_interval = db.Column(db.Integer, nullable=False)
logger_guid = db.Column(db.ForeignKey('assets.asset_guid'), nullable=False)
user_guid = db.Column(db.ForeignKey('users.user_guid'), nullable=False)
session_type = db.Column(db.SmallInteger, nullable=False)
computer_name = db.Column(db.Text, nullable=False)
asset = db.relationship('Asset', primaryjoin='LogSession.logger_guid == Asset.asset_guid', backref='log_sessions')
user = db.relationship('User', primaryjoin='LogSession.user_guid == User.user_guid', backref='log_sessions')
class Asset(db.Model):
__tablename__ = 'assets'
__table_args__ = (
db.CheckConstraint("(model)::text <> ''::text"),
db.CheckConstraint("(serial)::text <> ''::text"),
db.UniqueConstraint('model', 'serial')
)
asset_guid = db.Column(db.String(32), primary_key=True)
asset_type = db.Column(db.SmallInteger, nullable=False)
model = db.Column(db.String(32), nullable=False)
serial = db.Column(db.String(32), nullable=False)
active = db.Column(db.Boolean)
deleted = db.Column(db.Boolean)
asset_password = db.Column(db.String(20))
notes = db.Column(db.Text)
class Reading(db.Model):
__tablename__ = 'readings'
reading_guid = db.Column(db.String(32), primary_key=True)
reading = db.Column(db.Float(53), nullable=False)
reading_type = db.Column(db.SmallInteger, nullable=False)
time_stamp = db.Column(db.DateTime, nullable=False)
log_session_guid = db.Column(db.ForeignKey('log_sessions.log_session_guid'), nullable=False)
sensor_guid = db.Column(db.ForeignKey('assets.asset_guid'), nullable=False)
location_guid = db.Column(db.ForeignKey('locations.location_guid'), nullable=False)
channel = db.Column(db.SmallInteger, nullable=False)
max_alarm = db.Column(db.Boolean)
max_alarm_value = db.Column(db.Float(53))
min_alarm = db.Column(db.Boolean)
min_alarm_value = db.Column(db.Float(53))
compromised = db.Column(db.Boolean)
class Version(db.Model):
__tablename__ = 'versions'
db_version = db.Column(db.String(20), primary_key=True)
client_version = db.Column(db.String(20))
class User(UserMixin, db.Model):
__tablename__ = 'users'
__table_args__ = (
db.CheckConstraint("(login_name)::text <> ''::text"),
)
@property
def id(self):
"""Return an identifier."""
return self.user_guid
user_guid = db.Column(db.String(32), primary_key=True)
login_name = db.Column(db.String(32), nullable=False, unique=True)
first_name = db.Column(db.String(64))
last_name = db.Column(db.String(64))
user_password = db.Column(db.String(64))
user_group = db.Column(db.SmallInteger)
permissions = db.Column(db.BigInteger)
active = db.Column(db.Boolean)
deleted = db.Column(db.Boolean)
change = db.Column(db.Boolean)
notes = db.Column(db.Text)