Column descriptions
- group_session
- Group session ID
- frequency
- Frequency of the samples (main clock frequency).
- station
- The iMac that the participant was stationed at.
- timestamp_unix
- The Unix timestamp of the event.
- timestamp_iso8601
- The ISO-8601 timestamp of the event.
- aux_ekg
- value of the ekg channel.
where station = "cheetah"
✎ View and edit SQL
This data as json, copyable
0 records
CREATE TABLE "ekg_sync" (
[group_session] TEXT REFERENCES [group_session]([id]),
[frequency] INTEGER,
[station] TEXT REFERENCES [station]([id]),
[id] INTEGER,
[timestamp_unix] TEXT,
[timestamp_iso8601] TEXT,
[ekg] FLOAT,
[heart_rate] FLOAT,
PRIMARY KEY ([group_session], [frequency], [station], [id])
);
CREATE INDEX [idx_ekg_sync_station]
ON [ekg_sync] ([station]);
CREATE INDEX [idx_ekg_sync_group_session]
ON [ekg_sync] ([group_session]);