ams - Laravel Schema Designer

users

id increments
department_id ^FK bigInteger
role_id ^FK bigInteger
firstName string (100)
middleName string (100)
lastName string (100)
email string (255)
password string (255)
phoneNumber string (100)
lastLogin string (255)
status smallInteger
timestamps timestamps
softDeletes softDeletes

departments

id increments
name string (100)
description string (255)
status smallInteger
timestamps timestamps
softDeletes softDeletes

employees

id increments
user_id ^FK bigInteger
group_id ^FK bigInteger
job_type_id smallInteger
gender string (100)
startAt datetime
endAt datetime
status smallInteger
timestamps timestamps
softDeletes softDeletes
address string (255)
birthdate datetime

roles

id increments
title string (100)
description string (255)
status smallInteger
timestamps timestamps
softDeletes softDeletes

groups

id increments
name string (100)
description string (255)
timestamps timestamps
softDeletes softDeletes
status smallInteger

job_types

id increments
title string (100)
timestamps timestamps
softDeletes softDeletes

timesheets

id increments
timestamps timestamps
softDeletes softDeletes

salaries

id increments
timestamps timestamps
softDeletes softDeletes

user_login_logs

id increments
timestamps timestamps
softDeletes softDeletes

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