DB Schema - system table

Name	Type	Default	Max Length	Primary Key	Valid Values	Set By
id	int		10	true		auto
uuid	varchar		100			audit
name	varchar		100			audit
ip	varchar		45			audit
hostname	varchar		100			audit
dns_hostname	varchar		100			audit
domain	varchar		100			audit
dns_domain	varchar		100			audit
dbus_identifier	varchar		255			audit
fqdn	text					audit
description	text					audit
type	varchar		50			calculated
comments	text					manual
icon	varchar		50			calculated
os_group	varchar		50			audit
os_family	varchar		50			audit
os_name	varchar		100			audit
os_version	varchar		50			audit
attached_system_id	int		10			calculated
manufacturer	varchar		100			audit
model	varchar		200			audit
serial	varchar		200			audit
uptime	varchar		50			audit
form_factor	varchar		50			audit
os_bit	tinyint	0	3			audit
memory_count	int	0	10			audit
processor_count	tinyint	0	3			audit
os_installation_date	date	2000-01-01				audit
printer_port_name	varchar		50			audit
printer_shared	varchar		50			audit
printer_shared_name	varchar		50			audit
printer_color	enum				('y', 'n', '')	audit
printer_duplex	enum				('y', 'n', '')	audit
status	enum	production			('production', 'deleted', 'lost', 'maintenance', 'retired', 'unallocated')	audit
environment	enum	production			('production', 'dev', 'dr', 'eval', 'pre-prod', 'test', 'train', 'uat')	audit
class	enum				('desktop', 'laptop', 'tablet', 'workstation', 'server', 'virtual server', 'virtual desktop', 'hypervisor', '')	manual
function	varchar		100			manual
owner	varchar		100			manual
org_id	int	1	10			manual
location_id	int	1	10			manual
location_level	varchar		100			manual
location_suite	varchar		100			manual
location_room	varchar		100			manual
location_rack	varchar		100			manual
location_rack_position	varchar		100			manual
location_rack_size	int	0	10			manual
location_latitude	float					manual
location_longitude	float					manual
asset_number	varchar		50			manual
vm_server_name	varchar		150			calculated
vm_system_id	int		10			calculated
vm_group	varchar		150			manual
cluster_name	varchar		150			manual
cluster_type	varchar		150			manual
invoice_id	int		10			manual
purchase_invoice	varchar		50			manual
purchase_order_number	varchar		50			manual
purchase_cost_center	varchar		50			manual
purchase_vendor	varchar		100			manual
purchase_date	date	2000-01-01				manual
purchase_service_contract_number	varchar		255			manual
lease_expiry_date	date	2000-01-01				manual
purchase_amount	varchar		50			manual
warranty_duration	int	0	5			manual
warranty_expires	date	2000-01-01				manual
warranty_type	enum				('', '24x7x365', '9x5x5', 'Next Business Day')	manual
switch_system_id	int		10			manual
switch_port	int	0	10			manual
patch_panel	varchar		45			manual
patch_panel_port	int	0	10			manual
wall_port	varchar		100			manual
contact_name	varchar		50			manual
service_number	varchar		100			manual
service_provider	varchar		100			manual
service_type	varchar		100			manual
service_plan	varchar		100			manual
service_network	varchar		100			manual
unlock_pin	varchar		100			manual
serial_imei	varchar		100			manual
serial_sim	varchar		100			manual
nmis_group	varchar		50			manual
nmis_name	varchar		50			manual
nmis_role	varchar		50			manual
nmis_export	enum	n			('y', 'n')	manual
oae_manage	enum	y			('y', 'n')	manual
snmp_oid	text					audit
sysDescr	text					audit
sysObjectID	varchar		255			audit
sysUpTime	varchar		255			audit
sysContact	varchar		255			audit
sysName	varchar		255			audit
sysLocation	varchar		255			audit
first_seen	datetime	2000-01-01 00:00:00				audit
last_seen	datetime	2000-01-01 00:00:00				audit
last_seen_by	varchar		150			calculated
last_user	varchar		150
omk_uuid	varchar					imported