![]() ![]() My actual sql is (returns an exception 'foreign key mismatch - "diseases" referencing "beehives". ![]() How or where should i put the multiple foreign key constrain using the GUI ? The problem is when you want to use a multiple foreign key. I know that if you want to insert a foreign key using the GUI, you just have to scroll to the right and double click to insert the foreign key to the corresponding field. Primary keys become foreign keys in other tables, when creating relations among tables. SWAT+ contains many links between files, and the database follows suit by creating foreign key relationships where applicable. ![]() I am using SQLite and DB Browser for SQLite. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |