erp_project - Laravel Schema Designer

employees

id increments
fullname string
job_title string
mobile string
department_id ^FK integer
dob date
hiring_date date
email string
gender tinyInteger
address string
marital_status tinyInteger
timestamps timestamps

department

id increments
name json
description text
parent_id integer
timestamps timestamps

group_permissions

id increments
user_group_id integer
route_name string
timestamps timestamps

salaries

id increments
employee_id ^FK integer
basic integer
incentives integer
allowance integer
timestamps timestamps

materials

id increments
part_number string
brand tinyInteger
name string
qty integer
description longText
timestamps timestamps

suppliers

id increments
name string
description text
tax_number string
address text
mobile string
email string
timestamps timestamps

supplier_bills

id increments
supplier_id ^FK integer
discount integer
status tinyInteger
bill_date date
timestamps timestamps

supplier_bill_items

id increments
material_id ^FK integer
supplier_bill_id ^FK integer
price integer
qty integer
timestamps timestamps

products

id increments
type tinyInteger
brand tinyInteger
cost_price integer
name string
description longText
timestamps timestamps

product_materials

id increments
product_id ^FK integer
material_id ^FK integer
qty integer
timestamps timestamps

users

id increments
username string
user_group_id ^FK integer
password string
rememberToken rememberToken
status tinyInteger
timestamps timestamps

user_groups

id increments
name json
type enum
timestamps timestamps

technical_proposals

id increments
client_id ^FK integer
brand tinyInteger
project_name string
consultant_name string
responsible_engineer string
validate_date date
revision_id integer
timestamps timestamps

proposal_items

id increments
technical_proposal_id ^FK integer
product_id ^FK integer
qty integer
price integer
invoiced boolean
timestamps timestamps

settings

id increments
name string
value string
timestamps timestamps

commercial_proposal

id increments
timestamps timestamps
technical_proposal_id ^FK integer
revision_id integer
discount integer

clients

id increments
name string
description longText
mobile string
timestamps timestamps

invoices

id increments
invoice_date date
description longText
forwarded_to string
commercial_proposal_id ^FK integer
total integer
timestamps timestamps

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