Changes between Version 14 and Version 15 of TracDev/DatabaseSchema

Timestamp:

Mar 11, 2012, 11:36:57 PM (12 years ago)

Author:

Peter Suter

Comment:

Link to TicketSystem subpage

TracDev/DatabaseSchema

@@ -15 +15 @@
 || [./Common#Tableauth_cookie auth_cookie] || User login cookies. ||
 || [./Common#Tablecache cache] || Synchronization table for process- and thread-local caches. ||
-|| `component` || Values that can be used in a ticket's "component" field.  The `owner` column is used as the default assignee for new tickets, if not overridden at the time of ticket submission. ||
-|| `enum` || Maps integer IDs for issues' priorities, severities, etc. to human-readable names. ||
-|| `milestone` || Project milestones. ||
+|| [./TicketSystem#Tablecomponent component] || Values that can be used in a ticket's "component" field.  The `owner` column is used as the default assignee for new tickets, if not overridden at the time of ticket submission. ||
+|| [./TicketSystem#Tableenum enum] || Maps integer IDs for issues' priorities, severities, etc. to human-readable names. ||
+|| [./TicketSystem#Tablemilestone milestone] || Project milestones. ||
 || [./VersionControl#Tablenode_change node_change] || 1^st^ half of the repository cache: for every changeset (as identified by the revision number), this table contains the nodes (i.e. files or directories) that have been added/modified/deleted. ||
 || [./Common#Tablepermission permission] || Username/action pairs describing who's allowed to do what. This table's contents also hold permission groups. ||
@@ -26 +26 @@
 || [./Common#Tablesession_attribute session_attribute] || Information about user settings, including name, email, and diff options. ||
 || [./Common#Tablesystem system] || System information such as the database version and repository cache metadata  ||
-|| `ticket` || Tickets. ||
-|| `ticket_change` || Changes to tickets, on a field-by-field basis.  The field value `comment` is special: it associates a comment with a set of field changes. ||
-|| `ticket_custom` || The values of custom ticket fields. ||
-|| `version` || As in `component` and `milestone`, this holds the options of the drop-down `version` list on the ticket form. Every version can have a `time` set, although that is not presently used other than for ordering the list of versions in the UI. ||
+|| [./TicketSystem#Tableticket ticket] || Tickets. ||
+|| [./TicketSystem#Tableticket_change ticket_change] || Changes to tickets, on a field-by-field basis.  The field value `comment` is special: it associates a comment with a set of field changes. ||
+|| [./TicketSystem#Tableticket_custom ticket_custom] || The values of custom ticket fields. ||
+|| [./TicketSystem#Tableversion version] || As in `component` and `milestone`, this holds the options of the drop-down `version` list on the ticket form. Every version can have a `time` set, although that is not presently used other than for ordering the list of versions in the UI. ||
 || [./WikiSystem#Tablewiki wiki] || Wiki pages (including old revisions). ||