class WuXiaBooks(db.Model):
id = db.Column(db.Integer, primary_key=True, autoincrement=True)
title = db.Column(db.String(80))
img = db.Column(db.String(500))
cate = db.Column(db.String(20))
author = db.Column(db.String(20))
size = db.Column(db.String(20))
date = db.Column(db.String(20))
down = db.Column(db.String(20))
def __init__(self, title, img, cate, author, size, date, down):
self.title = title
self.img = img
self.cate = cate
self.author = author
self.size = size
self.date = date
self.down = down
def __repr__(self):
return "<WuXiaBooks %d %s>" % (self.id, self.title)
class Phage(db.Model):
phage_id = db.Column(db.String(35), primary_key=True)
accession = db.Column(db.String(15))
cluster = db.Column(db.String(5))
subcluster = db.Column(db.String(5))
class ClinicalIsolateContact(db.Model):
id = db.Column(db.Integer, primary_key=True)
contact_id = db.Column(db.String(25), nullable=False)
isolate_id = db.Column(db.String(35),
db.ForeignKey("clinicalisolate.isolate_id"),
nullable=False)
class Contact(db.Model):
contact_id = db.Column(db.String(25), primary_key=True)
name = db.Column(db.String(45))
email = db.Column(db.String(65))
institution = db.Column(db.String(65))
location = db.Column(db.String(65))