Untitled

 avatar
unknown
plain_text
2 months ago
5.5 kB
5
Indexable
erDiagram
    EMPLOYEE {
        INT ID_Employee
        STRING Emp_No
        STRING Name
        DATE Birthdate
        INT Nation_ID
        STRING Gender
        INT Religion_ID
        INT Marital_ID
        DATE Join_Date
        DATE Contract_End_Date
        DATE Pension_Date
        STRING Phone_Number
        STRING Id_Card
        STRING Username
        STRING Length_Of_Service
        INT Supervisor_ID
        INT Manager_ID
        INT ID_Corp
        INT ID_BU
        INT ID_Department
    }
    FAMILY_LIST {
        INT ID_Family_Member
        INT ID_Employee
        STRING Family_Member_Name
        STRING Relationship
        STRING Phone_Number
        STRING Address
        BOOL Address_is_same
        STRING New_Address
    }
    EDUCATION {
        INT Education_ID
        INT ID_Employee
        STRING Degree
        STRING Field_Of_Study
        STRING Institution
        DATE Start_Date
        DATE End_Date
        STRING Address
        STRING Country
    }
    MEDICAL_RECORD {
        INT Medical_Record_ID
        INT ID_Employee
        FLOAT Height
        FLOAT Shoes_Size
        FLOAT Weight
        STRING Blood_Type
        FLOAT Head_Size
        STRING Cloth_Size
        STRING Pants_Size
        BOOL Has_Disability
        TEXT Medical_Report
    }
    EXPERIENCE {
        INT Experience_ID
        INT ID_Employee
        STRING Company_Name
        STRING Company_Location
        STRING Line_Of_Business
        STRING Position_Held
        TEXT Job_Description
        STRING Achievement
        DATE Start_Employment_Period
        DATE End_Employment_Period
        FLOAT Initial_Salary
        FLOAT Last_Salary
        STRING Reason_For_Leaving
        STRING Reference_Name
        STRING Contact_Number
    }
    INSURANCE {
        INT Insurance_ID
        INT ID_Employee
        STRING Insurance_Name
        STRING Insurance_Number
        DATE Join_Date
        DATE End_Date
    }
    WORK_DATA {
        INT Work_Data_ID
        INT ID_Employee
        DATE Join_Date
        STRING Contract_Type
        DATE Contract_Start_Date
        DATE Contract_End_Date
        STRING Contract_Status
        STRING Position
        INT ID_BU
        INT ID_Department
        STRING Grade
        STRING Shift
    }
    CORP {
        INT ID_Corp
        STRING Corp_Name
        STRING Corp_Code
    }
    BU {
        INT ID_BU
        STRING BU
        STRING BU_Code
    }
    DEPT {
        INT ID_Department
        STRING Department_Name
        STRING Department_Code
    }
    RELIGION {
        INT Religion_ID
        STRING Religion_Name
        STRING Religion_Code
    }
    MARITAL {
        INT Marital_ID
        STRING Marital_Name
    }
    NATIONALITY {
        INT Nation_ID
        STRING Nation_Name
        STRING Nation_Code
    }
    GMT {
        INT GMT_ID
        STRING GMT_Detail
        STRING GMT_Code
    }
    ADDRESS {
        INT ID_Address
        INT ID_Employee
        STRING Address
        STRING Domicile_Address
        INT Country_ID
        INT Province_ID
        INT City_ID
        INT District_ID
        STRING Telp
        STRING Zip_Code
    }
    COUNTRY {
        INT Country_ID
        STRING Country_Name
        STRING Country_Code
    }
    PROVINCE {
        INT Province_ID
        INT Country_ID
        STRING Province_Name
        STRING Province_Code
    }
    CITY {
        INT City_ID
        INT Province_ID
        STRING City_Name
        STRING City_Code
    }
    DISTRICT {
        INT District_ID
        INT City_ID
        STRING District_Name
        STRING District_Code
    }
    EMERGENCY {
        INT ID_Employee
        STRING Contact_Person
        INT Relationship_ID
        STRING Phone
        BOOL Address_is_same
        INT ID_Address
        STRING Address
        STRING Domicile_Address
        INT Country_ID
        INT Province_ID
        INT City_ID
        INT District_ID
    }
    RELATIONSHIP {
        INT Relationship_ID
        STRING Relationship_Name
        STRING Relationship_Code
    }

    EMPLOYEE ||--o| CORP : "belongs to"
    EMPLOYEE ||--o| BU : "belongs to"
    EMPLOYEE ||--o| DEPT : "belongs to"
    EMPLOYEE ||--o| RELIGION : "follows"
    EMPLOYEE ||--o| MARITAL : "has"
    EMPLOYEE ||--o| NATIONALITY : "is"
    EMPLOYEE ||--o| GMT : "works in"
    EMPLOYEE ||--o| EMPLOYEE : "supervised by"
    EMPLOYEE ||--o| EMPLOYEE : "manages"
    EMPLOYEE ||--o| ADDRESS : "has"
    EMPLOYEE ||--o| FAMILY_LIST : "has family members"
    EMPLOYEE ||--o| EMERGENCY : "has emergency contact"
    EMPLOYEE ||--o| EDUCATION : "has education history"
    EMPLOYEE ||--o| MEDICAL_RECORD : "has medical record"
    EMPLOYEE ||--o| EXPERIENCE : "has work experience"
    EMPLOYEE ||--o| INSURANCE : "has insurance data"
    EMPLOYEE ||--o| WORK_DATA : "has work data"
    FAMILY_LIST ||--o| ADDRESS : "has address"
    EMERGENCY ||--o| RELATIONSHIP : "has relationship"
    EMERGENCY ||--o| COUNTRY : "located in"
    EMERGENCY ||--o| PROVINCE : "in province"
    EMERGENCY ||--o| CITY : "in city"
    EMERGENCY ||--o| DISTRICT : "in district"
    EDUCATION ||--o| COUNTRY : "in country"
    ADDRESS ||--o| COUNTRY : "located in"
    ADDRESS ||--o| PROVINCE : "in province"
    ADDRESS ||--o| CITY : "in city"
    ADDRESS ||--o| DISTRICT : "in district"
Editor is loading...
Leave a Comment