UserProfile

const Sequelize = require('sequelize');

// Import Premade Connector
const sequelize = require('./DBConfigs');

// Import Sequelize Model Class To Extend It
const Model = Sequelize.Model;

class UserProfile extends Model{}

// Defining Model
UserProfile.init({
   UserId:{
       type: Sequelize.STRING(100),
       primaryKey: true,
       allowNull: false
   },
   Role:{
       type: Sequelize.STRING(50),
       allowNull: true
   },
   Name:{
    type: Sequelize.STRING(100),
    allowNull: true
   },
   Known_as:{
    type: Sequelize.STRING(20),
    allowNull: true,
    },
    EmailId:{
        type: Sequelize.STRING(50),
        allowNull: true
    },
    TelNo:{
        type: Sequelize.STRING(25)
    },
    Title:{
        type: Sequelize.STRING(50)
    },
    MakerCode:{
        type: Sequelize.STRING(50)
    },
    makerDateTime:{
        type: Sequelize.DATE
    },
    Password:{
        type: Sequelize.STRING(256)
    },
    Active:{
        type: Sequelize.DECIMAL(18)
    },
    Qualifications:{
        type: Sequelize.STRING(256)
    },
    Stream:{
        type: Sequelize.STRING(256)
    },
    College:{
        type: Sequelize.STRING(256)
    },
    University:{
        type: Sequelize.STRING(256)
    },
    Persantage:{
        type: Sequelize.DECIMAL(18)
    },
    perm_Address:{
        type: Sequelize.STRING(256)
    },
    Current_Address:{
        type: Sequelize.STRING(256)
    },
    Phone_No:{
        type: Sequelize.DECIMAL(18)
    },
    DOB:{
        type: Sequelize.DATE
    },
    DOJ_In_Clg:{
        type: Sequelize.DATE
    },
    Confrm_Date:{
        type: Sequelize.DATE
    },
    Gender:{
        type: Sequelize.STRING(256)
    },
    Previous_Exp:{
        type: Sequelize.DECIMAL(18)
    },
    Last_Employer:{
        type: Sequelize.STRING(256)
    },
    Last_Emp_Address:{
        type: Sequelize.STRING(256)
    },
    Mob_No:{
        type: Sequelize.DECIMAL(18)
    },
    Experience:{
        type: Sequelize.STRING(256)
    },
    Date_Of_Proj_Joining:{
        type: Sequelize.DATE
    },
    Service_Type:{
        type: Sequelize.STRING(256)
    },
    Blood_Group:{
        type: Sequelize.STRING(256)
    },
    EM_Report_To_Emp:{
        type: Sequelize.STRING(256)
    },
    Flag:{
        type: Sequelize.CHAR(10)
    },
    EM_Org_Code:{
        type: Sequelize.CHAR(50)
    },
    EM_Confirm_Status:{
        type: Sequelize.CHAR(1)
    },
    EM_Effect_Dt_To:{
        type: Sequelize.DATE
    },
    EM_Holiday_Code:{
        type: Sequelize.STRING(50)
    },
    EM_WeeklyOff_Code:{
        type: Sequelize.STRING(50)
    },
    Branch_ID:{
        type: Sequelize.DECIMAL(18)
    },
    CL_Col_Id:{
        type: Sequelize.DECIMAL(18)
    },
    Class_Type:{
        type: Sequelize.STRING(50)
    },
    AttendFlag:{
        type: Sequelize.STRING(100)
    },
    Shiftids:{
        type: Sequelize.DECIMAL(18)
    },
    Shift_Start_HH:{
        type: Sequelize.DECIMAL(18)
    },
    Shift_END_HH:{
        type: Sequelize.DECIMAL(18)
    },
    Shift_Start_MM:{
        type: Sequelize.DECIMAL(18)
    },
    Shift_END_MM:{
        type: Sequelize.DECIMAL(18)
    },
    empAtt:{
        type: Sequelize.CHAR(1)
    },
    PunChId:{
        type: Sequelize.STRING(500)
    },
    Faculty_Unique_ID:{
        type: Sequelize.STRING(100)
    },
    FatherName:{
        type: Sequelize.STRING(1000)
    },
    MotherName:{
        type: Sequelize.STRING(1000)
    },
    PFNumber:{
        type: Sequelize.STRING(100)
    },
    BankName:{
        type: Sequelize.STRING(100)
    },
    BankBranchName:{
        type: Sequelize.STRING(1000)
    },
    BankAccountNumber:{
        type: Sequelize.STRING(1000)
    },
    IFSCCode:{
        type: Sequelize.STRING(1000)
    },
    PANNumber:{
        type: Sequelize.STRING(500)
    },
    GrossPayPerMonth:{
        type: Sequelize.STRING(500)
    },
    PayScale:{
        type: Sequelize.STRING(500)
    },
    AppointmentType:{
        type: Sequelize.DECIMAL(18)
    },
    Caste:{
        type: Sequelize.DECIMAL(18)
    },
    Religions:{
        type: Sequelize.DECIMAL(18)
    },
    UGDegree:{
        type: Sequelize.DECIMAL(18)
    },
    PGDegree:{
        type: Sequelize.DECIMAL(18)
    },
    HighestDegree:{
        type: Sequelize.DECIMAL(18)
    },
    ExperienceTeaching:{
        type: Sequelize.STRING(500)
    },
    ExperienceIndustry:{
        type: Sequelize.STRING(500)
    },
    ExperienceResearch:{
        type: Sequelize.STRING(500)
    },
    Image_path:{
        type: Sequelize.STRING
    },
    EncriptPassword:{
        type: Sequelize.STRING(500)
    },
    isfirstlogin:{
        type: Sequelize.CHAR(1)
    },
    newphoto:{
        type: Sequelize.STRING
    },
    User_Signature:{
        type: Sequelize.STRING
    },
    Designation_ID:{
        type: Sequelize.DECIMAL(18)
    }
  }, {
    sequelize,
    modelName: 'UserProfile',
    freezeTableName: true,
    timestamps: false
});


module.exports = UserProfile;


// Querry To Get Semester

UserProfile.findOne({
    where:{
        UserId: "0206CS171014"
    }
}).then(data=>{
    console.log(data.dataValues);
});