Option 1:

If we only care about the latest signals, the table should have:

• Foreign key to the ID in the feature table.
• An int column for PositiveSignal

Option 2:

Currently, the developer signal data does not have timestamps on the emojis over time, so we could aggregate it by day ourselves. Then we could have the following:

Table 1

• Signal ID
• Foreign key to the ID in the feature table.
• An int column for PositiveSignal
• Created at/Updated at timestamps

Table 2 (Latest table since spanner does not have window functions)

• Foreign key to the ID in the signal table.
• Foreign key to the ID in the feature table.

After choosing either option, we want to include lib/gcpspanner methods to create, edit, and delete entries