DevOps, CI/CD and Automation

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

I need to have multiple foreign keys on one column, can Designer do this?..

pekelly-OracleJan 29 2003 — edited Jan 29 2003

Basically I've a table that needs to link to three other tables. As far as I can tell Designer will only let me have the foreign keys on seperate columns;

Column_1 - FK1
Column_2 - FK2
Column_3 - FK3

I think it's a much better database design is to have all three link to one column and have a Type column denoting which table to references

Column_1 - FK1, FK2, FK3
Column_2 - Type (FK1, FK2, FK3)

Locked Post

New comments cannot be posted to this locked post.

Locked on Feb 26 2003

Added on Jan 29 2003

#designer

1 comment

307 views