ticketboo - Laravel Schema Designer

users

id increments
timestamps timestamps
softDeletes softDeletes
first_name string
last_name string
p_no string
email string
password string
image string
location string

categories

id increments
timestamps timestamps
name string
slug string

events

id increments
title string
start_date timestamp
end_date timestamp
location string
description string
visit_count integer
status tinyInteger
timestamps timestamps
softDeletes softDeletes

category_event

category_id ^FK bigInteger
event_id ^FK bigInteger

tickets

id increments
timestamps timestamps
softDeletes softDeletes
name string
quantity integer
price float
fee float
event_id ^FK bigInteger
qr_image string

favourites

id increments
user_id ^FK bigInteger
event_id ^FK bigInteger
timestamps timestamps

conversations

id increments
sender_id ^FK bigInteger
reciever_id ^FK bigInteger
timestamps timestamps

messages

id increments
parent_id ^FK bigInteger
sender_id ^FK bigInteger
reciever_id ^FK bigInteger
conversation_id ^FK bigInteger
message string
timestamps timestamps
softDeletes softDeletes

event_visits

id increments
timestamps timestamps
event_id ^FK bigInteger
user_id ^FK bigInteger

event_order

event_id ^FK bigInteger
order_id ^FK bigInteger
quantity integer
ticket_id ^FK bigInteger

orders

id increments
buyer_id ^FK bigInteger
seller_id ^FK bigInteger
discount float
fee float
total float
sub_total float
status tinyInteger
timestamps timestamps

order_transaction

id increments
order_id ^FK bigInteger
payment_id string
transaction_number string
status tinyInteger
currency string
total integer
timestamps timestamps

organizers

id increments
name string
timestamps timestamps

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