Changes between Version 2 and Version 3 of TracDev/DatabaseSchema/NotificationSystem
- Timestamp:
- Jul 31, 2015, 11:57:16 AM (9 years ago)
Legend:
- Unmodified
- Added
- Removed
- Modified
-
TracDev/DatabaseSchema/NotificationSystem
v2 v3 6 6 7 7 == Table `notify_subscription` 8 9 Table description: 10 8 11 ||'''Table'''||'''Key'''|| 9 12 ||''notify_subscription''||''id''|| 13 14 Column description: 10 15 11 16 ||'''Columns'''||'''Type'''||'''Notes'''|| … … 16 21 ||''sid''|| || The [wiki:TracDev/DatabaseSchema/Common#Tablesession session] ID of the subscriber. || 17 22 ||''authenticated''||`int`|| `1` for authenticated session IDs, `0` for anonymous session IDs || 18 ||''distributor''|| || Identifies the distributor to used for this subscription (e.g. `email`)||19 ||''format''|| || Identifies the MIME type to be used for this subscription (e.g. `text/plain` or `text/html`)||20 ||''priority''||`int`||Precedence level of this subscription . E.g.`1` overrules `2`. ||23 ||''distributor''|| || Identifies the distributor to used for this subscription, eg `email` || 24 ||''format''|| || Identifies the MIME type to be used for this subscription, eg `text/plain` or `text/html` || 25 ||''priority''||`int`||Precedence level of this subscription, eg `1` overrules `2`. || 21 26 ||''adverb''|| ||`always` or `never`|| 27 28 Index description: 22 29 23 30 ||'''Indices'''|| … … 25 32 ||''class''|| 26 33 27 Stores ifa subscription rule always/never applies for a certain user, at what priority and using what distribution method/format.34 This table stores whether a subscription rule always/never applies for a certain user, at what priority and using what distribution method/format. 28 35 29 36 Use the `trac.notification.model.Subscription` model class to access this table. … … 34 41 35 42 == Table `notify_watch` 43 44 Table description: 45 36 46 ||'''Table'''||'''Key'''|| 37 47 ||''notify_watch''||''id''|| 48 49 Column description: 38 50 39 51 ||'''Columns'''||'''Type'''||'''Notes'''|| … … 45 57 ||''target''|| || The target of this subscription (e.g. a ticket id). || 46 58 59 Index description: 60 47 61 ||'''Indices'''|| 48 62 ||''sid'', ''authenticated'', ''class''|| 49 63 ||''class'', ''realm'', ''target''|| 50 64 51 Stores watches to identify the target resource(s) of a subscription (e.g. a watched ticket's id, wiki page filters, joined groups, etc.) 65 This table stores watches to identify the target resource(s) of a subscription. For example, a watched ticket's id, wiki page filters, joined groups, etc. 52 66 53 67 Use the `trac.notification.model.Watch` model class to access this table.