.separator " "
CREATE TABLE movies(id TEXT PRIMARY KEY, title TEXT, year INT, rating REAL);
CREATE TABLE persons(id TEXT PRIMARY KEY, name TEXT, birth_date DATE);
CREATE TABLE roles(movie_id TEXT REFERENCES movies(id), person_id TEXT REFERENCES persons(id));
.import --skip 1 movies.tsv movies
.import --skip 1 persons.tsv persons
.import --skip 1 roles.tsv roles