MSDF ERD - Laravel Schema Designer

Citizens

identity increments
expiryDate date
name string
gender enum
telephone string
emailAddress string
job string
workPlace string
governorate enum
region enum

FamilyMembers

identity increments
name string
expiryDate date

Request

requesId increments
departmentType enum
serviceType enum
Account string
modifiedDate date
submissionDate string
stage string
status string
employee string
governorate enum
region enum

Employee

id increments
type string

Files

id increments
requestMasterId string

Notifications

id increments

Sms

id increments

Departement

id increments

TimeLine

id increments
Status string
date datetime
requestMasterId integer
Account string
Stage string
comment string

Team

id increments
timestamps timestamps

Email

id increments
subject string
body longText

Services

id increments
name string

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