{"repo":"gdsotirov/hr_schema","free":true,"listed":false,"github":"https://github.com/gdsotirov/hr_schema","clone":"git clone https://github.com/gdsotirov/hr_schema.git","description":"An example HR database for management of company's organization, employees, etc.","language":"SQL","stars":13,"topics":["database","sql","mysql"],"license":"GPL-2.0","category":"databases-storage","readme_excerpt":"# HR Schema An example HR database for management of company's organization (departments, divisions, locations), party (persons and relations), recruitment (jobs offers and candidates), employees (absences, appraisals, job and team history), remuneration (salary history, bonuses and distribution), etc. Database structure The database holds information for several domains as follows. Company organization Defines company's organization structure. Includes the following 5 tables: countries - list of countries where the company has activities; departments - departments register; divisions - company's divisions; locations - locations of company's offices, warehouses, etc.; regions - list of country regions where the company has activities. Employee management Defines employees and related data. Includes the following 11 tables: absence totals - defines the maximum days per absence type, user or division to be used in a calendar year; absence types - types of possible absences; absences - register of employees absences; appraisal period types - type of appraisals by period; appraisal types - type of appraisals; appraisals - employees appraisals; division change - employees division change register; employees - catalog of company's most valuable resources job history - employees job changes; memos - notes on employees behavior, attitude, problems, etc.; team change - employees team change history. Foreign exchange Defines currencies and rates. Includes the following 2 tables: curr r","default_branch":null,"files":null,"tree":[],"storefront":"/r/gdsotirov","claimed":false,"request_supported":{"post":"https://gitbuyer.com/r/gdsotirov/hr_schema/request-supported","requests":0},"note":"indexed from public GitHub; nothing is for sale on this page. Clone it from GitHub. Paid listings live at /search."}