[TangerineSDR] Personal Space WX Station Central Control System Database

[Engelke, Bill]

To all:                            Personal Space WX Station Central Control System Database

Please find attached :

  *   A PowerPoint layout showing database structure
  *   An Excel file listing my current understanding of what fields we need in each table

Note that I have configured third normal form for several fields, to improve efficiency.
Fields that should be indexed are denoted with *, although I have marked several fields as indexed when they would also be linked (i.e., foreign key), so maybe unnecessary.

This is a work in progress..    any feedback is most welcome - 73 - Bill AB4EJ
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.tapr.org/pipermail/tangerinesdr_lists.tapr.org/attachments/20201106/9960bad4/attachment-0001.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: Databaase_layout.pptx
Type: application/vnd.openxmlformats-officedocument.presentationml.presentation
Size: 37178 bytes
Desc: Databaase_layout.pptx
URL: <http://lists.tapr.org/pipermail/tangerinesdr_lists.tapr.org/attachments/20201106/9960bad4/attachment-0001.pptx>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: Database_fields.xlsx
Type: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
Size: 12209 bytes
Desc: Database_fields.xlsx
URL: <http://lists.tapr.org/pipermail/tangerinesdr_lists.tapr.org/attachments/20201106/9960bad4/attachment-0001.xlsx>