hrms - Laravel Schema Designer

candidate

id increments
first_name string (100)
last_name string (100)
date_of_birth date

contract_types

id increments
name string
created_at date
updated_at date
deleted_at string
employee_id ^FK integer

time

id increments
note string
start_date date
end_date date
status string
user_id ^FK integer

users

id increments
first_name string
last_name string
email string
password string
gendre string
birth_date date
adresse string
diplome string
tel longText
cv string
id_role ^FK integer
id_fiche ^FK integer
id_leave ^FK integer
contract_id ^FK integer

Roles

role_id increments
name string
description string

Permession

id increments
name string
description string

Permession_Role

id_role ^FK integer
id_permession ^FK integer

documents

id increments
name string
description string
user_id ^FK integer
attachement string
created_at date
updated_at date
deleted_at date

user_leaves

id increments
user_id ^FK integer
start_date date
end_date date
leave_type_id ^FK integer

salaires

id increments
gross_total float
nett_total float
payment_date date
user_id ^FK integer
created_at date
updated_at date
deleted_at date

leave_types

id increments
name string
availble_days integer
start_date date
end_date date
created_at date
updated_at date
deleted_at date

salary_components

id increments
name string
contract_type_id ^FK integer
cnss float
IRPP float
contribution_cnss float
logs_id ^FK integer

salaries_salary_components

id increments
salary_id ^FK integer
id_salaire_composant ^FK integer
created_at date
updated_at date
deleted_at date

Laravel Schema Designer v0.7.1 follow me on twitter @okyn01