class Tables(db.Model):
id = db.Column(db.Integer(), primary_key=True)
manufacture_id = db.Column(db.Integer,
db.ForeignKey('manufactures.id'),
nullable=False)
table_name = db.Column(db.String(128), nullable=False)
horizont_range = db.Column(db.Integer())
max_weight = db.Column(db.Integer())
tomog = db.relationship('Tomog', backref='table', lazy=True)
def __repr__(self):
return '{}'.format(self.table_name)
class Generator(db.Model):
id = db.Column(db.Integer(), primary_key=True)
manufacture_id = db.Column(db.Integer,
db.ForeignKey('manufactures.id'),
nullable=False)
generator_name = db.Column(db.String(128), nullable=False)
power = db.Column(db.Integer())
current = db.Column(db.Integer())
voltage = db.Column(db.Integer())
tomog = db.relationship('Tomog', backref='generator', lazy=True)
def __repr__(self):
return '{}'.format(self.generator_name)
class Tubes(db.Model):
id = db.Column(db.Integer(), primary_key=True)
manufacture_id = db.Column(db.Integer,
db.ForeignKey('manufactures.id'),
nullable=False)
tube_model = db.Column(db.String(128), nullable=False)
focus = db.Column(db.String(128))
capacity = db.Column(db.Float())
coolingrate = db.Column(db.Float())
servise_life = db.Column(db.Integer())
tomog = db.relationship('Tomog', backref='tube', lazy=True)
def __repr__(self):
return '{}'.format(self.tube_model)
class Hints(db.Model):
id = db.Column(db.Integer(), primary_key=True)
hint_name = db.Column(db.String(128), nullable=False)
hint_text = db.Column(db.Text)
def __repr__(self):
return '{}'.format(self.hint_name)
class User(db.Model, UserMixin):
id = db.Column(db.Integer(), primary_key=True)
name = db.Column(db.String(128), unique=True)
email = db.Column(db.String(128), unique=True)
password = db.Column(db.String(128), )
active = db.Column(db.Boolean())
roles = db.relationship('Role',
secondary=role_user,
backref=db.backref('user', lazy='dynamic'))
class Technologies(db.Model):
id = db.Column(db.Integer(), primary_key=True)
manufacture_id = db.Column(db.Integer,
db.ForeignKey('manufactures.id'),
nullable=False)
technology_name = db.Column(db.String(128), nullable=False)
technology_text = db.Column(db.Text)
category = db.Column(db.String(128))
def __repr__(self):
return "%s, %s" % (self.technology_name, self.manufacture)
class Image(db.Model):
id = db.Column(db.Integer(), primary_key=True)
name = db.Column(db.Unicode(64), nullable=False)
path = db.Column(db.Unicode(128), nullable=False)
tomograph = db.relationship('Tomog', backref='image', lazy=True)
def __unicode__(self):
return self.name
def __repr__(self):
return '{}'.format(self.name)
class Tomog(db.Model):
id = db.Column(db.Integer(), primary_key=True)
manufacture_id = db.Column(db.Integer,
db.ForeignKey('manufactures.id'),
nullable=False)
tomog_model = db.Column(db.String(128), nullable=False)
spiraltype = db.Column(db.String(128))
tubecount = db.Column(db.String(128))
gantry = db.Column(db.Integer())
slicecount = db.Column(db.Integer())
slice_thicness = db.Column(db.Float())
fov_x = db.Column(db.Integer())
fov_z = db.Column(db.Integer())
spatial_resolution = db.Column(db.Float())
rotation_time = db.Column(db.Float())
fps = db.Column(db.Integer())
room_size = db.Column(db.Float())
performance = db.Column(db.Float())
tube_id = db.Column(db.Integer, db.ForeignKey('tubes.id'), nullable=False)
generator_id = db.Column(db.Integer,
db.ForeignKey('generator.id'),
nullable=False)
table_id = db.Column(db.Integer,
db.ForeignKey('tables.id'),
nullable=False)
technologies = db.relationship('Technologies',
secondary=tomog_techno,
backref=db.backref('tomog', lazy='dynamic'))
image_id = db.Column(db.Integer, db.ForeignKey('image.id'))
def __repr__(self):
return '{}'.format(self.tomog_model)
class Manufactures(db.Model):
id = db.Column(db.Integer(), primary_key=True)
manufacture_name = db.Column(db.String(128), nullable=False)
manufacture_longname = db.Column(db.String(255))
country = db.Column(db.String(128))
tubes = db.relationship('Tubes', backref='manufacture', lazy=True)
generators = db.relationship('Generator', backref='manufacture', lazy=True)
tables = db.relationship('Tables', backref='manufacture', lazy=True)
technologies = db.relationship('Technologies',
backref='manufacture',
lazy=True)
tomog = db.relationship('Tomog', backref='manufacture', lazy=True)
def __repr__(self):
return '{}'.format(self.manufacture_name)
class Role(db.Model, RoleMixin):
id = db.Column(db.Integer(), primary_key=True)
name = db.Column(db.String(128), nullable=False)
description = db.Column(db.String(255))