class VersionCommentVote(db.Model):
versioncommentvote_id = db.Column(db.Integer, primary_key=True)
version_id = db.Column(
db.Integer, db.ForeignKey('version.version_id', ondelete='NO ACTION'))
voter_id = db.Column(db.Integer,
db.ForeignKey('user.id', ondelete='NO ACTION'))
value = db.Column(db.Integer)
vote_date = db.Column(db.DateTime())
class VersionComment(db.Model):
versioncomment_id = db.Column(db.Integer, primary_key=True)
version_id = db.Column(
db.Integer, db.ForeignKey('version.version_id', ondelete='NO ACTION'))
author_id = db.Column(db.Integer,
db.ForeignKey('user.id', ondelete='NO ACTION'))
body = db.Column(db.Text)
comment_date = db.Column(db.DateTime())
class Version(db.Model):
version_id = db.Column(db.Integer, primary_key=True)
date = db.Column(db.Date)
created = db.Column(db.DateTime)
song_id = db.Column(db.Integer) # Song.phishin_id
url = db.Column(db.String(256))
created_by = db.Column(db.Integer)
mu = db.Column(db.Float)
sigma = db.Column(db.Float)
phishin_id = db.Column(db.Integer)
show_id = db.Column(db.Integer)
class Vote(db.Model):
vote_id = db.Column(db.Integer, primary_key=True)
lhs = db.Column(db.Integer)
rhs = db.Column(db.Integer)
winner = db.Column(db.Integer)
created_by = db.Column(db.Integer)
created = db.Column(db.DateTime)
class User(db.Model, UserMixin):
id = db.Column(db.Integer, primary_key=True)
username = db.Column(db.String(50), nullable=False, unique=True)
password = db.Column(db.String(255), nullable=False, server_default='')
email = db.Column(db.String(255), nullable=False, unique=True)
confirmed_at = db.Column(db.DateTime())
active = db.Column('is_active',
db.Boolean(),
nullable=False,
server_default='0')
first_name = db.Column(db.String(100), nullable=False, server_default='')
last_name = db.Column(db.String(100), nullable=False, server_default='')
roles = db.relationship('Role',
secondary='user_roles',
backref=db.backref('users', lazy='dynamic'))
class UserRoles(db.Model):
id = db.Column(db.Integer(), primary_key=True)
user_id = db.Column(db.Integer(),
db.ForeignKey('user.id', ondelete='CASCADE'))
role_id = db.Column(db.Integer(),
db.ForeignKey('role.id', ondelete='CASCADE'))
class Role(db.Model):
id = db.Column(db.Integer(), primary_key=True)
name = db.Column(db.String(50), unique=True)
class ListenedTo(db.Model):
lt_id = db.Column(db.Integer, primary_key=True)
version_id = db.Column(db.Integer)
user_id = db.Column(db.Integer)
class Band(db.Model):
band_id = db.Column(db.Integer, primary_key=True)
name = db.Column(db.String(128))
desc = db.Column(db.Text)
class Show(db.Model):
show_id = db.Column(db.Integer, primary_key=True)
phishin_id = db.Column(db.Integer)
venue_id = db.Column(db.Integer)
date = db.Column(db.String(128))
class Venue(db.Model):
venue_id = db.Column(db.Integer, primary_key=True)
phishin_id = db.Column(db.Integer)
location = db.Column(db.String(128))
name = db.Column(db.String(128))
class Song(db.Model):
song_id = db.Column(db.Integer, primary_key=True)
name = db.Column(db.String(128))
desc = db.Column(db.String(128))
band_id = db.Column(db.Integer, index=True)
phishin_id = db.Column(db.Integer)
class Comment(db.Model):
comment_id = db.Column(db.Integer, primary_key=True)
version_id = db.Column(db.Integer)
content = db.Column(db.Text)
created_by = db.Column(db.Integer)
created = db.Column(db.DateTime)
