Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> comp.databases.theory -> Re: Foreign key problem

Re: Foreign key problem

From: <frebe73_at_gmail.com>
Date: 13 Jun 2006 06:13:37 -0700
Message-ID: <1150204417.457677.172490@g10g2000cwb.googlegroups.com>


> I can tell you how we did it, and perhaps this will help.
>
> Our tables look more like this:
>
> TABLEINFO (*table_name)
> COLUMNINFO (*table_name, *col_name)
> FK (*table_name,*table_name_par)
>
> TABFLAT(*table_name,*col_name)
>
> A table is defined by making entries into either COLUMNINFO or FK. You put
> non-FK columns into a table by making entries into COLUMNINFO.
>
> When an entry is made into FK, it establishes a foreign key but it also adds
> columns to the child table.

Columns in the fk (child) table need to have the same name as in the primary table, or?

/Fredrik Received on Tue Jun 13 2006 - 08:13:37 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US