Mike Moxcey 2002
 

All Designer Tables

Not really.  This is just all the tables that begin with CI_.  There is supposed to be a data model someplace in Designer, but I think that would be too confusing for me.

SQL>  select tname from tab where tname like 'CI%';

TNAME
------------------------------
CI_ACTION_ITEMS
CI_ACTIVITY_DECOMPS
CI_ACTIVITY_DEFINITIONS
CI_ACTIVITY_OBJECTIVES
CI_ACTIVITY_USAGES
CI_ACTORS
CI_ACTOR_GENERALIZATIONS
CI_ACTOR_IN_ORGANIZATIONS
CI_ACTOR_USAGES
CI_APPLICATION_MODULES
CI_APPLICATION_MODULE_USAGES
CI_APPLICATION_SYSTEMS
CI_APP_SYS_ACTIVITIES
CI_APP_SYS_ACTORS
CI_APP_SYS_ASSOCIATIONS
CI_APP_SYS_ASSUMPTIONS
CI_APP_SYS_BATCHES
CI_APP_SYS_BUSINESS_OBJECTS
CI_APP_SYS_BUSINESS_UNITS
CI_APP_SYS_CLASSIFIERS
CI_APP_SYS_CLUSTERS
CI_APP_SYS_COMMUNITIES
CI_APP_SYS_CONTAINER_ELEMENTS
CI_APP_SYS_CSFS
CI_APP_SYS_DATABASES
CI_APP_SYS_DATASTORES
CI_APP_SYS_DATA_ITEMS
CI_APP_SYS_DIAGRAMS
CI_APP_SYS_DOCUMENTS
CI_APP_SYS_DOMAINS
CI_APP_SYS_ENTITIES
CI_APP_SYS_EVENTS
CI_APP_SYS_EXTERNALS
CI_APP_SYS_FUNCTIONS
CI_APP_SYS_KPIS
CI_APP_SYS_LANGUAGES
CI_APP_SYS_LOCATIONS
CI_APP_SYS_MODULES
CI_APP_SYS_MODULE_UNITS
CI_APP_SYS_NAMED_RULES
CI_APP_SYS_NODES
CI_APP_SYS_OBJECTIVES
CI_APP_SYS_ORACLE_TYPES
CI_APP_SYS_ORG_UNITS
CI_APP_SYS_OS_FILES
CI_APP_SYS_PAC_FILES
CI_APP_SYS_PEOPLE
CI_APP_SYS_PREFERENCE_SETS
CI_APP_SYS_PROBLEMS
CI_APP_SYS_PSEUDOSTATES
CI_APP_SYS_SEQUENCES
CI_APP_SYS_STORAGE_DEFINITIONS
CI_APP_SYS_SYNONYMS
CI_APP_SYS_TABLES
CI_APP_SYS_TERMS
CI_APP_SYS_TRANS_MAPPING_SETS
CI_APP_SYS_UML_RULES
CI_APP_SYS_USER_DEFINED_SETS
CI_APP_SYS_USE_CASES
CI_APP_SYS_VIEW_LINKS
CI_ARC_RULES
CI_ARGUMENT_ITEM_USAGES
CI_ARGUMENT_PASSED_VALUES
CI_ASSOCIATIONS
CI_ASSOCIATION_ENDS
CI_ASSOCIATION_END_USAGES
CI_ASSOC_DERIVATION_COMPONENTS
CI_ASSUMPTIONS
CI_ASSUMPTION_TO_TABLES
CI_ATTRIBUTES
CI_ATTRIBUTE_DERIVATION_RULES
CI_ATTRIBUTE_DOMAINS
CI_ATTRIBUTE_QUALIFIERS
CI_ATTRIBUTE_VALUES
CI_AUDIT
CI_BASE_RELATION_LOCATIONS
CI_BATCHES
CI_BATCHLINES
CI_BATCHLINE_RUNS
CI_BATCH_RUNS
CI_BC4J_EVENT_ATT_MAPPINGS
CI_BUSINESS_OBJECTS
CI_BUSINESS_OBJECT_INTERFACES
CI_BUSINESS_OBJECT_USAGES
CI_BUSINESS_UNITS
CI_BUSINESS_UNIT_TO_OBJECTIVES
CI_BUSINESS_UNIT_TO_PROBLEMS
CI_BUSINESS_UNIT_USE_OF_NODES
CI_CAPTURE_OBJECTS
CI_CHANGE_HISTORY
CI_CHECK_CONSTRAINTS
CI_CLASSIFIERS
CI_CLASSIFIER_ATTRIBUTES
CI_CLASSIFIER_GENERALIZATIONS
CI_CLASSIFIER_RULES
CI_CLASSIFIER_SPEC_GROUPS
CI_CLUSTERS
CI_CLUSTER_COLUMNS
CI_CLUSTER_IMPLEMENTATIONS
CI_CLUSTER_INDEXES
CI_CODING_STANDARDS
CI_COLUMNS
CI_COLUMN_QUALIFIED_ATTRIBUTES
CI_COLUMN_STORAGES
CI_COMMUNITIES
CI_COMMUNITY_DATABASES
CI_COMMUNITY_MEMBERS
CI_CONSTRAINTS
CI_CONSTRAINT_USAGES
CI_CONTAINER_DEFINITIONS
CI_CONTAINER_ELEMENTS
CI_CONTEXT_MAPPINGS
CI_CRITICAL_SUCCESS_FACTORS
CI_CROSS_OBJECT_RULES
CI_CROSS_OBJ_RULE_IMPLEMENTS
CI_CUSTOM_ACTION_ITEMS
CI_CUSTOM_LINKS
CI_DATABASES
CI_DATABASE_FILES
CI_DATABASE_OBJECT_GRANTS
CI_DATABASE_PROFILES
CI_DATABASE_SYNONYMS
CI_DATABASE_TRIGGERS
CI_DATABASE_USERS
CI_DATABASE_USER_ROLES
CI_DATAFILES
CI_DATAFLOWS
CI_DATAFLOW_ATTRIBUTE_USAGES
CI_DATAFLOW_DATA_ITEM_USAGES
CI_DATASTORES
CI_DATASTORE_ATTRIBUTE_USAGES
CI_DATASTORE_DATA_ITEM_USAGES
CI_DATASTRUCTURES
CI_DATASTRUCTURE_ITEMS
CI_DATATYPE_MAPPINGS
CI_DATA_BOUND_ITEMS
CI_DATA_COMPONENTS
CI_DATA_ITEMS
CI_DBU_GRP_NAMESPACE
CI_DB_OBJECT_IMPLEMENTATIONS
CI_DIAGRAMS
CI_DIAGRAM_ELEMENT_USAGES
CI_DIAGRAM_SEGMENTS
CI_DIRECTORIES
CI_DISTRIBUTED_PROCESSINGS
CI_DOCUMENTS
CI_DOCUMENT_ATTACHMENTS
CI_DOMAINS
CI_DOMAIN_CONSTRAINTS
CI_ELEMENT_RULE_USAGES
CI_ELEMENT_TYPES
CI_EMPLOYMENTS
CI_ENTITIES
CI_ENTITY_BUSINESS_UNITS
CI_ENTITY_NAMESPACE_OBJECTS
CI_ENTITY_OBJECTS
CI_ENTITY_OBJECT_ATTRIBUTES
CI_ENTITY_OBJECT_USAGES
CI_ENT_OBJECT_ATT_NAMESPACE
CI_EVENTS
CI_EVENT_ACTIONS
CI_EVENT_CLASSIFIERS
CI_EVENT_HANDLERS
CI_EVENT_PUBLICATIONS
CI_EVENT_RAISERS
CI_EVENT_SUBSCRIPTIONS
CI_EVENT_TRIGGERS
CI_EXTENDED_ELEMENTS
CI_EXTENDED_STRUCTURE_ELEMENTS
CI_EXTENSION_POINTS
CI_EXTERNALS
CI_FILE_SECTIONS
CI_FILE_USAGES
CI_FOLDERS
CI_FOLDER_MEMBERS
CI_FOREIGN_KEY_CONSTRAINTS
CI_FRAGMENT_USAGES
CI_FUNCTIONS
CI_FUNCTION_ATTRIBUTE_USAGES
CI_FUNCTION_BUSINESS_UNITS
CI_FUNCTION_ENTITY_USAGES
CI_GENERAL_ACTIONS
CI_GENERAL_ATTRIBUTES
CI_GENERAL_MODULES
CI_GENERATOR_ACTION_ITEMS
CI_GENERIC_CLASSES
CI_GLOBAL_INDEX_PARTITIONS
CI_IMPLICIT_INDEX_STORAGES
CI_INCLUSION_ACTIONS
CI_INDEXES
CI_INDEX_ENTRIES
CI_INDEX_PARTITIONS
CI_INDEX_STORAGES
CI_INSTALLATIONS
CI_INTEGRITY_RULES
CI_INTERFACE_CLASSIFIERS
CI_INTERFACE_USAGES
CI_ITEMS
CI_ITEM_GROUPS
CI_ITEM_TYPE_ATTRIBUTES
CI_JAVA_MODULES
CI_JAVA_MOD_IMPLEMENTATIONS
CI_JOIN_COMPONENTS
CI_JOIN_CONSTRAINTS
CI_KEY_BASED_LINKS
CI_KEY_COMPONENTS
CI_KEY_PERFORMANCE_CONTROLS
CI_KEY_PERFORMANCE_INDICATORS
CI_LANGUAGES
CI_LISTS_OF_VALUES
CI_LOB_COLUMN_STORAGES
CI_LOB_STORAGES
CI_LOCAL_INDEX_PARTITIONS
CI_LOCATIONS
CI_LOGFILES
CI_LOV_INCLUSIONS
CI_MAPPING_ELEMENTS
CI_MEMBER_COMPONENTS
CI_MESSAGE_TYPE_ATTRIBUTES
CI_METHODS
CI_METHOD_PARAMETERS
CI_METHOD_RULE_USAGES
CI_MODULES
CI_MODULE_ARGUMENTS
CI_MODULE_ASSUMPTIONS
CI_MODULE_BUSINESS_UNITS
CI_MODULE_COMPONENTS
CI_MODULE_COMPONENT_INCLUSIONS
CI_MODULE_COMPONENT_LINKS
CI_MODULE_DETAIL_TABLE_USAGES
CI_MODULE_FUNCTIONS
CI_MODULE_NETWORKS
CI_MODULE_PROGRAM_DATA
CI_MODULE_UNITS
CI_NAMED_DATABASE_OBJECTS
CI_NAMED_DATABASE_SACS
CI_NAMED_PASSED_VALUES
CI_NAMED_RULES
CI_NAVIGATION_ACTION_ITEMS
CI_NESTED_TABLE_STORAGES
CI_NETWORK_CONNECTIONS
CI_NODES
CI_NON_ORACLE_DATABASES
CI_NON_PERSISTENT_QUEUES
CI_OBJECTIVES
CI_OBJECTIVE_OF_BUS_FUNCTION
CI_OBJECTIVE_TO_CSFS
CI_OBJECTIVE_TO_KPIS
CI_OBJECT_STATES
CI_ORACLE_COLLECTION_TYPES
CI_ORACLE_DATABASES
CI_ORACLE_OBJECT_TYPES
CI_ORACLE_TYPES
CI_ORACLE_USER_MODULE_ACCESSES
CI_ORGANIZATION_UNITS
CI_OS_FILES
CI_PACKAGES
CI_PARAMETERS
CI_PARTITION_KEY_ENTRIES
CI_PASSED_VALUES
CI_PEOPLE
CI_PEOPLE_IN_ROLES
CI_PERSISTENT_QUEUES
CI_PERSON_MANAGEMENTS
CI_PLANNING_ITEMS
CI_PLSQL_MODULES
CI_PLSQL_MOD_IMPLEMENTATIONS
CI_PREFERENCE_SETS
CI_PREFERENCE_SET_USAGES
CI_PRIMARY_ACCESS_FILES
CI_PRIMARY_KEY_CONSTRAINTS
CI_PROBLEMS
CI_PROBLEM_TO_MODULES
CI_PROGRAM_DATA
CI_PROJECTS
CI_PROJECT_STANDARDS
CI_PSEUDOSTATES
CI_PUBLIC_DATABASE_LINKS
CI_QUEUES
CI_QUEUE_IMPLEMENTATIONS
CI_QUEUE_NP_IMPLEMENTATIONS
CI_QUEUE_P_IMPLEMENTATIONS
CI_QUEUE_SUBSCRIBERS
CI_QUEUE_TABLE_DEFINITIONS
CI_QUEUE_TABLE_IMPLEMENTATIONS
CI_RECORDS
CI_RECORD_FILES
CI_REFERENCE_RANGES_SEQ
CI_RELATIONSHIP_ENDS
CI_RELATION_DEFINITIONS
CI_RELATION_INDEXES
CI_RELATION_SELECTIONS
CI_REPGROUP_PROPAGATIONS
CI_REPLICATION_GROUPS
CI_REPORTS
CI_REUSABLE_LOVS
CI_REUSABLE_MCOS
CI_ROLES
CI_ROLE_GRANT
CI_ROLE_MODULE_ACCESSES
CI_ROLE_QUALIFICATIONS
CI_ROLE_SPECIFICATIONS
CI_ROLLBACK_SEGMENTS
CI_ROOT_APPLICATION_SYSTEMS
CI_ROOT_CONTAINER_ELEMENTS
CI_ROOT_FOLDERS
CI_ROOT_PACKAGES
CI_ROOT_PROJECTS
CI_RPT_GROUPS
CI_SEQUENCES
CI_SEQUENCE_IMPLEMENTATIONS
CI_SERVER_OBJECT_USAGES
CI_SET_MEMBER_ITEMS
CI_SNAPSHOT_DEFINITIONS
CI_SNAPSHOT_IMPLEMENTATIONS
CI_SNAPSHOT_REFRESH_GROUPS
CI_SOURCE_FILES
CI_SPECIFIC_LOVS
CI_SPECIFIC_MCOS
CI_SQL_QUERY_SETS
CI_STATE_DEPENDENCIES
CI_STATE_RULES
CI_STEREOTYPES
CI_STEREOTYPE_GENERALIZATIONS
CI_STORAGE_DEFINITIONS
CI_SUBCOMPONENTS
CI_SUBSCRIPTION_ACTIVATIONS
CI_SUBSCRIPTION_DETAILS
CI_SYNONYMS
CI_SYSTEM_OBJECTIVE_OF_MODULES
CI_SYSTEM_PRIVILEGES
CI_TABLESPACES
CI_TABLESPACE_QUOTAS
CI_TABLES_ENTITIES
CI_TABLE_DEFINITIONS
CI_TABLE_IMPLEMENTATIONS
CI_TABLE_PARTITIONS
CI_TAGGED_VALUES
CI_TAGS
CI_TARGET_CLIENT_PROJECTS
CI_TERMS
CI_TRANSFERABLE_ELEMENT_TYPES
CI_TRANSFORMATION_MAPPING_SETS
CI_TRANSFORMER_STANDARDS
CI_TRANSITIONS
CI_TRIGGER_COLUMN_USAGES
CI_UML_DEPENDENCIES
CI_UML_DEPENDENCY_CLIENTS
CI_UML_DEPENDENCY_SUPPLIERS
CI_UML_RULES
CI_UNBOUND_ITEMS
CI_UNIQUENESS_RULES
CI_UNIQUE_IDENTIFIERS
CI_UNIQUE_IDENTIFIER_ENTRIES
CI_UNIQUE_KEY_CONSTRAINTS
CI_USER_DEFINED_SETS
CI_USER_OBJECT_INDEX_STORAGES
CI_USER_PREFERENCES
CI_USE_CASES
CI_USE_CASE_ACTIONS
CI_USE_CASE_ACTOR_USAGES
CI_USE_CASE_EVENT_INPUTS
CI_USE_CASE_EVENT_OUTPUTS
CI_USE_CASE_EXTENSIONS
CI_USE_CASE_GENERALIZATIONS
CI_USE_CASE_OBJECTIVES
CI_VALIDATION_VALUES
CI_VALIDATORS
CI_VIEW_DEFINITIONS
CI_VIEW_IMPLEMENTATIONS
CI_VIEW_LINKS
CI_VIEW_LINK_COMPONENTS
CI_VIEW_LINK_ENDS
CI_VIEW_LINK_END_USAGES
CI_VIEW_LINK_USAGES
CI_VIEW_OBJECTS
CI_VIEW_OBJECT_ATTRIBUTES
CI_VIEW_USAGES
CI_VIOLATIONS
CI_WEIGHTING_FACTORS
CI_WINDOWS
CI_WORKFLOW_ATTRIBUTES
CI_WORKFLOW_ITEM_TYPES
CI_WORKFLOW_MESSAGE_TYPES
CI_XMD_GENERAL_MODULES_SQS
 

There is also a CDI_Text table that holds info (and there are probably other CDI tables, too).
 


home