api_v2 - Laravel Schema Designer

companies

id increments
holding_id ^FK integer
name string
code string
common_name string
email string
phone string
reg_number string
tax_number string
note mediumText
identifier string
timestamps timestamps

users

id increments
first_name string (255)
last_name string (255)
email string (60)
password string (255)
company_id ^FK integer
phone string
holding_admin boolean
role_admin boolean
role_livestock boolean
role_agriculture boolean
timestamps timestamps

holdings

id increments
reg_number bigInteger
tax_number bigInteger
department integer
name string
note text
code string
common_name string
url string
timestamps timestamps

addresses

id increments
street string
zip_code string
city string
state string
country string
holding_id ^FK integer
company_id ^FK integer
farm_id string
supplier_id ^FK integer
customer_id ^FK integer
timestamps timestamps

farms

id increments
company_id ^FK integer
is_company boolean
all_farm_company_id integer
type string
name string
code string
common_name string
email string
phone string
reg_number string
tax_number string
note text
identifier string
timestamps timestamps

items

suppliers

id increments
description string
active boolean
detailed_description text
tax_number integer
contact_person string
phone string
email string
other_info string
address_id ^FK integer
item_id ^FK integer
contract_id ^FK integer
timestamps timestamps

categories

id increments
code string
name string
type string
minumum_stoc string
warranty string
special_discount string
maximum_discount string
primary_um string
net_weight string
gross_weight string
width string
height string
depth string
um string
sup_discount string
transport string
customs string
direct_costs string
sale_price string
currency string
description text
image_url string
timestamps timestamps
item_id ^FK integer

departments

id increments
code string
name string
description text
timestamps timestamps
item_id ^FK integer

types

id increments
code string
name string
description text
timestamps timestamps
item_id ^FK integer

banks

id increments
swift_code string
iban string
name string
address string
country string
currency string
timestamps timestamps
supplier_id ^FK integer

contracts

id increments
price integer
discount integer
name string
purchasing_item string
purchasing_price string
currency string
timestamps timestamps
supplier_id ^FK integer

salesOrders

id increments
number integer
date string
currency string
days_to_pay integer
deliver_by string
responsible string
customer_id ^FK integer
customer_display string
contact_person string
timestamps timestamps

salesInvoices

id increments
number integer
date string
currency string
days_to_pay integer
deliver_by string
responsible string
customer_id ^FK integer
customer_display string
contact_person string
deliver_by_date string
timestamps timestamps

purchaseOrders

id increments
number integer
date string
currency string
days_to_pay integer
deliver_by string
responsible string
customer_id ^FK integer
customer_display string
contact_person string
deliver_by_date string
timestamps timestamps

payments

id increments
report_date string
due_from string
to string
outstanding_invoice_all boolean
outstanding_invoice_029 boolean
outstanding_invoice_3059 boolean
outstanding_invoice_over_60 boolean
currency string
convert_to string
customer_id ^FK integer
customer_exchange_rate string
customer_document string
customer_status string
supplier_id ^FK integer
supplier_exchange_rate string
supplier_document string
supplier_status string
timestamps timestamps

receipts

id increments
number integer
date string
currency string
days_to_pay integer
deliver_by string
responsible string
supplier_id ^FK integer
supplier_display string
deliver_by_date string
transport_cost integer
vat_percent integer
vat integer
total_cost integer
note text
obs string
timestamps timestamps

customers

id increments
code string
name string
description text
active boolean
record_only boolean
detailed_description text
address_id ^FK integer
contact_person string
phone string
email string
tax_number string
other_info string
item_id ^FK integer
price integer
currency string
discount integer
timestamps timestamps

units

id increments
code string
name string
description string
act boolean
subtotal string
tax string
discount string
total string
timestamps timestamps

responsibles

id increments
name string
timestamps timestamps

shipments

id increments
timestamps timestamps
num integer
date string
currency string
days_to_pay integer
deliver_by string
responsible string
customer_id ^FK integer
customer_display string
deliver_by_date string
transport_cost integer
vat_percent integer
vat integer
total_cost integer
note text
obs string

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