builds

3 rows where job_id = 26

✎ View and edit SQL

This data as json, CSV (advanced)

CREATE TABLE builds (
            id INTEGER PRIMARY KEY,
            timestamp INTEGER NOT NULL,
            time REAL NOT NULL,
            result TEXT,
            build_id INTEGER NOT NULL,
            url TEXT UNIQUE NOT NULL,
            repo TEXT NOT NULL,
            branch TEXT NOT NULL,
            sha TEXT NOT NULL,
            host TEXT NOT NULL,
            job_id INTEGER NOT NULL,
            uses_success_cache BOOLEAN,
            success_cache_hit BOOLEAN,
            UNIQUE(build_id,job_id),
            CONSTRAINT result_check CHECK (result IN ('SUCCESS', 'FAILURE', 'ABORTED', 'UNSTABLE', 'NOT_BUILT', NULL)),
            FOREIGN KEY(job_id) REFERENCES jobs(id)
        );