InstanceArchive

instance_arch_t

Table definition as of 2015-09-18 11:28:46

Field	Type	Collation	Null	Key	Default	Extra	Privileges	Comment
id	int(11)		YES				select,insert,update,references
user_id	int(11)		YES				select,insert,update,references
guest_location_nbr	int(11)		YES				select,insert,update,references
environment_id	int(11)		YES				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				select,insert,update,references
instance_data_text	mediumtext	utf8_unicode_ci	YES				select,insert,update,references
cluster_id	int(11)		YES				select,insert,update,references
app_server_id	int(11)		YES				select,insert,update,references
db_server_id	int(11)		YES				select,insert,update,references
web_server_id	int(11)		YES				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	YES		localhost		select,insert,update,references
db_port_nbr	int(11)		YES				select,insert,update,references
db_name_text	varchar(64)	utf8_general_ci	YES		dreamfactory		select,insert,update,references
db_user_text	varchar(64)	utf8_general_ci	YES		dsp_user		select,insert,update,references
db_password_text	varchar(64)	utf8_general_ci	YES		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)		YES		0		select,insert,update,references
trial_instance_ind	tinyint(1)		YES		1		select,insert,update,references
provision_ind	tinyint(1)		YES		0		select,insert,update,references
deprovision_ind	tinyint(1)		YES		0		select,insert,update,references
state_nbr	int(11)		YES		0		select,insert,update,references
ready_state_nbr	int(11)		YES		0		select,insert,update,references
platform_state_nbr	int(11)		YES		0		select,insert,update,references
storage_version_nbr	int(11)		YES		0		select,insert,update,references
last_state_date	datetime		YES				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		YES				select,insert,update,references
lmod_date	timestamp		NO		CURRENT_TIMESTAMP	on update CURRENT_TIMESTAMP	select,insert,update,references