class SubCategories(db.Model):
id = db.Column(db.Integer, primary_key=True)
name = db.Column(db.String(120), index=True, unique=False)
category = db.Column(db.String(120), index=True, unique=False)
stat = db.Column(db.Integer, index=True, unique=False)
def __repr__(self):
return '<DataSet %r>' % (self.name)
class Resources(db.Model):
id = db.Column(db.Integer, primary_key=True)
name = db.Column(db.String(200), index=True, unique=True)
description = db.Column(db.String(2000), index=True, unique=True)
external_link = db.Column(db.String(500), index=True, unique=True)
#posts = db.relationship('Post', backref='author', lazy='dynamic')
def __repr__(self):
return '<DataSet %r>' % (self.name)
class Associations(db.Model):
id = db.Column(db.Integer, primary_key=True)
dataset = db.Column(db.String(120), index=True, unique=False)
attribute = db.Column(db.String(120), index=True, unique=False)
gene = db.Column(db.String(50), index=True, unique=False)
weight = db.Column(db.Float, index=True, unique=False)
#posts = db.relationship('Post', backref='author', lazy='dynamic')
def __repr__(self):
return '<DataSet %r>' % (self.name)
class DataSet(db.Model):
id = db.Column(db.Integer, primary_key=True)
name = db.Column(db.String(120), index=True, unique=False)
description = db.Column(db.String(250), index=True, unique=False)
measurement = db.Column(db.String(120), index=True, unique=False)
association = db.Column(db.String(250), index=True, unique=False)
category = db.Column(db.String(120), index=True, unique=False)
sub_category = db.Column(db.String(120), index=True, unique=False)
resource = db.Column(db.String(120), index=True, unique=False)
views = db.Column(db.Integer, index=True, unique=False)
numb_genes = db.Column(db.Integer, index=True, unique=False)
numb_associations = db.Column(db.Integer, index=True, unique=False)
numb_gene_associations = db.Column(db.Integer, index=True, unique=False)
#posts = db.relationship('Post', backref='author', lazy='dynamic')
def __repr__(self):
return '<DataSet %r>' % (self.name)
class Gene(db.Model):
id = db.Column(db.Integer, primary_key=True)
symbol = db.Column(db.String(64), index=True, unique=True)
name = db.Column(db.String(200), index=True, unique=False)
old_symbol = db.Column(db.String(200), index=True, unique=False)
old_name = db.Column(db.String(600), index=True, unique=False)
synonyms = db.Column(db.String(200), index=True, unique=False)
name_synonyms = db.Column(db.String(600), index=True, unique=False)
chromosome = db.Column(db.String(64), index=True, unique=False)
accession_numbers = db.Column(db.String(64), index=True, unique=False)
entrez_gene_id = db.Column(db.String(64), index=True, unique=False)
ensembl_gene_id = db.Column(db.String(64), index=True, unique=False)
pubmed_ids = db.Column(db.String(64), index=True, unique=False)
refseq_ids = db.Column(db.String(200), index=True, unique=False)
uniprot_id = db.Column(db.String(400), index=True, unique=False)
description = db.Column(db.String(4000), index=True, unique=False)
def __repr__(self):
return '<DataSet %r>' % (self.name)