lorenapestana - Laravel Schema Designer

users

id increments
store_id ^FK integer
name string (150)
lastname string (150)
email string
password string
timestamps timestamps
softDeletes softDeletes
remember_token string (100)

people

id increments
ubigeo_id ^FK integer
name string
lastname string (150)
phone string (20)
email string (255)
timestamps timestamps
softDeletes softDeletes
address string (255)
dni string (10)

purchase_orders

id increments
series string (10)
code string (10)
provider_id ^FK integer
store_from_id ^FK integer
store_to_id ^FK integer
payment_type_id ^FK integer
currency_id ^FK integer
exchange_rate_id ^FK integer
tax_id integer
date_order date
total_amount decimal (10,3)
user_id ^FK integer
status boolean
timestamps timestamps
softDeletes softDeletes

purchase_order_details

id increments
purchase_order_id ^FK integer
raw_material_id ^FK integer
product_id ^FK integer
quantity decimal (10,2)
price decimal (10,3)

products

id increments
material_id ^FK integer
category_id ^FK integer
collection_id ^FK integer
name string (100)
code string (20)
description string (255)
timestamps timestamps
softDeletes softDeletes

raw_materials

id increments
material_id ^FK integer
category_id ^FK integer
unit_measurement_id ^FK integer
name string (200)
timestamps timestamps
softDeletes softDeletes
code string (20)

raw_material_prices

id increments
raw_material_id ^FK integer
price decimal (10,3)
quantity decimal (10,2)
status boolean

product_recipes

id increments
product_id ^FK integer
raw_material_id ^FK integer
quantity decimal (10,3)

stores

id increments
type string
series string (10)
name string (25)
ubigeo_id ^FK integer
address string (255)
email string (150)
phone string (20)
cellphone string (50)
multiplierx1 decimal (8,2)
commission decimal (8,2)
timestamps timestamps
softDeletes softDeletes

ubigeos

id increments
department string (100)
province string (100)
district string (100)
code string (100)

configurations

id increments
tablename string (255)
value string (255)
type string (20)
code string (5)
parent_id integer
status boolean
timestamps timestamps
softDeletes softDeletes

exchange_rates

id increments
currency_id ^FK integer
amount decimal (10,3)
date date
timestamps timestamps
softDeletes softDeletes

providers

id increments
type string (20)
classification string (20)
ruc string (20)
name string (255)
address string (255)
email string (255)
phone string (255)
cellphone string (255)
ubigeo_id ^FK integer
timestamps timestamps
softDeletes softDeletes

purchases

id increments
document_id ^FK integer
purchase_order_id integer
series string (10)
code string (20)
date_purchase date
timestamps timestamps
softDeletes softDeletes
status boolean

cash_registers

id increments
user_id ^FK integer
open_date date
close_date date
timestamps timestamps
softDeletes softDeletes

sales

id increments
series string (10)
code string (20)
store_id ^FK integer
cash_register_id ^FK integer
currency_id ^FK integer
customer_id ^FK integer
payment_method_id ^FK integer
document_id ^FK integer
total_amount decimal (10,3)
discount_id ^FK integer
user_id ^FK integer
timestamps timestamps
softDeletes softDeletes

customers

id increments
customertable_id integer
customertable_type string (255)
timestamps timestamps
softDeletes softDeletes
body string

companies

id increments
ruc string (20)
ubigeo_id ^FK integer
name string (255)
address string (255)
email string (255)
phone string (20)
timestamps timestamps
softDeletes softDeletes

credit_notes

id increments
product_id ^FK integer
store_id ^FK integer
customer_id ^FK integer
amount decimal (10,3)
timestamps timestamps
softDeletes softDeletes

sale_details

id increments
sale_id ^FK integer
product_price_id ^FK integer
quantity decimal (10,3)
discount_id ^FK integer

product_prices

id increments
product_id ^FK integer
list decimal (10,3)
export decimal (10,3)
fob decimal (10,3)
status boolean

stock_products

id increments
store_id ^FK integer
product_id ^FK integer
quantity decimal (10,3)
timestamps timestamps
softDeletes softDeletes

stock_raw_materials

id increments
store_id ^FK integer
raw_material_id ^FK integer
quantity decimal (10,3)
timestamps timestamps
softDeletes softDeletes
unit_measurement_id ^FK integer

transfers

id increments
document_id ^FK integer
series string (10)
code string (20)
store_from_id ^FK integer
store_to_id ^FK integer
date date
timestamps timestamps
status boolean
softDeletes softDeletes

employees

id increments
ubigeo_id ^FK integer
name string (255)
lastname string (255)
document_type_id ^FK integer
number_document string (20)
civil_status string (30)
address string (255)
email string (200)
phone string (15)
cellphone string (20)
birthdate date
status boolean
timestamps timestamps
softDeletes softDeletes

transfer_details

id increments
transfer_id ^FK integer
product_id ^FK integer
quantity decimal (10,3)

services

id increments
series string (10)
code string (20)
description longText
customer_id ^FK integer
store_id ^FK integer
document_id ^FK integer
payment_method_id ^FK integer
cash_register_id ^FK integer
currency_id ^FK integer
total_amount decimal (10,3)
timestamps timestamps
softDeletes softDeletes

service_detail

id increments
service_id ^FK integer
name string (255)

kardexes

id increments
type_movement_id ^FK integer
entry_date date
departure_date date
provider_id ^FK integer
customer_id ^FK integer
store_from_id ^FK integer
store_to_id ^FK integer
document_id ^FK integer
series string (10)
code string (20)
raw_material_id ^FK integer
product_id ^FK integer
quantity decimal (10,3)
price decimal (10,3)
unit_measurement_id ^FK integer

work_orders

id increments
product_id ^FK integer
store_id ^FK integer
document_id ^FK integer
series string (10)
code string (20)
status boolean
date date
total_amount decimal (10,3)
user_id ^FK integer
timestamps timestamps
softDeletes softDeletes
authorize boolean

work_order_details

id increments
work_order_id ^FK integer
provider_id ^FK integer
currency_id ^FK integer
quantity decimal (10,3)
price decimal (10,3)
hour decimal (8,2)
hour_price decimal (10,3)

discounts

id increments
code string (50)
start_date date
finish_date date
valid_from date
applied_to_id ^FK integer
name string (255)
currency_id ^FK integer
description text
amount decimal (10,3)
percentage decimal (8,2)
timestamps timestamps
softDeletes softDeletes

orders

id increments
store_id ^FK integer
series string (10)
code string (20)
customer_id ^FK integer
product_id ^FK integer
quantity decimal (10,2)
date_order date
date_delivery date
payment_type_id ^FK integer
currency_id ^FK integer
total_amount decimal (10,3)
on_account decimal (10,2)
delivered_product boolean
timestamps timestamps
softDeletes softDeletes

employee_income

id increments
labor_data_id ^FK integer
tablename string (150)
total_amount decimal (10,2)
date date
timestamps timestamps
softDeletes softDeletes

employer_contributions

id increments
labor_data_id ^FK integer
tablename string (150)
date date
total_amount decimal (10,2)
timestamps timestamps
softDeletes softDeletes

contributions_discounts_employees

id increments
labor_data_id ^FK integer
tablename string (150)
total_amount decimal (10,2)
date date
timestamps timestamps
softDeletes softDeletes

works

id increments
work_order_id ^FK integer
date date
status boolean
timestamps timestamps

expenses

id increments
provider_id ^FK integer
document_id ^FK integer
series string (12)
code string (10)
gloss_id ^FK integer
amount decimal (10,3)
currency_id ^FK integer
date date
description longText
timestamps timestamps