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 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 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 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 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'))