2done.org

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

OpenStack Essex (Ubuntu パッケージ)で生成されるテーブル一覧

mysql> DESC table の結果

Nova

agent_builds

Field Type Null Key Default Extra
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 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

Field Type Null Key Default Extra
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 UNI NULL
aggregate_id int(11) NO MUL NULL

aggregate_metadata

Field Type Null Key Default Extra
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 NULL
value varchar(255) NO NULL

aggregates

Field Type Null Key Default Extra
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 UNI NULL
operational_state varchar(255) NO NULL
availability_zone varchar(255) NO NULL

auth_tokens

Field Type Null Key Default Extra
created_at datetime YES NULL
updated_at datetime YES NULL
deleted_at datetime YES NULL
deleted tinyint(1) YES NULL
token_hash varchar(255) NO PRI NULL
user_id varchar(255) YES NULL
server_management_url varchar(255) YES NULL
storage_url varchar(255) YES NULL
cdn_management_url varchar(255) YES NULL

block_device_mapping

Field Type Null Key Default Extra
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_id int(11) NO MUL NULL
device_name varchar(255) NO NULL
delete_on_termination tinyint(1) YES NULL
virtual_name varchar(255) YES NULL
snapshot_id int(11) YES MUL NULL
volume_id int(11) YES MUL NULL
volume_size int(11) YES NULL
no_device tinyint(1) YES NULL
connection_info mediumtext YES NULL

bw_usage_cache

Field Type Null Key Default Extra
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

cells

Field Type Null Key Default Extra
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

Field Type Null Key Default Extra
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 NULL
project_id varchar(255) YES NULL
file_name varchar(255) YES NULL

compute_nodes

Field Type Null Key Default Extra
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

Field Type Null Key Default Extra
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

Field Type Null Key Default Extra
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
instance_id int(11) YES NULL
password varchar(255) YES NULL
port int(11) YES NULL
pool_id int(11) YES MUL NULL

dns_domains

Field Type Null Key Default Extra
created_at datetime YES NULL
updated_at datetime YES NULL
deleted_at datetime YES NULL
deleted tinyint(1) YES NULL
domain varchar(512) NO PRI NULL
scope varchar(255) YES NULL
availability_zone varchar(255) YES NULL
project_id varchar(255) YES MUL NULL

fixed_ips

Field Type Null Key Default Extra
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
network_id int(11) YES MUL NULL
instance_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 NULL

floating_ips

Field Type Null Key Default Extra
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 NULL
host varchar(255) YES NULL
auto_assigned tinyint(1) YES NULL
pool varchar(255) YES NULL
interface varchar(255) YES NULL

instance_actions

Field Type Null Key Default Extra
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
action varchar(255) YES NULL
error mediumtext YES NULL
instance_uuid varchar(36) YES NULL

instance_faults

Field Type Null Key Default Extra
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 NULL
code int(11) NO NULL
message varchar(255) YES NULL
details mediumtext YES NULL

instance_info_caches

Field Type Null Key Default Extra
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_id varchar(36) NO UNI NULL

instance_metadata

Field Type Null Key Default Extra
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_id int(11) NO MUL NULL
key varchar(255) YES NULL
value varchar(255) YES NULL

instance_type_extra_specs

Field Type Null Key Default Extra
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_types

Field Type Null Key Default Extra
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

instances

Field Type Null Key Default Extra
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 NULL
user_data mediumtext YES NULL
reservation_id 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
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 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

Field Type Null Key Default Extra
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 int(11) YES MUL NULL

key_pairs

Field Type Null Key Default Extra
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 NULL
fingerprint varchar(255) YES NULL
public_key mediumtext YES NULL

migrate_version

Field Type Null Key Default Extra
repository_id varchar(250) NO PRI NULL
repository_path mediumtext YES NULL
version int(11) YES NULL

migrations

Field Type Null Key Default Extra
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

Field Type Null Key Default Extra
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 NULL
gateway varchar(255) YES NULL
broadcast varchar(255) YES NULL
dns1 varchar(255) YES NULL
vlan int(11) YES 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 NULL
host varchar(255) YES NULL
cidr_v6 varchar(255) YES 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 NULL
priority int(11) YES NULL
rxtx_base int(11) YES NULL

projects

Field Type Null Key Default Extra
created_at datetime YES NULL
updated_at datetime YES NULL
deleted_at datetime YES NULL
deleted tinyint(1) YES NULL
id varchar(255) NO PRI NULL
name varchar(255) YES NULL
description varchar(255) YES NULL
project_manager varchar(255) YES MUL NULL

provider_fw_rules

Field Type Null Key Default Extra
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

quotas

Field Type Null Key Default Extra
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

s3_images

Field Type Null Key Default Extra
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

Field Type Null Key Default Extra
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_id int(11) YES MUL NULL

security_group_rules

Field Type Null Key Default Extra
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

Field Type Null Key Default Extra
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

Field Type Null Key Default Extra
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

Field Type Null Key Default Extra
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

Field Type Null Key Default Extra
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

Field Type Null Key Default Extra
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
backend_id int(11) NO MUL NULL
vdi_uuid varchar(255) YES NULL

snapshots

Field Type Null Key Default Extra
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 int(11) 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

user_project_association

Field Type Null Key Default Extra
created_at datetime YES NULL
updated_at datetime YES NULL
deleted_at datetime YES NULL
deleted tinyint(1) YES NULL
user_id varchar(255) NO PRI NULL
project_id varchar(255) NO PRI NULL

user_project_role_association

Field Type Null Key Default Extra
created_at datetime YES NULL
updated_at datetime YES NULL
deleted_at datetime YES NULL
deleted tinyint(1) YES NULL
user_id varchar(255) NO PRI NULL
project_id varchar(255) NO PRI NULL
role varchar(255) NO PRI NULL

user_role_association

Field Type Null Key Default Extra
created_at datetime YES NULL
updated_at datetime YES NULL
deleted_at datetime YES NULL
deleted tinyint(1) YES NULL
user_id varchar(255) NO PRI NULL
role varchar(255) NO PRI NULL

users

Field Type Null Key Default Extra
created_at datetime YES NULL
updated_at datetime YES NULL
deleted_at datetime YES NULL
deleted tinyint(1) YES NULL
id varchar(255) NO PRI NULL
name varchar(255) YES NULL
access_key varchar(255) YES NULL
secret_key varchar(255) YES NULL
is_admin tinyint(1) YES NULL

virtual_interfaces

Field Type Null Key Default Extra
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
instance_id int(11) NO MUL NULL
uuid varchar(36) YES NULL

virtual_storage_arrays

Field Type Null Key Default Extra
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_metadata

Field Type Null Key Default Extra
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 int(11) NO MUL NULL
key varchar(255) YES NULL
value varchar(255) YES NULL

volume_type_extra_specs

Field Type Null Key Default Extra
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

Field Type Null Key Default Extra
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

Field Type Null Key Default Extra
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
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_id int(11) YES MUL 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_description varchar(255) YES NULL
provider_location varchar(256) YES NULL
provider_auth varchar(256) YES NULL
snapshot_id int(11) YES NULL
volume_type_id int(11) YES NULL

Glance

image_members

Field Type Null Key Default Extra
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

Field Type Null Key Default Extra
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

images

Field Type Null Key Default Extra
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

Field Type Null Key Default Extra
repository_id varchar(250) NO PRI NULL
repository_path text YES NULL
version int(11) YES NULL

KeyStone

ec2_credential

Field Type Null Key Default Extra
access varchar(64) NO PRI NULL
secret varchar(64) YES NULL
user_id varchar(64) YES NULL
tenant_id varchar(64) YES NULL

endpoint

Field Type Null Key Default Extra
id varchar(64) NO PRI NULL
region varchar(255) YES NULL
service_id varchar(64) NO MUL NULL
extra text YES NULL

metadata

Field Type Null Key Default Extra
user_id varchar(64) NO PRI NULL
tenant_id varchar(64) NO PRI NULL
data text YES NULL

migrate_version

Field Type Null Key Default Extra
repository_id varchar(250) NO PRI NULL
repository_path text YES NULL
version int(11) YES NULL

role

Field Type Null Key Default Extra
id varchar(64) NO PRI NULL
name varchar(64) YES UNI NULL

service

Field Type Null Key Default Extra
id varchar(64) NO PRI NULL
type varchar(255) YES NULL
extra text YES NULL

tenant

Field Type Null Key Default Extra
id varchar(64) NO PRI NULL
name varchar(64) YES UNI NULL
extra text YES NULL

token

Field Type Null Key Default Extra
id varchar(64) NO PRI NULL
expires datetime YES NULL
extra text YES NULL

user

Field Type Null Key Default Extra
id varchar(64) NO PRI NULL
name varchar(64) YES UNI NULL
extra text YES NULL

user_tenant_membership

Field Type Null Key Default Extra
user_id varchar(64) NO PRI NULL
tenant_id varchar(64) NO PRI NULL

Horizon

django_session

Field Type Null Key Default Extra
session_key varchar(40) NO PRI NULL
session_data longtext NO NULL
expire_date datetime NO MUL NULL