show Logical Data Model

ALL Tables



DROP TABLE Mantis_bug_text_table ;
   
CREATE TABLE    Mantis_bug_text_table .. ERD
   (                
                  ID_                  INTEGER        NOT NULL
   ,              description          VARCHAR(4000) 
   ,              steps_to_reproduce   VARCHAR(4000) 
   ,              additional_information VARCHAR(4000) 
   ,

   CONSTRAINT     pk_Mantis_bug_text_table
   PRIMARY KEY    (
                  ID_
                  )
   )
   ;


DROP TABLE Mantis_bugnote_text_table ;
   
CREATE TABLE    Mantis_bugnote_text_table .. ERD
   (                
                  ID_                  INTEGER        NOT NULL
   ,              note                 VARCHAR(4000) 
   ,

   CONSTRAINT     pk_Mantis_bugnote_text_table
   PRIMARY KEY    (
                  ID_
                  )
   )
   ;


DROP TABLE Mantis_custom_field_project_table ;
   
CREATE TABLE    Mantis_custom_field_project_table .. ERD
   (                
                  field_id             INTEGER        NOT NULL
   ,              project_id           INTEGER        NOT NULL
   ,              sequence             INTEGER       
   ,

   CONSTRAINT     pk_Mantis_custom_field_project_table
   PRIMARY KEY    (
                  field_id
   ,              project_id
                  )
   )
   ;


DROP TABLE Mantis_custom_field_table ;
   
CREATE TABLE    Mantis_custom_field_table .. ERD
   (                
                  ID_                  INTEGER        NOT NULL
   ,              name                 VARCHAR(64)    NOT NULL
   ,              Type_                INTEGER       
   ,              possible_values      VARCHAR(255)  
   ,              default_value        VARCHAR(255)  
   ,              valid_regexp         VARCHAR(255)  
   ,              access_level_r       INTEGER       
   ,              access_level_rw      INTEGER       
   ,              length_min           INTEGER       
   ,              length_max           INTEGER       
   ,              advanced             INTEGER       
   ,              require_report       INTEGER       
   ,              require_update       INTEGER       
   ,              display_report       INTEGER       
   ,              display_update       INTEGER       
   ,              require_resolved     INTEGER       
   ,              display_resolved     INTEGER       
   ,              display_closed       INTEGER       
   ,              require_closed       INTEGER       
   ,

   CONSTRAINT     pk_Mantis_custom_field_table
   PRIMARY KEY    (
                  ID_
                  )
   )
   ;


DROP TABLE Mantis_news_table ;
   
CREATE TABLE    Mantis_news_table .. ERD
   (                
                  ID_                  INTEGER        NOT NULL
   ,              project_id           INTEGER       
   ,              poster_id            INTEGER       
   ,              date_posted          TIMESTAMP     
   ,              last_modified        TIMESTAMP     
   ,              view_state           INTEGER       
   ,              announcement         INTEGER       
   ,              headline             VARCHAR(64)   
   ,              body                 VARCHAR(4000) 
   ,

   CONSTRAINT     pk_Mantis_news_table
   PRIMARY KEY    (
                  ID_
                  )
   )
   ;


DROP TABLE Mantis_project_file_table ;
   
CREATE TABLE    Mantis_project_file_table .. ERD
   (                
                  ID_                  INTEGER        NOT NULL
   ,              project_id           INTEGER       
   ,              title                VARCHAR(250)  
   ,              description          VARCHAR(250)  
   ,              diskfile             VARCHAR(250)  
   ,              filename             VARCHAR(250)  
   ,              folder               VARCHAR(250)  
   ,              filesize             INTEGER       
   ,              file_type            VARCHAR(250)  
   ,              date_added           TIMESTAMP     
   ,              content              BLOB          
   ,

   CONSTRAINT     pk_Mantis_project_file_table
   PRIMARY KEY    (
                  ID_
                  )
   )
   ;


DROP TABLE Mantis_project_hierarchy_table ;
   
CREATE TABLE    Mantis_project_hierarchy_table .. ERD
   (                
                  child_id             INTEGER        NOT NULL
   ,              parent_id            INTEGER       
   ,

   CONSTRAINT     pk_Mantis_project_hierarchy_table
   PRIMARY KEY    (
                  child_id
                  )
   )
   ;


DROP TABLE Mantis_project_table ;
   
CREATE TABLE    Mantis_project_table .. ERD
   (                
                  ID_                  INTEGER        NOT NULL
   ,              name                 VARCHAR(128)   NOT NULL
   ,              status               INTEGER       
   ,              enabled              INTEGER       
   ,              view_state           INTEGER       
   ,              access_min           INTEGER       
   ,              file_path            VARCHAR(250)  
   ,              description          VARCHAR(4000) 
   ,

   CONSTRAINT     pk_Mantis_project_table
   PRIMARY KEY    (
                  ID_
                  )
   )
   ;


DROP TABLE Mantis_project_version_table ;
   
CREATE TABLE    Mantis_project_version_table .. ERD
   (                
                  ID_                  INTEGER        NOT NULL
   ,              project_id           INTEGER        NOT NULL
   ,              version              VARCHAR(64)    NOT NULL
   ,              date_order           TIMESTAMP     
   ,              description          VARCHAR(4000) 
   ,              released             INTEGER       
   ,

   CONSTRAINT     pk_Mantis_project_version_table
   PRIMARY KEY    (
                  ID_
                  )
   ,

   UNIQUE         (
                  ID_
   ,              project_id
   ,              version
   ,              date_order
   ,              description
   ,              released
                  )
                  CONSTRAINT  k11_Mantis_project_version_table
   )
   ;


DROP TABLE Mantis_tokens_table ;
   
CREATE TABLE    Mantis_tokens_table .. ERD
   (                
                  ID_                  INTEGER        NOT NULL
   ,              owner                INTEGER       
   ,              Type_                INTEGER       
   ,              timestamp            TIMESTAMP     
   ,              expiry               TIMESTAMP     
   ,              value                VARCHAR(4000) 
   ,

   CONSTRAINT     pk_Mantis_tokens_table
   PRIMARY KEY    (
                  ID_
                  )
   )
   ;


DROP TABLE Mantis_user_table ;
   
CREATE TABLE    Mantis_user_table .. ERD
   (                
                  ID_                  INTEGER        NOT NULL
   ,              username             VARCHAR(32)   
   ,              realname             VARCHAR(64)   
   ,              email                VARCHAR(64)   
   ,              Password_            VARCHAR(32)   
   ,              date_created         TIMESTAMP     
   ,              last_visit           TIMESTAMP     
   ,              enabled              INTEGER       
   ,              protected            INTEGER       
   ,              access_level         INTEGER       
   ,              login_count          INTEGER       
   ,              lost_password_request_count INTEGER       
   ,              failed_login_count   INTEGER       
   ,              cookie_string        VARCHAR(64)    NOT NULL
   ,

   CONSTRAINT     pk_Mantis_user_table
   PRIMARY KEY    (
                  ID_
                  )
   )
   ;


DROP TABLE Mantis_bug_table ;
   
CREATE TABLE    Mantis_bug_table .. ERD
   (                
                  ID_                  INTEGER        NOT NULL
   ,              project_id           INTEGER       
   ,              reporter_id          INTEGER       
   ,              handler_id           INTEGER       
   ,              duplicate_id         INTEGER       
   ,              priority             INTEGER       
   ,              severity             INTEGER       
   ,              reproducibility      INTEGER       
   ,              status               INTEGER       
   ,              resolution           INTEGER       
   ,              projection           INTEGER       
   ,              category             VARCHAR(64)   
   ,              date_submitted       TIMESTAMP     
   ,              last_updated         TIMESTAMP     
   ,              eta                  INTEGER       
   ,              bug_text_id          INTEGER       
   ,              os                   VARCHAR(32)   
   ,              os_build             VARCHAR(32)   
   ,              platform             VARCHAR(32)   
   ,              version              VARCHAR(64)   
   ,              fixed_in_version     VARCHAR(64)   
   ,              build                VARCHAR(32)   
   ,              profile_id           INTEGER       
   ,              view_state           INTEGER       
   ,              summary              VARCHAR(128)  
   ,              sponsorship_total    INTEGER        NOT NULL
   ,              sticky               INTEGER       
   ,

   CONSTRAINT     pk_Mantis_bug_table
   PRIMARY KEY    (
                  ID_
                  )

   ,

   CONSTRAINT     fk1_Mantis_bug_table
   FOREIGN KEY    (
                  reporter_id
                  )
   REFERENCES     Mantis_user_table
                  (
                  ID_
                  )
   ,

   CONSTRAINT     fk2_Mantis_bug_table
   FOREIGN KEY    (
                  handler_id
                  )
   REFERENCES     Mantis_user_table
                  (
                  ID_
                  )
   ,

   CONSTRAINT     fk3_Mantis_bug_table
   FOREIGN KEY    (
                  duplicate_id
                  )
   REFERENCES     Mantis_bug_table
                  (
                  ID_
                  )
   )
   ;


DROP TABLE Mantis_bugnote_table ;
   
CREATE TABLE    Mantis_bugnote_table .. ERD
   (                
                  ID_                  INTEGER        NOT NULL
   ,              bug_id               INTEGER        NOT NULL
   ,              reporter_id          INTEGER       
   ,              bugnote_text_id      INTEGER       
   ,              view_state           INTEGER       
   ,              date_submitted       TIMESTAMP     
   ,              last_modified        TIMESTAMP     
   ,              note_type            INTEGER       
   ,              note_attr            VARCHAR(250)  
   ,

   CONSTRAINT     pk_Mantis_bugnote_table
   PRIMARY KEY    (
                  ID_
                  )

   ,

   CONSTRAINT     fk1_Mantis_bugnote_table
   FOREIGN KEY    (
                  bug_id
                  )
   REFERENCES     Mantis_bug_table
                  (
                  ID_
                  )
   ,

   CONSTRAINT     fk2_Mantis_bugnote_table
   FOREIGN KEY    (
                  reporter_id
                  )
   REFERENCES     Mantis_user_table
                  (
                  ID_
                  )
   )
   ;


DROP TABLE Mantis_config_table ;
   
CREATE TABLE    Mantis_config_table .. ERD
   (                
                  config_id            VARCHAR(64)    NOT NULL
   ,              project_id           INTEGER        NOT NULL
   ,              user_id              INTEGER        NOT NULL
   ,              access_reqd          INTEGER       
   ,              Type_                INTEGER       
   ,              value                VARCHAR(4000) 
   ,

   CONSTRAINT     pk_Mantis_config_table
   PRIMARY KEY    (
                  config_id
   ,              project_id
   ,              user_id
                  )

   ,

   CONSTRAINT     fk1_Mantis_config_table
   FOREIGN KEY    (
                  user_id
                  )
   REFERENCES     Mantis_user_table
                  (
                  ID_
                  )
   )
   ;


DROP TABLE Mantis_custom_field_string_table ;
   
CREATE TABLE    Mantis_custom_field_string_table .. ERD
   (                
                  field_id             INTEGER        NOT NULL
   ,              bug_id               INTEGER        NOT NULL
   ,              value                VARCHAR(255)  
   ,

   CONSTRAINT     pk_Mantis_custom_field_string_table
   PRIMARY KEY    (
                  field_id
   ,              bug_id
                  )

   ,

   CONSTRAINT     fk1_Mantis_custom_field_string_table
   FOREIGN KEY    (
                  bug_id
                  )
   REFERENCES     Mantis_bug_table
                  (
                  ID_
                  )
   )
   ;


DROP TABLE Mantis_filters_table ;
   
CREATE TABLE    Mantis_filters_table .. ERD
   (                
                  ID_                  INTEGER        NOT NULL
   ,              user_id              INTEGER       
   ,              project_id           INTEGER       
   ,              is_public            INTEGER       
   ,              name                 VARCHAR(64)   
   ,              filter_string        VARCHAR(4000) 
   ,

   CONSTRAINT     pk_Mantis_filters_table
   PRIMARY KEY    (
                  ID_
                  )

   ,

   CONSTRAINT     fk1_Mantis_filters_table
   FOREIGN KEY    (
                  user_id
                  )
   REFERENCES     Mantis_user_table
                  (
                  ID_
                  )
   )
   ;


DROP TABLE Mantis_project_category_table ;
   
CREATE TABLE    Mantis_project_category_table .. ERD
   (                
                  project_id           INTEGER        NOT NULL
   ,              category             VARCHAR(64)    NOT NULL
   ,              user_id              INTEGER       
   ,

   CONSTRAINT     pk_Mantis_project_category_table
   PRIMARY KEY    (
                  project_id
   ,              category
                  )

   ,

   CONSTRAINT     fk1_Mantis_project_category_table
   FOREIGN KEY    (
                  user_id
                  )
   REFERENCES     Mantis_user_table
                  (
                  ID_
                  )
   )
   ;


DROP TABLE Mantis_project_user_list_table ;
   
CREATE TABLE    Mantis_project_user_list_table .. ERD
   (                
                  project_id           INTEGER        NOT NULL
   ,              user_id              INTEGER        NOT NULL
   ,              access_level         INTEGER       
   ,

   CONSTRAINT     pk_Mantis_project_user_list_table
   PRIMARY KEY    (
                  project_id
   ,              user_id
                  )

   ,

   CONSTRAINT     fk1_Mantis_project_user_list_table
   FOREIGN KEY    (
                  user_id
                  )
   REFERENCES     Mantis_user_table
                  (
                  ID_
                  )
   )
   ;


DROP TABLE Mantis_sponsorship_table ;
   
CREATE TABLE    Mantis_sponsorship_table .. ERD
   (                
                  ID_                  INTEGER        NOT NULL
   ,              bug_id               INTEGER        NOT NULL
   ,              user_id              INTEGER       
   ,              amount               INTEGER       
   ,              logo                 VARCHAR(128)  
   ,              url                  VARCHAR(128)  
   ,              paid                 INTEGER       
   ,              date_submitted       TIMESTAMP     
   ,              last_updated         TIMESTAMP     
   ,

   CONSTRAINT     pk_Mantis_sponsorship_table
   PRIMARY KEY    (
                  ID_
                  )

   ,

   CONSTRAINT     fk1_Mantis_sponsorship_table
   FOREIGN KEY    (
                  bug_id
                  )
   REFERENCES     Mantis_bug_table
                  (
                  ID_
                  )
   ,

   CONSTRAINT     fk2_Mantis_sponsorship_table
   FOREIGN KEY    (
                  user_id
                  )
   REFERENCES     Mantis_user_table
                  (
                  ID_
                  )
   )
   ;


DROP TABLE Mantis_user_pref_table ;
   
CREATE TABLE    Mantis_user_pref_table .. ERD
   (                
                  ID_                  INTEGER        NOT NULL
   ,              user_id              INTEGER       
   ,              project_id           INTEGER       
   ,              default_profile      INTEGER       
   ,              default_project      INTEGER       
   ,              advanced_report      INTEGER       
   ,              advanced_view        INTEGER       
   ,              advanced_update      INTEGER       
   ,              refresh_delay        INTEGER       
   ,              redirect_delay       INTEGER       
   ,              bugnote_order        VARCHAR(4)    
   ,              email_on_new         INTEGER       
   ,              email_on_assigned    INTEGER       
   ,              email_on_feedback    INTEGER       
   ,              email_on_resolved    INTEGER       
   ,              email_on_closed      INTEGER       
   ,              email_on_reopened    INTEGER       
   ,              email_on_bugnote     INTEGER       
   ,              email_on_status      INTEGER       
   ,              email_on_priority    INTEGER       
   ,              email_on_priority_min_severity INTEGER       
   ,              email_on_status_min_severity INTEGER       
   ,              email_on_bugnote_min_severity INTEGER       
   ,              email_on_reopened_min_severity INTEGER       
   ,              email_on_closed_min_severity INTEGER       
   ,              email_on_resolved_min_severity INTEGER       
   ,              email_on_feedback_min_severity INTEGER       
   ,              email_on_assigned_min_severity INTEGER       
   ,              email_on_new_min_severity INTEGER       
   ,              email_bugnote_limit  INTEGER       
   ,              language             VARCHAR(32)   
   ,

   CONSTRAINT     pk_Mantis_user_pref_table
   PRIMARY KEY    (
                  ID_
                  )

   ,

   CONSTRAINT     fk1_Mantis_user_pref_table
   FOREIGN KEY    (
                  user_id
                  )
   REFERENCES     Mantis_user_table
                  (
                  ID_
                  )
   )
   ;


DROP TABLE Mantis_user_print_pref_table ;
   
CREATE TABLE    Mantis_user_print_pref_table .. ERD
   (                
                  user_id              INTEGER        NOT NULL
   ,              print_pref           VARCHAR(27)   
   ,

   CONSTRAINT     pk_Mantis_user_print_pref_table
   PRIMARY KEY    (
                  user_id
                  )

   ,

   CONSTRAINT     fk1_Mantis_user_print_pref_table
   FOREIGN KEY    (
                  user_id
                  )
   REFERENCES     Mantis_user_table
                  (
                  ID_
                  )
   )
   ;


DROP TABLE Mantis_user_profile_table ;
   
CREATE TABLE    Mantis_user_profile_table .. ERD
   (                
                  ID_                  INTEGER        NOT NULL
   ,              user_id              INTEGER       
   ,              platform             VARCHAR(32)   
   ,              os                   VARCHAR(32)   
   ,              os_build             VARCHAR(32)   
   ,              description          VARCHAR(4000) 
   ,

   CONSTRAINT     pk_Mantis_user_profile_table
   PRIMARY KEY    (
                  ID_
                  )

   ,

   CONSTRAINT     fk1_Mantis_user_profile_table
   FOREIGN KEY    (
                  user_id
                  )
   REFERENCES     Mantis_user_table
                  (
                  ID_
                  )
   )
   ;


DROP TABLE Mantis_bug_file_table ;
   
CREATE TABLE    Mantis_bug_file_table .. ERD
   (                
                  ID_                  INTEGER        NOT NULL
   ,              bug_id               INTEGER        NOT NULL
   ,              title                VARCHAR(250)  
   ,              description          VARCHAR(250)  
   ,              diskfile             VARCHAR(250)  
   ,              filename             VARCHAR(250)  
   ,              folder               VARCHAR(250)  
   ,              filesize             INTEGER       
   ,              file_type            VARCHAR(250)  
   ,              date_added           TIMESTAMP     
   ,              content              BLOB          
   ,

   CONSTRAINT     pk_Mantis_bug_file_table
   PRIMARY KEY    (
                  ID_
                  )

   ,

   CONSTRAINT     fk1_Mantis_bug_file_table
   FOREIGN KEY    (
                  bug_id
                  )
   REFERENCES     Mantis_bug_table
                  (
                  ID_
                  )
   )
   ;


DROP TABLE Mantis_bug_history_table ;
   
CREATE TABLE    Mantis_bug_history_table .. ERD
   (                
                  ID_                  INTEGER        NOT NULL
   ,              user_id              INTEGER       
   ,              bug_id               INTEGER        NOT NULL
   ,              date_modified        TIMESTAMP     
   ,              field_name           VARCHAR(32)   
   ,              old_value            VARCHAR(128)  
   ,              new_value            VARCHAR(128)  
   ,              Type_                INTEGER       
   ,

   CONSTRAINT     pk_Mantis_bug_history_table
   PRIMARY KEY    (
                  ID_
                  )

   ,

   CONSTRAINT     fk1_Mantis_bug_history_table
   FOREIGN KEY    (
                  user_id
                  )
   REFERENCES     Mantis_user_table
                  (
                  ID_
                  )
   ,

   CONSTRAINT     fk2_Mantis_bug_history_table
   FOREIGN KEY    (
                  bug_id
                  )
   REFERENCES     Mantis_bug_table
                  (
                  ID_
                  )
   )
   ;


DROP TABLE Mantis_bug_monitor_table ;
   
CREATE TABLE    Mantis_bug_monitor_table .. ERD
   (                
                  user_id              INTEGER        NOT NULL
   ,              bug_id               INTEGER        NOT NULL
   ,

   CONSTRAINT     pk_Mantis_bug_monitor_table
   PRIMARY KEY    (
                  user_id
   ,              bug_id
                  )

   ,

   CONSTRAINT     fk1_Mantis_bug_monitor_table
   FOREIGN KEY    (
                  user_id
                  )
   REFERENCES     Mantis_user_table
                  (
                  ID_
                  )
   ,

   CONSTRAINT     fk2_Mantis_bug_monitor_table
   FOREIGN KEY    (
                  bug_id
                  )
   REFERENCES     Mantis_bug_table
                  (
                  ID_
                  )
   )
   ;


DROP TABLE Mantis_bug_relationship_table ;
   
CREATE TABLE    Mantis_bug_relationship_table .. ERD
   (                
                  ID_                  INTEGER        NOT NULL
   ,              source_bug_id        INTEGER        NOT NULL
   ,              destination_bug_id   INTEGER       
   ,              relationship_type    INTEGER       
   ,

   CONSTRAINT     pk_Mantis_bug_relationship_table
   PRIMARY KEY    (
                  ID_
                  )

   ,

   CONSTRAINT     fk1_Mantis_bug_relationship_table
   FOREIGN KEY    (
                  source_bug_id
                  )
   REFERENCES     Mantis_bug_table
                  (
                  ID_
                  )
   ,

   CONSTRAINT     fk2_Mantis_bug_relationship_table
   FOREIGN KEY    (
                  destination_bug_id
                  )
   REFERENCES     Mantis_bug_table
                  (
                  ID_
                  )
   )
   ;


show Logical Data Model
show Physical Data Model


Mantis_bug_file_table - Table
Mantis_bug_history_table - Table
Mantis_bug_monitor_table - Table
Mantis_bug_relationship_table - Table
Mantis_bug_table - Table
Mantis_bug_text_table - Table
Mantis_bugnote_table - Table
Mantis_bugnote_text_table - Table
Mantis_config_table - Table
Mantis_custom_field_project_table - Table
Mantis_custom_field_string_table - Table
Mantis_custom_field_table - Table
Mantis_filters_table - Table
Mantis_news_table - Table
Mantis_project_category_table - Table
Mantis_project_file_table - Table
Mantis_project_hierarchy_table - Table
Mantis_project_table - Table
Mantis_project_user_list_table - Table
Mantis_project_version_table - Table
Mantis_sponsorship_table - Table
Mantis_tokens_table - Table
Mantis_user_pref_table - Table
Mantis_user_print_pref_table - Table
Mantis_user_profile_table - Table
Mantis_user_table - Table

Total: 26 Tables, 0 Views, 214 Table Attributes
For the specification of triggers please see the *.sqln file.