itg - Laravel Schema Designer

items

id increments
timestamps timestamps
name string
code string
user_id ^FK bigInteger
unit enum
description text

users

id increments
timestamps timestamps
name string
phone string
email string
password string

in_requests

id increments
timestamps timestamps
nokia_requester_id ^FK integer
user_id ^FK bigInteger
stream_id ^FK integer
notes text
site_id ^FK integer
subcontractor_id ^FK integer
internal_supplier_id ^FK integer
entity_id ^FK integer
work_order_id string
delivery_id ^FK bigInteger

streams

id increments
timestamps timestamps
name string

sites

id increments
timestamps timestamps
name string
code string
user_id ^FK bigInteger

itemables

id increments
timestamps timestamps
item_id ^FK integer
itemable_id integer
itemable_type string
quantity float

quantities

id increments
timestamps timestamps
item_id ^FK integer
request_id integer
request_type string
returned_reason enum
item_status enum
serial_number string

meters

id increments
timestamps timestamps
item_id ^FK integer
quantity float
serial_number string
item_status enum
returned_reason enum

entities

id increments
timestamps timestamps
name string
type string

nokia_requesters

id increments
timestamps timestamps
name string

internal_suppliers

id increments
timestamps timestamps
name string

subcontractors

id increments
timestamps timestamps
name string

site_engineers

id increments
timestamps timestamps
name string
national_id string
phone string

out_requests

id increments
timestamps timestamps
work_order_id string
nokia_requester_id ^FK integer
entity_id ^FK integer
user_id ^FK bigInteger
stream_id ^FK integer
notes text
site_id ^FK integer
subcontractor_id ^FK integer
internal_supplier_id ^FK integer
site_engineer_id ^FK integer

request_status

id increments
timestamps timestamps
request_id integer
request_type string
user_id ^FK bigInteger
status enum
description text
notes text

attachments

id increments
timestamps timestamps
request_status_id ^FK integer
attachment text

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