event_me - Laravel Schema Designer

types

id increments
name_ar string (50)
name_en string (50)
softDeletes softDeletes
timestamps timestamps

users

id increments
type_id ^FK integer
first_name string
last_name string
phone bigInteger
email string (100)
password string
is_active boolean
is_approved boolean
is_suspend boolean
softDeletes softDeletes
timestamps timestamps

type_requirements

id increments
type_id ^FK integer
requirement_id ^FK integer
softDeletes softDeletes
timestamps timestamps

events

id increments
owner_id ^FK integer
city_id integer
name_ar string
name_en string
image string
location string
capacity bigInteger
is_active boolean
has_volunteer boolean
has_guests boolean
start_at datetime
end_at datetime
timestamps timestamps
softDeletes softDeletes

event_volunteers

id increments
event_id ^FK integer
volunteer_id ^FK integer
is_approved boolean
timestamps timestamps
softDeletes softDeletes

event_guests

id increments
event_id ^FK integer
timestamps timestamps
softDeletes softDeletes
nationality_id ^FK integer

cities

id increments
name_ar string
name_en string
region string
timestamps timestamps
softDeletes softDeletes

volunteer_organizes

id increments
requirement_answer_id ^FK integer
city_id ^FK integer
volunteer_id integer
orgnize_name_ar string
orgnize_name_en string
hours integer
location string
softDeletes softDeletes
timestamps timestamps

requirements

id increments
name_ar string
name_en string
requirement_input_id ^FK integer
timestamps timestamps
softDeletes softDeletes

requirement_answers

id increments
user_id ^FK integer
type_requirement_id ^FK integer
answer string
timestamps timestamps
softDeletes softDeletes

requirement_input

id increments
name_ar string (100)
name_en string (100)
timestamps timestamps
softDeletes softDeletes

nationality

id increments
name_ar string
name_en string
softDeletes softDeletes
timestamps timestamps

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