extending existing tables
"Oleg Lebedev" <[email protected]> Fri, 15 Apr 2005 10:19:24 -0600
| Newsgroups | gmane.comp.java.enhydra.dods |
|---|---|
| Message-ID | <[email protected]> |
This is a multi-part message in MIME format. ------_=_NextPart_001_01C541D6.E3501251 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable I would like to create a table Teacher, which "extends" table User. In other words, I would like Teacher.objectid to be the foreign key to the table Used. However, this would lead to rows in the table Teacher have the same objectids as rows in the table User. I remember that starting with DODS 5.X all objectids should be unique across the whole database.=20 So, what would be the best way to model the "extending" table using DODS? Thanks. Oleg ------_=_NextPart_001_01C541D6.E3501251 Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"> <HTML><HEAD><TITLE>Message</TITLE> <META http-equiv=3DContent-Type content=3D"text/html; charset=3Dus-ascii"> <META content=3D"MSHTML 6.00.2800.1491" name=3DGENERATOR></HEAD> <BODY> <DIV><SPAN class=3D431271316-15042005><FONT face=3DVerdana size=3D2>I would= like to=20 create a table Teacher, which "extends" table User. In other words, I would= like=20 Teacher.objectid to be the foreign key to the table Used. However, this wou= ld=20 lead to rows in the table Teacher have the same objectids as = ;rows=20 in the table User. I remember that starting with DODS 5.X all objectid= s=20 should be unique across the whole database. </FONT></SPAN></DIV> <DIV><SPAN class=3D431271316-15042005><FONT face=3DVerdana size=3D2>So, wha= t would be=20 the best way to model the "extending" table using DODS?</FONT></SPAN></DIV> <DIV><SPAN class=3D431271316-15042005><FONT face=3DVerdana=20 size=3D2>Thanks.</FONT></SPAN></DIV> <DIV><SPAN class=3D431271316-15042005><FONT face=3DVerdana=20 size=3D2><BR>Oleg</FONT></SPAN></DIV></BODY></HTML> =00 ------_=_NextPart_001_01C541D6.E3501251--