class Outcome(db.Model):
id = db.Column(db.Integer, primary_key=True, autoincrement=True)
plc_status = db.Column(db.Integer)
id_patient = db.Column(db.Integer, db.ForeignKey('patient.id'))
patient = db.relationship('Patient',
backref=db.backref('outcome', uselist=False))
class StudyAlbum(db.Model):
id_study = db.Column(db.Integer,
db.ForeignKey('study.id'),
primary_key=True)
id_album = db.Column(db.Integer,
db.ForeignKey('album.id'),
primary_key=True)
study = db.relationship('Study', backref='study_album')
album = db.relationship('Album', backref='study_album')
class Album(db.Model):
id = db.Column(db.Integer, primary_key=True, autoincrement=True)
name = db.Column(db.String(100))
description = db.Column(db.String(100))
time_stamp = db.Column(db.DateTime, default=datetime.now())
def __init__(self, name, description):
self.name = name
self.description = description
self.time_stamp = datetime.now()
class QIBFeature(db.Model):
id = db.Column(db.Integer, primary_key=True, autoincrement=True)
feature_value = db.Column(db.Float)
id_qib = db.Column(db.Integer, db.ForeignKey('qib.id', ondelete='CASCADE'))
id_feature = db.Column(db.Integer, db.ForeignKey('feature.id'))
id_series_region = db.Column(db.Integer, db.ForeignKey('series_region.id'))
feature = db.relationship('Feature', backref='qib_feature')
qib = db.relationship('QIB', backref='qib_feature', passive_deletes=True)
series_region = db.relationship('SeriesRegion', backref='qib_feature')
class Series(db.Model):
id = db.Column(db.Integer, primary_key=True, autoincrement=True)
time_stamp = db.Column(db.DateTime, default=datetime.now())
name = db.Column(db.String(100), default=default_string)
series_uid = db.Column(db.String(70))
sickness = db.Column(db.String(100), default=default_string)
id_study = db.Column(db.Integer, db.ForeignKey('study.id'))
study = db.relationship('Study', backref='series')
id_modality = db.Column(db.Integer, db.ForeignKey('modality.id'))
modality = db.relationship('Modality', backref='series')
class QIB(db.Model):
__tablename__ = 'qib'
id = db.Column(db.Integer, primary_key=True, autoincrement=True)
name = db.Column(db.String(100), default=default_string)
description = db.Column(db.String(500), default=default_string)
outcome_column = db.Column(db.String(200), default='')
metadata_columns = db.Column(db.String(200), default='')
id_album = db.Column(db.Integer, db.ForeignKey('album.id'))
time_stamp = db.Column(db.DateTime, default=datetime.now())
album = db.relationship('Album', backref='qib')
def __init__(self, id_album, qib_name, qib_description):
self.id_album = id_album
self.name = qib_name
self.description = qib_description
self.time_stamp = datetime.now()
class Feature(db.Model):
id = db.Column(db.Integer, primary_key=True, autoincrement=True)
name = db.Column(db.String(100))
id_family = db.Column(db.Integer, db.ForeignKey('family.id'))
family = db.relationship('Family', backref='feature')
class Family(db.Model):
id = db.Column(db.Integer, primary_key=True, autoincrement=True)
name = db.Column(db.String(100))
class Region(db.Model):
id = db.Column(db.Integer, primary_key=True, autoincrement=True)
name = db.Column(db.String(100))
description = db.Column(db.String(100), default=default_string)
class SeriesRegion(db.Model):
id = db.Column(db.Integer, primary_key=True, autoincrement=True)
id_series = db.Column(db.Integer, db.ForeignKey('series.id'))
id_region = db.Column(db.Integer, db.ForeignKey('region.id'))
series = db.relationship('Series', backref='series_region')
region = db.relationship('Region', backref='series_region')
class Patient(db.Model):
id = db.Column(db.Integer, primary_key=True, autoincrement=True)
first_name = db.Column(db.String(100))
last_name = db.Column(db.String(100))
birthdate = db.Column(db.DateTime)
gender = db.Column(db.String(2))
class Study(db.Model):
id = db.Column(db.Integer, primary_key=True, autoincrement=True)
name = db.Column(db.String(300), default=default_string)
time_stamp = db.Column(db.DateTime, default=datetime.now())
id_patient = db.Column(db.Integer, db.ForeignKey('patient.id'))
patient = db.relationship('Patient', backref='study')