Quote:
Originally Posted by Damix2
Just in general a 'sub-table' in a ERD is just 2 tables in a parent-child relationship. The child will always hold the foreign key to point towards the parent, not entirely sure why you are getting an error.
Sorry, my help was fairly useless.
|
Does the following link give any valuable information?
http://sqlite.org/omitted.html
More specifically, this bit on foreign-key constraints:
Quote:
|
FOREIGN KEY constraints are parsed but are not enforced. However, the equivalent constraint enforcement can be achieved using triggers. The SQLite source tree contains source code and documentation for a C program that will read an SQLite database, analyze the foreign key constraints, and generate appropriate triggers automatically.
|