I am getting this error when trying to add references. I just assume that’s the way to structure the database, hoping to learn later on how to manage the data in the tables. Am I missing something here?
It looks like when I remove the enumerations (the numbers that I added 01_ 02_ etc) that it works fine.
A name of a table for SQLite shouldn’t start with a number. More on this here:
1 Like
Update: I saw that a user on stack overflow claims that names like that are allowed as long as they are in quotes. So maybe the devs could try and implement something like that to happen automatically in case this is true. Just a suggestion.
Yes I was thinking the same. Although indeed we should escape those names better, it is not wise to have table and column and names starting with numbers and using spaces.
Best convention is to use all lowercase, start with letter and use underscore between words.
1 Like