This data as json, CSV (advanced)
id ▼ | table_id | name |
---|---|---|
63 | Mobile_Food_Facility_Permit_fts 15 | Applicant |
64 | Mobile_Food_Facility_Permit_fts 15 | FacilityType |
65 | Mobile_Food_Facility_Permit_fts 15 | Address |
66 | Mobile_Food_Facility_Permit_fts 15 | LocationDescription |
67 | Mobile_Food_Facility_Permit_fts 15 | FoodItems |
JSON shape: default, array, newline-delimited, object
CREATE TABLE columns ( id integer PRIMARY KEY, table_id integer, name text, FOREIGN KEY (table_id) REFERENCES tables(id) );