nh7_weekender - Laravel Schema Designer

nh7_city

id increments
event_id ^FK integer
name string
is_active boolean
title string
type string
slug string
description text
owner string
last_updated_by string
timestamps timestamps

nh7_event

id increments
name string
is_active boolean
start_date date
end_date date
description text
owner string
last_updated_by string
timestamps timestamps

nh7_venue

id increments
event_id ^FK integer
name string
is_active boolean
address text
city string
city_id ^FK integer
pin_code string
state string
country string
latitude string
longitude string
map_link text
static_map_link text
owner string
last_updated_by string
timestamps timestamps

nh7_venue_facility

id increments
venue_id ^FK integer
avatar string
name string
description text
sequence_no integer
is_active boolean
owner string
last_updated_by string
timestamps timestamps

nh7_artist

id increments
avatar string
cover_img string
name string
is_active boolean
real_name string
nick_name string
description text
seo_title string
seo_keywords text
seo_description text
facebook_url string
twitter_url string
youtube_url string
instagram_url string
soundcloud_url string
bandcamp_url string
website string
slug string
owner string
last_updated_by string
timestamps timestamps

nh7_artist_work

id increments
artist_id ^FK integer
url text
title string
description text
sequence_no integer
is_active boolean
owner string
last_updated_by string
timestamps timestamps

nh7_sponsor

id increments
event_id ^FK integer
avatar string
is_active boolean
sponsored_by string
title string
sequence_no integer
owner string
last_updated_by string
timestamps timestamps

nh7_festival

id increments
event_id ^FK integer
avatar string
is_active boolean
title string
city_id ^FK integer
city string
venue_id ^FK integer
ticket_link text
start_date date
end_date date
sequence_no integer
description text
seo_title string
seo_keywords text
seo_description text
slug string
owner string
last_updated_by string
timestamps timestamps

nh7_festival_artist

id increments
festival_id ^FK integer
artist_id ^FK integer
is_active boolean
sequence_no integer
onstage_date date
onstage_time time
owner string
last_updated_by string
timestamps timestamps

nh7_festival_ticket

id increments
festival_id ^FK integer
name string
phase string
price integer
sequence_no integer
is_active boolean
owner string
last_updated_by string
timestamps timestamps

nh7_faq_category

id increments
name string
is_active boolean
owner string
last_updated_by string
timestamps timestamps

nh7_faq

id increments
event_id ^FK integer
faq_category_id ^FK integer
faq_category string
question text
answer text
is_active boolean
sequence_no integer
owner string
last_updated_by string
timestamps timestamps

nh7_festival_sponsor

id increments
festival_id ^FK integer
avatar string
is_active boolean
sponsored_by string
title string
sequence_no integer
owner string
last_updated_by string
timestamps timestamps

nh7_gallery

id increments
event_id ^FK integer
avatar string
is_active boolean
title string
description text
media_type string (10)
url text
festival_id ^FK integer
sequence_no integer
owner string
last_updated_by string
timestamps timestamps

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