home / train

file

6 rows where patch_id = 38430

✎ View and edit SQL

This data as json, CSV (advanced)

id ▼ patch_id filename
177431 38430 38430 .gitignore
177432 38430 38430 .phan/config.php
177433 38430 38430 composer.json
177434 38430 38430 includes/Babel.php
177435 38430 38430 includes/BabelLanguageCodes.php
177436 38430 38430 tests/phan/config.php

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options:

CREATE TABLE file (
            id INTEGER PRIMARY KEY,
            patch_id INTEGER NOT NULL,
            filename INTEGER NOT NULL,
            FOREIGN KEY(patch_id) REFERENCES patch(id)
        );
CREATE INDEX file_patch_id ON file(patch_id);
Powered by Datasette · Queries took 16.801ms