socialy - Laravel Schema Designer

location

id increments
name string (100)
status boolean
created_by integer
modified_by integer
timestamps timestamps

social_cause

id increments
name string (100)
status boolean
created_by integer
modified_by integer
timestamps timestamps

contribution_type

id increments
name string (100)
status boolean
created_by integer
modified_by integer
timestamps timestamps

ngo

id increments
user_id ^FK bigInteger
name string (1000)
logo string (100)
desc longText
status boolean
created_by integer
modified_by integer
timestamps timestamps

campaign

id increments
title string (1000)
short_info text
description longText
tax_detail longText
viewed_by bigInteger
social_cause_id bigInteger
location_id ^FK bigInteger
featured string (10)
home_banner string (10)
min_amount float
status boolean
created_by integer
modified_by integer
timestamps timestamps

campaign_donation_amount

id increments
campaign_id ^FK bigInteger
amount float
status boolean
created_by integer
modified_by integer
timestamps timestamps

campaign_contribution_type

id increments
campaign_id ^FK bigInteger
contribution_type_id ^FK integer
created_by integer
modified_by integer
timestamps timestamps

campaign_images

id increments
campaign_id ^FK bigInteger
image string (1000)
status string (10)
created_by integer
modified_by integer
timestamps timestamps

campaign_stories

id increments
campaign_id ^FK bigInteger
title string (1000)
image string (1000)
description longText
created_by integer
modified_by integer
timestamps timestamps

campaign_inkind

id increments
campaign_id ^FK bigInteger
name string (1000)
description longText
created_by integer
modified_by integer
timestamps timestamps

subscribers

id increments
email string (100)
status string (10)
created_by integer
modified_by integer
timestamps timestamps

users

id increments
name string (100)
email string (1000)
password string (1000)
mobile string (100)
gender string (10)
dob date
address text
city string (100)
state string (100)
pincode string (10)
country string (100)
user_type string (10)
status boolean
created_by integer
modified_by integer
remember_token rememberToken
timestamps timestamps

user_wishlist

id increments
user_id ^FK bigInteger
campaign_id ^FK bigInteger
created_by integer
modified_by integer
timestamps timestamps

user_donation

id increments
user_id ^FK bigInteger
campaign_id ^FK bigInteger
ngo_id ^FK bigInteger
donation_type string (100)
amount float
type string (100)
education string (1000)
skill string (1000)
avl_day string (100)
avl_time string (100)
start_date date
cover_letter string (1000)
facebook string (1000)
twitter string (1000)
linkedin string (1000)
campaign_inkind_id ^FK bigInteger
payment_status string (10)
transaction_id string (100)
payment_mode string (100)
card_no string (100)
payment_frequency string (10)
created_by ^FK integer
modified_by ^FK integer
timestamps timestamps

faqs

id increments
question text
answer longText
faq_category_id integer
status boolean
created_by ^FK bigInteger
modified_by ^FK bigInteger
timestamps timestamps

faq_category

id increments
name string (100)
status boolean
timestamps timestamps
created_by ^FK bigInteger
modified_by ^FK bigInteger

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