waferly - Laravel Schema Designer

categories

id increments
name string (255)
timestamps timestamps
softDeletes softDeletes

countries

id increments
name string (255)
timestamps timestamps
softDeletes softDeletes

cities

id increments
name string
country_id ^FK integer
timestamps timestamps
softDeletes softDeletes

branches

id increments
name string (255)
timestamps timestamps
company_id ^FK integer
softDeletes softDeletes
address string
phone string (255)
country_id ^FK integer
city_id ^FK integer

attchments

id increments
company_id ^FK integer
file string (255)
type string (255)
name string (255)
timestamps timestamps
softDeletes softDeletes

companies

id increments
site string (255)
name string (255)
category_id ^FK integer
country_id ^FK integer
city_id ^FK integer
attach_id ^FK integer
address string (255)
status enum
timestamps timestamps
softDeletes softDeletes
phone string (255)

users

id increments
company_id ^FK integer
branch_id ^FK integer
firstname string
lastname string (255)
email string (255)
type tinyInteger
password string (255)
phone string (255)
AmountAllowed integer
timemoney datetime
currency_id ^FK integer
timestamps timestamps
softDeletes softDeletes

currencies

id increments
name string (255)
timestamps timestamps
softDeletes softDeletes

incomes

id increments
currency_id ^FK integer
entry_date datetime
amount integer
softDeletes softDeletes
timestamps timestamps

expenses

id increments
timestamps timestamps
softDeletes softDeletes
entry_date datetime
amount integer
currency_id ^FK integer

payments

id increments
timestamps timestamps
softDeletes softDeletes
company_id ^FK integer
paid_at datetime
amount string

customers

id increments
company_id ^FK integer
user_id ^FK integer
name string (255)
email string (255)
phone string (255)
address string (255)
website string (255)
status tinyInteger
timestamps timestamps
softDeletes softDeletes

invoices

id increments
company_id ^FK integer
invoice_number integer
order_number string
invoice_at datetime
amount string
currency_id ^FK integer
customer_id ^FK integer
timestamps timestamps
softDeletes softDeletes

transfers

id increments
timestamps timestamps
softDeletes softDeletes
company_id ^FK integer
customer_id ^FK integer
status tinyInteger
user_id ^FK integer
payment_id ^FK integer

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