Hi,
How do you handle foreign keys ?
Do you create them when creating tables ? using a script (like generateForeignKeys.sql from stuff/script_to_generate_foreign_keys/) ?
In Compiere 3x, SynchronizeColumn process also generate FK.
What would be the best practice ?
Thanks and regards
Nicolas
Foreign key
Forum rules
This forum is personally pruned to avoid redundant posts. Related topics are grouped together. IF YOU HAVE REGISTERED, you need to send email to red1(a)red1.org with your username in the subject title to get me to activate you.
This forum is personally pruned to avoid redundant posts. Related topics are grouped together. IF YOU HAVE REGISTERED, you need to send email to red1(a)red1.org with your username in the subject title to get me to activate you.
3 posts
• Page 1 of 1
Foreign key
by nmicoud » Mon Oct 22, 2012 4:14 pm
- nmicoud
- Regular
- Posts: 137
- Joined: Fri Oct 07, 2011 6:19 pm
Re: Foreign key
by globalqss » Tue Oct 23, 2012 1:28 am
Hi Nicolas,
Usually I use the generateForeignKeys.sql on stuff
That could be done automatically on synchronize column - but I'm not sure if that's a good idea - it's easy to create the foreign key, but not so easy to delete it if you change the references, I mean if you change the column type or the ref table.
Regards,
Carlos Ruiz
Usually I use the generateForeignKeys.sql on stuff
That could be done automatically on synchronize column - but I'm not sure if that's a good idea - it's easy to create the foreign key, but not so easy to delete it if you change the references, I mean if you change the column type or the ref table.
Regards,
Carlos Ruiz
- globalqss
- Senior
- Posts: 599
- Joined: Thu Dec 29, 2005 4:15 am
- Location: Bogotá, Colombia
3 posts
• Page 1 of 1
Who is online
Users browsing this forum: No registered users and 2 guests