class Consumer(AppMixin, db.Model):
id = db.Column(db.Integer, primary_key=True)
first_name = db.Column(db.String, nullable=False)
last_name = db.Column(db.String, nullable=False)
address_id = db.Column(db.Integer, db.ForeignKey('address.id'), nullable=False)
devices = db.relationship('Device', backref='consumer', lazy='dynamic')
utility_provider_id = db.Column(db.Integer, db.ForeignKey('utility_provider.id'), nullable=False)
class Reading(AppMixin, db.Model):
id = db.Column(db.Integer, primary_key=True)
degree = db.Column(db.Float, default=27.0)
humidity = db.Column(db.Float, default=0.0)
transformer_id = db.Column(db.Integer, db.ForeignKey('transformer.id'), nullable=True)
voltage = db.Column(db.Float, default=0.0)
current = db.Column(db.Float, default=0.0)
power = db.Column(db.Float, default=0.0)
device_id = db.Column(db.Integer, db.ForeignKey('device.id'), nullable=False)
class Device(AppMixin, db.Model):
id = db.Column(db.Integer, primary_key=True)
reference_code = db.Column(db.String, nullable=False)
meter_reference_code = db.Column(db.String, nullable=True)
consumer_id = db.Column(db.Integer, db.ForeignKey('consumer.id'), nullable=True)
utility_provider_id = db.Column(db.Integer, db.ForeignKey('utility_provider.id'), nullable=True)
is_master = db.Column(db.Boolean, default=False)
is_slave = db.Column(db.Boolean, default=True)
transformer_id = db.Column(db.Integer, db.ForeignKey('transformer.id'), nullable=True)
transformer = db.relationship('Transformer', foreign_keys='Device.transformer_id')
class State(AppMixin, db.Model):
id = db.Column(db.Integer, primary_key=True)
name = db.Column(db.String(200))
code = db.Column(db.String(200))
country_id = db.Column(db.Integer, db.ForeignKey('country.id'), nullable=False)
cities = db.relationship('City', backref='state', lazy='dynamic')
class City(AppMixin, db.Model):
id = db.Column(db.Integer, primary_key=True)
name = db.Column(db.String(200))
code = db.Column(db.String(200))
state_id = db.Column(db.Integer, db.ForeignKey('state.id'), nullable=False)
country_id = db.Column(db.Integer, db.ForeignKey('country.id'), nullable=False)
class Transformer(AppMixin, db.Model):
id = db.Column(db.Integer, primary_key=True)
model_number = db.Column(db.String, nullable=False)
capacity = db.Column(db.Float, nullable=False)
address_id = db.Column(db.Integer, db.ForeignKey('address.id'), nullable=True)