webApp - Laravel Schema Designer

organisations

id increments
name string
type enum
speciality string
phone string
phone2 string
country string
email string
ngo_reference integer
softDeletes softDeletes
timestamps timestamps

interventions

id increments
organisation_id ^FK integer
date timestampTz
status enum
softDeletes softDeletes
timestamps timestamps

requests

id increments
village_id ^FK integer
created_by string
type string
quantity double
quantity_unit enum
emergency enum
softDeletes softDeletes
timestamps timestamps

villages

id increments
commune_id ^FK integer
name string
name_ar string
validated_by string
validated_at datetimeTz
longitude double
latitude double
population integer
families_count integer
softDeletes softDeletes
timestamps timestamps

intervention_request

intervention_id ^FK integer
request_id ^FK integer
quantity double
quantity_unit enum
softDeletes softDeletes
timestamps timestamps

communes

id increments
circle_id ^FK integer
name string
softDeletes softDeletes
timestamps timestamps

circles

id increments
province_id ^FK integer
name string
timestamps timestamps
softDeletes softDeletes

provinces

id increments
region_id ^FK integer
name string
timestamps timestamps
softDeletes softDeletes

regions

id increments
zone_id ^FK integer
name string
timestamps timestamps
softDeletes softDeletes

zones

id increments
name string
timestamps timestamps
softDeletes softDeletes

users

id increments
name string
email string
email_verified_at timeTz
password string
token string
timestamps timestamps
softDeletes softDeletes

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