Scribd Logo
Upload

Welcome to Scribd!

  • 5 views

    Erp HR

    Uploaded by

    Soumen Datta
    This document contains an entity relationship diagram (ERD) showing the relationships between various tables in a human resources database. The ERD includes tables for employees, departments, jobs, attendance records, bank details, appraisals, dependents and more. Lines connect the tables to show foreign key relationships. Primary and foreign keys are indicated for each table.

    Copyright:

    Attribution Non-Commercial (BY-NC)
    Download as PDF, TXT or read online from Scribd

    Erp HR

    Uploaded by

    Soumen Datta
    5 views2 pages
    This document contains an entity relationship diagram (ERD) showing the relationships between various tables in a human resources database. The ERD includes tables for employees, departments, jobs, attendance records, bank details, appraisals, dependents and more. Lines connect the tables to show foreign key relationships. Primary and foreign keys are indicated for each table.

    Original Title

    ERP_HR

    Copyright

    © Attribution Non-Commercial (BY-NC)

    Available Formats

    PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    This document contains an entity relationship diagram (ERD) showing the relationships between various tables in a human resources database. The ERD includes tables for employees, departments, jobs, attendance records, bank details, appraisals, dependents and more. Lines connect the tables to show foreign key relationships. Primary and foreign keys are indicated for each table.

    Copyright:

    Attribution Non-Commercial (BY-NC)
    Download as PDF, TXT or read online from Scribd
    Download as pdf or txt
    5 views2 pages

    Erp HR

    Uploaded by

    Soumen Datta
    This document contains an entity relationship diagram (ERD) showing the relationships between various tables in a human resources database. The ERD includes tables for employees, departments, jobs, attendance records, bank details, appraisals, dependents and more. Lines connect the tables to show foreign key relationships. Primary and foreign keys are indicated for each table.

    Copyright:

    Attribution Non-Commercial (BY-NC)
    Download as PDF, TXT or read online from Scribd
    Download as pdf or txt
    You are on page 1of 2

    [1,1]

    HR_EMP_DETAILS_VIEW LIABILITIES PAYMENT EXPENSE RECEIPT INCOME

    HR_DEPARTMENTS HR_COUNTRIES HR_JOBS


    ASSETS DEPARTMENT_ID NN (PK) COUNTRY_ID NN (PK) JOB_ID NN (PK)
    DEPARTMENT_NAME COUNTRY_NAME JOB_TITLE
    MANAGER_ID REGION_ID MIN_SALARY
    LOCATION_ID MAX_SALARY

    HR_EMPSTATUS HR_JOB_HISTORY HR_LEAVEDAYS


    STATUSID NN (PK) EMPLOYEE_ID NN (PFK) (IX2) ID NN (PK)
    STATUS NN START_DATE NN (PK) USERID_FK
    END_DATE ENTITLEDDAYS
    JOB_ID (FK) (IX3) TAKENDAYS
    DEPARTMENT_ID (FK) (IX1) LEAVEBALANCE

    HR_LEAVETYPES HR_APPRAISALS HR_DEPENDANTS


    TYPEID NN (PK) EMPID_FK EMPLOYEEID NN (PK)
    LEAVETYPE APPDATE MNAME
    TOTALDAYS APPCOMMENTS FNAME NN
    JOBGRPFROM APPRAISER LNAME NN
    JOBGRPTO APPRESULT GENDER NN
    REVIWER DOB NN
    EMPLOYEEID_FK NN
    [1,2]

    FIN_BANK_MST HR_EMPLOYEES HR_ATTENDANCE_REC


    BANK_ID (PK) EMPLOYEE_ID NN (PK) TRANSNO NN (PK)
    BANK_NAME FIRST_NAME (IX4) EMPLOYEEID
    BRANCH_NAME LAST_NAME (IX4) CATEGORY NN
    ADDRESS1 EMAIL (AK1) ENTRYDATE
    ADDRESS2 PHONE_NUMBER TRANSDATE
    ADDRESS3 HIRE_DATE TIMEIN
    PHONE_NO JOB_ID (FK) (IX2) TIMEOUT
    SALARY NOHRS NN
    COMMISSION_PCT ADJ_NOHRS NN
    MANAGER_ID (FK) (IX3) ADDCOMMENT NN
    DEPARTMENT_ID (FK) (IX1) TIMESTAMP NN
    POSTED NN
    PERIOD NN

    You might also like