action | ||
---|---|---|
id | INT NOT NULL AUTOINCREMENT | |
action_type_id | INT | |
Indexes | ||
pk_action primary key | ON id | |
idx_action | ON action_type_id | |
Foreign Keys | ||
fk_action_action_type | ( action_type_id ) ref action_type (id) |
action_realization | ||
---|---|---|
action_id | INT NOT NULL | |
provider_id | INT | |
fired_on | TIMESTAMP | |
ended_on | TIMESTAMP | |
low_level_actions | VARCHAR( 200 ) | |
rule_trigger_id | INT NOT NULL | |
Indexes | ||
idx_action_realization_action | ON action_id | |
idx_action_realization_provider | ON provider_id | |
idx_action_realization_rule | ON rule_trigger_id | |
idx_action_realization_0 primary key | ON action_id, rule_trigger_id | |
Foreign Keys | ||
fk_action_realization_action | ( action_id ) ref action (id) | |
fk_action_realization_1 | ( provider_id ) ref cloud_provider (organization_id) | |
fk_action_realization_2 | ( rule_trigger_id ) ref rule_trigger (id) |
action_type | ||
---|---|---|
id | INT NOT NULL AUTOINCREMENT | |
name | VARCHAR( 100 ) | |
Indexes | ||
pk_action_type primary key | ON id |
allowed_action | ||
---|---|---|
id | INT NOT NULL | |
action | INT | |
resource_class | VARCHAR( 30 ) | |
Indexes | ||
pk_allowed_action primary key | ON id | |
idx_allowed_action | ON action | |
Foreign Keys | ||
fk_allowed_action_action | ( action ) ref action (id) |
appl_monitor | ||
---|---|---|
id | INT NOT NULL AUTOINCREMENT | |
app_id | INT | |
it_slo | INT | |
execution_context | INT | |
metric | INT | |
value | VARCHAR( 10 ) | |
rw_data | VARCHAR( 20 ) | |
reported_on | TIMESTAMP | |
Indexes | ||
pk_appl_monitor primary key | ON id | |
idx_appl_monitor | ON it_slo | |
idx_appl_monitor_0 | ON app_id | |
idx_appl_monitor_1 | ON execution_context | |
idx_appl_monitor_2 | ON metric | |
Foreign Keys | ||
fk_appl_monitor_application | ( app_id ) ref application (id) | |
fk_appl_monitor | ( execution_context ) ref execution_context (id) | |
fk_appl_monitor_slo | ( it_slo ) ref it_slo (id) | |
fk_appl_monitor_metric | ( metric ) ref metric (id) |
application | ||
---|---|---|
id | INT NOT NULL | |
name | VARCHAR( 20 ) NOT NULL | |
version | VARCHAR( 10 ) NOT NULL | |
user | INT | |
resource | INT | |
Indexes | ||
idx_application_0 | ON user | |
pk_application primary key | ON id | |
idx_app_name | ON name | |
idx_application | ON resource | |
Foreign Keys | ||
fk_application_user | ( user ) ref user (id) | |
fk_application_resource | ( resource ) ref resource (id) |
application_components | ||
---|---|---|
associate software components with application | ||
id | INT NOT NULL AUTOINCREMENT | |
soft_component_id | INT | |
application_id | INT | |
Indexes | ||
idx_application_artfact_app | ON application_id | |
idx_application_artfact_art | ON soft_component_id | |
pk_application_artfact primary key | ON id | |
Foreign Keys | ||
fk_application_artfact_app | ( application_id ) ref application (id) | |
fk_application_artfact_art | ( soft_component_id ) ref software_component (id) |
cd_vm_type | ||
---|---|---|
id | INT NOT NULL | |
name | VARCHAR( 20 ) NOT NULL | |
datacenter | INT | |
ci_vm_type | INT | |
classified_on | TIMESTAMP NOT NULL | |
evaluated_on | TIMESTAMP NOT NULL | |
cpu | INT | |
ram | INT | |
disk | INT | |
benchmark_rate | DOUBLE | |
cost_per_hour | DOUBLE | |
resource | INT | |
Indexes | ||
idx_cd_resource_type | ON ci_vm_type | |
idx_cd_vm_type_0 unique | ON id | |
pk_cd_vm_type primary key | ON id | |
idx_cd_vm_type_1 | ON resource | |
idx_cd_vm_type | ON datacenter | |
Foreign Keys | ||
fk_cd_ci | ( ci_vm_type ) ref ci_vm_type (id) | |
fk_cd_vm_type_resource | ( resource ) ref resource (id) | |
fk_cd_vm_type_dc | ( datacenter ) ref data_center (id) |
ci_vm_type | ||
---|---|---|
id | INT NOT NULL | |
cpu_class | VARCHAR( 20 ) | |
memory_class | VARCHAR( 20 ) | |
io_class | VARCHAR( 20 ) | |
network_class | VARCHAR( 20 ) | |
Indexes | ||
pk_ci_resourse_type primary key | ON id |
cloud_provider | ||
---|---|---|
organization_id | INT NOT NULL | |
public | BOOL | |
paas | TINYINT DEFO 0 | |
iaas | TINYINT DEFO 0 | |
saas | TINYINT DEFO 0 | |
Indexes | ||
pk_cloud_provider primary key | ON organization_id | |
Foreign Keys | ||
fk_cloud_provider_organization | ( organization_id ) ref organization (id) |
component_dependency | ||
---|---|---|
id | INT NOT NULL | |
src_component | INT | |
dst_component | INT | |
type | VARCHAR( 20 ) | |
is_optional | BOOL | |
requires_local | BOOL | |
requires_remote | BOOL | |
requirement | INT | |
Indexes | ||
pk_component_dependency primary key | ON id | |
idx_component_dependency | ON src_component | |
idx_component_dependency_0 | ON dst_component | |
idx_component_dependency_1 | ON requirement | |
Foreign Keys | ||
fk_component_dependency_src | ( src_component ) ref software_component (id) | |
fk_component_dependency_dst | ( dst_component ) ref software_component (id) | |
fk_component_dependency | ( requirement ) ref requirements (id) |
component_inst_dependency | ||
---|---|---|
id | INT NOT NULL | |
src_instance | INT | |
dst_instance | INT | |
type | VARCHAR( 20 ) | |
is_option | BOOL | |
requires_local | BOOL | |
requires_remote | BOOL | |
requirement | INT | |
Indexes | ||
pk_component_inst_dependency primary key | ON id | |
idx_component_inst_dependency | ON src_instance | |
idx_component_inst_dependency_0 | ON dst_instance | |
idx_component_inst_dependency_1 | ON requirement | |
Foreign Keys | ||
fk_component_inst_dependency_src | ( src_instance ) ref software_component_instance (id) | |
fk_component_inst_dependency_dst | ( dst_instance ) ref software_component_instance (id) | |
fk_component_inst_dependency | ( requirement ) ref requirements (id) |
component_scalability | ||
---|---|---|
id | INT NOT NULL AUTOINCREMENT | |
software_comp | INT | |
scalability_policy | INT | |
Indexes | ||
pk_component_scalability primary key | ON id | |
idx_component_scalability | ON software_comp | |
idx_component_scalability_0 | ON scalability_policy | |
Foreign Keys | ||
fk_component_scalability_comp | ( software_comp ) ref software_component (id) | |
fk_component_scalability_scale | ( scalability_policy ) ref scalability_policy (id) |
data_center | ||
---|---|---|
id | INT NOT NULL AUTOINCREMENT | |
name | VARCHAR( 100 ) | |
location_id | INT | |
cloud_provider | INT | |
code_name | VARCHAR( 30 ) | |
Indexes | ||
pk_data_center primary key | ON id | |
idx_data_center | ON cloud_provider | |
idx_data_center_0 | ON location_id | |
Foreign Keys | ||
fk_data_center_location | ( location_id ) ref location (id) | |
fk_data_center_cloud_provider | ( cloud_provider ) ref cloud_provider (organization_id) |
data_object | ||
---|---|---|
id | INT NOT NULL | |
replication | VARCHAR( 20 ) | |
partitioning | VARCHAR( 20 ) | |
consistency | VARCHAR( 20 ) | |
name | VARCHAR( 100 ) | |
resource | INT | |
Indexes | ||
pk_data_object primary key | ON id | |
idx_data_object | ON resource | |
Foreign Keys | ||
fk_data_object_resource | ( resource ) ref resource (id) |
deployment | ||
---|---|---|
id | INT NOT NULL AUTOINCREMENT | |
component_instance | INT | |
software_config | INT | |
on_vm_instance | INT | |
on_component_instance | INT | |
on_paas | VARCHAR( 30 ) | |
Indexes | ||
pk_execution_instances primary key | ON id | |
idx_execution_instances_2 | ON on_vm_instance | |
idx_deployment_instances | ON component_instance | |
idx_deployment_instances_0 | ON software_config | |
idx_deployment_mapping | ON on_paas | |
idx_deployment_mapping_0 | ON on_component_instance | |
Foreign Keys | ||
fk_deployment_instances | ( component_instance ) ref software_component_instance (id) | |
fk_deployment_instances_conf | ( software_config ) ref software_component_config (id) | |
fk_deployment_mapping | ( on_paas ) ref platform_as_service (name) | |
fk_deployment_mapping_ari | ( on_component_instance ) ref software_component_instance (id) | |
fk_deployment_vm_inst | ( on_vm_instance ) ref vm_instance (id) |
deployment_execution | ||
---|---|---|
Associate a deployment plan with specific executions of an application | ||
id | INT NOT NULL AUTOINCREMENT | |
deployment_id | INT | |
execution_context | INT | |
requirements | INT | |
Indexes | ||
idx_deployment_execution | ON deployment_id | |
pk_deployment_execution primary key | ON id | |
idx_deployment_execution_0 | ON execution_context | |
idx_deployment_execution_1 | ON requirements | |
Foreign Keys | ||
fk_deployment_execution_depl | ( deployment_id ) ref deployment (id) | |
fk_deployment_execution | ( execution_context ) ref execution_context (id) | |
fk_deployment_execution_reqs | ( requirements ) ref requirements (id) |
event | ||
---|---|---|
name | VARCHAR( 100 ) NOT NULL | |
condition | INT | |
Indexes | ||
pk_event primary key | ON name | |
idx_event | ON condition | |
Foreign Keys | ||
fk_event | ( condition ) ref it_slo (id) |
event_instance | ||
---|---|---|
id | INT NOT NULL | |
event_name | VARCHAR( 100 ) | |
importance | VARCHAR( 50 ) | |
source_component | VARCHAR( 50 ) | |
fired_on | TIMESTAMP | |
execution_context | VARCHAR( 100 ) | |
Indexes | ||
pk_event_instance primary key | ON id | |
idx_event_instance | ON event_name | |
Foreign Keys | ||
fk_event_instance | ( event_name ) ref event (name) |
event_pattern | ||
---|---|---|
id | INT NOT NULL | |
first_event | VARCHAR( 50 ) | |
first_event_relation | VARCHAR( 50 ) | |
second_event | VARCHAR( 50 ) | |
second_event_relation | VARCHAR( 50 ) | |
operator | VARCHAR( 10 ) | |
Indexes | ||
pk_event_relation unique | ON id | |
idx_event_relation | ON first_event | |
idx_event_relation_0 | ON second_event | |
pk_event_relation_0 primary key | ON id | |
Foreign Keys | ||
fk_event_relation | ( first_event ) ref event (name) | |
fk_event_relation_0 | ( second_event ) ref event (name) |
execution_context | ||
---|---|---|
id | INT NOT NULL | |
app_id | INT | |
start_time | TIMESTAMP NOT NULL DEFO '0000-00-00 00:00:00' | |
end_time | TIMESTAMP NOT NULL DEFO '0000-00-00 00:00:00' | |
info | VARCHAR( 20 ) | |
total_cost | DOUBLE | |
Indexes | ||
pk_execution_context primary key | ON id | |
idx_execution_context | ON app_id | |
Foreign Keys | ||
fk_execution_context | ( app_id ) ref application (id) |
it_slo | ||
---|---|---|
id | INT NOT NULL | |
metric | INT | |
threshold | DOUBLE | |
platform | VARCHAR( 20 ) | |
Indexes | ||
pk_it_sla primary key | ON id | |
idx_it_sla_0 | ON platform | |
idx_it_slo | ON metric | |
Foreign Keys | ||
fk_it_sla_platform_as_service | ( platform ) ref platform_as_service (name) | |
fk_it_slo_metric | ( metric ) ref metric (id) |
location | ||
---|---|---|
id | INT NOT NULL AUTOINCREMENT | |
city | VARCHAR( 128 ) | |
country | VARCHAR( 128 ) | |
country_code | VARCHAR( 2 ) | |
latitude | DOUBLE | |
longitude | DOUBLE | |
address | VARCHAR( 256 ) | |
Indexes | ||
pk_location primary key | ON id |
metric | ||
---|---|---|
id | INT NOT NULL AUTOINCREMENT | |
name | VARCHAR( 20 ) | |
description | VARCHAR( 100 ) | |
value_direction | ENUM | |
layer | SMALLINT | |
unit | VARCHAR( 20 ) | |
property | INT | |
Indexes | ||
pk_metric primary key | ON id | |
idx_metric | ON property | |
Foreign Keys | ||
fk_metric_attribute | ( property ) ref property (id) |
object_association | ||
---|---|---|
id | INT NOT NULL | |
producer | INT | |
consumer | INT | |
execution_context | INT | |
started_on | TIMESTAMP | |
ended_on | TIMESTAMP | |
data_object_id | INT | |
Indexes | ||
pk_object_usage primary key | ON id | |
idx_object_usage | ON execution_context | |
idx_object_usage_0 | ON producer | |
idx_object_usage_1 | ON consumer | |
idx_object_association | ON data_object_id | |
Foreign Keys | ||
fk_object_usage_ec | ( execution_context ) ref execution_context (id) | |
fk_object_usage_prod | ( producer ) ref software_component_instance (id) | |
fk_object_usage_cons | ( consumer ) ref software_component_instance (id) | |
fk_object_association | ( data_object_id ) ref data_object (id) |
organization | ||
---|---|---|
id | INT NOT NULL AUTOINCREMENT | |
name | VARCHAR( 40 ) NOT NULL | |
www | VARCHAR( 100 ) | |
postal_address | VARCHAR( 256 ) | |
VARCHAR( 64 ) | ||
Indexes | ||
pk_organization_0 primary key | ON id |
permission | ||
---|---|---|
id | INT NOT NULL | |
role_id | INT | |
allowed | TINYINT | |
start | TIMESTAMP | |
end | TIMESTAMP | |
issued_by | INT | |
resource | INT | |
Indexes | ||
idx_permission | ON role_id | |
idx_permission_1 | ON issued_by | |
pk_permission primary key | ON id | |
idx_permission_0 | ON resource | |
Foreign Keys | ||
fk_permission_role | ( role_id ) ref role (id) | |
fk_permission_organization | ( issued_by ) ref organization (id) | |
fk_permission_resource | ( resource ) ref resource (id) |
permission_action | ||
---|---|---|
id | INT NOT NULL | |
permission_id | INT | |
action_id | INT | |
Indexes | ||
pk_permission_action primary key | ON id | |
idx_permission_action | ON permission_id | |
idx_permission_action_0 | ON action_id | |
Foreign Keys | ||
fk_permission_action | ( permission_id ) ref permission (id) | |
fk_permission_action_action | ( action_id ) ref action (id) |
physical_node | ||
---|---|---|
id | INT NOT NULL | |
ip | VARCHAR( 15 ) | |
location | VARCHAR( 20 ) | |
hardware | VARCHAR( 20 ) | |
cloud_provider_id | INT | |
resource | INT | |
Indexes | ||
pk_physical_node primary key | ON id | |
idx_physical_node | ON cloud_provider_id | |
idx_physical_node_0 | ON resource | |
Foreign Keys | ||
fk_physical_node | ( cloud_provider_id ) ref cloud_provider (organization_id) | |
fk_physical_node_resource | ( resource ) ref resource (id) |
platform_as_service | ||
---|---|---|
name | VARCHAR( 30 ) NOT NULL | |
api | VARCHAR( 20 ) | |
elasticity_ | VARCHAR( 20 ) | |
cloud_provider_id | INT | |
Indexes | ||
pk_platform_as_service unique | ON name | |
pk_platform_as_service_0 primary key | ON name | |
idx_platform_as_service | ON cloud_provider_id | |
Foreign Keys | ||
fk_platform_as_service | ( cloud_provider_id ) ref cloud_provider (organization_id) |
property | ||
---|---|---|
id | INT NOT NULL | |
name | VARCHAR( 100 ) | |
category | VARCHAR( 100 ) | |
measurable | BOOL | |
parent | INT | |
Indexes | ||
pk_attribute primary key | ON id | |
idx_property | ON parent | |
Foreign Keys | ||
fk_property_property_parent | ( parent ) ref property (id) |
provides_sec_control | ||
---|---|---|
sec_control_id | VARCHAR( 50 ) NOT NULL | |
cp_id | INT NOT NULL | |
Indexes | ||
idx_provides_sec_control_id | ON sec_control_id | |
idx_provides_sec_control_cp | ON cp_id | |
idx_provides_sec_control_0 primary key | ON sec_control_id, cp_id | |
Foreign Keys | ||
fk_provides_sec_control | ( sec_control_id ) ref security_control (id) | |
fk_provides_sec_control_2 | ( cp_id ) ref cloud_provider (organization_id) |
reqs_to_scalability_rule | ||
---|---|---|
req_id | INT NOT NULL | |
scalability_rule_name | VARCHAR( 100 ) NOT NULL | |
Indexes | ||
idx_reqs_to_elasticity_rule_0 primary key | ON req_id, scalability_rule_name | |
Foreign Keys | ||
fk_reqs_to_elasticity_rule | ( req_id ) ref requirements (id) | |
fk_reqs_to_elasticity_rule1 | ( scalability_rule_name ) ref scalability_rule (name) |
requirement_it_slo | ||
---|---|---|
id | INT NOT NULL AUTOINCREMENT | |
it_slo | INT | |
requirements | INT | |
Indexes | ||
pk_requirement_it_slo primary key | ON id | |
idx_requirement_it_slo | ON it_slo, requirements | |
Foreign Keys | ||
fk_requirement_it_slo_slo | ( it_slo ) ref it_slo (id) | |
fk_requirement_it_slo_req | ( requirements ) ref requirements (id) |
requirement_sec_control | ||
---|---|---|
id | INT NOT NULL AUTOINCREMENT | |
sec_control_id | VARCHAR( 50 ) | |
requirements | INT | |
Indexes | ||
idx_requirement_sec_control_req | ON requirements | |
pk_requirement_sec_control primary key | ON id | |
Foreign Keys | ||
fk_requirement_sec_control | ( sec_control_id ) ref security_control (id) | |
fk_requirement_sec_control_2 | ( requirements ) ref requirements (id) |
requirements | ||
---|---|---|
id | INT NOT NULL AUTOINCREMENT | |
priority | DOUBLE | |
Indexes | ||
pk_requirements primary key | ON id |
requirements_scalability | ||
---|---|---|
id | INT NOT NULL AUTOINCREMENT | |
requirements | INT | |
scalability | INT | |
Indexes | ||
pk_requirements_scalability primary key | ON id | |
idx_requirements_scalability | ON requirements, scalability | |
Foreign Keys | ||
fk_requirements_scalability_req | ( requirements ) ref requirements (id) | |
fk_requirements_scalability_scal | ( scalability ) ref scalability_policy (id) |
resource | ||
---|---|---|
id | INT NOT NULL | |
Indexes | ||
pk_resource primary key | ON id |
resource_coupling_monitor | ||
---|---|---|
name | VARCHAR( 20 ) NOT NULL | |
execution_context | INT NOT NULL | |
src | INT | |
dest | INT | |
reported_on | TIMESTAMP DEFO '0000-00-00 00:00:00' | |
metric | INT | |
raw_data | TIMESTAMP | |
Indexes | ||
idx_resource_coupling_monitoring | ON src | |
idx_resource_coupling_monitor primary key | ON name, execution_context | |
idx_resource_coupling_monitor_0 | ON execution_context | |
idx_resource_coupling_monitor_1 | ON dest | |
idx_resource_coupling_monitor_2 | ON metric | |
Foreign Keys | ||
fk_resource_coupling_monitor | ( execution_context ) ref execution_context (id) | |
fk_resource_coupling_monitor_metric | ( metric ) ref metric (id) | |
fk_resource_coupl_monitor_src | ( src ) ref vm_instance (id) | |
fk_resource_coupl_monitor_dst | ( dest ) ref vm_instance (id) |
resource_group | ||
---|---|---|
resource_id | INT NOT NULL | |
name | VARCHAR( 100 ) | |
Indexes | ||
pk_resource_group primary key | ON resource_id | |
Foreign Keys | ||
fk_resource_group_resource | ( resource_id ) ref resource (id) |
resource_monitor | ||
---|---|---|
id | INT NOT NULL AUTOINCREMENT | |
name | VARCHAR( 20 ) NOT NULL | |
execution_context | INT NOT NULL | |
vm_instance | INT NOT NULL | |
it_slo | INT | |
resource_class | VARCHAR( 20 ) | |
metric | INT | |
value | DOUBLE | |
reported_on | TIMESTAMP DEFO '0000-00-00 00:00:00' | |
raw_data | VARCHAR( 20 ) | |
data_object_id | INT | |
physical_node_id | INT | |
Indexes | ||
idx_resource_monitoring_2 | ON execution_context | |
idx_resource_monitoring_1 | ON vm_instance | |
idx_resource_monitoring_0 | ON it_slo | |
pk_resource_monitor primary key | ON id | |
idx_resource_monitor_1 | ON metric | |
idx_resource_monitor | ON data_object_id | |
idx_resource_monitor_0 | ON physical_node_id | |
Foreign Keys | ||
fk_resource_monitoring | ( execution_context ) ref execution_context (id) | |
fk_resource_monitoring_it_sla | ( it_slo ) ref it_slo (id) | |
fk_resource_monitor_metric | ( metric ) ref metric (id) | |
fk_resource_monitor | ( data_object_id ) ref data_object (id) | |
fk_resource_monitor_0 | ( physical_node_id ) ref physical_node (id) | |
fk_resource_monitor_vm | ( vm_instance ) ref vm_instance (id) |
resource_to_group | ||
---|---|---|
group_id | INT NOT NULL | |
resource_id | INT NOT NULL | |
Indexes | ||
idx_resource_to_group primary key | ON group_id, resource_id | |
idx_resource_to_group_0 | ON resource_id | |
idx_resource_to_group_1 | ON group_id | |
Foreign Keys | ||
fk_resource_to_group | ( group_id ) ref resource_group (resource_id) | |
fk_resource_to_group_resource | ( resource_id ) ref resource (id) |
role | ||
---|---|---|
id | INT NOT NULL AUTOINCREMENT | |
name | VARCHAR( 20 ) NOT NULL | |
Indexes | ||
pk_role_0 primary key | ON id |
rule_trigger | ||
---|---|---|
id | INT NOT NULL | |
rule_name | VARCHAR( 100 ) NOT NULL | |
fired_on | DATETIME | |
Indexes | ||
pk_rule_trigger primary key | ON id | |
Foreign Keys | ||
fk_elasticity_rule_trigger_1 | ( rule_name ) ref scalability_rule (name) |
rule_trigger_event | ||
---|---|---|
rule_trigger_id | INT NOT NULL | |
event_instance_id | INT NOT NULL | |
Indexes | ||
idx_rule_trigger_event | ON rule_trigger_id | |
idx_rule_trigger_event_0 | ON event_instance_id | |
idx_rule_trigger_event_1 primary key | ON rule_trigger_id, event_instance_id | |
Foreign Keys | ||
fk_rule_trigger_event | ( rule_trigger_id ) ref rule_trigger (id) | |
fk_rule_trigger_event1 | ( event_instance_id ) ref event_instance (id) |
scalability_policy | ||
---|---|---|
id | INT NOT NULL AUTOINCREMENT | |
scaling_type | ENUM | |
min_instances | INT | |
max_instance | INT | |
Indexes | ||
pk_scalability_policy primary key | ON id |
scalability_rule | ||
---|---|---|
name | VARCHAR( 20 ) NOT NULL | |
evaluate_frequency | TIMESTAMP | |
event | VARCHAR( 50 ) | |
pattern | INT | |
Indexes | ||
pk_elasticity_rule unique | ON name | |
pk_elasticity_rule_0 primary key | ON name | |
idx_elasticity_rule_0 | ON event | |
idx_elasticity_rule_1 | ON pattern | |
Foreign Keys | ||
fk_elasticity_rule | ( event ) ref event (name) | |
fk_elasticity_rule_0 | ( pattern ) ref event_pattern (id) |
scalability_rule_action | ||
---|---|---|
scalability_rule | VARCHAR( 100 ) NOT NULL | |
action | INT NOT NULL | |
Indexes | ||
idx_elasticity_rule_action_0 primary key | ON scalability_rule, action | |
Foreign Keys | ||
fk_elasticity_rule_action | ( scalability_rule ) ref scalability_rule (name) | |
fk_elasticity_rule_action_1 | ( action ) ref action (id) |
sec_control_slo | ||
---|---|---|
requirement_id | INT | |
sec_slo | INT | |
Indexes | ||
idx_sec_control_slo | ON requirement_id | |
idx_sec_control_slo_0 | ON sec_slo | |
Foreign Keys | ||
fk_sec_control_slo_req | ( requirement_id ) ref requirement_sec_control (id) | |
fk_sec_control_slo_it_slo | ( sec_slo ) ref it_slo (id) |
sec_property | ||
---|---|---|
prop_id | INT NOT NULL | |
domain | VARCHAR( 100 ) | |
Indexes | ||
idx_sec_property | ON prop_id | |
pk_sec_property primary key | ON prop_id | |
Foreign Keys | ||
fk_sec_property_attribute | ( prop_id ) ref property (id) |
security_control | ||
---|---|---|
id | VARCHAR( 50 ) NOT NULL | |
description | VARCHAR( 200 ) | |
domain | VARCHAR( 50 ) | |
Indexes | ||
idx_security_control primary key | ON id |
sla | ||
---|---|---|
id | INT NOT NULL | |
targeted_cost | DOUBLE | |
targeted_location | VARCHAR( 15 ) | |
targeted_revenue | DOUBLE | |
it_slo | INT | |
requirements | INT | |
application_id | INT | |
Indexes | ||
pk_business_sla primary key | ON id | |
idx_sla | ON it_slo | |
idx_sla_0 | ON requirements | |
idx_sla_1 | ON application_id | |
Foreign Keys | ||
fk_sla_it_slo | ( it_slo ) ref it_slo (id) | |
fk_sla_requirements | ( requirements ) ref requirements (id) | |
fk_sla_application | ( application_id ) ref application (id) |
sla_parties | ||
---|---|---|
sla_id | INT NOT NULL | |
provider_id | INT NOT NULL | |
requester_id | INT NOT NULL | |
Indexes | ||
idx_sla_parties primary key | ON provider_id, requester_id, sla_id | |
idx_sla_parties | ON sla_id | |
idx_sla_parties_0 | ON provider_id | |
Foreign Keys | ||
fk_sla_parties_sla | ( sla_id ) ref sla (id) | |
fk_sla_parties_cloud_provider | ( provider_id ) ref cloud_provider (organization_id) |
slo_assessment | ||
---|---|---|
id | INT NOT NULL AUTOINCREMENT | |
execution_context | INT | |
it_slo | INT | |
assessment | BOOL | |
Indexes | ||
pk_sla_history primary key | ON id | |
idx_sla_history | ON execution_context | |
idx_sla_history_0 | ON it_slo | |
Foreign Keys | ||
fk_sla_history | ( execution_context ) ref execution_context (id) | |
fk_sla | ( it_slo ) ref it_slo (id) |
software_component | ||
---|---|---|
id | INT NOT NULL AUTOINCREMENT | |
name | VARCHAR( 50 ) NOT NULL | |
description | VARCHAR( 100 ) | |
tag | VARCHAR( 20 ) | |
groupid | VARCHAR( 100 ) | |
resource | INT | |
Indexes | ||
idx_artifact unique | ON id | |
pk_artefact primary key | ON id | |
idx_software_component | ON resource | |
Foreign Keys | ||
fk_software_component_resource | ( resource ) ref resource (id) |
software_component_config | ||
---|---|---|
id | INT | |
port_num | INT | |
config | VARCHAR( 50 ) | |
retrieving_cmd | VARCHAR( 200 ) | |
deploying_cmd | VARCHAR( 200 ) | |
start_cmd | VARCHAR( 200 ) | |
Indexes | ||
pk_configuration unique | ON id |
software_component_instance | ||
---|---|---|
id | INT NOT NULL | |
name | VARCHAR( 20 ) NOT NULL | |
version | VARCHAR( 10 ) | |
software_component_id | INT | |
Indexes | ||
idx_artifact_instance_2 | ON software_component_id | |
pk_artefact_instance_0 primary key | ON id | |
Foreign Keys | ||
fk_artifact_instance_artifact_2 | ( software_component_id ) ref software_component (id) |
software_component_monitor | ||
---|---|---|
name | VARCHAR( 20 ) NOT NULL | |
execution_context | INT NOT NULL | |
component_instance | INT | |
it_slo | INT | |
metric | INT | |
value | DOUBLE | |
reported_on | TIMESTAMP DEFO '0000-00-00 00:00:00' | |
raw_data | VARCHAR( 20 ) | |
Indexes | ||
idx_high_level_monitor_0 | ON it_slo | |
idx_high_level_monitor_1 | ON execution_context | |
idx_high_level_monitor_2 primary key | ON name, execution_context | |
idx_artifact_monitor | ON component_instance | |
idx_artifact_monitor_0 | ON metric | |
Foreign Keys | ||
fk_high_monitor_sla | ( it_slo ) ref it_slo (id) | |
fk_high_level_monitor | ( execution_context ) ref execution_context (id) | |
fk_artefict_monitor | ( component_instance ) ref software_component_instance (id) | |
fk_artifact_monitor_metric | ( metric ) ref metric (id) |
user | ||
---|---|---|
id | INT NOT NULL AUTOINCREMENT | |
lastname | VARCHAR( 100 ) NOT NULL | |
firstname | VARCHAR( 100 ) | |
VARCHAR( 64 ) | ||
www | VARCHAR( 256 ) | |
login | VARCHAR( 100 ) | |
Indexes | ||
pk_users_0 primary key | ON id | |
idx_user unique | ON login |
user_belongs_to_group | ||
---|---|---|
user_id | INT NOT NULL | |
user_group_id | INT NOT NULL | |
Indexes | ||
pk_user_belongs_to_group primary key | ON user_id, user_group_id | |
idx_user_belongs_to_group | ON user_group_id | |
idx_user_belongs_to_group_0 | ON user_id | |
Foreign Keys | ||
fk_user_belongs_to_group | ( user_group_id ) ref user_group (id) | |
fk_user_belongs_to_group_user | ( user_id ) ref user (id) |
user_external_identifier | ||
---|---|---|
id | INT NOT NULL AUTOINCREMENT | |
user_id | INT | |
external_identifier | VARCHAR( 1024 ) | |
user_identifier_type_id | INT | |
Indexes | ||
pk_user_external_identifier primary key | ON id | |
idx_user_external_identifier | ON user_id | |
idx_user_external_identifier_0 | ON user_identifier_type_id | |
Foreign Keys | ||
fk_user_external_identifier | ( user_id ) ref user (id) | |
fk_user_external_identifier_2 | ( user_identifier_type_id ) ref user_identifier_type (id) |
user_group | ||
---|---|---|
id | INT NOT NULL AUTOINCREMENT | |
name | VARCHAR( 100 ) | |
Indexes | ||
pk_user_group primary key | ON id |
user_group_has_role | ||
---|---|---|
user_group_id | INT NOT NULL | |
role_id | INT NOT NULL | |
start | TIMESTAMP | |
end | TIMESTAMP | |
assigned_on | DATETIME | |
Indexes | ||
idx_user_group_has_role_1 primary key | ON user_group_id, role_id | |
Foreign Keys | ||
fk_user_group_has_role | ( user_group_id ) ref user_group (id) | |
fk_user_group_has_role_role | ( role_id ) ref role (id) |
user_has_role | ||
---|---|---|
user_id | INT NOT NULL | |
role_id | INT NOT NULL | |
start | DATETIME | |
end | DATETIME | |
assigned_on | DATETIME | |
Indexes | ||
idx_user_has_role | ON role_id | |
pk_user_has_role primary key | ON user_id, role_id | |
Foreign Keys | ||
fk_user_has_role_user | ( user_id ) ref user (id) | |
fk_user_has_role_role | ( role_id ) ref role (id) |
user_identifier_type | ||
---|---|---|
id | INT NOT NULL AUTOINCREMENT | |
name | VARCHAR( 100 ) | |
description | VARCHAR( 1024 ) | |
Indexes | ||
pk_user_identifier_type primary key | ON id |
user_works_for_organization | ||
---|---|---|
user_id | INT NOT NULL | |
organization_id | INT NOT NULL | |
Indexes | ||
pk_user_works_for_organization primary key | ON user_id, organization_id | |
idx_user_works_for_organization | ON user_id | |
idx_user_works_for_organization_0 | ON organization_id | |
Foreign Keys | ||
fk_user_works_for_organization | ( user_id ) ref user (id) | |
fk_user_works_for_organization_2 | ( organization_id ) ref organization (id) |
vm_config | ||
---|---|---|
id | INT NOT NULL AUTOINCREMENT | |
os | VARCHAR( 20 ) | |
is64os | BOOL | |
imageid | VARCHAR( 20 ) | |
privatekey | VARCHAR( 100 ) | |
ssh_key | VARCHAR( 100 ) | |
security_group | VARCHAR( 30 ) | |
group_name | VARCHAR( 30 ) | |
Indexes | ||
pk_vm_config primary key | ON id |
vm_instance | ||
---|---|---|
id | INT NOT NULL | |
cd_vm_id | INT | |
ip | VARCHAR( 15 ) | |
created_on | TIMESTAMP DEFO '0000-00-00 00:00:00' | |
destroyed_on | TIMESTAMP DEFO '0000-00-00 00:00:00' | |
vm_config | INT | |
Indexes | ||
idx_node_instance | ON cd_vm_id | |
idx_node_instance_0 | ON vm_config | |
pk_vm_instance primary key | ON id | |
Foreign Keys | ||
fk_node_instance_cd_vm_type | ( cd_vm_id ) ref cd_vm_type (id) | |
fk_node_instance_vm_config | ( vm_config ) ref vm_config (id) |
vm_to_pm_association | ||
---|---|---|
id | INT NOT NULL AUTOINCREMENT | |
vm | INT | |
started_on | DATE | |
ended_on | DATE | |
physical_node_id | INT | |
Indexes | ||
pk_vm_to_pm_association primary key | ON id | |
idx_vm_to_pm_association_0 | ON vm | |
idx_vm_to_pm_association | ON physical_node_id | |
Foreign Keys | ||
fk_vm_to_pm_association | ( physical_node_id ) ref physical_node (id) | |
fk_vm_to_pm_association_vm | ( vm ) ref vm_instance (id) |