Changes between Initial Version and Version 1 of TracDev/Proposals/AdvancedNotification/DatabaseSchema

Timestamp:

Oct 8, 2013, 7:58:35 AM (11 years ago)

Author:

Peter Suter

Comment:

Proposed new DB tables from ​th:AnnouncerPlugin schema version 6

TracDev/Proposals/AdvancedNotification/DatabaseSchema

@@ +1 @@
+[[PageOutline(2)]]
+
+= Trac Database Schema: Notification
+
+The TracNotification module stores notification event subscriptions in the database.
+
+== Table `subscription`
+||'''Table'''||'''Key'''||
+||''subscription''||''id''||
+
+||'''Columns'''||'''Type'''||'''Notes'''||
+||''id''||`auto_increment`|| ||
+||''time''||`int64`|| ||
+||''changetime''||`int64`|| ||
+||''class''|| || The name of the Python class that stored this subscription. ||
+||''sid''|| || The [wiki:TracDev/DatabaseSchema/Common#Tablesession session] ID of the subscriber. ||
+||''authenticated''||`int`|| `1` for authenticated session IDs, `0` for anonymous session IDs ||
+||''distributor''|| || Identifies the distributor to used for this subscription (e.g. `email`) ||
+||''format''|| || Identifies the MIME type to be used for this subscription (e.g. `text/plain` or `text/html`) ||
+||''priority''||`int`||Precedence level of this subscription. E.g. `1` overrules `2`. ||
+||''adverb''|| ||`always` or `never`||
+
+Stores if a subscription rule always/never applies for a certain user, at what priority and using what distribution method/format.
+
+Use the `trac.notification.model.Subscription` model class to access this table. 
+
+See [browser:psuter/trac/notification/model.py@advanced-notification-subscriptions#/ trac.notification.model.Subscription]
+
+== Table `subscription_attribute`
+||'''Table'''||'''Key'''||
+||''subscription_attribute''||''id''||
+
+||'''Columns'''||'''Type'''||'''Notes'''||
+||''id''||`auto_increment`|| ||
+||''sid''|| || The session ID of the subscriber. ||
+||''authenticated''||`int`|| `1` for authenticated session IDs, `0` for anonymous session IDs ||
+||''class''|| || The name of the Python class that stored this subscription attribute. ||
+||''realm''|| || The realm of this subscription (e.g. `ticket`). ||
+||''target''|| || The target of this subscription (e.g. a ticket id). ||
+
+Stores attributes to identify the target resource(s) of a subscription (e.g. a watched ticket's id, wiki page filters, joined groups, etc.)
+
+Use the `trac.notification.model.SubscriptionAttribute` model class to access this table. 
+
+See [browser:psuter/trac/notification/model.py@advanced-notification-subscription-attributes#/ trac.notification.model.SubscriptionAttribute]