fotografTestDB - Laravel Schema Designer

clients

id increments
first_name string (50)
last_name string (50)
email string (60)
created_at datetime
updated_at datetime

products

id increments
product string (50)
description string (100)
created_at datetime
updated_at datetime

purchases

id increments
product_id ^FK integer
client_id ^FK integer
created_at datetime
updated_at datetime

billingcycles

id increments
start_date date
end_date date

invoices

id increments
purchase_id ^FK integer
billingcycle_id ^FK integer
invoice_amount decimal
tax_rate integer
final_invoice_amount decimal
uncleared_amount decimal
invoice_date date
collection_date date
created_at datetime
updated_at datetime

banks

id increments
bank string (50)
bank_code string (20)
created_at datetime

payments

id increments
client_id integer
invoice_id integer
bank_id integer
amount decimal
created_at datetime
updated_at datetime

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