Re: foreing key .. reference..

On Sat, 2003-02-22 at 12:13, Andres Ledesma wrote:
> Hi evbody...
>
> Could anybody give me an example of foreing key ..references example ?


Here is an example from one of our applications.

Regards,
                    Andrew.

---------------------------
-- Contact Details
---------------------------
CREATE TABLE contact (
  contact_id INT4,
  name TEXT,
  address1 TEXT,
  address2 TEXT,
  city TEXT,
  state TEXT,
  country TEXT,
  postcode TEXT,
  phone TEXT,                    -- format is "+<contrycode>
(<areacode>) <localnumber>"
  fax TEXT,                      -- format is "+<contrycode>
(<areacode>) <localnumber>"
  email TEXT,
  PRIMARY KEY ( contact_id )
);


---------------------------
-- Registrar Details
---------------------------
CREATE TABLE registrar (
  registrar_id INT4,
  p_contactid INT4,
  d_contactid INT4,
  s_contactid INT4,
  registrar_name TEXT,
  commenced TIMESTAMP,
  PRIMARY KEY ( registrar_id ),
  CONSTRAINT p_contact_of_contact FOREIGN KEY ( p_contactid ) REFERENCES
contact,
  CONSTRAINT d_contact_of_contact FOREIGN KEY ( d_contactid ) REFERENCES
contact,
  CONSTRAINT s_contact_of_contact FOREIGN KEY ( s_contactid ) REFERENCES
contact
);


--
---------------------------------------------------------------------
Andrew @ Catalyst .Net.NZ Ltd, PO Box 11-053, Manners St,  Wellington
WEB: http://catalyst.net.nz/         PHYS: Level 2, 150-154 Willis St
DDI: +64(4)916-7201     MOB: +64(21)635-694    OFFICE: +64(4)499-2267
           Survey for nothing with http://survey.net.nz/
---------------------------------------------------------------------