tracking-app database - Laravel Schema Designer

users

user_id increments
name string (70)
email string (40)
phone string (15)
mu_account string (6)
department string (30)
timestamps timestamps
password string (255)

roles

role_id increments
role string (30)

role_user

user_id ^FK integer
role_id ^FK integer

companies

company_id increments
company_name string (40)
address string (150)
city string (40)
zip_code string (20)
country string (20)
timestamps timestamps

contacts

contact_id increments
name string (70)
email string (30)
phone string (20)
timestamps timestamps
company_id ^FK integer

items

item_id increments
asset_tag string (10)
serial_number string (20)
status enum
testing_status boolean
timestamps timestamps
department_id ^FK integer
part_number_id ^FK integer

departments

department_id increments
department_name string (20)

part_numbers

part_number_id increments
part_number string (50)
description string (100)
country_of_origin string (30)
international_price string (10)
internal_price string (10)

bookings

booking_id increments
shipping_date date
extension_date date
return_date date
booking_status string
timestamps timestamps
request_id ^FK integer

booking_item

booking_id ^FK integer
item_id ^FK integer

requests

request_id increments
shipment_purpose string
required_date date
end_date date
request_type string
request_status string
timestamps timestamps
user_id ^FK integer
contact_id ^FK integer
end_user ^FK integer
shipping_details text
request_details text

part_number_request

request_id ^FK integer
part_number_id ^FK integer
part_number_qty integer

stocks

id increments
stock_name string (30)
official_name string (30)
department_id ^FK integer

permissions

id increments
name string (255)
display_name string (255)
description string (255)
timestamps timestamps

permission_role

permission_id integer
role_id integer

permission_user

permission_id integer
user_id integer

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