This is an example table spec.

Table schema

Name Type Description
name TEXT Description for name column
points INTEGER This is a signed SQLite int column
size BIGINT This is a signed SQLite bigint column
action TEXT Action performed in generation
id INTEGER An index of some sort
path TEXT Path of example

Query examples

select * from example where id = 1
select name from example where action = 'new'
select e.* from example e, example_environments ee where e.id = ee.id