ER диаграмма базы данных Employee

This ER diagram shows the main entities and foreign key relationships for the Employee database.

Employee Database ERD Entity relationship diagram for Employee DB, laid out to minimize connector crossings with equal-width table blocks. COUNTRY PKCOUNTRY CURRENCY JOB PKJOB_CODE JOB_GRADE FKJOB_COUNTRY -> COUNTRY JOB_TITLE MIN_SALARY MAX_SALARY JOB_REQUIREMENT LANGUAGE_REQ DEPARTMENT PKDEPT_NO FKHEAD_DEPT -> DEPARTMENT DEPARTMENT BUDGET LOCATION PHONE_NO MNGR_NO (no FK in template) CUSTOMER PKCUST_NO FKCOUNTRY -> COUNTRY CUSTOMER CONTACT_FIRST CONTACT_LAST PHONE_NO ADDRESS_LINE1 ADDRESS_LINE2 CITY STATE_PROVINCE POSTAL_CODE ON_HOLD EMPLOYEE PKEMP_NO FKDEPT_NO -> DEPARTMENT FKJOB_CODE -> JOB FIRST_NAME PHONE_EXT LAST_NAME HIRE_DATE JOB_GRADE JOB_COUNTRY SALARY FULL_NAME PROJECT PKPROJ_ID FKTEAM_LEADER -> EMPLOYEE PROJ_NAME PROJ_DESC PRODUCT SALES PKPO_NUMBER FKCUST_NO -> CUSTOMER FKSALES_REP -> EMPLOYEE ORDER_STATUS ORDER_DATE SHIP_DATE DATE_NEEDED PAID QTY_ORDERED TOTAL_VALUE DISCOUNT ITEM_TYPE AGED SALARY_HISTORY PKFKEMP_NO -> EMPLOYEE PKCHANGE_DATE UPDATER_ID OLD_SALARY PERCENT_CHANGE NEW_SALARY EMPLOYEE_PROJECT PKFKEMP_NO -> EMPLOYEE PKFKPROJ_ID -> PROJECT PROJ_DEPT_BUDGET PKFISCAL_YEAR PKFKPROJ_ID -> PROJECT PKFKDEPT_NO -> DEPARTMENT QUART_HEAD_CNT PROJECTED_BUDGET N:1 N:1 N:1 N:1 N:1 N:1 N:1 N:1 N:1 N:1 N:1 N:1 N:1 Legend PKPrimary key FKForeign key Child table points to parent table All table blocks are equal width (300 px) Columns shown one per row