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. #----------------------------------------------------------------------------#