20160108_jeffrey - silenceuncrio/diary GitHub Wiki

Index

  • 0920 - 2016 年開始每天上班時間為 0830 ~ 1730
  • 0925 - SQLite
  • 1725 - IoT Platform - Database - Entity-Relationship Model

0920

2016 年開始每天上班時間為 0830 ~ 1730

感謝老婆昨晚提醒
早上問了文管中心的 Hingis 得知

2016 年開始每天上班時間為 0830 ~ 1730

結果我禮拜一到禮拜四還是上滿 8 小時又 20 分鐘

0925

繼續 SQLite

評價甚高的 SQL in 10 Minutes, Sams Teach Yourself (4th Edition)
拜讀一下

1725

IoT Platform - Database - Entity-Relationship Model

image

  • Each box can have more things
  • Things table is a abstract container contains different things:
    • KeypadInputs
    • OpenDetectors
    • LightDetectors
    • MotionDetectors
    • VibrateDetectors
    • SoundDetectos
    • TempDetectors
    • CoDetectors
    • BleDetectors
  • Each action can be trigger by rule
  • Each rule according some thing's attribute to trigger action
    • For example, if the temperature of some thing(thing_id: 7) higher than 30, then trigger the action(action_id: 3)