quotation - Laravel Schema Designer

users

id increments
name string
phone string
email string
logo string
password string
role enum
timestamps timestamps
softDeletes softDeletes
employee_title string
city_id integer

companies

id increments
name string
address text
phone string
email string
website string
user_id ^FK integer
timestamps timestamps
softDeletes softDeletes
logo string
tax_no string
city_id integer

contact_persons

id increments
company_id ^FK integer
name string
employee_title string
phone string
email string
address string
timestamps timestamps
softDeletes softDeletes

brands

id increments
name string
logo string
timestamps timestamps
softDeletes softDeletes

products

id increments
timestamps timestamps
softDeletes softDeletes
brand_id ^FK integer
name string
desc text
price string
custom_fields json

QuotationPrices

id increments
user_id ^FK integer
company_id ^FK integer
customer_id ^FK integer
total string
tax string
discount string
total_after string
payment_methods string
payment_must string
expired_date string
signature string
date string
timestamps timestamps
softDeletes softDeletes

order_products

id increments
timestamps timestamps
softDeletes softDeletes
order_id ^FK integer
product_id ^FK integer
qty integer
tax string
discount string

custom_fields

id increments
brand_id ^FK integer
field_name string (200)
default_value string (200)
label_title text
validation text
field_type enum
is_required boolean
order integer
timestamps timestamps

countries

id increments
timestamps timestamps
softDeletes softDeletes
name string (191)

cities

id increments
timestamps timestamps
softDeletes softDeletes
name string (191)
country_id integer

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