T7846: akonadi > MySQL ERD Review

[Pablo Sanchez]

pablo added a comment.


  **Optional Parent FK's**
  
  The tables listed below have NULL'able //Foreign Keys//.  Is this intended?
  
  Generally I like to make the DBMS enforce as much //Referential Integrity// as possible.
  
  Sometimes it doesn't make sense to make FK's **NOT NULL** so ... that's why I'm asking.  ;)
  
  //Note:  recursive relationships must have a NULL'able FK so we're good on that front.//
  
  - **[MimeTypeTable]** -> **[PIMItemTable]**
  - **[CollectionTable]** -> **[PIMItemTable]**
  - **[RelationTypeTable]** > **[RelationTable]**

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

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