SMSFCalcs - Laravel Schema Designer

users

id increments
timestamps timestamps
username string (50)
email string
password string
confirmed boolean
confirmationCode string

funds

id increments
fundReference string (40)
fundGroup string (20)
timestamps timestamps
startDateYear date
endDateYear date
year date
user_id ^FK integer

members

id increments
timestamps timestamps
fund_id ^FK integer
memberReference string (40)
superAccountCommencement date
superAccountOpeningBalance decimal (11,2)
superAccountClosingBalance decimal (11,2)
pensionAccountCommencement date
pensionAccountOpeningBalance decimal (11,2)
pensionAccountClosingBalance decimal (11,2)
user_id ^FK integer

superTransactions

id increments
timestamps timestamps
transcationDate date
transcationType enum
transcationAmount decimal (11,2)
member_id ^FK integer
user_id ^FK integer

pensionTransactions

id increments
timestamps timestamps
transcationDate date
transcationType enum
transcationAmount decimal (11,2)
member_id ^FK integer
user_id ^FK integer

taxReference

transactionType string (50)
taxRate decimal (5,4)

orders

id increments
timestamps timestamps
orderReference string (40)
orderDate date
orderStatus enum
user_id ^FK integer
fund_id ^FK integer

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