-- phpMyAdmin SQL Dump
-- version 2.11.3deb1ubuntu1.3
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Oct 19, 2011 at 09:15 PM
-- Server version: 5.0.51
-- PHP Version: 5.2.4-2ubuntu5.17
SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
--
-- Database: `TOGAF_CM`
--
-- --------------------------------------------------------
--
-- Table structure for table `togaf9_CMO_actor`
--
CREATE TABLE IF NOT EXISTS `togaf9_CMO_actor` (
`id` int(11) NOT NULL,
`name` varchar(64) collate utf8_unicode_ci NOT NULL,
`description` varchar(255) collate utf8_unicode_ci default NULL,
`category` varchar(64) collate utf8_unicode_ci default NULL,
`source` varchar(255) collate utf8_unicode_ci default NULL,
`owner` varchar(255) collate utf8_unicode_ci default NULL,
`no_ftes` varchar(255) collate utf8_unicode_ci default NULL,
`actor_goal` varchar(255) collate utf8_unicode_ci default NULL,
`actor_tasks` varchar(255) collate utf8_unicode_ci default NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
-- --------------------------------------------------------
--
-- Table structure for table `togaf9_CMO_application_component`
--
CREATE TABLE IF NOT EXISTS `togaf9_CMO_application_component` (
`id` int(11) NOT NULL,
`name` varchar(64) collate utf8_unicode_ci NOT NULL,
`description` varchar(255) collate utf8_unicode_ci default NULL,
`category` varchar(64) collate utf8_unicode_ci default NULL,
`source` varchar(255) collate utf8_unicode_ci default NULL,
`owner` varchar(255) collate utf8_unicode_ci default NULL,
`standards_class` varchar(255) collate utf8_unicode_ci default NULL,
`standard_creation_date` date default NULL,
`last_standard_review_date` date default NULL,
`next_standard_review_date` date default NULL,
`retire_date` date default NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
-- --------------------------------------------------------
--
-- Table structure for table `togaf9_CMO_business_service`
--
CREATE TABLE IF NOT EXISTS `togaf9_CMO_business_service` (
`id` int(11) NOT NULL,
`name` varchar(64) collate utf8_unicode_ci NOT NULL,
`description` varchar(255) collate utf8_unicode_ci default NULL,
`category` varchar(64) collate utf8_unicode_ci default NULL,
`source` varchar(255) collate utf8_unicode_ci default NULL,
`owner` varchar(255) collate utf8_unicode_ci default NULL,
`standards_class` varchar(255) collate utf8_unicode_ci default NULL,
`standard_creation_date` date default NULL,
`last_standard_review_date` date default NULL,
`next_standard_review_date` date default NULL,
`retire_date` date default NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
-- --------------------------------------------------------
--
-- Table structure for table `togaf9_CMO_capability`
--
CREATE TABLE IF NOT EXISTS `togaf9_CMO_capability` (
`id` int(11) NOT NULL,
`name` varchar(64) collate utf8_unicode_ci NOT NULL,
`description` varchar(255) collate utf8_unicode_ci default NULL,
`category` varchar(64) collate utf8_unicode_ci default NULL,
`source` varchar(255) collate utf8_unicode_ci default NULL,
`owner` varchar(255) collate utf8_unicode_ci default NULL,
`business_value` varchar(255) collate utf8_unicode_ci default NULL,
`increments` varchar(255) collate utf8_unicode_ci default NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
-- --------------------------------------------------------
--
-- Table structure for table `togaf9_CMO_constraint`
--
CREATE TABLE IF NOT EXISTS `togaf9_CMO_constraint` (
`id` int(11) NOT NULL,
`name` varchar(64) collate utf8_unicode_ci NOT NULL,
`description` varchar(255) collate utf8_unicode_ci default NULL,
`category` varchar(64) collate utf8_unicode_ci default NULL,
`source` varchar(255) collate utf8_unicode_ci default NULL,
`owner` varchar(255) collate utf8_unicode_ci default NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
-- --------------------------------------------------------
--
-- Table structure for table `togaf9_CMO_contract`
--
CREATE TABLE IF NOT EXISTS `togaf9_CMO_contract` (
`id` int(11) NOT NULL,
`name` varchar(64) collate utf8_unicode_ci NOT NULL,
`description` varchar(255) collate utf8_unicode_ci default NULL,
`category` varchar(64) collate utf8_unicode_ci default NULL,
`source` varchar(255) collate utf8_unicode_ci default NULL,
`owner` varchar(255) collate utf8_unicode_ci default NULL,
`behavior_characteristics` varchar(255) collate utf8_unicode_ci default NULL,
`service_name_caller` varchar(255) collate utf8_unicode_ci default NULL,
`service_name_called` varchar(255) collate utf8_unicode_ci default NULL,
`service_quality_characteristics` varchar(255) collate utf8_unicode_ci default NULL,
`availability_characteristics` varchar(255) collate utf8_unicode_ci default NULL,
`service_times` varchar(255) collate utf8_unicode_ci default NULL,
`manageability_characteristics` varchar(255) collate utf8_unicode_ci default NULL,
`serviceability_characteristics` varchar(255) collate utf8_unicode_ci default NULL,
`performance_characteristics` varchar(255) collate utf8_unicode_ci default NULL,
`response_requirements` varchar(255) collate utf8_unicode_ci default NULL,
`reliability_characteristics` varchar(255) collate utf8_unicode_ci default NULL,
`quality_of_information_required` varchar(255) collate utf8_unicode_ci default NULL,
`contract_control_requirements` varchar(255) collate utf8_unicode_ci default NULL,
`result_control_requirements` varchar(255) collate utf8_unicode_ci default NULL,
`recoverability_characteristics` varchar(255) collate utf8_unicode_ci default NULL,
`locatability_characteristics` varchar(255) collate utf8_unicode_ci default NULL,
`security_characteristics` varchar(255) collate utf8_unicode_ci default NULL,
`privacy_characteristics` varchar(255) collate utf8_unicode_ci default NULL,
`integrity_characteristics` varchar(255) collate utf8_unicode_ci default NULL,
`credibility_characteristics` varchar(255) collate utf8_unicode_ci default NULL,
`localization_characteristics` varchar(255) collate utf8_unicode_ci default NULL,
`internationalization_characteristics` varchar(255) collate utf8_unicode_ci default NULL,
`interoperability_characteristics` varchar(255) collate utf8_unicode_ci default NULL,
`scalability_characteristics` varchar(255) collate utf8_unicode_ci default NULL,
`portability_characteristics` varchar(255) collate utf8_unicode_ci default NULL,
`extensibility_characteristics` varchar(255) collate utf8_unicode_ci default NULL,
`capacity_characteristics` varchar(255) collate utf8_unicode_ci default NULL,
`throughput` varchar(255) collate utf8_unicode_ci default NULL,
`throughput_period` varchar(255) collate utf8_unicode_ci default NULL,
`growth` varchar(255) collate utf8_unicode_ci default NULL,
`growth_period` varchar(255) collate utf8_unicode_ci default NULL,
`peak_profile_short_term` varchar(255) collate utf8_unicode_ci default NULL,
`peak_profile_long_term` varchar(255) collate utf8_unicode_ci default NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
-- --------------------------------------------------------
--
-- Table structure for table `togaf9_CMO_control`
--
CREATE TABLE IF NOT EXISTS `togaf9_CMO_control` (
`id` int(11) NOT NULL,
`name` varchar(64) collate utf8_unicode_ci NOT NULL,
`description` varchar(255) collate utf8_unicode_ci default NULL,
`category` varchar(64) collate utf8_unicode_ci default NULL,
`source` varchar(255) collate utf8_unicode_ci default NULL,
`owner` varchar(255) collate utf8_unicode_ci default NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
-- --------------------------------------------------------
--
-- Table structure for table `togaf9_CMO_data_entity`
--
CREATE TABLE IF NOT EXISTS `togaf9_CMO_data_entity` (
`id` int(11) NOT NULL,
`name` varchar(64) collate utf8_unicode_ci NOT NULL,
`description` varchar(255) collate utf8_unicode_ci default NULL,
`category` varchar(64) collate utf8_unicode_ci default NULL,
`source` varchar(255) collate utf8_unicode_ci default NULL,
`owner` varchar(255) collate utf8_unicode_ci default NULL,
`privacy_classification` varchar(255) collate utf8_unicode_ci default NULL,
`retention_classification` varchar(255) collate utf8_unicode_ci default NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
-- --------------------------------------------------------
--
-- Table structure for table `togaf9_CMO_driver`
--
CREATE TABLE IF NOT EXISTS `togaf9_CMO_driver` (
`id` int(11) NOT NULL,
`name` varchar(64) collate utf8_unicode_ci NOT NULL,
`description` varchar(255) collate utf8_unicode_ci default NULL,
`category` varchar(64) collate utf8_unicode_ci default NULL,
`source` varchar(255) collate utf8_unicode_ci default NULL,
`owner` varchar(255) collate utf8_unicode_ci default NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
-- --------------------------------------------------------
--
-- Table structure for table `togaf9_CMO_event`
--
CREATE TABLE IF NOT EXISTS `togaf9_CMO_event` (
`id` int(11) NOT NULL,
`name` varchar(64) collate utf8_unicode_ci NOT NULL,
`description` varchar(255) collate utf8_unicode_ci default NULL,
`category` varchar(64) collate utf8_unicode_ci default NULL,
`source` varchar(255) collate utf8_unicode_ci default NULL,
`owner` varchar(255) collate utf8_unicode_ci default NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
-- --------------------------------------------------------
--
-- Table structure for table `togaf9_CMO_function`
--
CREATE TABLE IF NOT EXISTS `togaf9_CMO_function` (
`id` int(11) NOT NULL,
`name` varchar(64) collate utf8_unicode_ci NOT NULL,
`description` varchar(255) collate utf8_unicode_ci default NULL,
`category` varchar(64) collate utf8_unicode_ci default NULL,
`source` varchar(255) collate utf8_unicode_ci default NULL,
`owner` varchar(255) collate utf8_unicode_ci default NULL,
`standards_class` varchar(255) collate utf8_unicode_ci default NULL,
`standard_creation_date` date default NULL,
`last_standard_review_date` date default NULL,
`next_standard_review_date` date default NULL,
`retire_date` date default NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
-- --------------------------------------------------------
--
-- Table structure for table `togaf9_CMO_gap`
--
CREATE TABLE IF NOT EXISTS `togaf9_CMO_gap` (
`id` int(11) NOT NULL,
`name` varchar(64) collate utf8_unicode_ci NOT NULL,
`description` varchar(255) collate utf8_unicode_ci default NULL,
`category` varchar(64) collate utf8_unicode_ci default NULL,
`source` varchar(255) collate utf8_unicode_ci default NULL,
`owner` varchar(255) collate utf8_unicode_ci default NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
-- --------------------------------------------------------
--
-- Table structure for table `togaf9_CMO_goal`
--
CREATE TABLE IF NOT EXISTS `togaf9_CMO_goal` (
`id` int(11) NOT NULL,
`name` varchar(64) collate utf8_unicode_ci NOT NULL,
`description` varchar(255) collate utf8_unicode_ci default NULL,
`category` varchar(64) collate utf8_unicode_ci default NULL,
`source` varchar(255) collate utf8_unicode_ci default NULL,
`owner` varchar(255) collate utf8_unicode_ci default NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
-- --------------------------------------------------------
--
-- Table structure for table `togaf9_CMO_information_system_service`
--
CREATE TABLE IF NOT EXISTS `togaf9_CMO_information_system_service` (
`id` int(11) NOT NULL,
`name` varchar(64) collate utf8_unicode_ci NOT NULL,
`description` varchar(255) collate utf8_unicode_ci default NULL,
`category` varchar(64) collate utf8_unicode_ci default NULL,
`source` varchar(255) collate utf8_unicode_ci default NULL,
`owner` varchar(255) collate utf8_unicode_ci default NULL,
`standards_class` varchar(255) collate utf8_unicode_ci default NULL,
`standard_creation_date` date default NULL,
`last_standard_review_date` date default NULL,
`next_standard_review_date` date default NULL,
`retire_date` date default NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
-- --------------------------------------------------------
--
-- Table structure for table `togaf9_CMO_location`
--
CREATE TABLE IF NOT EXISTS `togaf9_CMO_location` (
`id` int(11) NOT NULL,
`name` varchar(64) collate utf8_unicode_ci NOT NULL,
`description` varchar(255) collate utf8_unicode_ci default NULL,
`category` varchar(64) collate utf8_unicode_ci default NULL,
`source` varchar(255) collate utf8_unicode_ci default NULL,
`owner` varchar(255) collate utf8_unicode_ci default NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
-- --------------------------------------------------------
--
-- Table structure for table `togaf9_CMO_logical_application_component`
--
CREATE TABLE IF NOT EXISTS `togaf9_CMO_logical_application_component` (
`id` int(11) NOT NULL,
`name` varchar(64) collate utf8_unicode_ci NOT NULL,
`description` varchar(255) collate utf8_unicode_ci default NULL,
`category` varchar(64) collate utf8_unicode_ci default NULL,
`source` varchar(255) collate utf8_unicode_ci default NULL,
`owner` varchar(255) collate utf8_unicode_ci default NULL,
`standards_class` varchar(255) collate utf8_unicode_ci default NULL,
`standard_creation_date` date default NULL,
`last_standard_review_date` date default NULL,
`next_standard_review_date` date default NULL,
`retire_date` date default NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
-- --------------------------------------------------------
--
-- Table structure for table `togaf9_CMO_logical_data_component`
--
CREATE TABLE IF NOT EXISTS `togaf9_CMO_logical_data_component` (
`id` int(11) NOT NULL,
`name` varchar(64) collate utf8_unicode_ci NOT NULL,
`description` varchar(255) collate utf8_unicode_ci default NULL,
`category` varchar(64) collate utf8_unicode_ci default NULL,
`source` varchar(255) collate utf8_unicode_ci default NULL,
`owner` varchar(255) collate utf8_unicode_ci default NULL,
`standards_class` varchar(255) collate utf8_unicode_ci default NULL,
`standard_creation_date` date default NULL,
`last_standard_review_date` date default NULL,
`next_standard_review_date` date default NULL,
`retire_date` date default NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
-- --------------------------------------------------------
--
-- Table structure for table `togaf9_CMO_logical_technology_component`
--
CREATE TABLE IF NOT EXISTS `togaf9_CMO_logical_technology_component` (
`id` int(11) NOT NULL,
`name` varchar(64) collate utf8_unicode_ci NOT NULL,
`description` varchar(255) collate utf8_unicode_ci default NULL,
`category` varchar(64) collate utf8_unicode_ci default NULL,
`source` varchar(255) collate utf8_unicode_ci default NULL,
`owner` varchar(255) collate utf8_unicode_ci default NULL,
`standards_class` varchar(255) collate utf8_unicode_ci default NULL,
`standard_creation_date` date default NULL,
`last_standard_review_date` date default NULL,
`next_standard_review_date` date default NULL,
`retire_date` date default NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
-- --------------------------------------------------------
--
-- Table structure for table `togaf9_CMO_measure`
--
CREATE TABLE IF NOT EXISTS `togaf9_CMO_measure` (
`id` int(11) NOT NULL,
`name` varchar(64) collate utf8_unicode_ci NOT NULL,
`description` varchar(255) collate utf8_unicode_ci default NULL,
`category` varchar(64) collate utf8_unicode_ci default NULL,
`source` varchar(255) collate utf8_unicode_ci default NULL,
`owner` varchar(255) collate utf8_unicode_ci default NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
-- --------------------------------------------------------
--
-- Table structure for table `togaf9_CMO_objective`
--
CREATE TABLE IF NOT EXISTS `togaf9_CMO_objective` (
`id` int(11) NOT NULL,
`name` varchar(64) collate utf8_unicode_ci NOT NULL,
`description` varchar(255) collate utf8_unicode_ci default NULL,
`category` varchar(64) collate utf8_unicode_ci default NULL,
`source` varchar(255) collate utf8_unicode_ci default NULL,
`owner` varchar(255) collate utf8_unicode_ci default NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
-- --------------------------------------------------------
--
-- Table structure for table `togaf9_CMO_organization_unit`
--
CREATE TABLE IF NOT EXISTS `togaf9_CMO_organization_unit` (
`id` int(11) NOT NULL,
`name` varchar(64) collate utf8_unicode_ci NOT NULL,
`description` varchar(255) collate utf8_unicode_ci default NULL,
`category` varchar(64) collate utf8_unicode_ci default NULL,
`source` varchar(255) collate utf8_unicode_ci default NULL,
`owner` varchar(255) collate utf8_unicode_ci default NULL,
`headcount` varchar(255) collate utf8_unicode_ci default NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
-- --------------------------------------------------------
--
-- Table structure for table `togaf9_CMO_physical_application_component`
--
CREATE TABLE IF NOT EXISTS `togaf9_CMO_physical_application_component` (
`id` int(11) NOT NULL,
`name` varchar(64) collate utf8_unicode_ci NOT NULL,
`description` varchar(255) collate utf8_unicode_ci default NULL,
`category` varchar(64) collate utf8_unicode_ci default NULL,
`source` varchar(255) collate utf8_unicode_ci default NULL,
`owner` varchar(255) collate utf8_unicode_ci default NULL,
`lifecycle_status` varchar(255) collate utf8_unicode_ci default NULL,
`standards_class` varchar(255) collate utf8_unicode_ci default NULL,
`standard_creation_date` date default NULL,
`last_standard_review_date` date default NULL,
`next_standard_review_date` date default NULL,
`retire_date` date default NULL,
`initial_live_date` date default NULL,
`date_of_last_release` varchar(255) collate utf8_unicode_ci default NULL,
`date_of_next_release` varchar(255) collate utf8_unicode_ci default NULL,
`retirement_date` date default NULL,
`availability_characteristics` varchar(255) collate utf8_unicode_ci default NULL,
`service_times` varchar(255) collate utf8_unicode_ci default NULL,
`manageability_characteristics` varchar(255) collate utf8_unicode_ci default NULL,
`serviceability_characteristics` varchar(255) collate utf8_unicode_ci default NULL,
`performance_characteristics` varchar(255) collate utf8_unicode_ci default NULL,
`reliability_characteristics` varchar(255) collate utf8_unicode_ci default NULL,
`recoverability_characteristics` varchar(255) collate utf8_unicode_ci default NULL,
`locatability_characteristics` varchar(255) collate utf8_unicode_ci default NULL,
`security_characteristics` varchar(255) collate utf8_unicode_ci default NULL,
`privacy_characteristics` varchar(255) collate utf8_unicode_ci default NULL,
`integrity_characteristics` varchar(255) collate utf8_unicode_ci default NULL,
`credibility_characteristics` varchar(255) collate utf8_unicode_ci default NULL,
`localization_characteristics` varchar(255) collate utf8_unicode_ci default NULL,
`internationalization_characteristics` varchar(255) collate utf8_unicode_ci default NULL,
`interoperability_characteristics` varchar(255) collate utf8_unicode_ci default NULL,
`scalability_characteristics` varchar(255) collate utf8_unicode_ci default NULL,
`portability_characteristics` varchar(255) collate utf8_unicode_ci default NULL,
`extensibility_characteristics` varchar(255) collate utf8_unicode_ci default NULL,
`capacity_characteristics` varchar(255) collate utf8_unicode_ci default NULL,
`throughput` varchar(255) collate utf8_unicode_ci default NULL,
`throughput_period` varchar(255) collate utf8_unicode_ci default NULL,
`growth` varchar(255) collate utf8_unicode_ci default NULL,
`growth_period` varchar(255) collate utf8_unicode_ci default NULL,
`peak_profile_short_term` varchar(255) collate utf8_unicode_ci default NULL,
`peak_profile_long_term` varchar(255) collate utf8_unicode_ci default NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
-- --------------------------------------------------------
--
-- Table structure for table `togaf9_CMO_physical_data_component`
--
CREATE TABLE IF NOT EXISTS `togaf9_CMO_physical_data_component` (
`id` int(11) NOT NULL,
`name` varchar(64) collate utf8_unicode_ci NOT NULL,
`description` varchar(255) collate utf8_unicode_ci default NULL,
`category` varchar(64) collate utf8_unicode_ci default NULL,
`source` varchar(255) collate utf8_unicode_ci default NULL,
`owner` varchar(255) collate utf8_unicode_ci default NULL,
`standards_class` varchar(255) collate utf8_unicode_ci default NULL,
`standard_creation_date` date default NULL,
`last_standard_review_date` date default NULL,
`next_standard_review_date` date default NULL,
`retire_date` date default NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
-- --------------------------------------------------------
--
-- Table structure for table `togaf9_CMO_physical_technology_component`
--
CREATE TABLE IF NOT EXISTS `togaf9_CMO_physical_technology_component` (
`id` int(11) NOT NULL,
`name` varchar(64) collate utf8_unicode_ci NOT NULL,
`description` varchar(255) collate utf8_unicode_ci default NULL,
`category` varchar(64) collate utf8_unicode_ci default NULL,
`source` varchar(255) collate utf8_unicode_ci default NULL,
`owner` varchar(255) collate utf8_unicode_ci default NULL,
`standards_class` varchar(255) collate utf8_unicode_ci default NULL,
`standard_creation_date` date default NULL,
`last_standard_review_date` date default NULL,
`next_standard_review_date` date default NULL,
`retire_date` date default NULL,
`product_name` varchar(255) collate utf8_unicode_ci default NULL,
`module_name` varchar(255) collate utf8_unicode_ci default NULL,
`vendor` varchar(255) collate utf8_unicode_ci default NULL,
`version` varchar(255) collate utf8_unicode_ci default NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
-- --------------------------------------------------------
--
-- Table structure for table `togaf9_CMO_platform_service`
--
CREATE TABLE IF NOT EXISTS `togaf9_CMO_platform_service` (
`id` int(11) NOT NULL,
`name` varchar(64) collate utf8_unicode_ci NOT NULL,
`description` varchar(255) collate utf8_unicode_ci default NULL,
`category` varchar(64) collate utf8_unicode_ci default NULL,
`source` varchar(255) collate utf8_unicode_ci default NULL,
`owner` varchar(255) collate utf8_unicode_ci default NULL,
`standards_class` varchar(255) collate utf8_unicode_ci default NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
-- --------------------------------------------------------
--
-- Table structure for table `togaf9_CMO_principle`
--
CREATE TABLE IF NOT EXISTS `togaf9_CMO_principle` (
`id` int(11) NOT NULL,
`name` varchar(64) collate utf8_unicode_ci NOT NULL,
`description` varchar(255) collate utf8_unicode_ci default NULL,
`category` varchar(64) collate utf8_unicode_ci default NULL,
`source` varchar(255) collate utf8_unicode_ci default NULL,
`owner` varchar(255) collate utf8_unicode_ci default NULL,
`priority` varchar(255) collate utf8_unicode_ci default NULL,
`statement_of_principle` varchar(255) collate utf8_unicode_ci default NULL,
`rationale` varchar(255) collate utf8_unicode_ci default NULL,
`implication` varchar(255) collate utf8_unicode_ci default NULL,
`metric` varchar(255) collate utf8_unicode_ci default NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
-- --------------------------------------------------------
--
-- Table structure for table `togaf9_CMO_process`
--
CREATE TABLE IF NOT EXISTS `togaf9_CMO_process` (
`id` int(11) NOT NULL,
`name` varchar(64) collate utf8_unicode_ci NOT NULL,
`description` varchar(255) collate utf8_unicode_ci default NULL,
`category` varchar(64) collate utf8_unicode_ci default NULL,
`source` varchar(255) collate utf8_unicode_ci default NULL,
`owner` varchar(255) collate utf8_unicode_ci default NULL,
`standards_class` varchar(255) collate utf8_unicode_ci default NULL,
`standard_creation_date` date default NULL,
`last_standard_review_date` date default NULL,
`next_standard_review_date` date default NULL,
`retire_date` date default NULL,
`process_criticality` varchar(255) collate utf8_unicode_ci default NULL,
`manual_or_automated` varchar(255) collate utf8_unicode_ci default NULL,
`process_volumetrics` varchar(255) collate utf8_unicode_ci default NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
-- --------------------------------------------------------
--
-- Table structure for table `togaf9_CMO_product`
--
CREATE TABLE IF NOT EXISTS `togaf9_CMO_product` (
`id` int(11) NOT NULL,
`name` varchar(64) collate utf8_unicode_ci NOT NULL,
`description` varchar(255) collate utf8_unicode_ci default NULL,
`category` varchar(64) collate utf8_unicode_ci default NULL,
`source` varchar(255) collate utf8_unicode_ci default NULL,
`owner` varchar(255) collate utf8_unicode_ci default NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
-- --------------------------------------------------------
--
-- Table structure for table `togaf9_CMO_requirement`
--
CREATE TABLE IF NOT EXISTS `togaf9_CMO_requirement` (
`id` int(11) NOT NULL,
`name` varchar(64) collate utf8_unicode_ci NOT NULL,
`description` varchar(255) collate utf8_unicode_ci default NULL,
`category` varchar(64) collate utf8_unicode_ci default NULL,
`source` varchar(255) collate utf8_unicode_ci default NULL,
`owner` varchar(255) collate utf8_unicode_ci default NULL,
`statement_of_requirement` varchar(255) collate utf8_unicode_ci default NULL,
`rationale` varchar(255) collate utf8_unicode_ci default NULL,
`acceptance_criteria` varchar(255) collate utf8_unicode_ci default NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
-- --------------------------------------------------------
--
-- Table structure for table `togaf9_CMO_role`
--
CREATE TABLE IF NOT EXISTS `togaf9_CMO_role` (
`id` int(11) NOT NULL,
`name` varchar(64) collate utf8_unicode_ci NOT NULL,
`description` varchar(255) collate utf8_unicode_ci default NULL,
`category` varchar(64) collate utf8_unicode_ci default NULL,
`source` varchar(255) collate utf8_unicode_ci default NULL,
`owner` varchar(255) collate utf8_unicode_ci default NULL,
`estimated_number_of_ftes_that_operate_in_this_role` varchar(255) collate utf8_unicode_ci default NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
-- --------------------------------------------------------
--
-- Table structure for table `togaf9_CMO_service`
--
CREATE TABLE IF NOT EXISTS `togaf9_CMO_service` (
`id` int(11) NOT NULL,
`name` varchar(64) collate utf8_unicode_ci NOT NULL,
`description` varchar(255) collate utf8_unicode_ci default NULL,
`category` varchar(64) collate utf8_unicode_ci default NULL,
`source` varchar(255) collate utf8_unicode_ci default NULL,
`owner` varchar(255) collate utf8_unicode_ci default NULL,
`standards_class` varchar(255) collate utf8_unicode_ci default NULL,
`standard_creation_date` date default NULL,
`last_standard_review_date` date default NULL,
`next_standard_review_date` date default NULL,
`retire_date` date default NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
-- --------------------------------------------------------
--
-- Table structure for table `togaf9_CMO_service_quality`
--
CREATE TABLE IF NOT EXISTS `togaf9_CMO_service_quality` (
`id` int(11) NOT NULL,
`name` varchar(64) collate utf8_unicode_ci NOT NULL,
`description` varchar(255) collate utf8_unicode_ci default NULL,
`category` varchar(64) collate utf8_unicode_ci default NULL,
`source` varchar(255) collate utf8_unicode_ci default NULL,
`owner` varchar(255) collate utf8_unicode_ci default NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
-- --------------------------------------------------------
--
-- Table structure for table `togaf9_CMO_technology_component`
--
CREATE TABLE IF NOT EXISTS `togaf9_CMO_technology_component` (
`id` int(11) NOT NULL,
`name` varchar(64) collate utf8_unicode_ci NOT NULL,
`description` varchar(255) collate utf8_unicode_ci default NULL,
`category` varchar(64) collate utf8_unicode_ci default NULL,
`source` varchar(255) collate utf8_unicode_ci default NULL,
`owner` varchar(255) collate utf8_unicode_ci default NULL,
`standards_class` varchar(255) collate utf8_unicode_ci default NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
-- --------------------------------------------------------
--
-- Table structure for table `togaf9_CMO_work_package`
--
CREATE TABLE IF NOT EXISTS `togaf9_CMO_work_package` (
`id` int(11) NOT NULL,
`name` varchar(64) collate utf8_unicode_ci NOT NULL,
`description` varchar(255) collate utf8_unicode_ci default NULL,
`category` varchar(64) collate utf8_unicode_ci default NULL,
`source` varchar(255) collate utf8_unicode_ci default NULL,
`owner` varchar(255) collate utf8_unicode_ci default NULL,
`capability_delivered` varchar(255) collate utf8_unicode_ci default NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;