<![CDATA[FrontAccounting forum — DB-referential integrity]]> https://frontaccounting.com/punbb/viewtopic.php?id=10536 Sat, 29 Jun 2024 18:20:51 +0000 PunBB <![CDATA[Re: DB-referential integrity]]> https://frontaccounting.com/punbb/viewtopic.php?pid=43220#p43220 Yes you can use Foreign Keys.
FA uses Foreign Keys but not at DB Level.
The referential Integrity is maintained through Code

]]> Sat, 29 Jun 2024 18:20:51 +0000 https://frontaccounting.com/punbb/viewtopic.php?pid=43220#p43220 <![CDATA[DB-referential integrity]]> https://frontaccounting.com/punbb/viewtopic.php?pid=43154#p43154 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

]]> Thu, 13 Jun 2024 23:03:05 +0000 https://frontaccounting.com/punbb/viewtopic.php?pid=43154#p43154