snipeit - Laravel Schema Designer

users

id increments
timestamps timestamps
company_id ^FK integer
username string
email string
phone string
remenber_token string (255)
password string (255)
role_id ^FK integer
department_id ^FK integer
softDeletes softDeletes

team_user

id increments
timestamps timestamps
team_id integer
user_id integer
role tinyInteger

teams

id increments
timestamps timestamps
category tinyInteger
name string (64)
company_id integer

companies

id increments
name string (64)
timestamps timestamps
address string
contact_id ^FK integer
user_id ^FK integer

departments

id increments
timestamps timestamps
company_id integer
name string (64)

circuits

id increments
timestamps timestamps
name string (64)
company_id integer

districts

id increments
timestamps timestamps
name string (64)
circuit_id integer

city_groups

id increments
timestamps timestamps
district_id integer
name string (64)

cinemas

id increments
timestamps timestamps
name string (64)
city_group_id integer
region_id ^FK integer

locations

id increments
timestamps timestamps
name string (64)
category tinyInteger
cinema_id ^FK integer

assets

id increments
timestamps timestamps
manufacturer_id integer
dealer_id integer
service_provider_id integer
asset_type_id integer
status tinyInteger
sn string
ip string
software_version string
firmware_version string
purchased_at timestamp
installed_at timestamp
warrant_due_at string
last_fixed_at timestamp
metric_updated_at timestamp
dynamic_attributes_doc_id string
poweron boolean
available_status enum
location_id ^FK integer
asset_model_id ^FK integer

components

id increments
timestamps timestamps
asset_id integer
name string (64)

events

id increments
timestamps timestamps
subject string (255)
status tinyInteger
category_id ^FK integer
description text
event_reporter_id integer
severity tinyInteger
location_id ^FK integer
contact_id integer
ticket_id ^FK integer
event_handler_id ^FK integer

tickets

id increments
timestamps timestamps
ticket_creator_id integer
description string (64)
status tinyInteger

asset_types

id increments
timestamps timestamps
name string (64)

region

id increments
timestamps timestamps
level integer
name string (64)
full_name string (64)
parent_id integer

gateways

id increments
timestamps timestamps
ip string (15)
sn string (10)
version string (10)
devices_ip_scheme string
device_ip_scheme_ver string (10)
should_auto_update boolean
cinema_id ^FK integer

component_attributes

id increments
timestamps timestamps
component_id ^FK integer
name string
value string

asset_brands

id increments
timestamps timestamps
name string
manufacturer_id ^FK integer

asset_models

id increments
timestamps timestamps
asset_brand_id ^FK integer
name string

contacts

id increments
timestamps timestamps
name string
user_id ^FK integer
phone string

ticket_flows

id increments
timestamps timestamps
ticket_id ^FK integer
owner_Id ^FK integer
assignee_id ^FK integer

roles

id increments
timestamps timestamps
name string (64)
permissions text

event_categories

id increments
timestamps timestamps
name string

medias

id increments
timestamps timestamps
thumbnail string
url string
event_id ^FK integer
asset_id ^FK integer
user_id ^FK integer

asset_event

id increments
timestamps timestamps
event_id ^FK integer
asset_id ^FK integer
description string

asset_fix

id increments
timestamps timestamps
fix_type string
component_id ^FK integer
description string

asset_transfer

id increments
timestamps timestamps
previous_location_id ^FK integer
previous_cinema_id ^FK integer
current_location_id ^FK integer
current_cinema_id ^FK integer
description string

malfunctions

id increments
timestamps timestamps
name string
level tinyInteger
parent_id integer
user_id ^FK integer

ticket_logs

id increments
timestamps timestamps
ticket_id ^FK integer
sender_id ^FK integer
receiver_id ^FK integer
solution_type tinyInteger
reason string
solution string