]> models_diagram _diagram_info Diagram: Models Date: Apr 29 2009 - 09:00 Migration version: 108 Generated by RailRoad 0.4.0 Document Document title :string description :text created_on :datetime Attachment Attachment container_type :string filename :string disk_filename :string filesize :integer content_type :string digest :string downloads :integer created_on :datetime description :string Document->Attachment n Repository Repository url :string login :string password :string root_url :string Change Change action :string path :string from_path :string from_revision :string revision :string branch :string Repository->Change n n Changeset Changeset revision :string committer :string committed_on :datetime comments :text commit_date :date scmid :string Repository->Changeset n MailHandler MailHandler TimeEntry TimeEntry hours :float comments :string spent_on :date tyear :integer tmonth :integer tweek :integer created_on :datetime updated_on :datetime CustomValue CustomValue customized_type :string value :text TimeEntry->CustomValue n Token Token action :string value :string created_on :datetime AuthSourceLdap AuthSourceLdap name :string host :string port :integer account :string account_password :string base_dn :string attr_login :string attr_firstname :string attr_lastname :string attr_mail :string onthefly_register :boolean tls :boolean User User login :string hashed_password :string firstname :string lastname :string mail :string mail_notification :boolean admin :boolean status :integer last_login_on :datetime language :string created_on :datetime updated_on :datetime identity_url :string AuthSourceLdap->User n IssueCategory IssueCategory name :string Issue Issue subject :string description :text due_date :date lock_version :integer created_on :datetime updated_on :datetime start_date :date done_ratio :integer estimated_hours :float IssueCategory->Issue n IssueCustomField IssueCustomField name :string field_format :string possible_values :text regexp :string min_length :integer max_length :integer is_required :boolean is_for_all :boolean is_filter :boolean position :integer searchable :boolean default_value :text editable :boolean IssueCustomField->Issue n n Tracker Tracker name :string is_in_chlog :boolean position :integer is_in_roadmap :boolean IssueCustomField->Tracker n n Project Project name :string description :text homepage :string is_public :boolean created_on :datetime updated_on :datetime identifier :string status :integer lft :integer rgt :integer IssueCustomField->Project n n IssueCustomField->CustomValue n Enumeration Enumeration opt :string name :string position :integer is_default :boolean Issue->TimeEntry n Watcher Watcher watchable_type :string Issue->Watcher n Journal Journal journalized_type :string notes :text created_on :datetime Issue->Journal n Issue->User watcher_users n n IssueRelation IssueRelation relation_type :string delay :integer Issue->IssueRelation relations_from n Issue->IssueRelation relations_to n Issue->Attachment n Issue->Changeset n n Issue->CustomValue n MessageObserver MessageObserver WikiContent WikiContent text :text comments :string updated_on :datetime version :integer WikiContent::Version WikiContent::Version WikiContent->WikiContent::Version versions n WikiPage WikiPage title :string created_on :datetime protected :boolean WikiPage->WikiContent content 1 WikiPage->WikiPage children n WikiPage->Attachment n EnabledModule EnabledModule name :string Comment Comment commented_type :string comments :text created_on :datetime updated_on :datetime Query Query name :string filters :text is_public :boolean column_names :text Member Member created_on :datetime mail_notification :boolean Mailer Mailer Workflow Workflow JournalDetail JournalDetail property :string prop_key :string old_value :string value :string Journal->JournalDetail details n UserCustomField UserCustomField name :string field_format :string possible_values :text regexp :string min_length :integer max_length :integer is_required :boolean is_for_all :boolean is_filter :boolean position :integer searchable :boolean default_value :text editable :boolean UserCustomField->CustomValue n TimeEntryCustomField TimeEntryCustomField name :string field_format :string possible_values :text regexp :string min_length :integer max_length :integer is_required :boolean is_for_all :boolean is_filter :boolean position :integer searchable :boolean default_value :text editable :boolean TimeEntryCustomField->CustomValue n CustomField CustomField name :string field_format :string possible_values :text regexp :string min_length :integer max_length :integer is_required :boolean is_for_all :boolean is_filter :boolean position :integer searchable :boolean default_value :text editable :boolean CustomField->CustomValue n Setting Setting name :string value :text updated_on :datetime User->Token rss_token 1 User->IssueCategory n User->Member memberships n User->Member n User->Changeset n User->Project n n User->CustomValue n UserPreference UserPreference others :text hide_mail :boolean time_zone :string User->UserPreference preference 1 AuthSource AuthSource name :string host :string port :integer account :string account_password :string base_dn :string attr_login :string attr_firstname :string attr_lastname :string attr_mail :string onthefly_register :boolean tls :boolean AuthSource->User n WikiRedirect WikiRedirect title :string redirects_to :string created_on :datetime Message Message subject :string content :text created_on :datetime updated_on :datetime locked :boolean sticky :integer Message->Watcher n Message->User watcher_users n n Message->Message children n Message->Attachment n Version Version name :string description :string effective_date :date created_on :datetime updated_on :datetime wiki_page_title :string Version->Issue fixed_issues n Version->Attachment n Board Board name :string description :string position :integer Board->Watcher n Board->User watcher_users n n Board->Message topics n Board->Message n IssueStatus IssueStatus name :string is_closed :boolean is_default :boolean position :integer IssueStatus->Workflow n Tracker->IssueCustomField custom_fields n n Tracker->Issue n Tracker->Workflow n Tracker->Project n n Role Role name :string position :integer assignable :boolean builtin :integer permissions :text Role->Member n Role->Workflow n Changeset->Change n ProjectCustomField ProjectCustomField name :string field_format :string possible_values :text regexp :string min_length :integer max_length :integer is_required :boolean is_for_all :boolean is_filter :boolean position :integer searchable :boolean default_value :text editable :boolean ProjectCustomField->CustomValue n Wiki Wiki start_page :string status :integer Wiki->WikiPage pages n Wiki->WikiRedirect redirects n Project->Document n Project->Repository 1 Project->TimeEntry n Project->IssueCategory n Project->Issue n Project->EnabledModule n Project->Query n Project->Member n Project->Journal issue_changes n n Project->Version n Project->Board n Project->Attachment n Project->Changeset n n Project->Wiki 1 Project->CustomValue n News News title :string summary :string description :text created_on :datetime Project->News n News->Comment n Repository::Subversion Repository::Subversion url :string login :string password :string root_url :string Repository::Subversion->Change n n Repository::Subversion->Changeset n Repository::Bazaar Repository::Bazaar url :string login :string password :string root_url :string Repository::Bazaar->Change n n Repository::Bazaar->Changeset n Repository::Git Repository::Git url :string login :string password :string root_url :string Repository::Git->Change n n Repository::Git->Changeset n Repository::Mercurial Repository::Mercurial url :string login :string password :string root_url :string Repository::Mercurial->Change n n Repository::Mercurial->Changeset n Repository::Filesystem Repository::Filesystem url :string login :string password :string root_url :string Repository::Filesystem->Change n n Repository::Filesystem->Changeset n Repository::Cvs Repository::Cvs url :string login :string password :string root_url :string Repository::Cvs->Change n n Repository::Cvs->Changeset n Repository::Darcs Repository::Darcs url :string login :string password :string root_url :string Repository::Darcs->Change n n Repository::Darcs->Changeset n