event_management_db - Laravel Schema Designer

users

id increments
timestamps timestamps
softDeletes softDeletes
name string (17)
phone string (16)
avatar string (255)
disabled boolean

orders

id increments
timestamps timestamps
softDeletes softDeletes
user_id ^FK integer
tickets_count integer
note string
location_id ^FK integer
event_id ^FK integer
payment_type smallInteger
status smallInteger
price decimal (10,10)

locations

id increments
timestamps timestamps
coordinate string
street string
governorate string
city string
note string
user_id ^FK integer

tickets

id increments
timestamps timestamps
softDeletes softDeletes
price decimal (10,10)
order_id ^FK integer
status smallInteger
ticket_class_id ^FK integer

admins

id increments
timestamps timestamps
softDeletes softDeletes
name string
email string
disabled boolean

events

id increments
timestamps timestamps
softDeletes softDeletes
admin_id ^FK integer
description longText
title string
start_date date
end_date date
start_time time
end_time time
booking_start_time datetime
booking_end_time datetime

ticket_classes

id increments
timestamps timestamps
event_id ^FK integer
price decimal (10,10)
tickets_count integer
booked_tickets_count integer

images

id increments
timestamps timestamps
path string
name string
model_id integer
model_name string

settings

id increments
timestamps timestamps
key string
value string
updated_by ^FK integer

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