Human_Resource - Laravel Schema Designer

employees

id increments
first_name string (250)
second_name string (250)
third_name string (250)
fourth_name string (250)
family_name string (250)
birthdate date
first_name_en string (150)
second_name_en string (150)
third_name_en string (150)
fourth_name_en string (150)
mother_first_name string (150)
mother_second_name string (150)
mother_third_name string (150)
image longText
active smallInteger
email string (150)
phone string (20)
gender tinyInteger
nationality_id ^FK integer
country_id ^FK integer
category_id ^FK integer
blood_type smallInteger
nationalism_id ^FK integer
marital_status tinyInteger
classification_id ^FK integer
timestamps timestamps
softDeletes softDeletes

nationalitys

id increments
name string (150)
timestamps timestamps
softDeletes softDeletes

countrys

id increments
name string (150)
timestamps timestamps
softDeletes softDeletes

categories

id increments
parint_id integer
name string (300)
name_en string
timestamps timestamps
softDeletes softDeletes
type smallInteger

structure_type

id increments
name string
timestamps timestamps

studies

id increments
employee_id ^FK integer
academic_year string
academic_achievement_id ^FK integer
timestamps timestamps
softDeletes softDeletes

academic_achievements

id increments
name string
timestamps timestamps

academic_title

id increments
name string
year string
employee_id ^FK integer
timestamps timestamps

nationalisms

id increments
name string
timestamps timestamps

employee_identities

id increments
employee_id ^FK integer
category_id ^FK integer
identity_code string (20)
expiry_date date
timestamps timestamps
softDeletes softDeletes
category_name string
category_name_en string
job_name string
job_name_en string

job_informations

id increments
category_id integer
job_title string (255)
job_title_en string
employee_id ^FK integer
structure_type_id ^FK integer
active tinyInteger
timestamps timestamps
softDeletes softDeletes

classifications

id increments
name string
timestamps timestamps

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