Nova Data Model

	A	B	C	D	E	F
1	Model	Field	Type	Attr	Short Description	Example

2	Service	id	Integer	PK	Unique Id	1,2...
3		host	String		running host name	localhost
4		binary	String		type of service	nova-compute
5		topic	String		AMQP topic name	compute-host1
6		report_count	Integer	Not Null, Default 0	number of "report_state" called
7		disabled	Boolean	Default False	disable flag
8		availability_zone	String	default nova	service's zone	nova
9	ComputeNode	id	Integer	PK	Unique Id
10		service_id	Integer	relation Service(disabled = false)	Service reference Id
11		vcpus	Integer		num of vcpu	4
12		memory_mb	Integer		memory size by mb	2048
13		local_gb	Integer		local disk size by gb	40
14		vcpus_used	Integer		num of used vcpu	2
15		memory_mb_used	Integer		size of used memory by mb	1024
16		local_gb_used	Integer		size of used local disk by gb	20
17		hypervisor_type	Text		name of hypervisor	libvirt
18		hypervisor_version	Integer		version of hypervisor. use for live migration. if source/dest hypervisor version is not same, fail to migration	1
19		cpu_info	Text		cpu details info represented as json format	# '{"arch":"x86_64", # "model":"Nehalem", # "topology":{"sockets":1, "threads":2, "cores":3}, # "features":["tdtscp", "xtpr"]}'
20	Certificate	id	Integer	PK	Unique Id
21		user_id	String		certificate's user	shida
22		project_id	String		certificate's project	dev project
23		file_name	String		public key file name	newcerts/inbound.pem
24	Instance	id	Integer	PK, Auto Increment	Unique Id
25		name	String		instance name	i-XXXXXX, i-XXXXXX-rescure
26		user_id	String		instance owner user	shida
27		project_id	String		instance owned project	dev project
28		image_ref	String		referenced image id	ami-xxxxxxxx
29		kernel_id	String		referenced kernel image id	aki-xxxxxxxx
30		ramdisk_id	String		referenced ramdisk image id	ari-xxxxxxxx
31		server_name	String		name represented OSAPI	new-server-test
32		launch_index	Integer		index of launch sequence
33		key_name	String		keypair name	mykey
34		key_data	Text		public key fingerprint	43:51:43:a1:b5:fc:8b:b7:0a:3a:a9:b1:0f:66:73:a8
35		power_state	Integer		code of power state	NOSTATE = 0x00 RUNNING = 0x01 BLOCKED = 0x02 PAUSED = 0x03 SHUTDOWN = 0x04 SHUTOFF = 0x05 CRASHED = 0x06 SUSPENDED = 0x07 FAILED = 0x08 BUILDING = 0x09
36		vm_state	String		value of vm state	ACTIVE = 'active' BUILDING = 'building' REBUILDING = 'rebuilding' PAUSED = 'paused' SUSPENDED = 'suspended' RESCUED = 'rescued' DELETED = 'deleted' STOPPED = 'stopped' MIGRATING = 'migrating' RESIZING = 'resizing' ERROR = 'error'
37		task_state	String		value of instance task state	SCHEDULING = 'scheduling' BLOCK_DEVICE_MAPPING = 'block_device_mapping' NETWORKING = 'networking' SPAWNING = 'spawning' IMAGE_SNAPSHOT = 'image_snapshot' IMAGE_BACKUP = 'image_backup' UPDATING_PASSWORD = 'updating_password' RESIZE_PREP = 'resize_prep' RESIZE_MIGRATING = 'resize_migrating' RESIZE_MIGRATED = 'resize_migrated' RESIZE_FINISH = 'resize_finish' RESIZE_REVERTING = 'resize_reverting' RESIZE_CONFIRMING = 'resize_confirming' RESIZE_VERIFY = 'resize_verify' REBUILDING = 'rebuilding' REBOOTING = 'rebooting' PAUSING = 'pausing' UNPAUSING = 'unpausing' SUSPENDING = 'suspending' RESUMING = 'resuming' RESCUING = 'rescuing' UNRESCUING = 'unrescuing' DELETING = 'deleting' STOPPING = 'stopping' STARTING = 'starting'
38		memory_mb	Integer		userd memory	1024
39		vcpus	Integer		used vcpu	2
40		local_gb	Integer		used local disk	20
41		hostname	String		running host name
42		host	String		reference of ComputeNode
43		instance_type_id	Integer		reference for InstanceTypes
44		user_data	Text		instance user_data
45		reservation_id	String		reservation id	r-xxxxxx
46		scheduled_at	DateTime		time of scheduled
47		launched_at	DateTime		time of spawn instance
48		terminated_at	DateTime		time of terminated
49		availability_zone	String		running zone name	nova
50		display_name	String		User editable field for display in user-facing UIs	my first instance
51		display_description	String		User editable field for display in user-facing UIs	Django + MySQL
52		launched_on	Text		first launched host info	compute1
53		locked	Boolean		instance lock flag. When server.lock api called this flag turn on
54		os_type	String		Linux/Windows or others	Linux
55		architecture	String		x86/i386
56		vm_mode	String		mode of vms. para virtualization or hardware virtualization	pv hv hvm
57		uuid	String		universal unique id for live migration	compute1-xxxxxxxx
58		root_device_name	String		device name for EBS boot	/dev/sda
59		config_drive	String		values for vsa volume	/dev/sdh
60		access_ip_v4	String		ip for connect to the instance	64.142.4.112
61		access_ip_v6	String		ip for connect to the instance	2001:0DB8:AC10:FE01
62	VirtualStorageArray	id	Integer	PK, Auto Increment
63		name	String		name of vsa	vsa-xxxxxxxx
64		display_name	String		display in user-facing UIs	My vsa
65		display_description	String		display in user-facing UIs	used for database store
66		project_id	String		vsa owned project name	dev project
67		availability_zone	String		vsa joined zone
68		instance_type_id	Integer		reference for InstanceTypes
69		image_ref	String
70		vc_count	Integer	default 0
71		vol_count	Integer	defaut 0
72		status	String
73	InstanceActions	id	Integer	PK
74		instance_id	Integer	FK Instance
75		action	String		action name for OSAPI extension	add_tweedle
76		error	Text		error string
77	InstanceTypes	id	Integer	PK
78		name	String	Unique
79		memory_mb	Integer
80		vcpus	Integer
81		local_gb	Integer
82		flavorid	Integer	Unique
83		swap	Integer	Not Null, default 0	swap size associate with flavor
84		rxtx_quota	Integer	Not Null, default 0	It looks deprecate
85		rxtx_cap	Integer	Not Null, default 0	capacity of virtual network as mbps	100
86	Volume	id	Integer	PK, Auto Increment
87		name	String		name of volume	vol-xxxxxxxx
88		user_id	String			shida
89		project_id	String			dev_project
90		snapshot_id	String		snapshot id which volume's source	snap-xxxxxxxx
91		host	String		host name of nova-volume	localhost
92		size	Integer		size of volume by gb	2
93		availability_zone	String		availability zone name	nova
94		instance_id	Integer	FK: Instances.id(Volume.deleted=false)	volume attached instance id
95		mountpoint	String		device name of attached	/dev/sdh
96		attach_time	String		time of attached
97		status	String		status of volume	in-use available creating deleting error error_deleteing
98		attach_status	String		status of attach/dettach	attached detached
99		scheduled_at	DateTime
100		launched_at	DateTime