tool_reportistica_sistemi_db - Laravel Schema Designer

hosts

id increments
timestamp_from timestamp
timestamp_to timestamp
active boolean
name string
pool_id ^FK integer
datacenter_id ^FK integer
memory_free bigInteger
cpu_model_name string
cpu_nr integer
cpu_speed float (4,3)
SR text
memory_total bigInteger
host_is_master boolean
ip_address ipAddress
uuid string (36)

virtualmachines

id increments
timestamp_from timestamp
timestamp_to timestamp
active boolean
host_id ^FK integer
uname string
name string
distro string
major integer
minor integer
vm_name string
name_description string
uptime integer
uuid string (36)
ram bigInteger
cpu integer
up_to_date boolean
resident_on string
scope string

disks

id increments
vm_id ^FK integer
diskindex tinyInteger
type string
size bigInteger
name string
disk_uid string

networks

id increments
vm_id ^FK integer
interface string
ip ipAddress
mac macAddress

virtualhosts

id increments
timestamp_from timestamp
timestamp_to timestamp
active boolean
vm_id ^FK integer
agency_id ^FK integer
erlog string
redir string
ssl boolean
ip ipAddress
file string
vm_name string
aclog string
sn string
cms string

alias

id increments
vh_id ^FK integer
name string

software

id increments
vm_id ^FK integer
name string
description string
vm_name string
major integer
minor integer

pools

id increments
timestamp_from timestamp
timestamp_to timestamp
active boolean
name string
host_master_id ^FK integer
uuid string (36)
SR text

json_versions

id increments
hosts string
pools string
virtualmachines string
virtualhosts string
software string
customers string
reports string

json_log

id increments
date date
type enum
filename string
status tinyInteger
message string

customers

id increments
active boolean
name string
parent_id integer

agencies

id increments
name string

users

id increments
email string
password string

users_customers

id increments
user_id ^FK integer
customer_id ^FK integer

roles

id increments
name string

users_roles

id increments
user_id ^FK integer
role_id ^FK integer

reports

id increments
contract_id ^FK integer
date date
vm_name string
fs_used_GB float
fs_total_GB float
cpu_util_idle float
cpu_util_used float
mem_avail_GB float
mem_total_GB float

datacenters

id increments
name string

services

id increments
name string

contracts

id increments
name string
date_start date
date_end date
customer_id ^FK integer
ram integer
cpu integer
file_system integer

contracts_services

id increments
contract_id ^FK integer
service_id ^FK integer

services_virtualmachines

id increments
service_id ^FK integer
vm_id ^FK integer

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