Dear Nikita, Thank you for this workaround, it seems to work.
> Just checked dbimport with sqlite, seems like driver still skips part > of the information about foreign keys (or rather quite strictly > follows the definition of the table). I don't think it is an issue with the driver. I think something is not configured properly in Cayenne, or we are still missing some setting in Cayenne. I use org.xerial:sqlite-jdbc:RELEASE version 3.36.0.3 from Maven Central, and the original sqlite database is handled properly in DBeaver. For example the foreign key information is properly displayed on the ER Diagram, etc. If DBeaver can do it, then it is not an issue with the driver. As I said in my previous email, one has to explicitly turn on the foreign key support, which I did for this driver (connection). Apart from that, I haven't changed anything. Ali
