1 Foreign Key fk_application_artfact_app application_components references application ( application_id -> id ) application_id Foreign Key fk_application_artfact_art application_components references software_component ( soft_component_id -> id ) soft_component_id Foreign Key fk_component_scalability_comp component_scalability references software_component ( software_comp -> id ) software_comp Foreign Key fk_component_scalability_scale component_scalability references scalability_policy ( scalability_policy -> id ) scalability_policy Foreign Key fk_event_relation event_pattern references event ( first_event -> name ) first_event Foreign Key fk_event_relation_0 event_pattern references event ( second_event -> name ) second_event Foreign Key fk_deployment_execution_depl deployment_execution references deployment ( deployment_id -> id ) deployment_id Foreign Key fk_deployment_execution deployment_execution references execution_context ( execution_context -> id ) execution_context Foreign Key fk_user_works_for_organization user_works_for_organization references user ( user_id -> id ) user_id Foreign Key fk_user_works_for_organization_2 user_works_for_organization references organization ( organization_id -> id ) organization_id Foreign Key fk_object_usage_ec object_association references execution_context ( execution_context -> id ) execution_context Foreign Key fk_object_usage_prod object_association references software_component_instance ( producer -> id ) producer Foreign Key fk_platform_as_service platform_as_service references cloud_provider ( cloud_provider_id -> organization_id ) cloud_provider_id Foreign Key fk_user_belongs_to_group user_belongs_to_group references user_group ( user_group_id -> id ) user_group_id Foreign Key fk_user_belongs_to_group_user user_belongs_to_group references user ( user_id -> id ) user_id Foreign Key fk_user_external_identifier user_external_identifier references user ( user_id -> id ) user_id Foreign Key fk_user_external_identifier_2 user_external_identifier references user_identifier_type ( user_identifier_type_id -> id ) user_identifier_type_id Foreign Key fk_metric_attribute metric references property ( property -> id ) property Foreign Key fk_rule_trigger_event rule_trigger_event references rule_trigger ( rule_trigger_id -> id ) rule_trigger_id Foreign Key fk_rule_trigger_event1 rule_trigger_event references event_instance ( event_instance_id -> id ) event_instance_id Foreign Key fk_elasticity_rule scalability_rule references event ( event -> name ) event Foreign Key fk_elasticity_rule_0 scalability_rule references event_pattern ( pattern -> id ) pattern Foreign Key fk_sla_parties_sla sla_parties references sla ( sla_id -> id ) sla_id Foreign Key fk_sla_parties_cloud_provider sla_parties references cloud_provider ( provider_id -> organization_id ) provider_id Foreign Key fk_elasticity_rule_trigger_1 rule_trigger references scalability_rule ( rule_name -> name ) rule_name Foreign Key fk_allowed_action_action allowed_action references action ( action -> id ) action Foreign Key fk_permission_action permission_action references permission ( permission_id -> id ) permission_id Foreign Key fk_permission_action_action permission_action references action ( action_id -> id ) action_id Foreign Key fk_application_user application references user ( user -> id ) user Foreign Key fk_physical_node physical_node references cloud_provider ( cloud_provider_id -> organization_id ) cloud_provider_id Foreign Key fk_physical_node_resource physical_node references resource ( resource -> id ) resource Foreign Key fk_resource_to_group resource_to_group references resource_group ( group_id -> resource_id ) group_id Foreign Key fk_resource_to_group_resource resource_to_group references resource ( resource_id -> id ) resource_id Foreign Key fk_resource_group_resource resource_group references resource ( resource_id -> id ) resource_id Foreign Key fk_sec_property_attribute sec_property references property ( prop_id -> id ) prop_id Foreign Key fk_data_center_location data_center references location ( location_id -> id ) location_id Foreign Key fk_data_center_cloud_provider data_center references cloud_provider ( cloud_provider -> organization_id ) cloud_provider Foreign Key fk_user_has_role_user user_has_role references user ( user_id -> id ) user_id Foreign Key fk_user_has_role_role user_has_role references role ( role_id -> id ) role_id Foreign Key fk_data_object_resource data_object references resource ( resource -> id ) resource Foreign Key fk_node_instance_cd_vm_type vm_instance references cd_vm_type ( cd_vm_id -> id ) cd_vm_id Foreign Key fk_node_instance_vm_config vm_instance references vm_config ( vm_config -> id ) vm_config Foreign Key fk_resource_coupling_monitor_metric resource_coupling_monitor references metric ( metric -> id ) metric Foreign Key fk_resource_coupl_monitor_src resource_coupling_monitor references vm_instance ( src -> id ) src Foreign Key fk_resource_coupl_monitor_dst resource_coupling_monitor references vm_instance ( dest -> id ) dest Foreign Key fk_vm_to_pm_association vm_to_pm_association references physical_node ( physical_node_id -> id ) physical_node_id Foreign Key fk_vm_to_pm_association_vm vm_to_pm_association references vm_instance ( vm -> id ) vm Foreign Key fk_deployment_instances deployment references software_component_instance ( component_instance -> id ) component_instance Foreign Key fk_deployment_instances_conf deployment references software_component_config ( software_config -> id ) software_config Foreign Key fk_deployment_mapping deployment references platform_as_service ( on_paas -> name ) on_paas Foreign Key fk_deployment_mapping_ari deployment references software_component_instance ( on_component_instance -> id ) on_component_instance Foreign Key fk_deployment_vm_inst deployment references vm_instance ( on_vm_instance -> id ) on_vm_instance Foreign Key fk_artifact_instance_artifact_2 software_component_instance references software_component ( software_component_id -> id ) software_component_id Foreign Key fk_execution_context execution_context references application ( app_id -> id ) app_id Foreign Key fk_it_sla_platform_as_service it_slo references platform_as_service ( platform -> name ) platform Foreign Key fk_sla_it_slo sla references it_slo ( it_slo -> id ) it_slo Foreign Key fk_sla_requirements sla references requirements ( requirements -> id ) requirements Foreign Key fk_sla_application sla references application ( application_id -> id ) application_id Foreign Key fk_sla_history slo_assessment references execution_context ( execution_context -> id ) execution_context Foreign Key fk_sla slo_assessment references it_slo ( it_slo -> id ) it_slo Foreign Key fk_event event references it_slo ( condition -> id ) condition Foreign Key fk_high_monitor_sla software_component_monitor references it_slo ( it_slo -> id ) it_slo Foreign Key fk_high_level_monitor software_component_monitor references execution_context ( execution_context -> id ) execution_context Foreign Key fk_artefict_monitor software_component_monitor references software_component_instance ( component_instance -> id ) component_instance Foreign Key fk_resource_monitor_metric resource_monitor references metric ( metric -> id ) metric Foreign Key fk_resource_monitor resource_monitor references data_object ( data_object_id -> id ) data_object_id Foreign Key fk_resource_monitor_vm resource_monitor references vm_instance ( vm_instance -> id ) vm_instance Foreign Key fk_sec_control_slo_req sec_control_slo references requirement_sec_control ( requirement_id -> id ) requirement_id Foreign Key fk_sec_control_slo_it_slo sec_control_slo references it_slo ( sec_slo -> id ) sec_slo Foreign Key fk_property_property_parent property references property ( parent -> id ) parent Foreign Key fk_action_action_type action references action_type ( action_type_id -> id ) action_type_id Foreign Key fk_provides_sec_control provides_sec_control references security_control ( sec_control_id -> id ) sec_control_id Foreign Key fk_provides_sec_control_2 provides_sec_control references cloud_provider ( cp_id -> organization_id ) cp_id Foreign Key fk_requirement_sec_control requirement_sec_control references security_control ( sec_control_id -> id ) sec_control_id Foreign Key fk_requirement_sec_control_2 requirement_sec_control references requirements ( requirements -> id ) requirements Foreign Key fk_requirements_scalability_req requirements_scalability references requirements ( requirements -> id ) requirements Foreign Key fk_requirements_scalability_scal requirements_scalability references scalability_policy ( scalability -> id ) scalability Foreign Key fk_reqs_to_elasticity_rule reqs_to_scalability_rule references requirements ( req_id -> id ) req_id Foreign Key fk_reqs_to_elasticity_rule1 reqs_to_scalability_rule references scalability_rule ( scalability_rule_name -> name ) scalability_rule_name Foreign Key fk_requirement_it_slo_slo requirement_it_slo references it_slo ( it_slo -> id ) it_slo Foreign Key fk_requirement_it_slo_req requirement_it_slo references requirements ( requirements -> id ) requirements Foreign Key fk_elasticity_rule_action scalability_rule_action references scalability_rule ( scalability_rule -> name ) scalability_rule Foreign Key fk_elasticity_rule_action_1 scalability_rule_action references action ( action -> id ) action Foreign Key fk_appl_monitor_application appl_monitor references application ( app_id -> id ) app_id Foreign Key fk_appl_monitor appl_monitor references execution_context ( execution_context -> id ) execution_context Foreign Key fk_action_realization_1 action_realization references cloud_provider ( provider_id -> organization_id ) provider_id Foreign Key fk_user_group_has_role user_group_has_role references user_group ( user_group_id -> id ) user_group_id Foreign Key fk_user_group_has_role_role user_group_has_role references role ( role_id -> id ) role_id Foreign Key fk_permission_role permission references role ( role_id -> id ) role_id Foreign Key fk_permission_organization permission references organization ( issued_by -> id ) issued_by Foreign Key fk_permission_resource permission references resource ( resource -> id ) resource Foreign Key fk_cloud_provider_organization cloud_provider references organization ( organization_id -> id ) organization_id Foreign Key fk_cd_vm_type_resource cd_vm_type references resource ( resource -> id ) resource Foreign Key fk_cd_vm_type_dc cd_vm_type references data_center ( datacenter -> id ) datacenter Foreign Key fk_component_dependency_src component_dependency references software_component ( src_component -> id ) src_component Foreign Key fk_component_dependency_dst component_dependency references software_component ( dst_component -> id ) dst_component Foreign Key fk_component_inst_dependency_src component_inst_dependency references software_component_instance ( src_instance -> id ) src_instance Foreign Key fk_component_inst_dependency_dst component_inst_dependency references software_component_instance ( dst_instance -> id ) dst_instance ci_vm_typeTable pasaage_schema.ci_vm_type Primary Key ( id ) idid int not null Referred by cd_vm_type ( ci_vm_type -> id ) cpu_classcpu_class varchar( 20 ) memory_classmemory_class varchar( 20 ) io_classio_class varchar( 20 ) network_classnetwork_class varchar( 20 ) vm_configTable pasaage_schema.vm_config Primary Key ( id ) idid int not null Referred by vm_instance ( vm_config -> id ) osos varchar( 20 ) is64osis64os bool imageidimageid varchar( 20 ) privatekeyprivatekey varchar( 100 ) ssh_keyssh_key varchar( 100 ) security_groupsecurity_group varchar( 30 ) group_namegroup_name varchar( 30 ) application_componentsTable pasaage_schema.application_components associate software components with application
 Primary Key ( id ) idid int not null Index ( soft_component_id ) soft_component_idsoft_component_id int References software_component ( soft_component_id -> id ) Index ( application_id ) application_idapplication_id int References application ( application_id -> id ) component_scalabilityTable pasaage_schema.component_scalability Primary Key ( id ) idid int not null Index ( software_comp ) software_compsoftware_comp int References software_component ( software_comp -> id ) Index ( scalability_policy ) scalability_policyscalability_policy int References scalability_policy ( scalability_policy -> id ) event_patternTable pasaage_schema.event_pattern Unique Index ( id ) Primary Key ( id ) idid int not null Referred by scalability_rule ( pattern -> id ) Index ( first_event ) first_eventfirst_event varchar( 50 ) References event ( first_event -> name ) first_event_relationfirst_event_relation varchar( 50 ) Index ( second_event ) second_eventsecond_event varchar( 50 ) References event ( second_event -> name ) second_event_relationsecond_event_relation varchar( 50 ) operatoroperator varchar( 10 ) deployment_executionTable pasaage_schema.deployment_execution Associate a deployment plan with specific executions of an application
 Primary Key ( id ) idid int not null Index ( deployment_id ) deployment_iddeployment_id int References deployment ( deployment_id -> id ) Index ( execution_context ) execution_contextexecution_context int References execution_context ( execution_context -> id ) Index ( requirements ) requirementsrequirements int References requirements ( requirements -> id ) user_works_for_organizationTable pasaage_schema.user_works_for_organization Primary Key ( user_id, organization_id ) Index ( user_id ) user_iduser_id int not null References user ( user_id -> id ) Primary Key ( user_id, organization_id ) Index ( organization_id ) organization_idorganization_id int not null References organization ( organization_id -> id ) user_identifier_typeTable pasaage_schema.user_identifier_type Primary Key ( id ) idid int not null Referred by user_external_identifier ( user_identifier_type_id -> id ) namename varchar( 100 ) descriptiondescription varchar( 1024 ) scalability_policyTable pasaage_schema.scalability_policy Primary Key ( id ) idid int not null Referred by component_scalability ( scalability_policy -> id ) Referred by requirements_scalability ( scalability -> id ) scaling_typescaling_type enum( 'horizontal','vertical' ) min_instancesmin_instances int max_instancemax_instance int object_associationTable pasaage_schema.object_association Primary Key ( id ) idid int not null Index ( producer ) producerproducer int References software_component_instance ( producer -> id ) Index ( consumer ) consumerconsumer int References software_component_instance ( consumer -> id ) Index ( execution_context ) execution_contextexecution_context int References execution_context ( execution_context -> id ) started_onstarted_on timestamp ended_onended_on timestamp Index ( data_object_id ) data_object_iddata_object_id int References data_object ( data_object_id -> id ) platform_as_serviceTable pasaage_schema.platform_as_service Unique Index ( name ) Primary Key ( name ) namename varchar( 30 ) not null Referred by deployment ( on_paas -> name ) Referred by it_slo ( platform -> name ) apiapi varchar( 20 ) elasticity_elasticity_ varchar( 20 ) Index ( cloud_provider_id ) cloud_provider_idcloud_provider_id int References cloud_provider ( cloud_provider_id -> organization_id ) user_belongs_to_groupTable pasaage_schema.user_belongs_to_group Primary Key ( user_id, user_group_id ) Index ( user_id ) user_iduser_id int not null References user ( user_id -> id ) Primary Key ( user_id, user_group_id ) Index ( user_group_id ) user_group_iduser_group_id int not null References user_group ( user_group_id -> id ) user_external_identifierTable pasaage_schema.user_external_identifier Primary Key ( id ) idid int not null Index ( user_id ) user_iduser_id int References user ( user_id -> id ) external_identifierexternal_identifier varchar( 1024 ) Index ( user_identifier_type_id ) user_identifier_type_iduser_identifier_type_id int References user_identifier_type ( user_identifier_type_id -> id ) user_groupTable pasaage_schema.user_group Primary Key ( id ) idid int not null Referred by user_belongs_to_group ( user_group_id -> id ) Referred by user_group_has_role ( user_group_id -> id ) namename varchar( 100 ) userTable pasaage_schema.user Primary Key ( id ) idid int not null Referred by application ( user -> id ) Referred by user_belongs_to_group ( user_id -> id ) Referred by user_external_identifier ( user_id -> id ) Referred by user_has_role ( user_id -> id ) Referred by user_works_for_organization ( user_id -> id ) lastnamelastname varchar( 100 ) not null firstnamefirstname varchar( 100 ) emailemail varchar( 64 ) wwwwww varchar( 256 ) Unique Index ( login ) loginlogin varchar( 100 ) requirementsTable pasaage_schema.requirements Primary Key ( id ) idid int not null Referred by component_dependency ( requirement -> id ) Referred by component_inst_dependency ( requirement -> id ) Referred by deployment_execution ( requirements -> id ) Referred by reqs_to_scalability_rule ( req_id -> id ) Referred by requirement_it_slo ( requirements -> id ) Referred by requirement_sec_control ( requirements -> id ) Referred by requirements_scalability ( requirements -> id ) Referred by sla ( requirements -> id ) prioritypriority double metricTable pasaage_schema.metric Primary Key ( id ) idid int not null Referred by appl_monitor ( metric -> id ) Referred by it_slo ( metric -> id ) Referred by resource_coupling_monitor ( metric -> id ) Referred by resource_monitor ( metric -> id ) Referred by software_component_monitor ( metric -> id ) namename varchar( 20 ) descriptiondescription varchar( 100 ) value_directionvalue_direction enum( 'lower','higher' ) layerlayer smallint unitunit varchar( 20 ) Index ( property ) propertyproperty int References property ( property -> id ) rule_trigger_eventTable pasaage_schema.rule_trigger_event Index ( rule_trigger_id ) Primary Key ( rule_trigger_id, event_instance_id ) rule_trigger_idrule_trigger_id int not null References rule_trigger ( rule_trigger_id -> id ) Index ( event_instance_id ) Primary Key ( rule_trigger_id, event_instance_id ) event_instance_idevent_instance_id int not null References event_instance ( event_instance_id -> id ) scalability_ruleTable pasaage_schema.scalability_rule Unique Index ( name ) Primary Key ( name ) namename varchar( 20 ) not null Referred by reqs_to_scalability_rule ( scalability_rule_name -> name ) Referred by rule_trigger ( rule_name -> name ) Referred by scalability_rule_action ( scalability_rule -> name ) evaluate_frequencyevaluate_frequency timestamp Index ( event ) eventevent varchar( 50 ) References event ( event -> name ) Index ( pattern ) patternpattern int References event_pattern ( pattern -> id ) sla_partiesTable pasaage_schema.sla_parties Primary Key ( provider_id, requester_id, sla_id ) Index ( sla_id ) sla_idsla_id int not null References sla ( sla_id -> id ) Primary Key ( provider_id, requester_id, sla_id ) Index ( provider_id ) provider_idprovider_id int not null References cloud_provider ( provider_id -> organization_id ) Primary Key ( provider_id, requester_id, sla_id ) requester_idrequester_id int not null roleTable pasaage_schema.role Primary Key ( id ) idid int not null Referred by permission ( role_id -> id ) Referred by user_group_has_role ( role_id -> id ) Referred by user_has_role ( role_id -> id ) namename varchar( 20 ) not null rule_triggerTable pasaage_schema.rule_trigger Primary Key ( id ) idid int not null Referred by action_realization ( rule_trigger_id -> id ) Referred by rule_trigger_event ( rule_trigger_id -> id ) rule_namerule_name varchar( 100 ) not null References scalability_rule ( rule_name -> name ) fired_onfired_on datetime allowed_actionTable pasaage_schema.allowed_action Primary Key ( id ) idid int not null Index ( action ) actionaction int References action ( action -> id ) resource_classresource_class varchar( 30 ) permission_actionTable pasaage_schema.permission_action Primary Key ( id ) idid int not null Index ( permission_id ) permission_idpermission_id int References permission ( permission_id -> id ) Index ( action_id ) action_idaction_id int References action ( action_id -> id ) applicationTable pasaage_schema.application Primary Key ( id ) idid int not null Referred by appl_monitor ( app_id -> id ) Referred by application_components ( application_id -> id ) Referred by execution_context ( app_id -> id ) Referred by sla ( application_id -> id ) Index ( name ) namename varchar( 20 ) not null versionversion varchar( 10 ) not null Index ( user ) useruser int References user ( user -> id ) Index ( resource ) resourceresource int References resource ( resource -> id ) software_componentTable pasaage_schema.software_component Unique Index ( id ) Primary Key ( id ) idid int not null Referred by application_components ( soft_component_id -> id ) Referred by component_dependency ( src_component -> id ) Referred by component_dependency ( dst_component -> id ) Referred by component_scalability ( software_comp -> id ) Referred by software_component_instance ( software_component_id -> id ) namename varchar( 50 ) not null descriptiondescription varchar( 100 ) tagtag varchar( 20 ) groupidgroupid varchar( 100 ) Index ( resource ) resourceresource int References resource ( resource -> id ) physical_nodeTable pasaage_schema.physical_node Primary Key ( id ) idid int not null Referred by resource_monitor ( physical_node_id -> id ) Referred by vm_to_pm_association ( physical_node_id -> id ) ipip varchar( 15 ) locationlocation varchar( 20 ) hardwarehardware varchar( 20 ) Index ( cloud_provider_id ) cloud_provider_idcloud_provider_id int References cloud_provider ( cloud_provider_id -> organization_id ) Index ( resource ) resourceresource int References resource ( resource -> id ) resource_to_groupTable pasaage_schema.resource_to_group Primary Key ( group_id, resource_id ) Index ( group_id ) group_idgroup_id int not null References resource_group ( group_id -> resource_id ) Primary Key ( group_id, resource_id ) Index ( resource_id ) resource_idresource_id int not null References resource ( resource_id -> id ) resource_groupTable pasaage_schema.resource_group Primary Key ( resource_id ) resource_idresource_id int not null References resource ( resource_id -> id ) Referred by resource_to_group ( group_id -> resource_id ) namename varchar( 100 ) resourceTable pasaage_schema.resource Primary Key ( id ) idid int not null Referred by application ( resource -> id ) Referred by cd_vm_type ( resource -> id ) Referred by data_object ( resource -> id ) Referred by permission ( resource -> id ) Referred by physical_node ( resource -> id ) Referred by resource_group ( resource_id -> id ) Referred by resource_to_group ( resource_id -> id ) Referred by software_component ( resource -> id ) organizationTable pasaage_schema.organization Primary Key ( id ) idid int not null Referred by cloud_provider ( organization_id -> id ) Referred by permission ( issued_by -> id ) Referred by user_works_for_organization ( organization_id -> id ) namename varchar( 40 ) not null wwwwww varchar( 100 ) postal_addresspostal_address varchar( 256 ) emailemail varchar( 64 ) locationTable pasaage_schema.location Primary Key ( id ) idid int not null Referred by data_center ( location_id -> id ) citycity varchar( 128 ) countrycountry varchar( 128 ) country_codecountry_code varchar( 2 ) latitudelatitude double longitudelongitude double addressaddress varchar( 256 ) sec_propertyTable pasaage_schema.sec_property Index ( prop_id ) Primary Key ( prop_id ) prop_idprop_id int not null References property ( prop_id -> id ) domaindomain varchar( 100 ) data_centerTable pasaage_schema.data_center Primary Key ( id ) idid int not null Referred by cd_vm_type ( datacenter -> id ) namename varchar( 100 ) Index ( location_id ) location_idlocation_id int References location ( location_id -> id ) Index ( cloud_provider ) cloud_providercloud_provider int References cloud_provider ( cloud_provider -> organization_id ) code_namecode_name varchar( 30 ) user_has_roleTable pasaage_schema.user_has_role Primary Key ( user_id, role_id ) user_iduser_id int not null References user ( user_id -> id ) Index ( role_id ) Primary Key ( user_id, role_id ) role_idrole_id int not null References role ( role_id -> id ) startstart datetime endend datetime assigned_onassigned_on datetime data_objectTable pasaage_schema.data_object Primary Key ( id ) idid int not null Referred by object_association ( data_object_id -> id ) Referred by resource_monitor ( data_object_id -> id ) replicationreplication varchar( 20 ) partitioningpartitioning varchar( 20 ) consistencyconsistency varchar( 20 ) namename varchar( 100 ) Index ( resource ) resourceresource int References resource ( resource -> id ) vm_instanceTable pasaage_schema.vm_instance Primary Key ( id ) idid int not null Referred by deployment ( on_vm_instance -> id ) Referred by resource_coupling_monitor ( src -> id ) Referred by resource_coupling_monitor ( dest -> id ) Referred by resource_monitor ( vm_instance -> id ) Referred by vm_to_pm_association ( vm -> id ) Index ( cd_vm_id ) cd_vm_idcd_vm_id int References cd_vm_type ( cd_vm_id -> id ) ipip varchar( 15 ) created_oncreated_on timestamp default '0000-00-00 00:00:00' destroyed_ondestroyed_on timestamp default '0000-00-00 00:00:00' Index ( vm_config ) vm_configvm_config int References vm_config ( vm_config -> id ) resource_coupling_monitorTable pasaage_schema.resource_coupling_monitor Primary Key ( name, execution_context ) namename varchar( 20 ) not null Primary Key ( name, execution_context ) Index ( execution_context ) execution_contextexecution_context int not null References execution_context ( execution_context -> id ) Index ( src ) srcsrc int References vm_instance ( src -> id ) Index ( dest ) destdest int References vm_instance ( dest -> id ) reported_onreported_on timestamp default '0000-00-00 00:00:00' Index ( metric ) metricmetric int References metric ( metric -> id ) raw_dataraw_data timestamp vm_to_pm_associationTable pasaage_schema.vm_to_pm_association Primary Key ( id ) idid int not null Index ( vm ) vmvm int References vm_instance ( vm -> id ) started_onstarted_on date ended_onended_on date Index ( physical_node_id ) physical_node_idphysical_node_id int References physical_node ( physical_node_id -> id ) deploymentTable pasaage_schema.deployment Primary Key ( id ) idid int not null Referred by deployment_execution ( deployment_id -> id ) Index ( component_instance ) component_instancecomponent_instance int References software_component_instance ( component_instance -> id ) Index ( software_config ) software_configsoftware_config int References software_component_config ( software_config -> id ) Index ( on_vm_instance ) on_vm_instanceon_vm_instance int References vm_instance ( on_vm_instance -> id ) Index ( on_component_instance ) on_component_instanceon_component_instance int References software_component_instance ( on_component_instance -> id ) Index ( on_paas ) on_paason_paas varchar( 30 ) References platform_as_service ( on_paas -> name ) software_component_configTable pasaage_schema.software_component_config Unique Index ( id ) idid int Referred by deployment ( software_config -> id ) port_numport_num int configconfig varchar( 50 ) retrieving_cmdretrieving_cmd varchar( 200 ) deploying_cmddeploying_cmd varchar( 200 ) start_cmdstart_cmd varchar( 200 ) software_component_instanceTable pasaage_schema.software_component_instance Primary Key ( id ) idid int not null Referred by component_inst_dependency ( src_instance -> id ) Referred by component_inst_dependency ( dst_instance -> id ) Referred by deployment ( component_instance -> id ) Referred by deployment ( on_component_instance -> id ) Referred by object_association ( producer -> id ) Referred by object_association ( consumer -> id ) Referred by software_component_monitor ( component_instance -> id ) namename varchar( 20 ) not null versionversion varchar( 10 ) Index ( software_component_id ) software_component_idsoftware_component_id int References software_component ( software_component_id -> id ) execution_contextTable pasaage_schema.execution_context Primary Key ( id ) idid int not null Referred by appl_monitor ( execution_context -> id ) Referred by deployment_execution ( execution_context -> id ) Referred by object_association ( execution_context -> id ) Referred by resource_coupling_monitor ( execution_context -> id ) Referred by resource_monitor ( execution_context -> id ) Referred by slo_assessment ( execution_context -> id ) Referred by software_component_monitor ( execution_context -> id ) Index ( app_id ) app_idapp_id int References application ( app_id -> id ) start_timestart_time timestamp not null default '0000-00-00 00:00:00' end_timeend_time timestamp not null default '0000-00-00 00:00:00' infoinfo varchar( 20 ) total_costtotal_cost double it_sloTable pasaage_schema.it_slo Primary Key ( id ) idid int not null Referred by appl_monitor ( it_slo -> id ) Referred by event ( condition -> id ) Referred by requirement_it_slo ( it_slo -> id ) Referred by resource_monitor ( it_slo -> id ) Referred by sec_control_slo ( sec_slo -> id ) Referred by sla ( it_slo -> id ) Referred by slo_assessment ( it_slo -> id ) Referred by software_component_monitor ( it_slo -> id ) Index ( metric ) metricmetric int References metric ( metric -> id ) thresholdthreshold double Index ( platform ) platformplatform varchar( 20 ) References platform_as_service ( platform -> name ) slaTable pasaage_schema.sla Primary Key ( id ) idid int not null Referred by sla_parties ( sla_id -> id ) targeted_costtargeted_cost double targeted_locationtargeted_location varchar( 15 ) targeted_revenuetargeted_revenue double Index ( it_slo ) it_sloit_slo int References it_slo ( it_slo -> id ) Index ( requirements ) requirementsrequirements int References requirements ( requirements -> id ) Index ( application_id ) application_idapplication_id int References application ( application_id -> id ) slo_assessmentTable pasaage_schema.slo_assessment Primary Key ( id ) idid int not null Index ( execution_context ) execution_contextexecution_context int References execution_context ( execution_context -> id ) Index ( it_slo ) it_sloit_slo int References it_slo ( it_slo -> id ) assessmentassessment bool eventTable pasaage_schema.event Primary Key ( name ) namename varchar( 100 ) not null Referred by event_instance ( event_name -> name ) Referred by event_pattern ( first_event -> name ) Referred by event_pattern ( second_event -> name ) Referred by scalability_rule ( event -> name ) Index ( condition ) conditioncondition int References it_slo ( condition -> id ) software_component_monitorTable pasaage_schema.software_component_monitor Primary Key ( name, execution_context ) namename varchar( 20 ) not null Index ( execution_context ) Primary Key ( name, execution_context ) execution_contextexecution_context int not null References execution_context ( execution_context -> id ) Index ( component_instance ) component_instancecomponent_instance int References software_component_instance ( component_instance -> id ) Index ( it_slo ) it_sloit_slo int References it_slo ( it_slo -> id ) Index ( metric ) metricmetric int References metric ( metric -> id ) valuevalue double reported_onreported_on timestamp default '0000-00-00 00:00:00' raw_dataraw_data varchar( 20 ) resource_monitorTable pasaage_schema.resource_monitor Primary Key ( id ) idid int not null namename varchar( 20 ) not null Index ( execution_context ) execution_contextexecution_context int not null References execution_context ( execution_context -> id ) Index ( vm_instance ) vm_instancevm_instance int not null References vm_instance ( vm_instance -> id ) Index ( it_slo ) it_sloit_slo int References it_slo ( it_slo -> id ) resource_classresource_class varchar( 20 ) Index ( metric ) metricmetric int References metric ( metric -> id ) valuevalue double reported_onreported_on timestamp default '0000-00-00 00:00:00' raw_dataraw_data varchar( 20 ) Index ( data_object_id ) data_object_iddata_object_id int References data_object ( data_object_id -> id ) Index ( physical_node_id ) physical_node_idphysical_node_id int References physical_node ( physical_node_id -> id ) sec_control_sloTable pasaage_schema.sec_control_slo Index ( requirement_id ) requirement_idrequirement_id int References requirement_sec_control ( requirement_id -> id ) Index ( sec_slo ) sec_slosec_slo int References it_slo ( sec_slo -> id ) propertyTable pasaage_schema.property Primary Key ( id ) idid int not null Referred by metric ( property -> id ) Referred by property ( parent -> id ) Referred by sec_property ( prop_id -> id ) namename varchar( 100 ) categorycategory varchar( 100 ) measurablemeasurable bool Index ( parent ) parentparent int References property ( parent -> id ) security_controlTable pasaage_schema.security_control Primary Key ( id ) idid varchar( 50 ) not null Referred by provides_sec_control ( sec_control_id -> id ) Referred by requirement_sec_control ( sec_control_id -> id ) descriptiondescription varchar( 200 ) domaindomain varchar( 50 ) action_typeTable pasaage_schema.action_type Primary Key ( id ) idid int not null Referred by action ( action_type_id -> id ) namename varchar( 100 ) actionTable pasaage_schema.action Primary Key ( id ) idid int not null Referred by action_realization ( action_id -> id ) Referred by allowed_action ( action -> id ) Referred by permission_action ( action_id -> id ) Referred by scalability_rule_action ( action -> id ) Index ( action_type_id ) action_type_idaction_type_id int References action_type ( action_type_id -> id ) provides_sec_controlTable pasaage_schema.provides_sec_control Index ( sec_control_id ) Primary Key ( sec_control_id, cp_id ) sec_control_idsec_control_id varchar( 50 ) not null References security_control ( sec_control_id -> id ) Index ( cp_id ) Primary Key ( sec_control_id, cp_id ) cp_idcp_id int not null References cloud_provider ( cp_id -> organization_id ) requirement_sec_controlTable pasaage_schema.requirement_sec_control Primary Key ( id ) idid int not null Referred by sec_control_slo ( requirement_id -> id ) sec_control_idsec_control_id varchar( 50 ) References security_control ( sec_control_id -> id ) Index ( requirements ) requirementsrequirements int References requirements ( requirements -> id ) requirements_scalabilityTable pasaage_schema.requirements_scalability Primary Key ( id ) idid int not null Index ( requirements, scalability ) requirementsrequirements int References requirements ( requirements -> id ) Index ( requirements, scalability ) scalabilityscalability int References scalability_policy ( scalability -> id ) reqs_to_scalability_ruleTable pasaage_schema.reqs_to_scalability_rule Primary Key ( req_id, scalability_rule_name ) req_idreq_id int not null References requirements ( req_id -> id ) Primary Key ( req_id, scalability_rule_name ) scalability_rule_namescalability_rule_name varchar( 100 ) not null References scalability_rule ( scalability_rule_name -> name ) requirement_it_sloTable pasaage_schema.requirement_it_slo Primary Key ( id ) idid int not null Index ( it_slo, requirements ) it_sloit_slo int References it_slo ( it_slo -> id ) Index ( it_slo, requirements ) requirementsrequirements int References requirements ( requirements -> id ) scalability_rule_actionTable pasaage_schema.scalability_rule_action Primary Key ( scalability_rule, action ) scalability_rulescalability_rule varchar( 100 ) not null References scalability_rule ( scalability_rule -> name ) Primary Key ( scalability_rule, action ) actionaction int not null References action ( action -> id ) appl_monitorTable pasaage_schema.appl_monitor Primary Key ( id ) idid int not null Index ( app_id ) app_idapp_id int References application ( app_id -> id ) Index ( it_slo ) it_sloit_slo int References it_slo ( it_slo -> id ) Index ( execution_context ) execution_contextexecution_context int References execution_context ( execution_context -> id ) Index ( metric ) metricmetric int References metric ( metric -> id ) valuevalue varchar( 10 ) rw_datarw_data varchar( 20 ) reported_onreported_on timestamp action_realizationTable pasaage_schema.action_realization Index ( action_id ) Primary Key ( action_id, rule_trigger_id ) action_idaction_id int not null References action ( action_id -> id ) Index ( provider_id ) provider_idprovider_id int References cloud_provider ( provider_id -> organization_id ) fired_onfired_on timestamp ended_onended_on timestamp low_level_actionslow_level_actions varchar( 200 ) Index ( rule_trigger_id ) Primary Key ( action_id, rule_trigger_id ) rule_trigger_idrule_trigger_id int not null References rule_trigger ( rule_trigger_id -> id ) user_group_has_roleTable pasaage_schema.user_group_has_role Primary Key ( user_group_id, role_id ) user_group_iduser_group_id int not null References user_group ( user_group_id -> id ) Primary Key ( user_group_id, role_id ) role_idrole_id int not null References role ( role_id -> id ) startstart timestamp endend timestamp assigned_onassigned_on datetime permissionTable pasaage_schema.permission Primary Key ( id ) idid int not null Referred by permission_action ( permission_id -> id ) Index ( role_id ) role_idrole_id int References role ( role_id -> id ) allowedallowed tinyint startstart timestamp endend timestamp Index ( issued_by ) issued_byissued_by int References organization ( issued_by -> id ) Index ( resource ) resourceresource int References resource ( resource -> id ) event_instanceTable pasaage_schema.event_instance Primary Key ( id ) idid int not null Referred by rule_trigger_event ( event_instance_id -> id ) Index ( event_name ) event_nameevent_name varchar( 100 ) References event ( event_name -> name ) importanceimportance varchar( 50 ) source_componentsource_component varchar( 50 ) fired_onfired_on timestamp execution_contextexecution_context varchar( 100 ) cloud_providerTable pasaage_schema.cloud_provider Primary Key ( organization_id ) organization_idorganization_id int not null References organization ( organization_id -> id ) Referred by action_realization ( provider_id -> organization_id ) Referred by data_center ( cloud_provider -> organization_id ) Referred by physical_node ( cloud_provider_id -> organization_id ) Referred by platform_as_service ( cloud_provider_id -> organization_id ) Referred by provides_sec_control ( cp_id -> organization_id ) Referred by sla_parties ( provider_id -> organization_id ) publicpublic bool paaspaas tinyint default 0 iaasiaas tinyint default 0 saassaas tinyint default 0 cd_vm_typeTable pasaage_schema.cd_vm_type Unique Index ( id ) Primary Key ( id ) idid int not null Referred by vm_instance ( cd_vm_id -> id ) namename varchar( 20 ) not null Index ( datacenter ) datacenterdatacenter int References data_center ( datacenter -> id ) Index ( ci_vm_type ) ci_vm_typeci_vm_type int References ci_vm_type ( ci_vm_type -> id ) classified_onclassified_on timestamp not null evaluated_onevaluated_on timestamp not null cpucpu int ramram int diskdisk int benchmark_ratebenchmark_rate double cost_per_hourcost_per_hour double Index ( resource ) resourceresource int References resource ( resource -> id ) component_dependencyTable pasaage_schema.component_dependency Primary Key ( id ) idid int not null Index ( src_component ) src_componentsrc_component int References software_component ( src_component -> id ) Index ( dst_component ) dst_componentdst_component int References software_component ( dst_component -> id ) typetype varchar( 20 ) is_optionalis_optional bool requires_localrequires_local bool requires_remoterequires_remote bool Index ( requirement ) requirementrequirement int References requirements ( requirement -> id ) component_inst_dependencyTable pasaage_schema.component_inst_dependency Primary Key ( id ) idid int not null Index ( src_instance ) src_instancesrc_instance int References software_component_instance ( src_instance -> id ) Index ( dst_instance ) dst_instancedst_instance int References software_component_instance ( dst_instance -> id ) typetype varchar( 20 ) is_optionis_option bool requires_localrequires_local bool requires_remoterequires_remote bool Index ( requirement ) requirementrequirement int References requirements ( requirement -> id )

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 )
email 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 )
email 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)