Friday, July 30, 2021

Foreign Keys

 Trying to ge tused to inputing to sqlite. The first flights table uses text entries 

for origin and destination. I can redo this table using foreign keys, which adds more information.

I create a table of airports with airport code. Then my flights table - foreing keys - becomes

merely numbers in the origin and destination columns. Neat!!






https://www.sqlite.org/cli.html

No comments: