2done.org

Linuxメインなメモ書き。二度寝してから書く。(ご意見は Twitter あたりで。そのうちコメント欄つけます。)

OpenStack Folsom (2012/11/05 stable/folsom)で生成されるテーブル一覧

mysql> DESC table の結果

KeyStone

ec2_credential

FieldTypeNullKeyDefaultExtra
access varchar(64) NO PRI NULL  
secret varchar(64) YES NULL    
user_id varchar(64) YES NULL    
tenant_id varchar(64) YES NULL    

endpoint

FieldTypeNullKeyDefaultExtra
id varchar(64) NO PRI NULL  
region varchar(255) YES NULL    
service_id varchar(64) NO MUL NULL  
extra text YES NULL    

metadata

FieldTypeNullKeyDefaultExtra
user_id varchar(64) NO PRI NULL  
tenant_id varchar(64) NO PRI NULL  
data text YES NULL    

migrate_version

FieldTypeNullKeyDefaultExtra
repository_id varchar(250) NO PRI NULL  
repository_path text YES NULL    
version int(11) YES NULL    

role

FieldTypeNullKeyDefaultExtra
id varchar(64) NO PRI NULL  
name varchar(64) NO UNI NULL  

service

FieldTypeNullKeyDefaultExtra
id varchar(64) NO PRI NULL  
type varchar(255) YES NULL    
extra text YES NULL    

tenant

FieldTypeNullKeyDefaultExtra
id varchar(64) NO PRI NULL  
name varchar(64) NO UNI NULL  
extra text YES NULL    

token

FieldTypeNullKeyDefaultExtra
id varchar(64) NO PRI NULL  
expires datetime YES NULL    
extra text YES NULL    
valid tinyint(1) NO NULL    

user

FieldTypeNullKeyDefaultExtra
id varchar(64) NO PRI NULL  
name varchar(64) NO UNI NULL  
extra text YES NULL    

user_tenant_membership

FieldTypeNullKeyDefaultExtra
user_id varchar(64) NO PRI NULL  
tenant_id varchar(64) NO PRI NULL  

Glance

image_members

FieldTypeNullKeyDefaultExtra
id int(11) NO PRI NULL auto_increment
image_id varchar(36) NO MUL NULL  
member varchar(255) NO NULL    
can_share tinyint(1) NO NULL    
created_at datetime NO NULL    
updated_at datetime YES NULL    
deleted_at datetime YES NULL    
deleted tinyint(1) NO MUL NULL  

image_properties

FieldTypeNullKeyDefaultExtra
id int(11) NO PRI NULL auto_increment
image_id varchar(36) NO MUL NULL  
name varchar(255) NO NULL    
value text YES NULL    
created_at datetime NO NULL    
updated_at datetime YES NULL    
deleted_at datetime YES NULL    
deleted tinyint(1) NO MUL NULL  

image_tags

FieldTypeNullKeyDefaultExtra
id int(11) NO PRI NULL auto_increment
image_id varchar(36) NO MUL NULL  
value varchar(255) NO NULL    
created_at datetime NO NULL    
updated_at datetime YES NULL    
deleted_at datetime YES NULL    
deleted tinyint(1) NO NULL    

images

FieldTypeNullKeyDefaultExtra
id varchar(36) NO PRI NULL  
name varchar(255) YES NULL    
size bigint(20) YES NULL    
status varchar(30) NO NULL    
is_public tinyint(1) NO MUL NULL  
location text YES NULL    
created_at datetime NO NULL    
updated_at datetime YES NULL    
deleted_at datetime YES NULL    
deleted tinyint(1) NO MUL NULL  
disk_format varchar(20) YES NULL    
container_format varchar(20) YES NULL    
checksum varchar(32) YES NULL    
owner varchar(255) YES NULL    
min_disk int(11) NO NULL    
min_ram int(11) NO NULL    
protected tinyint(1) YES NULL    

migrate_version

FieldTypeNullKeyDefaultExtra
repository_id varchar(250) NO PRI NULL  
repository_path text YES NULL    
version int(11) YES NULL    

Nova

agent_builds

FieldTypeNullKeyDefaultExtra
created_at datetime YES NULL    
updated_at datetime YES NULL    
deleted_at datetime YES NULL    
deleted tinyint(1) YES NULL    
id int(11) NO PRI NULL auto_increment
hypervisor varchar(255) YES MUL NULL  
os varchar(255) YES NULL    
architecture varchar(255) YES NULL    
version varchar(255) YES NULL    
url varchar(255) YES NULL    
md5hash varchar(255) YES NULL    

aggregate_hosts

FieldTypeNullKeyDefaultExtra
created_at datetime YES NULL    
updated_at datetime YES NULL    
deleted_at datetime YES NULL    
deleted tinyint(1) YES NULL    
id int(11) NO PRI NULL auto_increment
host varchar(255) YES NULL    
aggregate_id int(11) NO MUL NULL  

aggregate_metadata

FieldTypeNullKeyDefaultExtra
created_at datetime YES NULL    
updated_at datetime YES NULL    
deleted_at datetime YES NULL    
deleted tinyint(1) YES NULL    
id int(11) NO PRI NULL auto_increment
aggregate_id int(11) NO MUL NULL  
key varchar(255) NO MUL NULL  
value varchar(255) NO NULL    

aggregates

FieldTypeNullKeyDefaultExtra
created_at datetime YES NULL    
updated_at datetime YES NULL    
deleted_at datetime YES NULL    
deleted tinyint(1) YES NULL    
id int(11) NO PRI NULL auto_increment
name varchar(255) YES NULL    
availability_zone varchar(255) NO NULL    

block_device_mapping

FieldTypeNullKeyDefaultExtra
created_at datetime YES NULL    
updated_at datetime YES NULL    
deleted_at datetime YES NULL    
deleted tinyint(1) YES NULL    
id int(11) NO PRI NULL auto_increment
device_name varchar(255) NO NULL    
delete_on_termination tinyint(1) YES NULL    
virtual_name varchar(255) YES NULL    
snapshot_id varchar(36) YES MUL NULL  
volume_id varchar(36) YES MUL NULL  
volume_size int(11) YES NULL    
no_device tinyint(1) YES NULL    
connection_info mediumtext YES NULL    
instance_uuid varchar(36) YES MUL NULL  

bw_usage_cache

FieldTypeNullKeyDefaultExtra
created_at datetime YES NULL    
updated_at datetime YES NULL    
deleted_at datetime YES NULL    
deleted tinyint(1) YES NULL    
id int(11) NO PRI NULL auto_increment
start_period datetime NO NULL    
last_refreshed datetime YES NULL    
bw_in bigint(20) YES NULL    
bw_out bigint(20) YES NULL    
mac varchar(255) YES NULL    
uuid varchar(36) YES MUL NULL  

cells

FieldTypeNullKeyDefaultExtra
created_at datetime YES NULL    
updated_at datetime YES NULL    
deleted_at datetime YES NULL    
deleted tinyint(1) YES NULL    
id int(11) NO PRI NULL auto_increment
api_url varchar(255) YES NULL    
username varchar(255) YES NULL    
password varchar(255) YES NULL    
weight_offset float YES NULL    
weight_scale float YES NULL    
name varchar(255) YES NULL    
is_parent tinyint(1) YES NULL    
rpc_host varchar(255) YES NULL    
rpc_port int(11) YES NULL    
rpc_virtual_host varchar(255) YES NULL    

certificates

FieldTypeNullKeyDefaultExtra
created_at datetime YES NULL    
updated_at datetime YES NULL    
deleted_at datetime YES NULL    
deleted tinyint(1) YES NULL    
id int(11) NO PRI NULL auto_increment
user_id varchar(255) YES MUL NULL  
project_id varchar(255) YES MUL NULL  
file_name varchar(255) YES NULL    

compute_node_stats

FieldTypeNullKeyDefaultExtra
created_at datetime YES NULL    
updated_at datetime YES NULL    
deleted_at datetime YES NULL    
deleted tinyint(1) YES NULL    
id int(11) NO PRI NULL auto_increment
compute_node_id int(11) NO MUL NULL  
key varchar(255) NO NULL    
value varchar(255) YES NULL    

compute_nodes

FieldTypeNullKeyDefaultExtra
created_at datetime YES NULL    
updated_at datetime YES NULL    
deleted_at datetime YES NULL    
deleted tinyint(1) YES NULL    
id int(11) NO PRI NULL auto_increment
service_id int(11) NO NULL    
vcpus int(11) NO NULL    
memory_mb int(11) NO NULL    
local_gb int(11) NO NULL    
vcpus_used int(11) NO NULL    
memory_mb_used int(11) NO NULL    
local_gb_used int(11) NO NULL    
hypervisor_type mediumtext NO NULL    
hypervisor_version int(11) NO NULL    
cpu_info mediumtext NO NULL    
disk_available_least int(11) YES NULL    
free_ram_mb int(11) YES NULL    
free_disk_gb int(11) YES NULL    
current_workload int(11) YES NULL    
running_vms int(11) YES NULL    
hypervisor_hostname varchar(255) YES NULL    

console_pools

FieldTypeNullKeyDefaultExtra
created_at datetime YES NULL    
updated_at datetime YES NULL    
deleted_at datetime YES NULL    
deleted tinyint(1) YES NULL    
id int(11) NO PRI NULL auto_increment
address varchar(255) YES NULL    
username varchar(255) YES NULL    
password varchar(255) YES NULL    
console_type varchar(255) YES NULL    
public_hostname varchar(255) YES NULL    
host varchar(255) YES NULL    
compute_host varchar(255) YES NULL    

consoles

FieldTypeNullKeyDefaultExtra
created_at datetime YES NULL    
updated_at datetime YES NULL    
deleted_at datetime YES NULL    
deleted tinyint(1) YES NULL    
id int(11) NO PRI NULL auto_increment
instance_name varchar(255) YES NULL    
password varchar(255) YES NULL    
port int(11) YES NULL    
pool_id int(11) YES MUL NULL  
instance_uuid varchar(36) YES MUL NULL  

dns_domains

FieldTypeNullKeyDefaultExtra
created_at datetime YES NULL    
updated_at datetime YES NULL    
deleted_at datetime YES NULL    
deleted tinyint(1) YES NULL    
domain varchar(255) NO PRI NULL  
scope varchar(255) YES NULL    
availability_zone varchar(255) YES NULL    
project_id varchar(255) YES MUL NULL  

fixed_ips

FieldTypeNullKeyDefaultExtra
created_at datetime YES NULL    
updated_at datetime YES NULL    
deleted_at datetime YES NULL    
deleted tinyint(1) YES NULL    
id int(11) NO PRI NULL auto_increment
address varchar(255) YES MUL NULL  
network_id int(11) YES MUL NULL  
allocated tinyint(1) YES NULL    
leased tinyint(1) YES NULL    
reserved tinyint(1) YES NULL    
virtual_interface_id int(11) YES MUL NULL  
host varchar(255) YES MUL NULL  
instance_uuid varchar(36) YES MUL NULL  

floating_ips

FieldTypeNullKeyDefaultExtra
created_at datetime YES NULL    
updated_at datetime YES NULL    
deleted_at datetime YES NULL    
deleted tinyint(1) YES NULL    
id int(11) NO PRI NULL auto_increment
address varchar(255) YES NULL    
fixed_ip_id int(11) YES MUL NULL  
project_id varchar(255) YES MUL NULL  
host varchar(255) YES MUL NULL  
auto_assigned tinyint(1) YES NULL    
pool varchar(255) YES MUL NULL  
interface varchar(255) YES NULL    

instance_faults

FieldTypeNullKeyDefaultExtra
created_at datetime YES NULL    
updated_at datetime YES NULL    
deleted_at datetime YES NULL    
deleted tinyint(1) YES NULL    
id int(11) NO PRI NULL auto_increment
instance_uuid varchar(36) YES MUL NULL  
code int(11) NO NULL    
message varchar(255) YES NULL    
details mediumtext YES NULL    

instance_id_mappings

FieldTypeNullKeyDefaultExtra
created_at datetime YES NULL    
updated_at datetime YES NULL    
deleted_at datetime YES NULL    
deleted tinyint(1) YES NULL    
id int(11) NO PRI NULL auto_increment
uuid varchar(36) NO MUL NULL  

instance_info_caches

FieldTypeNullKeyDefaultExtra
created_at datetime YES NULL    
updated_at datetime YES NULL    
deleted_at datetime YES NULL    
deleted tinyint(1) YES NULL    
id int(11) NO PRI NULL auto_increment
network_info mediumtext YES NULL    
instance_uuid varchar(36) NO UNI NULL  

instance_metadata

FieldTypeNullKeyDefaultExtra
created_at datetime YES NULL    
updated_at datetime YES NULL    
deleted_at datetime YES NULL    
deleted tinyint(1) YES NULL    
id int(11) NO PRI NULL auto_increment
key varchar(255) YES NULL    
value varchar(255) YES NULL    
instance_uuid varchar(36) YES MUL NULL  

instance_system_metadata

FieldTypeNullKeyDefaultExtra
created_at datetime YES NULL    
updated_at datetime YES NULL    
deleted_at datetime YES NULL    
deleted tinyint(1) YES NULL    
id int(11) NO PRI NULL auto_increment
instance_uuid varchar(36) NO MUL NULL  
key varchar(255) NO NULL    
value varchar(255) YES NULL    

instance_type_extra_specs

FieldTypeNullKeyDefaultExtra
created_at datetime YES NULL    
updated_at datetime YES NULL    
deleted_at datetime YES NULL    
deleted tinyint(1) YES NULL    
id int(11) NO PRI NULL auto_increment
instance_type_id int(11) NO MUL NULL  
key varchar(255) YES NULL    
value varchar(255) YES NULL    

instance_type_projects

FieldTypeNullKeyDefaultExtra
created_at datetime YES NULL    
updated_at datetime YES NULL    
deleted_at datetime YES NULL    
deleted tinyint(1) YES NULL    
id int(11) NO PRI NULL auto_increment
instance_type_id int(11) NO MUL NULL  
project_id varchar(255) YES NULL    

instance_types

FieldTypeNullKeyDefaultExtra
created_at datetime YES NULL    
updated_at datetime YES NULL    
deleted_at datetime YES NULL    
deleted tinyint(1) YES NULL    
name varchar(255) YES NULL    
id int(11) NO PRI NULL auto_increment
memory_mb int(11) NO NULL    
vcpus int(11) NO NULL    
swap int(11) NO NULL    
vcpu_weight int(11) YES NULL    
flavorid varchar(255) YES NULL    
rxtx_factor float YES NULL    
root_gb int(11) YES NULL    
ephemeral_gb int(11) YES NULL    
disabled tinyint(1) YES NULL    
is_public tinyint(1) YES NULL    

instances

FieldTypeNullKeyDefaultExtra
created_at datetime YES NULL    
updated_at datetime YES NULL    
deleted_at datetime YES NULL    
deleted tinyint(1) YES NULL    
id int(11) NO PRI NULL auto_increment
internal_id int(11) YES NULL    
user_id varchar(255) YES NULL    
project_id varchar(255) YES MUL NULL  
image_ref varchar(255) YES NULL    
kernel_id varchar(255) YES NULL    
ramdisk_id varchar(255) YES NULL    
server_name varchar(255) YES NULL    
launch_index int(11) YES NULL    
key_name varchar(255) YES NULL    
key_data mediumtext YES NULL    
power_state int(11) YES NULL    
vm_state varchar(255) YES NULL    
memory_mb int(11) YES NULL    
vcpus int(11) YES NULL    
hostname varchar(255) YES NULL    
host varchar(255) YES MUL NULL  
user_data mediumtext YES NULL    
reservation_id varchar(255) YES MUL NULL  
scheduled_at datetime YES NULL    
launched_at datetime YES NULL    
terminated_at datetime YES MUL NULL  
display_name varchar(255) YES NULL    
display_description varchar(255) YES NULL    
availability_zone varchar(255) YES NULL    
locked tinyint(1) YES NULL    
os_type varchar(255) YES NULL    
launched_on mediumtext YES NULL    
instance_type_id int(11) YES NULL    
vm_mode varchar(255) YES NULL    
uuid varchar(36) YES UNI NULL  
architecture varchar(255) YES NULL    
root_device_name varchar(255) YES NULL    
access_ip_v4 varchar(255) YES NULL    
access_ip_v6 varchar(255) YES NULL    
config_drive varchar(255) YES NULL    
task_state varchar(255) YES MUL NULL  
default_ephemeral_device varchar(255) YES NULL    
default_swap_device varchar(255) YES NULL    
progress int(11) YES NULL    
auto_disk_config tinyint(1) YES NULL    
shutdown_terminate tinyint(1) YES NULL    
disable_terminate tinyint(1) YES NULL    
root_gb int(11) YES NULL    
ephemeral_gb int(11) YES NULL    
cell_name varchar(255) YES NULL    

iscsi_targets

FieldTypeNullKeyDefaultExtra
created_at datetime YES NULL    
updated_at datetime YES NULL    
deleted_at datetime YES NULL    
deleted tinyint(1) YES NULL    
id int(11) NO PRI NULL auto_increment
target_num int(11) YES NULL    
host varchar(255) YES MUL NULL  
volume_id varchar(36) YES MUL NULL  

key_pairs

FieldTypeNullKeyDefaultExtra
created_at datetime YES NULL    
updated_at datetime YES NULL    
deleted_at datetime YES NULL    
deleted tinyint(1) YES NULL    
id int(11) NO PRI NULL auto_increment
name varchar(255) YES NULL    
user_id varchar(255) YES MUL NULL  
fingerprint varchar(255) YES NULL    
public_key mediumtext YES NULL    

migrate_version

FieldTypeNullKeyDefaultExtra
repository_id varchar(250) NO PRI NULL  
repository_path mediumtext YES NULL    
version int(11) YES NULL    

migrations

FieldTypeNullKeyDefaultExtra
created_at datetime YES NULL    
updated_at datetime YES NULL    
deleted_at datetime YES NULL    
deleted tinyint(1) YES NULL    
id int(11) NO PRI NULL auto_increment
source_compute varchar(255) YES NULL    
dest_compute varchar(255) YES NULL    
dest_host varchar(255) YES NULL    
status varchar(255) YES NULL    
instance_uuid varchar(255) YES NULL    
old_instance_type_id int(11) YES NULL    
new_instance_type_id int(11) YES NULL    

networks

FieldTypeNullKeyDefaultExtra
created_at datetime YES NULL    
updated_at datetime YES NULL    
deleted_at datetime YES NULL    
deleted tinyint(1) YES NULL    
id int(11) NO PRI NULL auto_increment
injected tinyint(1) YES NULL    
cidr varchar(255) YES NULL    
netmask varchar(255) YES NULL    
bridge varchar(255) YES MUL NULL  
gateway varchar(255) YES NULL    
broadcast varchar(255) YES NULL    
dns1 varchar(255) YES NULL    
vlan int(11) YES MUL NULL  
vpn_public_address varchar(255) YES NULL    
vpn_public_port int(11) YES NULL    
vpn_private_address varchar(255) YES NULL    
dhcp_start varchar(255) YES NULL    
project_id varchar(255) YES MUL NULL  
host varchar(255) YES MUL NULL  
cidr_v6 varchar(255) YES MUL NULL  
gateway_v6 varchar(255) YES NULL    
label varchar(255) YES NULL    
netmask_v6 varchar(255) YES NULL    
bridge_interface varchar(255) YES NULL    
multi_host tinyint(1) YES NULL    
dns2 varchar(255) YES NULL    
uuid varchar(36) YES MUL NULL  
priority int(11) YES NULL    
rxtx_base int(11) YES NULL    

provider_fw_rules

FieldTypeNullKeyDefaultExtra
created_at datetime YES NULL    
updated_at datetime YES NULL    
deleted_at datetime YES NULL    
deleted tinyint(1) YES NULL    
id int(11) NO PRI NULL auto_increment
protocol varchar(5) YES NULL    
from_port int(11) YES NULL    
to_port int(11) YES NULL    
cidr varchar(255) YES NULL    

quota_classes

FieldTypeNullKeyDefaultExtra
created_at datetime YES NULL    
updated_at datetime YES NULL    
deleted_at datetime YES NULL    
deleted tinyint(1) YES NULL    
id int(11) NO PRI NULL auto_increment
class_name varchar(255) YES MUL NULL  
resource varchar(255) YES NULL    
hard_limit int(11) YES NULL    

quota_usages

FieldTypeNullKeyDefaultExtra
created_at datetime YES NULL    
updated_at datetime YES NULL    
deleted_at datetime YES NULL    
deleted tinyint(1) YES NULL    
id int(11) NO PRI NULL auto_increment
project_id varchar(255) YES MUL NULL  
resource varchar(255) YES NULL    
in_use int(11) NO NULL    
reserved int(11) NO NULL    
until_refresh int(11) YES NULL    

quotas

FieldTypeNullKeyDefaultExtra
id int(11) NO PRI NULL auto_increment
created_at datetime YES NULL    
updated_at datetime YES NULL    
deleted_at datetime YES NULL    
deleted tinyint(1) YES NULL    
project_id varchar(255) YES NULL    
resource varchar(255) NO NULL    
hard_limit int(11) YES NULL    

reservations

FieldTypeNullKeyDefaultExtra
created_at datetime YES NULL    
updated_at datetime YES NULL    
deleted_at datetime YES NULL    
deleted tinyint(1) YES NULL    
id int(11) NO PRI NULL auto_increment
uuid varchar(36) NO NULL    
usage_id int(11) NO MUL NULL  
project_id varchar(255) YES MUL NULL  
resource varchar(255) YES NULL    
delta int(11) NO NULL    
expire datetime YES NULL    

s3_images

FieldTypeNullKeyDefaultExtra
created_at datetime YES NULL    
updated_at datetime YES NULL    
deleted_at datetime YES NULL    
deleted tinyint(1) YES NULL    
id int(11) NO PRI NULL auto_increment
uuid varchar(36) NO NULL    

security_group_instance_association

FieldTypeNullKeyDefaultExtra
created_at datetime YES NULL    
updated_at datetime YES NULL    
deleted_at datetime YES NULL    
deleted tinyint(1) YES NULL    
id int(11) NO PRI NULL auto_increment
security_group_id int(11) YES MUL NULL  
instance_uuid varchar(36) YES MUL NULL  

security_group_rules

FieldTypeNullKeyDefaultExtra
created_at datetime YES NULL    
updated_at datetime YES NULL    
deleted_at datetime YES NULL    
deleted tinyint(1) YES NULL    
id int(11) NO PRI NULL auto_increment
parent_group_id int(11) YES MUL NULL  
protocol varchar(255) YES NULL    
from_port int(11) YES NULL    
to_port int(11) YES NULL    
cidr varchar(255) YES NULL    
group_id int(11) YES MUL NULL  

security_groups

FieldTypeNullKeyDefaultExtra
created_at datetime YES NULL    
updated_at datetime YES NULL    
deleted_at datetime YES NULL    
deleted tinyint(1) YES NULL    
id int(11) NO PRI NULL auto_increment
name varchar(255) YES NULL    
description varchar(255) YES NULL    
user_id varchar(255) YES NULL    
project_id varchar(255) YES NULL    

services

FieldTypeNullKeyDefaultExtra
created_at datetime YES NULL    
updated_at datetime YES NULL    
deleted_at datetime YES NULL    
deleted tinyint(1) YES NULL    
id int(11) NO PRI NULL auto_increment
host varchar(255) YES NULL    
binary varchar(255) YES NULL    
topic varchar(255) YES NULL    
report_count int(11) NO NULL    
disabled tinyint(1) YES NULL    
availability_zone varchar(255) YES NULL    

sm_backend_config

FieldTypeNullKeyDefaultExtra
created_at datetime YES NULL    
updated_at datetime YES NULL    
deleted_at datetime YES NULL    
deleted tinyint(1) YES NULL    
id int(11) NO PRI NULL auto_increment
flavor_id int(11) NO MUL NULL  
sr_uuid varchar(255) YES NULL    
sr_type varchar(255) YES NULL    
config_params varchar(2047) YES NULL    

sm_flavors

FieldTypeNullKeyDefaultExtra
created_at datetime YES NULL    
updated_at datetime YES NULL    
deleted_at datetime YES NULL    
deleted tinyint(1) YES NULL    
id int(11) NO PRI NULL auto_increment
label varchar(255) YES NULL    
description varchar(255) YES NULL    

sm_volume

FieldTypeNullKeyDefaultExtra
created_at datetime YES NULL    
updated_at datetime YES NULL    
deleted_at datetime YES NULL    
deleted tinyint(1) YES NULL    
id varchar(36) NO PRI NULL  
backend_id int(11) NO MUL NULL  
vdi_uuid varchar(255) YES NULL    

snapshot_id_mappings

FieldTypeNullKeyDefaultExtra
created_at datetime YES NULL    
updated_at datetime YES NULL    
deleted_at datetime YES NULL    
deleted tinyint(1) YES NULL    
id int(11) NO PRI NULL auto_increment
uuid varchar(36) NO NULL    

snapshots

FieldTypeNullKeyDefaultExtra
created_at datetime YES NULL    
updated_at datetime YES NULL    
deleted_at datetime YES NULL    
deleted tinyint(1) YES NULL    
id varchar(36) NO PRI NULL  
volume_id varchar(36) NO NULL    
user_id varchar(255) YES NULL    
project_id varchar(255) YES NULL    
status varchar(255) YES NULL    
progress varchar(255) YES NULL    
volume_size int(11) YES NULL    
scheduled_at datetime YES NULL    
display_name varchar(255) YES NULL    
display_description varchar(255) YES NULL    

task_log

FieldTypeNullKeyDefaultExtra
created_at datetime YES NULL    
updated_at datetime YES NULL    
deleted_at datetime YES NULL    
deleted tinyint(1) YES NULL    
id int(11) NO PRI NULL auto_increment
task_name varchar(255) NO NULL    
state varchar(255) NO NULL    
host varchar(255) NO MUL NULL  
period_beginning varchar(255) NO MUL NULL  
period_ending varchar(255) NO MUL NULL  
message varchar(255) NO NULL    
task_items int(11) YES NULL    
errors int(11) YES NULL    

virtual_interfaces

FieldTypeNullKeyDefaultExtra
created_at datetime YES NULL    
updated_at datetime YES NULL    
deleted_at datetime YES NULL    
deleted tinyint(1) YES NULL    
id int(11) NO PRI NULL auto_increment
address varchar(255) YES UNI NULL  
network_id int(11) YES MUL NULL  
uuid varchar(36) YES NULL    
instance_uuid varchar(36) YES MUL NULL  

virtual_storage_arrays

FieldTypeNullKeyDefaultExtra
created_at datetime YES NULL    
updated_at datetime YES NULL    
deleted_at datetime YES NULL    
deleted tinyint(1) YES NULL    
id int(11) NO PRI NULL auto_increment
display_name varchar(255) YES NULL    
display_description varchar(255) YES NULL    
project_id varchar(255) YES NULL    
availability_zone varchar(255) YES NULL    
instance_type_id int(11) NO NULL    
image_ref varchar(255) YES NULL    
vc_count int(11) NO NULL    
vol_count int(11) NO NULL    
status varchar(255) YES NULL    

volume_id_mappings

FieldTypeNullKeyDefaultExtra
created_at datetime YES NULL    
updated_at datetime YES NULL    
deleted_at datetime YES NULL    
deleted tinyint(1) YES NULL    
id int(11) NO PRI NULL auto_increment
uuid varchar(36) NO NULL    

volume_metadata

FieldTypeNullKeyDefaultExtra
created_at datetime YES NULL    
updated_at datetime YES NULL    
deleted_at datetime YES NULL    
deleted tinyint(1) YES NULL    
id int(11) NO PRI NULL auto_increment
volume_id varchar(36) NO MUL NULL  
key varchar(255) YES NULL    
value varchar(255) YES NULL    

volume_type_extra_specs

FieldTypeNullKeyDefaultExtra
created_at datetime YES NULL    
updated_at datetime YES NULL    
deleted_at datetime YES NULL    
deleted tinyint(1) YES NULL    
id int(11) NO PRI NULL auto_increment
volume_type_id int(11) NO MUL NULL  
key varchar(255) YES NULL    
value varchar(255) YES NULL    

volume_types

FieldTypeNullKeyDefaultExtra
created_at datetime YES NULL    
updated_at datetime YES NULL    
deleted_at datetime YES NULL    
deleted tinyint(1) YES NULL    
id int(11) NO PRI NULL auto_increment
name varchar(255) YES NULL    

volumes

FieldTypeNullKeyDefaultExtra
created_at datetime YES NULL    
updated_at datetime YES NULL    
deleted_at datetime YES NULL    
deleted tinyint(1) YES NULL    
id varchar(36) NO PRI NULL  
ec2_id varchar(255) YES NULL    
user_id varchar(255) YES NULL    
project_id varchar(255) YES NULL    
host varchar(255) YES NULL    
size int(11) YES NULL    
availability_zone varchar(255) YES NULL    
mountpoint varchar(255) YES NULL    
status varchar(255) YES NULL    
attach_status varchar(255) YES NULL    
scheduled_at datetime YES NULL    
launched_at datetime YES NULL    
terminated_at datetime YES NULL    
display_name varchar(255) YES NULL    
display_description varchar(255) YES NULL    
provider_location varchar(256) YES NULL    
provider_auth varchar(256) YES NULL    
snapshot_id varchar(36) YES NULL    
volume_type_id int(11) YES NULL    
instance_uuid varchar(36) YES MUL NULL  
attach_time datetime YES NULL    

Cinder

iscsi_targets

FieldTypeNullKeyDefaultExtra
created_at datetime YES NULL    
updated_at datetime YES NULL    
deleted_at datetime YES NULL    
deleted tinyint(1) YES NULL    
id int(11) NO PRI NULL auto_increment
target_num int(11) YES NULL    
host varchar(255) YES NULL    
volume_id varchar(36) YES MUL NULL  

migrate_version

FieldTypeNullKeyDefaultExtra
repository_id varchar(250) NO PRI NULL  
repository_path mediumtext YES NULL    
version int(11) YES NULL    

migrations

FieldTypeNullKeyDefaultExtra
created_at datetime YES NULL    
updated_at datetime YES NULL    
deleted_at datetime YES NULL    
deleted tinyint(1) YES NULL    
id int(11) NO PRI NULL auto_increment
source_compute varchar(255) YES NULL    
dest_compute varchar(255) YES NULL    
dest_host varchar(255) YES NULL    
status varchar(255) YES NULL    
instance_uuid varchar(255) YES NULL    
old_instance_type_id int(11) YES NULL    
new_instance_type_id int(11) YES NULL    

quota_classes

FieldTypeNullKeyDefaultExtra
created_at datetime YES NULL    
updated_at datetime YES NULL    
deleted_at datetime YES NULL    
deleted tinyint(1) YES NULL    
id int(11) NO PRI NULL auto_increment
class_name varchar(255) YES MUL NULL  
resource varchar(255) YES NULL    
hard_limit int(11) YES NULL    

quota_usages

FieldTypeNullKeyDefaultExtra
created_at datetime YES NULL    
updated_at datetime YES NULL    
deleted_at datetime YES NULL    
deleted tinyint(1) YES NULL    
id int(11) NO PRI NULL auto_increment
project_id varchar(255) YES MUL NULL  
resource varchar(255) YES NULL    
in_use int(11) NO NULL    
reserved int(11) NO NULL    
until_refresh int(11) YES NULL    

quotas

FieldTypeNullKeyDefaultExtra
id int(11) NO PRI NULL auto_increment
created_at datetime YES NULL    
updated_at datetime YES NULL    
deleted_at datetime YES NULL    
deleted tinyint(1) YES NULL    
project_id varchar(255) YES NULL    
resource varchar(255) NO NULL    
hard_limit int(11) YES NULL    

reservations

FieldTypeNullKeyDefaultExtra
created_at datetime YES NULL    
updated_at datetime YES NULL    
deleted_at datetime YES NULL    
deleted tinyint(1) YES NULL    
id int(11) NO PRI NULL auto_increment
uuid varchar(36) NO NULL    
usage_id int(11) NO MUL NULL  
project_id varchar(255) YES MUL NULL  
resource varchar(255) YES NULL    
delta int(11) NO NULL    
expire datetime YES NULL    

servicesservices

FieldTypeNullKeyDefaultExtra
created_at datetime YES NULL    
updated_at datetime YES NULL    
deleted_at datetime YES NULL    
deleted tinyint(1) YES NULL    
id int(11) NO PRI NULL auto_increment
host varchar(255) YES NULL    
binary varchar(255) YES NULL    
topic varchar(255) YES NULL    
report_count int(11) NO NULL    
disabled tinyint(1) YES NULL    
availability_zone varchar(255) YES NULL    

sm_backend_config

FieldTypeNullKeyDefaultExtra
created_at datetime YES NULL    
updated_at datetime YES NULL    
deleted_at datetime YES NULL    
deleted tinyint(1) YES NULL    
id int(11) NO PRI NULL auto_increment
flavor_id int(11) NO MUL NULL  
sr_uuid varchar(255) YES NULL    
sr_type varchar(255) YES NULL    
config_params varchar(2047) YES NULL    

sm_flavors

FieldTypeNullKeyDefaultExtra
created_at datetime YES NULL    
updated_at datetime YES NULL    
deleted_at datetime YES NULL    
deleted tinyint(1) YES NULL    
id int(11) NO PRI NULL auto_increment
label varchar(255) YES NULL    
ription varchar(255) YES NULL    

sm_volume

FieldTypeNullKeyDefaultExtra
created_at datetime YES NULL    
updated_at datetime YES NULL    
deleted_at datetime YES NULL    
deleted tinyint(1) YES NULL    
id varchar(36) NO PRI NULL  
backend_id int(11) NO MUL NULL  
vdi_uuid varchar(255) YES NULL    

snapshots

FieldTypeNullKeyDefaultExtra
created_at datetime YES NULL    
updated_at datetime YES NULL    
deleted_at datetime YES NULL    
deleted tinyint(1) YES NULL    
id varchar(36) NO PRI NULL  
volume_id varchar(36) NO NULL    
user_id varchar(255) YES NULL    
project_id varchar(255) YES NULL    
status varchar(255) YES NULL    
progress varchar(255) YES NULL    
volume_size int(11) YES NULL    
scheduled_at datetime YES NULL    
display_name varchar(255) YES NULL    
display_ription varchar(255) YES NULL    

volume_metadata

FieldTypeNullKeyDefaultExtra
created_at datetime YES NULL    
updated_at datetime YES NULL    
deleted_at datetime YES NULL    
deleted tinyint(1) YES NULL    
id int(11) NO PRI NULL auto_increment
volume_id varchar(36) NO MUL NULL  
key varchar(255) YES NULL    
value varchar(255) YES NULL    

volume_type_extra_specs

FieldTypeNullKeyDefaultExtra
created_at datetime YES NULL    
updated_at datetime YES NULL    
deleted_at datetime YES NULL    
deleted tinyint(1) YES NULL    
id int(11) NO PRI NULL auto_increment
volume_type_id int(11) NO MUL NULL  
key varchar(255) YES NULL    
value varchar(255) YES NULL    

volume_types

FieldTypeNullKeyDefaultExtra
created_at datetime YES NULL    
updated_at datetime YES NULL    
deleted_at datetime YES NULL    
deleted tinyint(1) YES NULL    
id int(11) NO PRI NULL auto_increment
name varchar(255) YES NULL    

volumes

FieldTypeNullKeyDefaultExtra
created_at datetime YES NULL    
updated_at datetime YES NULL    
deleted_at datetime YES NULL    
deleted tinyint(1) YES NULL    
id varchar(36) NO PRI NULL  
ec2_id varchar(255) YES NULL    
user_id varchar(255) YES NULL    
project_id varchar(255) YES NULL    
host varchar(255) YES NULL    
size int(11) YES NULL    
availability_zone varchar(255) YES NULL    
instance_uuid varchar(36) YES NULL    
mountpoint varchar(255) YES NULL    
attach_time varchar(255) YES NULL    
status varchar(255) YES NULL    
attach_status varchar(255) YES NULL    
scheduled_at datetime YES NULL    
launched_at datetime YES NULL    
terminated_at datetime YES NULL    
display_name varchar(255) YES NULL    
display_ription varchar(255) YES NULL    
provider_location varchar(256) YES NULL    
provider_auth varchar(256) YES NULL    
snapshot_id varchar(36) YES NULL    
volume_type_id int(11) YES NULL    

Quantum

dnsnameservers

FieldTypeNullKeyDefaultExtra
address varchar(128) NO PRI NULL  
subnet_id varchar(36) NO PRI NULL  

externalnetworks

FieldTypeNullKeyDefaultExtra
network_id varchar(36) NO PRI NULL  

floatingips

FieldTypeNullKeyDefaultExtra
tenant_id varchar(255) YES NULL    
id varchar(36) NO PRI NULL  
floating_ip_address varchar(64) NO NULL    
floating_network_id varchar(36) NO NULL    
floating_port_id varchar(36) NO MUL NULL  
fixed_port_id varchar(36) YES MUL NULL  
fixed_ip_address varchar(64) YES NULL    
router_id varchar(36) YES MUL NULL  

ipallocationpools

FieldTypeNullKeyDefaultExtra
id varchar(36) NO PRI NULL  
subnet_id varchar(36) YES MUL NULL  
first_ip varchar(64) NO NULL    
last_ip varchar(64) NO NULL    

ipallocations

FieldTypeNullKeyDefaultExtra
port_id varchar(36) YES MUL NULL  
ip_address varchar(64) NO PRI NULL  
subnet_id varchar(36) NO PRI NULL  
network_id varchar(36) NO PRI NULL  
expiration datetime YES NULL    

ipavailabilityranges

FieldTypeNullKeyDefaultExtra
allocation_pool_id varchar(36) NO PRI    
first_ip varchar(64) NO PRI NULL  
last_ip varchar(64) NO PRI NULL  

networks

FieldTypeNullKeyDefaultExtra
tenant_id varchar(255) YES NULL    
id varchar(36) NO PRI NULL  
name varchar(255) YES NULL    
status varchar(16) YES NULL    
admin_state_up tinyint(1) YES NULL    
shared tinyint(1) YES NULL    

ovs_network_bindings

FieldTypeNullKeyDefaultExtra
network_id varchar(36) NO PRI NULL  
network_type varchar(32) NO NULL    
physical_network varchar(64) YES NULL    
segmentation_id int(11) YES NULL    

ovs_tunnel_allocations

FieldTypeNullKeyDefaultExtra
tunnel_id int(11) NO PRI NULL  
allocated tinyint(1) NO NULL    

ovs_tunnel_endpoints

FieldTypeNullKeyDefaultExtra
ip_address varchar(64) NO PRI NULL  
id int(11) NO NULL    

ovs_tunnel_ips

FieldTypeNullKeyDefaultExtra
ip_address varchar(255) NO PRI NULL  

ovs_vlan_allocations

FieldTypeNullKeyDefaultExtra
physical_network varchar(64) NO PRI NULL  
vlan_id int(11) NO PRI NULL  
allocated tinyint(1) NO NULL    

ports

FieldTypeNullKeyDefaultExtra
tenant_id varchar(255) YES NULL    
id varchar(36) NO PRI NULL  
name varchar(255) YES NULL    
network_id varchar(36) NO MUL NULL  
mac_address varchar(32) NO NULL    
admin_state_up tinyint(1) NO NULL    
status varchar(16) NO NULL    
device_id varchar(255) NO NULL    
device_owner varchar(255) NO NULL    

routers

FieldTypeNullKeyDefaultExtra
tenant_id varchar(255) YES NULL    
id varchar(36) NO PRI NULL  
name varchar(255) YES NULL    
status varchar(16) YES NULL    
admin_state_up tinyint(1) YES NULL    
gw_port_id varchar(36) YES MUL NULL  

routes

FieldTypeNullKeyDefaultExtra
destination varchar(64) NO PRI NULL  
nexthop varchar(64) NO PRI NULL  
subnet_id varchar(36) NO PRI NULL  

subnets

FieldTypeNullKeyDefaultExtra
tenant_id varchar(255) YES NULL    
id varchar(36) NO PRI NULL  
name varchar(255) YES NULL    
network_id varchar(36) YES MUL NULL  
ip_version int(11) NO NULL    
cidr varchar(64) NO NULL    
gateway_ip varchar(64) YES NULL    
enable_dhcp tinyint(1) YES NULL    
shared tinyint(1) YES NULL