class Departmant(db.Model):
__bind_key__ = 'hrms'
__tablename__ = 'departmant'
ID = db.Column(db.BigInteger, primary_key=True)
DEPARTMENT_NAME = db.Column(db.String(255))
DC_LEAD = db.Column(db.String(50))
class User(db.Model):
__tablename__ = 'user'
id = db.Column(db.Integer, primary_key=True, autoincrement=True)
username = db.Column('email_Id', db.String(255), nullable=False )
#This property should return True if this is an active user - in addition to being authenticated, they also have activated their account, not been suspended, or any condition your application has for rejecting an account. Inactive accounts may not log in (without being forced of course).
is_active = db.Column(db.Integer, nullable=False )
#This property should return True if the user is authenticated, i.e. they have provided valid credentials. (Only authenticated users will fulfill the criteria of login_required.)
# is_authenticated = db.Column(db.Integer, nullable=False )
#This property should return True if this is an anonymous user. (Actual users should return False instead.)
is_anonymous = db.Column(db.Integer, nullable=False )
is_admin = db.Column(db.Integer, nullable=False )
def get_id(self) :
return( str(self.id).encode("utf-8").decode("utf-8") )
def __init__(self,id,username,is_active,is_anonymous, is_admin ):
self.username = username
self.id = id
self.is_active = is_active
self.is_anonymous = is_anonymous
self.is_admin = is_admin
def save(self) :
#print("Saving: %s as %d" % (self.username, self.is_authenticated))
db.session.commit()
class Quotefile(db.Model):
__bind_key__ = 'hrms'
__tablename__ = 'quotefiles'
id = db.Column(db.BigInteger, primary_key=True)
quoteFileName = db.Column(db.String(255))
fileData = db.Column(LONGBLOB)
class ClaimApprover(db.Model):
__bind_key__ = 'hrms'
__tablename__ = 'claim_approver'
approver_name = db.Column(db.String(255), primary_key=True)
employee_id = db.Column(db.String(255))
Team = db.Column(db.String(255), nullable=False)
class Activity(db.Model):
__bind_key__ = 'goalsheet'
id = db.Column(db.Integer, unique=True, nullable=False, primary_key=True)
description = db.Column(db.String(1000), nullable=False)
task = db.Column(db.Integer, db.ForeignKey("task.id"))
goalSheetId = db.Column(db.Integer, db.ForeignKey("goal_sheet.id"))
class FilesUpload(db.Model):
__bind_key__ = 'hrms'
__tablename__ = 'files_upload'
FILE_ID = db.Column(db.BigInteger, primary_key=True)
FILE_DATA = db.Column(TINYBLOB)
FILE_NAME = db.Column(db.String(255))
class City(db.Model):
__bind_key__ = 'hrms'
__tablename__ = 'cities'
id = db.Column(db.Integer, primary_key=True)
name = db.Column(db.String(30), nullable=False)
state_id = db.Column(db.Integer, nullable=False, index=True)
class ItemsKitchenSink(db.Model):
__bind_key__ = 'skillstree'
id = db.Column(db.Integer, unique=True, nullable=False, primary_key=True )
title = db.Column(db.String(240), nullable=False )
description = db.Column(db.String(1000), nullable=False )
parentId = db.Column(db.Integer, nullable=False ) #Not using foriegn key into the same table..too many bugs in MySql
class TravelDetail(db.Model):
__bind_key__ = 'hrms'
__tablename__ = 'travel_details'
travel_request_id = db.Column(db.String(255), primary_key=True)
employee_id = db.Column(db.String(255), nullable=False)
status = db.Column(db.String(255))
approver_emp_id = db.Column(db.String(255))
class Country(db.Model):
__bind_key__ = 'hrms'
__tablename__ = 'country'
ID = db.Column(db.BigInteger, primary_key=True)
COUNTRY_NAME = db.Column(db.String(255))
CURRENCY = db.Column(db.String(255))
COUNTRY_DETAILS = db.Column(db.String(5000))
class Empassetfile(db.Model):
__bind_key__ = 'hrms'
__tablename__ = 'empassetfiles'
id = db.Column(db.BigInteger, primary_key=True)
empAssetList = db.Column(db.String(255))
agreementFileName = db.Column(db.String(255))
agreementCopy = db.Column(LONGBLOB)
class ExpenseApprover(db.Model):
__bind_key__ = 'hrms'
__tablename__ = 'expense_approver'
Id = db.Column(db.Integer, primary_key=True)
APPROVER_TEAM = db.Column(db.String(45))
APPROVER_NAME = db.Column(db.String(45))
EMPLOYEE_ID = db.Column(db.String(45))
class Pofile(db.Model):
__bind_key__ = 'hrms'
__tablename__ = 'pofiles'
id = db.Column(db.BigInteger, primary_key=True)
poNumber = db.Column(db.String)
poLetter = db.Column(LONGBLOB)
createdDate = db.Column(db.Date)
class Emprolemapping(db.Model):
__bind_key__ = 'hrms'
__tablename__ = 'emprolemapping'
id = db.Column(db.BigInteger, primary_key=True)
roleId = db.Column(db.Integer)
empId = db.Column(db.BigInteger)
emailId = db.Column(db.String(255))
class Skill(db.Model):
__bind_key__ = 'hrms'
__tablename__ = 'skills'
ID = db.Column(db.BigInteger, primary_key=True)
name = db.Column(db.String(500))
SKILL_TYPE_ID = db.Column(db.ForeignKey('skill_type.ID'), index=True)
skill_type = db.relationship('SkillType', primaryjoin='Skill.SKILL_TYPE_ID == SkillType.ID', backref='skills')
class FamilyRelation(db.Model):
__bind_key__ = 'hrms'
__tablename__ = 'family_relation'
id = db.Column(db.Integer, primary_key=True)
relationship = db.Column(db.String(255))
immigration_request_id = db.Column(db.ForeignKey('immigration_request.immigration_request_id'), nullable=False, index=True)
immigration_request = db.relationship('ImmigrationRequest', primaryjoin='FamilyRelation.immigration_request_id == ImmigrationRequest.immigration_request_id', backref='family_relations')
class ExpenseType(db.Model):
__bind_key__ = 'hrms'
__tablename__ = 'expense_type'
id = db.Column(db.Integer, primary_key=True)
expense_type = db.Column(db.String(100))
expense_group_id = db.Column(db.ForeignKey('expense_group.id', ondelete='CASCADE'), index=True)
expense_group = db.relationship('ExpenseGroup', primaryjoin='ExpenseType.expense_group_id == ExpenseGroup.id', backref='expense_types')
class State(db.Model):
__bind_key__ = 'hrms'
__tablename__ = 'state'
ID = db.Column(db.BigInteger, primary_key=True)
name = db.Column(db.String(500))
COUNTRY_ID = db.Column(db.ForeignKey('country.ID'), index=True)
country = db.relationship('Country', primaryjoin='State.COUNTRY_ID == Country.ID', backref='states')
class SkillType(db.Model):
__bind_key__ = 'hrms'
__tablename__ = 'skill_type'
ID = db.Column(db.BigInteger, primary_key=True)
name = db.Column(db.String(500))
SKILL_CATEGORY_ID = db.Column(db.ForeignKey('skill_category.ID'), index=True)
skill_category = db.relationship('SkillCategory', primaryjoin='SkillType.SKILL_CATEGORY_ID == SkillCategory.ID', backref='skill_types')
class VisaType(db.Model):
__bind_key__ = 'hrms'
__tablename__ = 'visa_type'
ID = db.Column(db.BigInteger, primary_key=True)
name = db.Column(db.String(500))
COUNTRY_ID = db.Column(db.ForeignKey('country.ID'), nullable=False, index=True)
country = db.relationship('Country', primaryjoin='VisaType.COUNTRY_ID == Country.ID', backref='visa_types')
class DegreeType(db.Model):
__bind_key__ = 'hrms'
__tablename__ = 'degree_type'
ID = db.Column(db.BigInteger, primary_key=True)
NAME = db.Column(db.String(500))
QUALIFICATION_TYPE_ID = db.Column(db.ForeignKey('qualification_type.ID'), index=True)
qualification_type = db.relationship('QualificationType', primaryjoin='DegreeType.QUALIFICATION_TYPE_ID == QualificationType.ID', backref='degree_types')
class Contact(db.Model):
__bind_key__ = 'hrms'
__tablename__ = 'contacts'
ID = db.Column(db.Integer, primary_key=True)
EMAIL = db.Column(db.String(255))
FIRSTNAME = db.Column(db.String(255))
LASTNAME = db.Column(db.String(255))
TELEPHONE = db.Column(db.String(255))
class Assetsubcategory(db.Model):
__bind_key__ = 'hrms'
__tablename__ = 'assetsubcategory'
id = db.Column(db.Integer, primary_key=True)
categoryId = db.Column(db.ForeignKey('assetcategory.id'), index=True)
subCategory = db.Column(db.String)
assetcategory = db.relationship('Assetcategory', primaryjoin='Assetsubcategory.categoryId == Assetcategory.id', backref='assetsubcategories')
class CertificationNameType(db.Model):
__bind_key__ = 'hrms'
__tablename__ = 'certification_name_type'
ID = db.Column(db.BigInteger, primary_key=True)
name = db.Column(db.String(500))
CERTIFICATION_TYPE_ID = db.Column(db.ForeignKey('certification_type.ID'), index=True)
certification_type = db.relationship('CertificationType', primaryjoin='CertificationNameType.CERTIFICATION_TYPE_ID == CertificationType.ID', backref='certification_name_types')
class SeparationTask(db.Model):
__bind_key__ = 'hrms'
__tablename__ = 'separation_task'
task_id = db.Column(db.BigInteger, primary_key=True)
checklist = db.Column(db.String(255))
description = db.Column(db.String(255))
#mandatory = db.Column(BIT(1))
task_type = db.Column(db.String(255))
class TemplateGoalList(
db.Model
): # A list of goals from Master, that should be copied for a givem Template
__bind_key__ = 'goalsheet'
id = db.Column(db.Integer, unique=True, nullable=False,
primary_key=True) # Template ID
templateId = db.Column(db.Integer, db.ForeignKey("assignment_template.id"))
mastergoalId = db.Column(db.Integer, db.ForeignKey("master_goal.id"))
class AssignmentTemplate(db.Model):
__bind_key__ = 'goalsheet'
id = db.Column(db.Integer, unique=True, nullable=False, primary_key=True)
title = db.Column(
db.String(240), nullable=False
) # Name of the template .e.g. Principal Consultant Goals
description = db.Column(db.String(1000),
nullable=False) # Description of the template
finalized = db.Column(db.Boolean(), default=False)
class EmployeeProject(db.Model):
__bind_key__ = 'hrms'
__tablename__ = 'employee_project'
project_name = db.Column(db.String(255), primary_key=True)
approver_emp_id = db.Column(db.ForeignKey('travel_approver.employee_id'), nullable=False, index=True)
customer_name = db.Column(db.ForeignKey('project_customer.customer_name'), nullable=False, index=True)
approver_emp = db.relationship('TravelApprover', primaryjoin='EmployeeProject.approver_emp_id == TravelApprover.employee_id', backref='employee_projects')
project_customer = db.relationship('ProjectCustomer', primaryjoin='EmployeeProject.customer_name == ProjectCustomer.customer_name', backref='employee_projects')
class HotelList(db.Model):
__bind_key__ = 'hrms'
__tablename__ = 'hotel_list'
id = db.Column(db.String(255), primary_key=True)
hotel_name = db.Column(db.String(255))
star_rating = db.Column(db.String(255))
cityId = db.Column(db.ForeignKey('cities.id'), nullable=False, index=True)
city = db.relationship('City', primaryjoin='HotelList.cityId == City.id', backref='hotel_lists')
class ManagerInfo(db.Model):
__bind_key__ = 'hrms'
__tablename__ = 'manager_info'
ID = db.Column(db.BigInteger, primary_key=True)
name = db.Column(db.String(500))
departMent_Id = db.Column(db.ForeignKey('departmant.ID'), nullable=False, index=True)
emp_id = db.Column(db.String(50), unique=True)
departmant = db.relationship('Departmant', primaryjoin='ManagerInfo.departMent_Id == Departmant.ID', backref='manager_infos')
