tipsy_app - Laravel Schema Designer

customers

id increments
username string (120)
password string (120)
name binary
birthday date
gender enum
email binary
phone string (30)
show_tutorial enum
picture string (200)
smoke enum
facebook_id binary
google_id binary
status_id ^FK integer
timestamps timestamps
softDeletes softDeletes

clubs

id increments
name string
company_name string
logo string
location json
satus_id ^FK integer
grade integer
timestamps timestamps
softDeletes softDeletes

interests

id increments
name string
description text
timestamps timestamps
softDeletes softDeletes
icon string

grades

id increments
name string
description string
icon string
timestamps timestamps
softDeletes softDeletes

users_interests

id increments
customer_id ^FK bigInteger
interests_id ^FK integer
timestamps timestamps
softDeletes softDeletes

status

id increments
code string
name string
description text
timestamps timestamps
softDeletes softDeletes

events

id increments
title string
image string
description text
themes_id json
date datetime
location string
scheduled_publish_date datetime
active boolean
club_id ^FK integer
timestamps timestamps
softDeletes softDeletes

users_interested_events

id increments
user_id ^FK integer
event_id ^FK integer
action enum
timestamps timestamps

bookings

id increments
customer_id ^FK bigInteger
club_id ^FK integer
number_of_participents smallInteger
booking_date datetime
booking_status enum
booking_for enum
comment text
timestamps timestamps

clubs_menus_categries_items

id increments
name string
description text
image string
order tinyInteger
timestamps timestamps
softDeletes softDeletes

clubs_menus_items

id increments
name string
image string
description string
ingredients text
club_id ^FK bigInteger
clubs_menus_categries_items_id ^FK bigInteger
available_for_customers boolean
has_happy_hour_discount boolean
has_member_discount boolean
is_vegan boolean
is_gluten_free boolean
is_spicy boolean
timestamps timestamps
softDeletes softDeletes

clubs_menus_items_prices

id increments
clubs_menus_item_id ^FK bigInteger
full_price decimal (8,3)
happy_hour_price decimal (8,3)
universal_code string
quantity string
timestamps timestamps
softDeletes softDeletes

checkins

id increments
customer_id ^FK bigInteger
location json
club_id ^FK bigInteger
qrcode_id ^FK bigInteger
timestamps timestamps

qrcodes

id increments
timestamps timestamps

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