Skip to content

Database

tilttek/table-safety-bundle

The bundle adds four tables to the schema the ORM generates for its connection, through TableSafetySchemaListener:

TableKeyHolds
tilttek_table_safety_tabletable_refeach table's settings, as JSON
tilttek_table_safety_participationtable_ref, participanteach participant's lines and veils, checklist and session zero, as JSON, when they first answered and when they last changed
tilttek_table_safety_signalidthe signals: table, kind, audience, the moment and its microsecond, the author of a named signal, when it was seen
tilttek_table_safety_feedbacktable_ref, session, participanteach participant's stars and wishes of each session, as JSON

The participations and the feedback are indexed by participant, for an export or an erasure; the signals by table and microsecond, for the last ones of a table, and by author. An anonymous signal's author is null. The moments are written in UTC, to the second; the microsecond keeps the order of two signals of the same second.