------------------------------------------------------------------------- The Mantis Data Model specified in ERD Notation ------------------------------------------------------------------------- - ec E_Mantis_bug_file_table | - eca,pk A_id D_Number - eca,k1 A_bug_id E_Mantis_bug_table - eca A_title D_str_250 - eca A_description D_str_250 - eca A_diskfile D_str_250 - eca A_filename D_str_250 - eca A_folder D_str_250 - eca A_filesize D_Number - eca A_file_type D_str_250 - eca A_date_added D_Timestamp - eca A_content D_BLOB - ec E_Mantis_bug_history_table | - eca,pk A_id D_Number - eca A_user_id E_Mantis_user_table - eca,k2 A_bug_id E_Mantis_bug_table - eca A_date_modified D_Timestamp - eca A_field_name D_str_32 - eca A_old_value D_str_128 - eca A_new_value D_str_128 - eca A_type D_Number - ec E_Mantis_bug_monitor_table | - eca,pk A_user_id E_Mantis_user_table - eca,pk A_bug_id E_Mantis_bug_table - ec E_Mantis_bug_relationship_table | - eca,pk A_id D_Number - eca,k3 A_source_bug_id E_Mantis_bug_table - eca A_destination_bug_id E_Mantis_bug_table - eca A_relationship_type D_Number - ec E_Mantis_bug_table | - eca,pk A_id D_Number - eca A_project_id D_Number - eca A_reporter_id E_Mantis_user_table - eca A_handler_id E_Mantis_user_table - eca A_duplicate_id E_Mantis_bug_table - eca A_priority D_Number - eca A_severity D_Number - eca A_reproducibility D_Number - eca A_status D_Number - eca A_resolution D_Number - eca A_projection D_Number - eca A_category D_str_64 - eca A_date_submitted D_Timestamp - eca A_last_updated D_Timestamp - eca A_eta D_Number - eca A_bug_text_id D_Number - eca A_os D_str_32 - eca A_os_build D_str_32 - eca A_platform D_str_32 - eca A_version D_str_64 - eca A_fixed_in_version D_str_64 - eca A_build D_str_32 - eca A_profile_id D_Number - eca A_view_state D_Number - eca A_summary D_str_128 - eca,k4 A_sponsorship_total D_Number - eca A_sticky D_Number - ec E_Mantis_bug_text_table | - eca,pk A_id D_Number - eca A_description D_str_4000 - eca A_steps_to_reproduce D_str_4000 - eca A_additional_information D_str_4000 - ec E_Mantis_bugnote_table | - eca,pk A_id D_Number - eca,k5 A_bug_id E_Mantis_bug_table - eca A_reporter_id E_Mantis_user_table - eca A_bugnote_text_id D_Number - eca A_view_state D_Number - eca A_date_submitted D_Timestamp - eca A_last_modified D_Timestamp - eca A_note_type D_Number - eca A_note_attr D_str_250 - ec E_Mantis_bugnote_text_table | - eca,pk A_id D_Number - eca A_note D_str_4000 - ec E_Mantis_config_table | - eca,pk,k6 A_config_id D_str_64 - eca,pk A_project_id D_Number - eca,pk A_user_id E_Mantis_user_table - eca A_access_reqd D_Number - eca A_type D_Number - eca A_value D_str_4000 - ec E_Mantis_custom_field_project_table | - eca,pk A_field_id D_Number - eca,pk A_project_id D_Number - eca A_sequence D_Number - ec E_Mantis_custom_field_string_table | - eca,pk A_field_id D_Number - eca,pk,k7 A_bug_id E_Mantis_bug_table - eca A_value D_str_255 - ec E_Mantis_custom_field_table | - eca,pk A_id D_Number - eca,k8 A_name D_str_64 - eca A_type D_Number - eca A_possible_values D_str_255 - eca A_default_value D_str_255 - eca A_valid_regexp D_str_255 - eca A_access_level_r D_Number - eca A_access_level_rw D_Number - eca A_length_min D_Number - eca A_length_max D_Number - eca A_advanced D_Number - eca A_require_report D_Number - eca A_require_update D_Number - eca A_display_report D_Number - eca A_display_update D_Number - eca A_require_resolved D_Number - eca A_display_resolved D_Number - eca A_display_closed D_Number - eca A_require_closed D_Number - ec E_Mantis_filters_table | - eca,pk A_id D_Number - eca A_user_id E_Mantis_user_table - eca A_project_id D_Number - eca A_is_public D_Number - eca A_name D_str_64 - eca A_filter_string D_str_4000 - ec E_Mantis_news_table | - eca,pk A_id D_Number - eca A_project_id D_Number - eca A_poster_id D_Number - eca A_date_posted D_Timestamp - eca A_last_modified D_Timestamp - eca A_view_state D_Number - eca A_announcement D_Number - eca A_headline D_str_64 - eca A_body D_str_4000 - ec E_Mantis_project_category_table | - eca,pk A_project_id D_Number - eca,pk A_category D_str_64 - eca A_user_id E_Mantis_user_table - ec E_Mantis_project_file_table | - eca,pk A_id D_Number - eca A_project_id D_Number - eca A_title D_str_250 - eca A_description D_str_250 - eca A_diskfile D_str_250 - eca A_filename D_str_250 - eca A_folder D_str_250 - eca A_filesize D_Number - eca A_file_type D_str_250 - eca A_date_added D_Timestamp - eca A_content D_BLOB - ec E_Mantis_project_hierarchy_table | - eca,pk A_child_id D_Number - eca A_parent_id D_Number - ec E_Mantis_project_table | - eca,pk A_id D_Number - eca,k9 A_name D_str_128 - eca A_status D_Number - eca A_enabled D_Number - eca A_view_state D_Number - eca A_access_min D_Number - eca A_file_path D_str_250 - eca A_description D_str_4000 - ec E_Mantis_project_user_list_table | - eca,pk A_project_id D_Number - eca,pk,k10 A_user_id E_Mantis_user_table - eca A_access_level D_Number - ec E_Mantis_project_version_table | - eca,pk A_id D_Number - eca,k11 A_project_id D_Number - eca,k11 A_version D_str_64 - eca A_date_order D_Timestamp - eca A_description D_str_4000 - eca A_released D_Number - ec E_Mantis_sponsorship_table | - eca,pk A_id D_Number - eca,k12 A_bug_id E_Mantis_bug_table - eca A_user_id E_Mantis_user_table - eca A_amount D_Number - eca A_logo D_str_128 - eca A_url D_str_128 - eca A_paid D_Number - eca A_date_submitted D_Timestamp - eca A_last_updated D_Timestamp - ec E_Mantis_tokens_table | - eca,pk A_id D_Number - eca A_owner D_Number - eca A_type D_Number - eca A_timestamp D_Timestamp - eca A_expiry D_Timestamp - eca A_value D_str_4000 - ec E_Mantis_user_pref_table | - eca,pk A_id D_Number - eca A_user_id E_Mantis_user_table - eca A_project_id D_Number - eca A_default_profile D_Number - eca A_default_project D_Number - eca A_advanced_report D_Number - eca A_advanced_view D_Number - eca A_advanced_update D_Number - eca A_refresh_delay D_Number - eca A_redirect_delay D_Number - eca A_bugnote_order D_str_4 - eca A_email_on_new D_Number - eca A_email_on_assigned D_Number - eca A_email_on_feedback D_Number - eca A_email_on_resolved D_Number - eca A_email_on_closed D_Number - eca A_email_on_reopened D_Number - eca A_email_on_bugnote D_Number - eca A_email_on_status D_Number - eca A_email_on_priority D_Number - eca A_email_on_priority_min_severity D_Number - eca A_email_on_status_min_severity D_Number - eca A_email_on_bugnote_min_severity D_Number - eca A_email_on_reopened_min_severity D_Number - eca A_email_on_closed_min_severity D_Number - eca A_email_on_resolved_min_severity D_Number - eca A_email_on_feedback_min_severity D_Number - eca A_email_on_assigned_min_severity D_Number - eca A_email_on_new_min_severity D_Number - eca A_email_bugnote_limit D_Number - eca A_language D_str_32 - ec E_Mantis_user_print_pref_table | - eca,pk A_user_id E_Mantis_user_table - eca A_print_pref D_str_27 - ec E_Mantis_user_profile_table | - eca,pk A_id D_Number - eca A_user_id E_Mantis_user_table - eca A_platform D_str_32 - eca A_os D_str_32 - eca A_os_build D_str_32 - eca A_description D_str_4000 - ec E_Mantis_user_table | - eca,pk A_id D_Number - eca A_username D_str_32 - eca A_realname D_str_64 - eca A_email D_str_64 - eca A_password D_str_32 - eca A_date_created D_Timestamp - eca A_last_visit D_Timestamp - eca A_enabled D_Number - eca A_protected D_Number - eca A_access_level D_Number - eca A_login_count D_Number - eca A_lost_password_request_count D_Number - eca A_failed_login_count D_Number - eca,k13 A_cookie_string D_str_64 Domain specifications: -------------------------------------------------------------------------- - d D_Number INTEGER - d D_BLOB BLOB - d D_Timestamp TIMESTAMP - d D_str_4 VARCHAR( 4 ) - d D_str_27 VARCHAR( 27 ) - d D_str_32 VARCHAR( 32 ) - d D_str_64 VARCHAR( 64 ) - d D_str_128 VARCHAR( 128 ) - d D_str_250 VARCHAR( 250 ) - d D_str_255 VARCHAR( 255 ) - d D_str_4000 VARCHAR( 4000 ) end of spec --------------------------------------------------------------------------