Foreign keys

From: Sami Mohammed (SMOHAMME..ndependenthealth.com)
Date: Fri Mar 18 2005 - 11:28:40 EST

  • Next message: Holger Hoffstätte: "Re: orderby on tomany relation"

    My tables structure are given below:

    1. User_table
    user_key number primary key,
    user_id varchar,
    F&Lname varchar,
    psswd varchar,
    lastLogin date,
    ActiveFlag char(1)
    sec_master_key number referening to security_master_table(sec_master_key ) or foreign key

    2.sec_master_Table Table:
    sec_master_key number primarykey,
    description varchar,
    err_role_key number foreign key refering to table err_role_table,
    cw_role key number foreign key refering to table cw_role_table,
    last_chng_date date.

    3.err_role_table
    err_role_key number primary key,
    err_role_id varchar,
    err_role_description,
    last_chng_date date

    4. cw_role_table
    cwr_role_key number primary key,
    cw_role_id varchar,
    errcw
    last_chng_date date.

    i have question:

    in the above table structure if we remove the foreign keys and maintain the relationship using in the application, is it possible. My db analyst ask me to maintain in webappliction

    i saw in ur tutorial and tutoriadb file in that also u dont have any foreign key relationship for ARTIST, GALLERY and PAINTING tables.
    But in the datamap.map file, i saw relationship. was it done manually or what. I am using the techonolgy for quite some time, but still i am not strong, may be i am asking some silly question. sorry for that.

    see below for db-relationship

    <db-relationship name="paintingArray" source="ARTIST" target="PAINTING" toMany="true">
                    <db-attribute-pair source="ARTIST_ID" target="ARTIST_ID"/>
            </db-relationship>
            <db-relationship name="paintingArray" source="GALLERY" target="PAINTING" toMany="true">
                    <db-attribute-pair source="GALLERY_ID" target="GALLERY_ID"/>
            </db-relationship>
            <db-relationship name="toArtist" source="PAINTING" target="ARTIST" toMany="false">
                    <db-attribute-pair source="ARTIST_ID" target="ARTIST_ID"/>
            </db-relationship>
            <db-relationship name="toGallery" source="PAINTING" target="GALLERY" toMany="false">
                    <db-attribute-pair source="GALLERY_ID" target="GALLERY_ID"/>
            </db-relationship>
            <obj-relationship name="paintingArray" source="Artist" target="Painting" db-relationship-path="paintingArray"/>
            <obj-relationship name="paintingArray" source="Gallery" target="Painting" db-relationship-path="paintingArray"/>
            <obj-relationship name="toArtist" source="Painting" target="Artist" db-relationship-path="toArtist"/>
            <obj-relationship name="toGallery" source="Painting" target="Gallery" db-relationship-path="toGallery"/>

    CONFIDENTIALITY NOTICE. This e-mail and attachments, if any, may contain confidential information which is privileged and protected from disclosure by Federal and State
    confidentiality laws rules and regulations. This e-mail and attachments, if any, are intended for the designated addressee only. If you are not the designated addressee, you
    are hereby notified that any disclosure, copying, or distribution of this e-mail and its attachments, if any, may be unlawful and may subject you to legal consequences. If you
    have received this e-mail and attachments in error, please contact Independent Health immediately at (716) 631-3001 and delete the e-mail and its attachments from your
    computer. Thank you for your attention

    This archive was generated by hypermail 2.0.0 : Fri Mar 18 2005 - 11:29:05 EST