Column descriptions
where group_session = "exp_2022_09_30_10"
✎ View and edit SQL
This data as json, copyable, CSV (advanced)
Suggested facets: mission_start_timestamp_iso8601 (date), trial_start_timestamp_iso8601 (date), trial_stop_timestamp_iso8601 (date)
mission_stop_timestamp_iso8601 (date)
1
✖
CREATE TABLE "minecraft_mission" (
[id] TEXT PRIMARY KEY,
[group_session] TEXT REFERENCES [group_session]([id]),
[name] TEXT,
[mission_start_timestamp_unix] TEXT,
[mission_start_timestamp_iso8601] TEXT,
[mission_stop_timestamp_unix] TEXT,
[mission_stop_timestamp_iso8601] TEXT,
[trial_start_timestamp_unix] TEXT,
[trial_start_timestamp_iso8601] TEXT,
[trial_stop_timestamp_unix] TEXT,
[trial_stop_timestamp_iso8601] TEXT,
[final_team_score] INTEGER,
[testbed_version] TEXT
);
CREATE INDEX [idx_minecraft_mission_group_session]
ON [minecraft_mission] ([group_session]);