class DimSCCountry(db.Model):
__tablename__ = 'dim_sc_countries'
id = db.Column('id', db.Integer, primary_key=True, autoincrement=True)
name = db.Column('name', db.String(), index=True)
def __str__(self):
return self.name
class DimEmail(db.Model):
__tablename__ = 'dim_email'
id = db.Column('id', db.Integer, primary_key=True, autoincrement=True)
email = db.Column('email', db.String(), index=True)
def __str__(self):
return self.email
class DimAcademicPosition(db.Model):
__tablename__ = 'dim_academic_positions'
id = db.Column('id', db.Integer, primary_key=True, autoincrement=True)
title = db.Column('title', db.String(), index=True)
def __str__(self):
return self.title
class DimScopusField(db.Model):
__tablename__ = 'dim_scopus_fields'
id = db.Column('id', db.Integer, primary_key=True, autoincrement=True)
code = db.Column('code', db.Integer, unique=True)
abbrev = db.Column('abbrev', db.String())
description = db.Column('description', db.String())
detail = db.Column('detail', db.String())
class DimThaiName(db.Model):
__tablename__ = 'dim_thai_names'
id = db.Column('id', db.Integer, primary_key=True, autoincrement=True)
firstname = db.Column('firstname', db.String(), index=True)
lastname = db.Column('lastname', db.String(), index=True)
@property
def fullname(self):
return '{} {}'.format(self.firstname, self.lastname)
def __str__(self):
return '{} {}'.format(self.firstname, self.lastname)
class BridgeScopusAuthorDetailGroup(db.Model):
__tablename__ = 'br_scopus_author_detail_group'
scopus_author_detail_group_id = db.Column(
'scopus_author_detail_group_id',
db.ForeignKey('dim_scopus_author_detail_groups.id'),
primary_key=True)
scopus_author_detail_id = db.Column(
'scopus_author_detail_id',
db.ForeignKey('dim_scopus_author_detail.id'))
scopus_author_detail_group = db.relationship('DimScopusAuthorDetailGroup',
backref=db.backref('details'))
scopus_author_detail = db.relationship('DimScopusAuthorDetail')
class BridgeUniversityGroup(db.Model):
__tablename__ = 'br_university_groups'
university_group_id = db.Column('university_group_id',
db.ForeignKey('dim_university_groups.id'),
primary_key=True)
university_id = db.Column('university_id',
db.ForeignKey('dim_universities.id'),
primary_key=True)
university_group = db.relationship('DimUniversityGroup',
backref=db.backref('universities'))
university = db.relationship('DimUniversity')
def __str__(self):
return self.university.name
class BridgeEmailGroup(db.Model):
__tablename__ = 'br_email_group'
email_group_id = db.Column('email_group_id',
db.ForeignKey('dim_email_group.id'),
primary_key=True)
email_id = db.Column('email_id',
db.ForeignKey('dim_email.id'),
primary_key=True)
email_group = db.relationship('DimEmailGroup',
backref=db.backref('emails'))
email = db.relationship('DimEmail')
def __str__(self):
return self.email.email
class BridgeEngNameGroup(db.Model):
__tablename__ = 'br_eng_name_groups'
en_name_id = db.Column('en_name_id',
db.ForeignKey('dim_eng_names.id'),
primary_key=True)
en_name_group_id = db.Column('en_name_group_id',
db.ForeignKey('dim_eng_name_groups.id'),
primary_key=True)
name = db.relationship('DimEngName')
en_name_group = db.relationship('DimEngNameGroup',
backref=db.backref('names'))
@property
def fullname(self):
return self.name.fullname
class BridgeScopusFieldGroup(db.Model):
__tablename__ = 'br_scopus_field_group'
scopus_field_group_id = db.Column(
'scopus_field_group_id',
db.ForeignKey('dim_scopus_field_groups.id'),
primary_key=True)
scopus_field_id = db.Column('scopus_field_id',
db.ForeignKey('dim_scopus_fields.id'),
primary_key=True)
frequency = db.Column('frequency', db.Integer)
scopus_field_group = db.relationship('DimScopusFieldGroup',
backref=db.backref('scopus_fields'))
scopus_field = db.relationship('DimScopusField')
def __str__(self):
return self.scopus_field.detail
class DimScopusAuthorDetailGroup(db.Model):
__tablename__ = 'dim_scopus_author_detail_groups'
id = db.Column('id', db.Integer, primary_key=True, autoincrement=True)
class DimScopusAuthorDetail(db.Model):
__tablename__ = 'dim_scopus_author_detail'
id = db.Column('id', db.Integer, primary_key=True, autoincrement=True)
# Author's identifier serves as a key for historical reporting
identifier = db.Column('identifier', db.String())
en_firstname = db.Column('en_firstname', db.String())
en_lastname = db.Column('en_lastname', db.String())
url = db.Column('url', db.String())
coauthor_count = db.Column('coauthor_count', db.Integer, default=0)
h_index = db.Column('h_index', db.Integer)
pub_start = db.Column('pub_start', db.Integer())
pub_end = db.Column('pub_end', db.Integer())
citation_count = db.Column('citation_count', db.Integer, default=0)
cited_by_count = db.Column('cited_by_count', db.Integer, default=0)
document_count = db.Column('document_count', db.Integer, default=0)
affiliation = db.Column('affiliation', db.String())
department = db.Column('department', db.String())
current = db.Column('current', db.Boolean(), default=True)
start_date = db.Column('start_date', db.Date())
end_date = db.Column('end_date', db.Date(), default=datetime(9999, 12, 31))
class FactResearcher(db.Model):
__tablename__ = 'fact_researchers'
id = db.Column('id', db.Integer, primary_key=True, autoincrement=True)
old_id = db.Column('old_id', db.Integer)
email_group_id = db.Column('email_group_id',
db.ForeignKey('dim_email_group.id'))
email_group = db.relationship('DimEmailGroup',
backref=db.backref('researcher',
uselist=False))
academic_position_id = db.Column(
'academic_position_id', db.ForeignKey('dim_academic_positions.id'))
academic_position = db.relationship('DimAcademicPosition',
backref=db.backref('researchers',
lazy='dynamic'))
university_group_id = db.Column('university_group_id',
db.ForeignKey('dim_university_groups.id'))
university_group = db.relationship('DimUniversityGroup',
backref=db.backref('researcher',
uselist=False))
th_name_group_id = db.Column('thname_group_id',
db.ForeignKey('dim_thai_name_groups.id'))
th_name_group = db.relationship('DimThaiNameGroup',
backref=db.backref('researcher',
uselist=False))
en_name_group_id = db.Column('en_name_group_id',
db.ForeignKey('dim_eng_name_groups.id'))
en_name_group = db.relationship('DimEngNameGroup',
backref=db.backref('researcher',
uselist=False))
sc_graduated_date = db.Column('sc_graduated_year', db.Date())
sc_country_id = db.Column('sc_country_id',
db.ForeignKey('dim_sc_countries.id'))
sc_university_id = db.Column('sc_university_id',
db.ForeignKey('dim_sc_universities.id'))
sc_field = db.Column('sc_field', db.String())
sc_specialty = db.Column('sc_specialty', db.String())
sc_country = db.relationship('DimSCCountry',
backref=db.backref('students'))
sc_university = db.relationship('DimSCUniversity',
backref=db.backref('students'))
scopus_author_detail_group_id = db.Column(
'scopus_author_detail_groups_id',
db.ForeignKey('dim_scopus_author_detail_groups.id'))
scopus_author_detail_group = db.relationship(
'DimScopusAuthorDetailGroup', backref=db.backref('researcher'))
scopus_field_group_id = db.Column(
'scopus_field_group_id', db.ForeignKey('dim_scopus_field_groups.id'))
scopus_field_group = db.relationship('DimScopusFieldGroup',
backref=db.backref('researcher'))
class DimEmailGroup(db.Model):
__tablename__ = 'dim_email_group'
id = db.Column('id', db.Integer, primary_key=True, autoincrement=True)
class DimEngNameGroup(db.Model):
__tablename__ = 'dim_eng_name_groups'
id = db.Column('id', db.Integer, primary_key=True, autoincrement=True)
class DimScopusFieldGroup(db.Model):
__tablename__ = 'dim_scopus_field_groups'
id = db.Column('id', db.Integer, primary_key=True, autoincrement=True)
class DimUniversityGroup(db.Model):
__tablename__ = 'dim_university_groups'
id = db.Column('id', db.Integer, primary_key=True, autoincrement=True)