ticket-ref - Laravel Schema Designer

users

id increments
first_name string
last_name string
email string
mobile string
image string
is_active tinyInteger
is_verified tinyInteger
is_admin tinyInteger
registered_ip string
logged_ip string
country_code string
time_zone string
login_time datetime
logout_time datetime
timestamps timestamps
softDeletes softDeletes

events

id increments
event_id integer
name string
production_name string
city string
venue string
event_date string
ct_event_date string
data longText
is_active tinyInteger
timestamps timestamps
softDeletes softDeletes

tickets

id increments
event_id ^FK integer
commission_id ^FK integer
quantity string
section string
row string
price_actual string
price_sale string
url string
description longText
delivery_option string
created_by ^FK integer
timestamps timestamps
softDeletes softDeletes

sales

id increments
ticket_id ^FK integer
buyer_id ^FK integer
seller_id ^FK integer
date string
quantity string
total_price string
price_actual string
commission_amount string
payment_id string
transaction_id string
payment_status string
seller_status ^FK integer
buyer_status ^FK integer
timestamps timestamps
softDeletes softDeletes

status_master

id increments
name string
slug string
timestamps timestamps
softDeletes softDeletes

payments

id increments
type enum
sale_id ^FK integer
payout_id ^FK integer
payment_id string
transaction_id string
amount string
timestamps timestamps
softDeletes softDeletes

payouts

id increments
user_id ^FK integer
sale_id ^FK integer
amount string
payment_id string
transaction_id string
created_by ^FK integer
timestamps timestamps
softDeletes softDeletes

commission_master

id increments
value string
timestamps timestamps
softDeletes softDeletes

revenue

id increments
ticket_id ^FK integer
buyer_id ^FK integer
seller_id ^FK integer
type enum
revenue_percentage string
amount string
timestamps timestamps
softDeletes softDeletes

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