Column descriptions
where group_session = "exp_2023_01_30_13"
✎ View and edit SQL
This data as json, copyable
0 records
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]);