seema - Laravel Schema Designer

companies

id increments
timestamps timestamps
name string
name1 string
name2 string
phone string
mobile string
fax string
website string
postal_street string
postal_plc string
postal_city string
postal_country ^FK integer
delivery_street string
delivery_plc string
delivery_city string
delivery_country ^FK integer
debitor integer
kreditor integer
IBAN string
BIC string
vatnumber string
FK_parantcompany integer

contacts

id increments
timestamps timestamps
email string
encrypted_password string
companyid ^FK integer
phone string
mobile string
first_name string
last_name string
position string
title string

products

id increments
timestamps timestamps
categoryid ^FK integer
name_de string
name_en string
name_ru string
details_de text
details_en text
details_ru text
manufacturer string
year string
model string
serial_number string
weight decimal
internal_notice text
purchase_price decimal
sales_price decimal
show_frontend boolean
machine_status enum
company_incoming ^FK integer
contact_incoming ^FK integer
company_outgoing ^FK integer
contact_outgoing ^FK integer
quoting enum
newsletter boolean

docs

id increments
timestamps timestamps
doctype string
docnumber integer
docname string
isaarchived boolean
title string
headertext text
footertext text
totalnet decimal
discountpercent decimal
totaltax decimal
totalbrt decimal
parentdoc ^FK integer
project_id ^FK integer

doclines

id increments
timestamps timestamps
text text
amount integer
amount_delivered integer
amount_billed integer
singleprice decimal
groupprice decimal
order integer
isgroup boolean
isoptional boolean
FK_product_id ^FK integer

project

id increments
timestamps timestamps
subject string
details text
closedate date
status ^FK integer

attachments

id increments
timestamps timestamps
type enum
filename string
filesize integer
order integer
privacy enum

packlists

id increments
timestamps timestamps

users

id increments
timestamps timestamps

categories

id increments
timestamps timestamps
name_de string
name_en string
name_ru string
parent ^FK integer

emails

id increments
timestamps timestamps
email_attachments ^FK integer
to string
cc string
subject string
body text
raw text
datetime datetime

emailattachments

id increments
timestamps timestamps

conversation

id increments
timestamps timestamps
title string

propertytemplates

id increments
timestamps timestamps

property

id increments
timestamps timestamps

listitems

id increments
timestamps timestamps

countries

id increments
timestamps timestamps

marketinglists

id increments
name string
tasks text
timestamps timestamps

leads

id increments
timestamps timestamps

role

id increments
timestamps timestamps
company ^FK integer
contact ^FK integer
role string

status

id increments
timestamps timestamps
name string

doctypes

id increments
timestamps timestamps
name string
type enum
nextdocnumber integer
prefix string
forwardto integer
archiveonsafe boolean
amount_delivered boolean
amount_billed boolean

marketinglistmembers

id increments
timestamps timestamps

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