Untitled
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