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.