<![CDATA[FrontAccounting forum — DB-referential integrity]]> 2024-06-29T18:20:51Z PunBB https://frontaccounting.com/punbb/viewtopic.php?id=10536 <![CDATA[Re: DB-referential integrity]]> Yes you can use Foreign Keys.
FA uses Foreign Keys but not at DB Level.
The referential Integrity is maintained through Code

]]> https://frontaccounting.com/punbb/profile.php?id=20175 2024-06-29T18:20:51Z https://frontaccounting.com/punbb/viewtopic.php?pid=43220#p43220 <![CDATA[DB-referential integrity]]> Hi everyone
I know that FA uses InnoDb engine and InnoDb can use foreign keys to ensure database integrity, so, I want to know why FA 2.4 doesn't use foreign keys, and I also want to know if there is any problem if I create foreign keys to implement referential integrity at database level.

Regards

]]> https://frontaccounting.com/punbb/profile.php?id=47960 2024-06-13T23:03:05Z https://frontaccounting.com/punbb/viewtopic.php?pid=43154#p43154