Home
seema
Fork
Export all
Schema
Model
Controller
Seeding
Form
Laravel 4.2
Add to favorites
Comments (0)
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
×
Comments for seema
No comments have been made yet.
Laravel Schema Designer v0.7.1
follow me on twitter
@okyn01