smarttel_inventory - Laravel Schema Designer

users

id increments
email string (255)
username string (255)
password string (255)

roles

id increments
title string (255)

permissions

id increments
slug string (100)

permission_roles

permission_id ^FK integer
role_id ^FK integer

role_user

role_id ^FK integer
user_id ^FK integer

login_attempts

id increments
user_id integer
login_ip string (50)
username string (255)
timestamps timestamps
browser_agent string (255)
success boolean

modules

id integer
name string (255)
icon string (100)
order tinyInteger
status tinyInteger
is_single tinyInteger

menus

id increments
module_id ^FK integer
menu_name string (255)
menu_icon string (255)
link string (255)
slug string (255)
menu_order tinyInteger
show_hide tinyInteger
parent_id ^FK integer

profiles

id ^FK integer
first_name string (255)
last_name string (255)
middle_name string (255)
gender enum
dob date
phone string (20)
current_address string (255)
permanent_address string (255)

state_district_local_bodies

id string (255)
state string (255)
district string (255)
local_body string
local_body_classification enum
ward enum
household integer
population integer
active tinyInteger

stations

id increments
name string (255)
area_name string
state_district_local_body_id ^FK integer
latitude double
logintude double
contact_person_id ^FK integer
station_id string (255)
station_band string (100)

contact_persons

id increments
full_name string (255)
title string (20)
gender string (10)
mobile_one string (20)
mobile_two string (20)
email string (20)
permanent_address string (255)
temporary_address string (255)

suppliers

id increments
contact_person_id ^FK integer
name string (255)
state_district_local_body_id integer
area_name string (255)
landline_number string (15)
landline_number_two string
mobile_one string (20)
mobile_two string (20)
website string (255)
email string (255)
pan_no string (255)
active boolean
description text

manufactures

id string (255)
timestamps timestamps
name string (255)
country string (100)
phone_one string (20)
phone_two string (20)
email string (255)
website string (255)
description text

warehouses

id increments
timestamps timestamps
name string (255)
state_district_local_body_id ^FK integer
area_name string (255)
latitude double
logintude string

warehouse_user

user_id ^FK integer
warehouse_id ^FK integer

plots

id integer
plot_no integer
remarks string (255)

item_units

id string (255)
unit_name string (255)

items

id increments
item_name string (255)
item_code string (255)
item_unit_id ^FK integer
supplier_id ^FK integer
manufacture_id string (255)
reorder_quantity integer
model_no string (255)
image string (255)
remarks string (255)
category_id ^FK integer

categories

id increments
name string (255)
parent_id ^FK integer

item_stocks

id increments
item_id ^FK integer
warehouse_id ^FK integer
quantity float
timestamps string
plot_id ^FK integer

station_requests

id increments
station_id ^FK integer
request_date_time datetime
requested_by_user_id ^FK integer
issured_by_user_id ^FK integer
remarks string (255)

station_item_request_items

id increments
station_request_id ^FK integer
item_id ^FK integer
request_quantity float
issued_quantity float
requst_unit_id string (100)
warehouse_id ^FK integer

item_transactions

id increments
timestamps timestamps
item_id ^FK integer
station_id ^FK integer
warehouse_id ^FK integer
quantity float
received_date date
transaction_type enum
transfer_type enum
remarks string (255)
status enum
decision_by ^FK integer
serial_number string (255)
p_n string (255)

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