class LeaveApproval(db.Model):
__tablename__ = 'leave_approval'
approval_id = db.Column(db.Integer, primary_key=True, autoincrement=True)
application_id = db.Column(db.Integer, db.ForeignKey('leave_applications.application_id'), nullable=False)
payroll_no = db.Column(db.Integer, db.ForeignKey('employee_registration.payroll_no'), nullable=False)
next_person_to_approve = db.Column(db.Integer, nullable=False)
aproval_status = db.Column(db.Integer , nullable=False)
note = db.Column(db.String(350), nullable=False)
is_deleted = db.Column(db.Boolean(), default=False)
userid = db.Column(db.Integer, nullable=False,default='001')
editor = db.Column(db.String(20), nullable=True,default='001')
date_created = db.Column(db.DateTime, nullable=True, default=now)
date_updated = db.Column(db.DateTime, nullable=True, default=now)
def __repr__(self):
return self.approval_id
class LeaveReliever(db.Model):
__tablename__ = 'leave_reliever'
reliever_id = db.Column(db.Integer, primary_key=True, autoincrement=True)
leave_id = db.Column(db.Integer, db.ForeignKey('leave_types.leave_id'), nullable=False)
payroll_no = db.Column(db.Integer, db.ForeignKey('employee_registration.payroll_no'), nullable=False)
reliever_payroll_no = db.Column(db.Integer, db.ForeignKey('employee_registration.payroll_no'), nullable=False)
date_from = db.Column(db.Date, nullable=True, default=current_date)
date_to = db.Column(db.Date, nullable=True, default=current_date)
relieve_status = db.Column(db.Integer, default=0, nullable=False)
application_note = db.Column(db.String(300), nullable=True)
date_applied = current_date,
is_deleted = db.Column(db.Boolean(), default=False)
userid = db.Column(db.Integer, nullable=False, default='001')
editor = db.Column(db.String(20), nullable=True, default='001')
date_created = db.Column(db.DateTime, nullable=True, default=now)
date_updated = db.Column(db.DateTime, nullable=True, default=now)
def __repr__(self):
return self.reliever_id
class InitialLeaveBalane(db.Model):
"""Model for the stations table"""
__tablename__ = 'initial_leave_balance'
balance_id = db.Column(db.Integer, primary_key = True)
payroll_no=db.Column(db.Integer, db.ForeignKey('employee_registration.payroll_no'), nullable=False)
initial_balance = db.Column(db.Integer, nullable=False)
is_deleted = db.Column(db.Boolean(), default=False)
userid = db.Column(db.Integer, nullable=False,default='001')
editor = db.Column(db.String(20), nullable=True,default='001')
date_created = db.Column(db.DateTime, nullable=True, default=now)
date_updated = db.Column(db.DateTime, nullable=True, default=now)
class StaffSupervisors(db.Model):
__tablename__ = 'staff_supervisors'
id=db.Column(db.Integer, primary_key=True, autoincrement=True)
supervisor_payroll_no =db.Column(db.Integer , nullable=False)
payroll_no = db.Column(db.Integer, db.ForeignKey('employee_registration.payroll_no'), primary_key=True, nullable=False)
note = db.Column(db.String(350), nullable=True)
is_deleted = db.Column(db.Boolean(), default=False)
userid = db.Column(db.Integer, nullable=False, default='001')
editor = db.Column(db.String(20), nullable=True, default='001')
date_created = db.Column(db.DateTime, nullable=True, default=now)
date_updated = db.Column(db.DateTime, nullable=True, default=now)
class LeaveAuthorization(db.Model):
__tablename__ ='leave_authorization'
auth_id = db.Column(db.Integer, primary_key=True, autoincrement=True)
supervisor_payroll_no = db.Column(db.Integer, db.ForeignKey('employee_registration.payroll_no'), nullable=False)
emp_payroll_no = db.Column(db.Integer, nullable=False)
leave_application_id = db.Column(db.Integer, nullable=False)
leave_id = db.Column(db.Integer, nullable=False)
auth_stage = db.Column(db.Integer, nullable=False)
note = db.Column(db.String(350), nullable=True)
is_deleted = db.Column(db.Boolean(), default=False)
userid = db.Column(db.Integer, nullable=False, default='001')
editor = db.Column(db.String(20), nullable=True, default='001')
date_created = db.Column(db.DateTime, nullable=True, default=now)
date_updated = db.Column(db.DateTime, nullable=True, default=now)
class Cadre(db.Model):
__tablename__ = 'designation'
designation_id = db.Column(db.Integer, primary_key =True,autoincrement=True)
designation_name = db.Column(db.String(100), nullable=False)
description = db.Column(db.String(300), nullable=True)
code = db.Column(db.String(50), nullable=True)
department_id = db.Column(db.Integer, db.ForeignKey('departments.department_id'), nullable=False)
level = db.Column(db.Integer, nullable=False)
is_deleted = db.Column(db.Boolean(), default=False)
userid = db.Column(db.Integer, nullable=False,default='001')
editor = db.Column(db.String(20), nullable=True,default='001')
date_created = db.Column(db.DateTime, nullable=True, default=now)
date_updated = db.Column(db.DateTime, nullable=True, default=now)
def __repr__(self):
return self.designation_id