pridepartners - Laravel Schema Designer

member

memberid increments
name string (256)
address string (256)
country string (256)
state string (256)
telephone string (256)
fax string (256)
website string (256)
services enum
photo string (256)

contacts

contactid increments
memberid ^FK integer
userid integer
firstname string (256)
lastname string (256)
email string (256)
phone string (256)
ext string (256)
celphone string (256)
primary tinyInteger
photo string (256)

users

userid increments
username string (256)
password string (256)
confirm string (256)
type enum
last_login timestamp
active tinyInteger

staff

staffid increments
firstname string (256)
lastname string (256)
email string (256)
userid integer
photo string (256)

poll_question

pollquestionid increments
description string (256)
staffid ^FK integer
created datetime
expire date

poll_options

polloptionsid increments
description string (256)
pollquestionid ^FK integer

poll_answers

pollanswersid increments
pollquestionid ^FK integer
polloptionsid ^FK integer
userid ^FK integer
answered datetime

news

newsid increments
tittle string (256)
description string (256)
body string (256)
image string (256)
video string (256)
public boolean
created datetime
category enum
staffid ^FK integer

news_comment

newscommentid increments
text string (256)
created datetime
memberid ^FK integer
newsid ^FK integer

events

eventsid increments
name string (256)
description string (256)
city string (256)
state string (256)
country string (256)
venue string (256)
address string (256)
staffid ^FK integer
date date
hour time
created datetime

event_guests

ideventguests increments
eventsid ^FK integer
contactid ^FK integer

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