ParkNWash Sep - Laravel Schema Designer

employee

id increments
timestamps timestamps
softDeletes softDeletes
country_id integer
mall_id integer
name_en string
name_ar string
job_description_id integer
nationality_id integer
gender enum
birthdate date
status enum
email string
phone string
address_en string
address_ar string
employee_code string
join_date datetime
main_salary double
civil_id string
national_id string
entrance_date datetime
passport_id string
residence_at datetime
residence_end datetime
passport_end_date datetime
work_status enum
bank_id integer
account_number string (300)
beneficiary_name string (300)
iban string (200)
swift string

job_description

id increments
timestamps timestamps
softDeletes softDeletes
name_en string
name_ar string

allowance_type

id increments
timestamps timestamps
softDeletes softDeletes
name_en string
name_ar string

allowance

id increments
timestamps timestamps
softDeletes softDeletes
country_id integer
mall_id integer
type_id integer
employee_id integer
amount double
calculation_method enum

employee_deduction_type

id increments
timestamps timestamps
softDeletes softDeletes
name_en string
name_ar string

nationality

id increments
timestamps timestamps
softDeletes softDeletes
name_en string
name_ar string

employee_deduction

id increments
timestamps timestamps
softDeletes softDeletes
country_id integer
mall_id integer
type_id integer
employee_id integer
amount double
calculation_method enum

reason_to_leave

id increments
timestamps timestamps
softDeletes softDeletes
name_en string
name_ar string

employee_termination

id increments
timestamps timestamps
softDeletes softDeletes
country_id integer
mall_id integer
employee_id integer
reason_id integer
date datetime
bonus double
notes_en text
notes_ar text

payroll

id increments
timestamps timestamps
softDeletes softDeletes
country_id integer
mall_id integer
account_id integer
month enum
year integer
employee_number integer
total double
payment_date datetime
description_en text
description_ar text

payroll_employee

id increments
timestamps timestamps
softDeletes softDeletes
country_id integer
mall_id integer
employee_id integer
payroll_id integer
main_salary double
allowances double
deductions double
bonus double
total double

receipt

id increments
timestamps timestamps
softDeletes softDeletes
country_id integer
mall_id integer
employee_id integer
account_id integer
type enum
date datetime
amount double
allocate string
allocate_id integer

account

id increments
timestamps timestamps
softDeletes softDeletes
country_id integer
mall_id integer
type_id integer
name_en string
name_ar string
description_en text
description_ar text
balance double
initial_balance double

vacation_type

id increments
timestamps timestamps
softDeletes softDeletes
name_en string
name_ar string

vacation

id increments
timestamps timestamps
softDeletes softDeletes
country_id integer
mall_id string
employee_id integer
type_id integer
start_at datetime
end_at datetime
status enum
application_date datetime
amount double

attendees

id increments
timestamps timestamps
softDeletes softDeletes
country_id integer
mall_id integer
employee_id integer
date datetime
type enum

custody_category

id increments
timestamps timestamps
softDeletes softDeletes
name_en string
name_ar string

custody_data

id increments
timestamps timestamps
softDeletes softDeletes
name_en string
name_ar string
category_id integer

custody

id increments
timestamps timestamps
softDeletes softDeletes
country_id integer
mall_id integer
employee_id integer
category_id integer
data_id integer
notes_en text
notes_ar text
number integer
date datetime
status enum

custody_movement

id increments
timestamps timestamps
softDeletes softDeletes
custody_id integer
date datetime
movement enum

account_type

id increments
timestamps timestamps
softDeletes softDeletes
name_en string
name_ar string

transaction

id increments
timestamps timestamps
softDeletes softDeletes
country_id integer
mall_id integer
date datetime
account_id integer
type string
description_en text
description_ar text
debit double
credit double
balance double

loan_type

id increments
timestamps timestamps
softDeletes softDeletes
name_en string
name_ar string

deduction_type

id increments
timestamps timestamps
softDeletes softDeletes
name_en string
name_ar string

bonus_type

id increments
timestamps timestamps
softDeletes softDeletes
name_en string
name_ar string

loan

id increments
timestamps timestamps
softDeletes softDeletes
country_id integer
mall_id integer
employee_id integer
account_id integer
type_id integer
amount double
date datetime
status enum
notes_en text
notes_ar text

deduction

id increments
timestamps timestamps
softDeletes softDeletes
account_id integer
country_id integer
mall_id integer
employee_id integer
type_id integer
amount double
date datetime
status enum
notes_en text
notes_ar text

bonus

id increments
timestamps timestamps
softDeletes softDeletes
account_id integer
country_id integer
mall_id integer
employee_id integer
type_id integer
amount double
date datetime
status enum
notes_en text
notes_ar text

bank

id increments
timestamps timestamps
name_en string (200)
name_ar string (200)

job_card

id increments
timestamps timestamps
employee_id integer
date date
total double
orders_count integer