---
tags: [hr, database]
module: HR
---

# DatabaseTables

## Connections
[[_HR]] · [[[Model]Employee]] · [[[Model]Position]] · [[[Model]PayrollEntry]] · [[[Model]Account]] · [[[Model]JournalEntry]] · [[[Model]FiscalYear]] · [[[Model]User]]

## Source
`Modules/HR/Database/Migrations/tenancy/`

## `employees`
`id` · `name` · `email` · `mobile` · `country_code` · `cost_account_id` → [[[Model]Account]] · soft_deletes

## `positions`
`id` · `name_en` · `name_ar` · soft_deletes

## `employee_position`
`id` · `employee_id` → [[[Model]Employee]] · `position_id` → [[[Model]Position]] · `salary` (decimal 11,2) · `effective_date` · soft_deletes

## `payroll_entries`
`id` · `year_id` → [[[Model]FiscalYear]] · `date` · `month` · `year` · `payment_account_id` → [[[Model]Account]] · `journal_entry_id` → [[[Model]JournalEntry]] · `created_by` → [[[Model]User]] · soft_deletes

## `payroll_entry_details`
`id` · `payroll_entry_id` → [[[Model]PayrollEntry]] · `employee_id` → [[[Model]Employee]] · `salary_amount` (decimal 11,2) · `description` · `created_by` → [[[Model]User]] · soft_deletes