T7846: akonadi > MySQL ERD Review

[Daniel Vrátil]

dvratil added a comment.


  I would call it **[CollectionAttributeTypeTable]** to keep consistency with the other tables :)
  
  I'm not sure what you mean by "//does each **[ResourceTable]** get its own//" - there's only one **[ResourceTable]** - if you are asking if each Resource in the **[ResourceTable]** gets it's own "domain" then no, all Resources share the same table space.
  
  Btw:
  
    akonadi=# select encode(type::bytea, 'escape') as type, count(*) from collectionattributetable group by type;
                type            | count
    ----------------------------+-------
     noselect                   |   196
     favorite                   |     3
     ENTITYDISPLAY              |   103
     uidvalidity                |   194
     highestmodseq              |   186
     KAlarmCollection           |     3
     collectionquota            |   194
     ctag                       |    10
     SpecialCollectionAttribute |     8
     uidnext                    |   194
     KAlarmCompatibility        |     3
     imapquota                  |   194
     PERSISTENTSEARCH           |     2
     AccessRights               |   860
     BlockAlarmsAttribute       |    95
     imapacl                    |   188
     davprotocol                |    10
     collectionidentification   |   818
     collectionflags            |   194
     newmailnotifierattribute   |   690
     collectioncolor            |    32
     collectionannotations      |   747
    (22 rows)
    
    akonadi=# select count(*) from collectionattributetable;
     count 
    -------
      4924
  
  Notice how consistent we are in naming the attributes ;-)

TASK DETAIL
  https://phabricator.kde.org/T7846

To: pablo, dvratil
Cc: knauss, dvratil, kde-pim, pablo
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mail.kde.org/pipermail/kde-pim/attachments/20180205/7743097e/attachment.html>