AppGini does not allow a field to be Foreign Key and Unique Key at the same time.
- Unique.gif (7.57 KiB) Viewed 4963 times
Set the field as Foreign in AppGini
Set the field as Unique in PhpMyAdmin
Problem solved.
Foreign Key and Unique Key at the same time
Foreign Key and Unique Key at the same time
Problem:
AppGini does not allow a field to be Foreign Key and Unique Key at the same time.
Solution:
Set the field as Foreign in AppGini
Set the field as Unique in PhpMyAdmin
Problem solved.
AppGini does not allow a field to be Foreign Key and Unique Key at the same time.
Solution:
Set the field as Foreign in AppGini
Set the field as Unique in PhpMyAdmin
Problem solved.
AppGini 22.14 - xampp 3.3.0 - PHP 7.4.30 - Summary reports - Calendar - Mass update - Messages - AppGiniHelper
Re: Foreign Key and Unique Key at the same time
I'll modify this restriction in future releases ... notice that this (foreign key AND unique) would create a one-to-one relation between the two tables rather than one-to-many.
AppGini plugins to add more power to your apps:
- DataTalk is an innovative AppGini plugin based on ChatGPT that allows you to interact with your AppGini database using natural language questions, without writing any SQL. Check the demo video
- Check our other plugins and get a generous discount of up to 30% when buying 2 or more plugins.
- Need personalized consulting on your specific app and customizations? Book an online call with me here.
Re: Foreign Key and Unique Key at the same time
Thanks for alerting about this.
But in my case it is exactly what I need to do in this table.
But in my case it is exactly what I need to do in this table.
AppGini 22.14 - xampp 3.3.0 - PHP 7.4.30 - Summary reports - Calendar - Mass update - Messages - AppGiniHelper