InstanceGuestArchive
From DreamFactory
instance_guest_arch_t
Table definition as of 2015-09-18 11:28:46
| Field | Type | Collation | Null | Key | Default | Extra | Privileges | Comment |
|---|---|---|---|---|---|---|---|---|
| id | int(11) | NO | select,insert,update,references | |||||
| instance_id | int(11) | NO | select,insert,update,references | |||||
| vendor_id | int(11) | NO | select,insert,update,references | |||||
| vendor_image_id | int(11) | NO | select,insert,update,references | |||||
| vendor_credentials_id | int(11) | YES | select,insert,update,references | |||||
| flavor_nbr | int(11) | NO | select,insert,update,references | |||||
| base_image_text | varchar(32) | utf8_unicode_ci | NO | select,insert,update,references | ||||
| region_text | varchar(32) | utf8_unicode_ci | NO | select,insert,update,references | ||||
| availability_zone_text | varchar(32) | utf8_unicode_ci | NO | select,insert,update,references | ||||
| security_group_text | varchar(1024) | utf8_unicode_ci | NO | select,insert,update,references | ||||
| ssh_key_text | varchar(64) | utf8_unicode_ci | NO | select,insert,update,references | ||||
| root_device_type_nbr | int(11) | NO | select,insert,update,references | |||||
| public_host_text | varchar(256) | utf8_unicode_ci | NO | select,insert,update,references | ||||
| public_ip_text | varchar(20) | utf8_unicode_ci | NO | select,insert,update,references | ||||
| private_host_text | varchar(256) | utf8_unicode_ci | NO | select,insert,update,references | ||||
| private_ip_text | varchar(20) | utf8_unicode_ci | NO | select,insert,update,references | ||||
| state_nbr | int(11) | NO | select,insert,update,references | |||||
| state_text | varchar(64) | utf8_unicode_ci | YES | select,insert,update,references | ||||
| create_date | datetime | NO | select,insert,update,references | |||||
| lmod_date | timestamp | NO | 0000-00-00 00:00:00 | select,insert,update,references |
