El Farouk - Laravel Schema Designer

employees

id increments
timestamps timestamps
softDeletes softDeletes
first_name string
middle_name string
last_name string
family_name string
national_id string
birth_address string
birth_city string
birth_date datetime
join_date datetime
gender enum
health_status enum
social_status enum
military_treatment enum
military_summons string

phones

id increments
timestamps timestamps
employee_id ^FK bigInteger
number string

qualifications

id increments
timestamps timestamps
qualification_name string

employee_qualification

id increments
timestamps timestamps
employee_id ^FK bigInteger
qualification_id ^FK bigInteger
qualification_date datetime
qualification_round enum
qualification_degree string
qualification_major string
qualification_source string

job_history

id increments
timestamps timestamps
softDeletes softDeletes
date datetime
employee_id ^FK bigInteger
job_function_id ^FK bigInteger
financial_degree_id ^FK bigInteger
degree_date datetime
job_style_id ^FK bigInteger
cadre enum
job_status enum
nomination_type_id ^FK bigInteger

job_functions

id increments
timestamps timestamps
sub_group_id ^FK bigInteger
name string

functional_groups

id increments
timestamps timestamps
name string

financial_degrees

id increments
timestamps timestamps
name string
code string

childrens

id increments
timestamps timestamps
softDeletes softDeletes
name string
gender enum
birth_date datetime
employee_id ^FK bigInteger

residence_address

id increments
timestamps timestamps
softDeletes softDeletes
address string
employee_id ^FK bigInteger

languages

id increments
timestamps timestamps
name string
level enum
employee_id ^FK bigInteger

sub_groups

id increments
timestamps timestamps
name string
functional_group_id ^FK bigInteger

job_styles

id increments
timestamps timestamps
title string

teacher_degrees

id increments
timestamps timestamps
title string

nomination_types

id increments
timestamps timestamps
title string

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