InstanceGuest
From DreamFactory
instance_guest_t
Table definition as of 2015-09-18 11:28:46
| Field | Type | Collation | Null | Key | Default | Extra | Privileges | Comment |
|---|---|---|---|---|---|---|---|---|
| id | int(11) | NO | PRI | auto_increment | select,insert,update,references | |||
| instance_id | int(11) | NO | MUL | select,insert,update,references | ||||
| vendor_id | int(11) | NO | select,insert,update,references | |||||
| vendor_image_id | int(11) | NO | 0 | select,insert,update,references | ||||
| vendor_credentials_id | int(11) | YES | select,insert,update,references | |||||
| flavor_nbr | int(11) | NO | 0 | select,insert,update,references | ||||
| base_image_text | varchar(32) | utf8_general_ci | NO | t1.micro | select,insert,update,references | |||
| region_text | varchar(32) | utf8_general_ci | YES | select,insert,update,references | ||||
| availability_zone_text | varchar(32) | utf8_general_ci | YES | select,insert,update,references | ||||
| security_group_text | varchar(1024) | utf8_general_ci | YES | select,insert,update,references | ||||
| ssh_key_text | varchar(64) | utf8_general_ci | YES | select,insert,update,references | ||||
| root_device_type_nbr | int(11) | NO | 0 | select,insert,update,references | ||||
| public_host_text | varchar(256) | utf8_general_ci | YES | select,insert,update,references | ||||
| public_ip_text | varchar(20) | utf8_general_ci | YES | select,insert,update,references | ||||
| private_host_text | varchar(256) | utf8_general_ci | YES | select,insert,update,references | ||||
| private_ip_text | varchar(20) | utf8_general_ci | YES | select,insert,update,references | ||||
| state_nbr | int(11) | NO | 0 | select,insert,update,references | ||||
| state_text | varchar(64) | utf8_general_ci | YES | select,insert,update,references | ||||
| create_date | datetime | NO | select,insert,update,references | |||||
| lmod_date | timestamp | NO | CURRENT_TIMESTAMP | on update CURRENT_TIMESTAMP | select,insert,update,references |
