JubeenProgram - Laravel Schema Designer

users

id increments
timestamps timestamps
user_email string (user_name)
password string
user_role ^FK integer
status integer

roles

role_name string
timestamps timestamps
id increments

ticket_categories

ticket_category_id increments
ticket_category_name string
ticket_value decimal (10,2)
timestamps timestamps

audiences

id increments
first_name string
last_name string
age integer
sex string
address text
reservation_id ^FK integer
email_id string
phone_no string
timestamps timestamps

reservations

reservation_id increments
reservation_code string
ticket_category_id ^FK integer
no_of_audience integer
status integer
booked_user_id ^FK integer
checked_user_id ^FK integer
checked_status integer
checked_date timestamp
amount decimal (12,2)
timestamps timestamps

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