InvoicePlane 2 - Laravel Schema Designer

attachments

id increments
original_filename text
timestamps timestamps
softDeletes softDeletes

email_templates

id increments
softDeletes softDeletes

payment_methods

id increments
softDeletes softDeletes

payments

id increments
timestamps timestamps
softDeletes softDeletes

notes

id increments
timestamps timestamps
softDeletes softDeletes

custom_fields

id increments
softDeletes softDeletes

custom_field_values

id increments
timestamps timestamps

clients

id increments
timestamps timestamps
softDeletes softDeletes

addresses

id increments
softDeletes softDeletes

contact_persons

id increments
softDeletes softDeletes

users

id increments
timestamps timestamps
softDeletes softDeletes

logs

id increments
timestamps timestamps

settings

id increments

items

id increments
softDeletes softDeletes

item_families

id increments
softDeletes softDeletes

roles

id increments

permissions

id increments

projects

id increments
timestamps timestamps
softDeletes softDeletes

tasks

id increments
timestamps timestamps
softDeletes softDeletes

time_trackings

id increments
timestamps timestamps
softDeletes softDeletes

vouchers

id increments
voucher_group_id ^FK integer
status_id ^FK integer
user_id ^FK integer
client_id ^FK integer
timestamps timestamps
softDeletes softDeletes

voucher_groups

id increments
title string
description text
number_template text
next_id integer
left_padding integer
softDeletes softDeletes

voucher_statuses

id increments
title string
description text
type enum
read_only boolean

invoices

id increments
voucher_id ^FK integer

voucher_items

id increments
timestamps timestamps
softDeletes softDeletes
name text
description text
original_item_id ^FK integer

voucher_amounts

id increments
item_subtotal decimal (30,10)
item_tax_total decimal (30,10)
item_discount_total decimal (30,10)
item_total decimal (30,10)
voucher_tax_total decimal (30,10)
voucher_discount_total decimal (30,10)
voucher_total decimal (30,10)
voucher_paid decimal (30,10)
voucher_balance decimal (30,10)

credit_invoices

id increments

purchase_invoices

id increments

quotes

id increments

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