T7846: akonadi > MySQL ERD Review

[Daniel Vrátil]

dvratil added a comment.


  > Flags should be NOT NULL
  
  Fair point, I added it to actionables, that should be fairly easy to fix. Just needs modifying the XML and Akonadi should be able to self-correct the schema
  
  > Key/Value Pair anti-pattern
  
  The link lists the problems but does not offer any good advice, considering our storage is generic (we don't know the keys beforehand). What would be your advice? We can normalize the  **[CollectionAttributeTable].type** column by moving the key names to their own table  like we do in **[PartTable]** as suggested in the link, but that's about all that I could find there that would apply in our case.

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/cfa60d50/attachment.html>