Instance
From DreamFactory
instance_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 | |||
| user_id | int(11) | NO | MUL | select,insert,update,references | ||||
| guest_location_nbr | int(11) | NO | 0 | select,insert,update,references | ||||
| environment_id | int(11) | NO | MUL | 1 | select,insert,update,references | |||
| instance_id_text | varchar(64) | utf8_general_ci | YES | select,insert,update,references | ||||
| instance_name_text | varchar(128) | utf8_general_ci | YES | UNI | select,insert,update,references | |||
| instance_data_text | mediumtext | utf8_unicode_ci | YES | select,insert,update,references | ||||
| cluster_id | int(11) | NO | MUL | 1 | select,insert,update,references | |||
| app_server_id | int(11) | NO | MUL | 6 | select,insert,update,references | |||
| db_server_id | int(11) | NO | MUL | 4 | select,insert,update,references | |||
| web_server_id | int(11) | NO | MUL | 5 | select,insert,update,references | |||
| storage_id_text | varchar(64) | utf8_general_ci | YES | select,insert,update,references | ||||
| db_host_text | varchar(1024) | utf8_unicode_ci | NO | localhost | select,insert,update,references | |||
| db_port_nbr | int(11) | NO | 3306 | select,insert,update,references | ||||
| db_name_text | varchar(64) | utf8_general_ci | NO | dreamfactory | select,insert,update,references | |||
| db_user_text | varchar(64) | utf8_general_ci | NO | dsp_user | select,insert,update,references | |||
| db_password_text | varchar(64) | utf8_general_ci | NO | dsp_user | select,insert,update,references | |||
| request_id_text | varchar(128) | utf8_general_ci | YES | select,insert,update,references | ||||
| request_date | datetime | YES | select,insert,update,references | |||||
| activate_ind | tinyint(1) | NO | 0 | select,insert,update,references | ||||
| trial_instance_ind | tinyint(1) | NO | 1 | select,insert,update,references | ||||
| provision_ind | tinyint(1) | NO | 0 | select,insert,update,references | ||||
| deprovision_ind | tinyint(1) | NO | 0 | select,insert,update,references | ||||
| state_nbr | int(11) | NO | 0 | select,insert,update,references | ||||
| ready_state_nbr | int(11) | NO | 0 | select,insert,update,references | ||||
| platform_state_nbr | int(11) | NO | 0 | select,insert,update,references | ||||
| storage_version_nbr | int(11) | NO | 0 | select,insert,update,references | ||||
| last_state_date | datetime | NO | MUL | select,insert,update,references | ||||
| start_date | datetime | YES | select,insert,update,references | |||||
| end_date | datetime | YES | select,insert,update,references | |||||
| terminate_date | datetime | 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 |
