Data model - marcoplaisier/QuotePad GitHub Wiki

  • identifier (id)
    • database generated id
  • order (integer)
    • that determines the order in which the texts are displayed. Default is newest last, but can be changed.
  • delta-text (string)
    • Quill.js internal representation of texts. Required for updates to texts
  • html-text (string)
    • HTML representation of text. Easier to convert to bytes string needed by hardware
  • (Not implemented) timings (text)
    • Stores the timing of (part of) the texts. E.g. to temporarily stop the text
  • background color (integer)
    • Integer (0, 8-14)
  • status (integer)
    • new, active, inactive, archived
  • font (integer)
    • 1-4
  • speed (integer)
    • 1-15 (slow - fast)
  • color scheme (integer)
    • 0, 1
  • creation-timestamp (timestamp)
    • timestamp when the text was first created
  • last-mod timestamp (timestamp)
    • timestamp when the text was last edited.