Somaweb1 - Laravel Schema Designer

MemberInfo

MemberID increments
MemberHouseholdID ^FK integer
MemberTypeID ^FK integer
LoginEmail string
LoginSecret string
LoginSecretExpired boolean
FirstName string (50)
MiddleName string (50)
LastName string (60)
MailingAddress1 string (80)
MailingAddress2 string (80)
MailingAddress3 string (80)
MailingCity string (40)
MailingStateABR string (2)
MailingZipRoot string (10)
MailingZipPlus4 smallInteger
MailingAddressCountry string
HomeAddress1 string (80)
HomeAddress2 string (80)
HomeAddress3 string (80)
HomeCity string (40)
HomeStateABR string (2)
HomeZipRoot string (10)
HomeAddressCountry string
DOB date
HomePhone integer
WorkPhone integer
CellPhone integer
IsCellPhoneSMSCapable boolean
Email2 string (80)
Comments string (300)
MembershipRenewalDate date
MembershipExpirationDate date
ModificationData datetime

MemberInterest

MemberID ^FK integer
InterestID ^FK integer
ModificationData datetime

InterestTypes

InterestType string (20)
InterestID increments
ModificationData datetime

MemberType

MemberTypeID increments
MemberType string (20)
MemberTypeAddtionalText string (100)
ModificationData datetime

MemberAccountTransaction

MemberID ^FK integer
TransactionID integer
TransactionDate date
TransactionAmount decimal
TransactionTypeID ^FK integer
TransactionNote string (300)
ModificationData datetime

TransactionTypes

TransactionTypeID integer
TransactionType string (20)
ModificationData datetime

Event

EventID increments
EventTypeID ^FK integer
EventTitle string (60)
EventDetails text
EventLeadID ^FK integer
EventStartTime time
EventStartDate date
EventEndDate date
EventEndTime time
EventLocationID ^FK integer
EventCap smallInteger
ModificationData datetime

EventType

EventTypeID increments
EventType string (20)
ModificationData datetime

EventLead

EventLeadID increments
FirstName string (80)
LastName string (80)
MiddleName string (80)
EventLeadURL string (255)
EventLeadAffiliation string (255)
EventLeadBIO text
ModificationData datetime

Location

LocationID increments
LocationTitle string (255)
LocationMAPLink string
LocationImage binary
ModificationData datetime

MemberEvent

MemberID ^FK integer
MemberEventType ^FK integer
MemberEventID ^FK integer
ModificationData datetime

PrvLoginSecret

PrvLoginSecretID increments
MemberID ^FK integer
PrvLoginSecret string
ModificationData datetime

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