t_scholar_articles_counts = db.Table('scholar_articles_counts',
db.Column('scholar_id', db.Integer),
db.Column('count', db.BigInteger))
t_scholar_citations_count = db.Table('scholar_citations_count',
db.Column('scholar_id', db.Integer),
db.Column('sum', db.BigInteger))
t_scholar_citations_counts = db.Table('scholar_citations_counts',
db.Column('scholar_id', db.Integer),
db.Column('sum', db.BigInteger))
t_scholar_cooperations = db.Table(
'scholar_cooperations', db.Column('article_id', db.Integer),
db.Column('scholar_ids', db.ARRAY(INTEGER())),
db.Column('citations_count', db.Integer))
class ScholarCooperator(db.Model):
__tablename__ = 'scholar_cooperators'
id = db.Column(db.Integer,
primary_key=True,
server_default=db.FetchedValue())
scholar_id = db.Column(db.Integer, nullable=False)
cooperator_id = db.Column(db.Integer, nullable=False)
t_scholar_cooperators_count = db.Table('scholar_cooperators_count',
db.Column('scholar_id', db.Integer),
seeking_description = db.Column(db.String())
image_link = db.Column(db.String(500))
class Artist(db.Model):
'''
Creates the Artist table schema in db
'''
__tablename__ = 'artist_tbl'
id = db.Column(db.Integer, primary_key=True)
name = db.Column(db.String)
genres = db.Column(db.ARRAY(db.String()))
city = db.Column(db.String(120))
state = db.Column(db.String(120))
phone = db.Column(db.String(120))
website = db.Column(db.String(500))
facebook_link = db.Column(db.String(500))
seeking_venue = db.Column(db.Boolean, default=False)
seeking_description = db.Column(db.String())
image_link = db.Column(db.String(500))
#----------------------------------------------------------------------------#
# Filters.
#----------------------------------------------------------------------------#
