AW: extending existing tables
"Madl Alfred - Together AT" <[email protected]> Fri, 15 Apr 2005 19:22:24 +0200
| Newsgroups | gmane.comp.java.enhydra.dods |
|---|---|
| Message-ID | <[email protected]> |
This is a multi-part message in MIME format. ------=_NextPart_000_002A_01C541F0.73BF98E0 Content-Type: multipart/alternative; boundary="----=_NextPart_001_002B_01C541F0.73BF98E0" ------=_NextPart_001_002B_01C541F0.73BF98E0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable I would simply create a "normal" Teacher table having a foreign key (not null) to the User table and creating a unique index on the foreign key. =20 Greetings. =20 Alfred -----Urspr=FCngliche Nachricht----- Von: Oleg Lebedev [mailto:[email protected]]=20 Bereitgestellt: Freitag, 15. April 2005 18:19 Bereitgestellt in: DODS Unterhaltung: extending existing tables Betreff: [dods] extending existing tables 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_002B_01C541F0.73BF98E0 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"> <HTML><HEAD><TITLE>Nachricht</TITLE> <META http-equiv=3DContent-Type content=3D"text/html; = charset=3Diso-8859-1"> <META content=3D"MSHTML 6.00.2800.1491" name=3DGENERATOR></HEAD> <BODY> <DIV><SPAN class=3D342142117-15042005><FONT face=3DArial color=3D#0000ff = size=3D2>I=20 would simply create a "normal" Teacher table having a foreign key = (not=20 null) to the User table and creating a unique index on the foreign=20 key.</FONT></SPAN></DIV> <DIV><SPAN class=3D342142117-15042005><FONT face=3DArial color=3D#0000ff = size=3D2></FONT></SPAN> </DIV> <DIV><SPAN class=3D342142117-15042005><FONT face=3DArial color=3D#0000ff = size=3D2>Greetings.</FONT></SPAN></DIV> <DIV><SPAN class=3D342142117-15042005><FONT face=3DArial color=3D#0000ff = size=3D2></FONT></SPAN> </DIV> <DIV><SPAN class=3D342142117-15042005><FONT face=3DArial color=3D#0000ff = size=3D2>Alfred</FONT></SPAN></DIV> <BLOCKQUOTE dir=3Dltr style=3D"MARGIN-RIGHT: 0px"> <DIV></DIV> <DIV class=3DOutlookMessageHeader lang=3Dde dir=3Dltr = align=3Dleft><FONT face=3DTahoma=20 size=3D2>-----Urspr=FCngliche Nachricht-----<BR><B>Von:</B> Oleg = Lebedev=20 [mailto:[email protected]] <BR><B>Bereitgestellt:</B> Freitag, = 15.=20 April 2005 18:19<BR><B>Bereitgestellt in:</B> = DODS<BR><B>Unterhaltung:</B>=20 extending existing tables<BR><B>Betreff:</B> [dods] extending existing = tables<BR><BR></FONT></DIV> <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=20 like Teacher.objectid to be the foreign key to the table Used. = However, this=20 would lead to rows in the table Teacher have the = same objectids=20 as rows in the table User. I remember that starting with = DODS 5.X=20 all objectids should be unique across the whole database. = </FONT></SPAN></DIV> <DIV><SPAN class=3D431271316-15042005><FONT face=3DVerdana = size=3D2>So, what would=20 be 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></BLOCKQUOTE></BODY></HTML> ------=_NextPart_001_002B_01C541F0.73BF98E0-- ------=_NextPart_000_002A_01C541F0.73BF98E0 Content-Type: application/x-pkcs7-signature; name="smime.p7s" Content-Transfer-Encoding: base64 Content-Disposition: attachment; filename="smime.p7s" MIAGCSqGSIb3DQEHAqCAMIACAQExCzAJBgUrDgMCGgUAMIAGCSqGSIb3DQEHAQAAoIII2jCCAmIw ggHLoAMCAQICAw1A8DANBgkqhkiG9w0BAQQFADBiMQswCQYDVQQGEwJaQTElMCMGA1UEChMcVGhh d3RlIENvbnN1bHRpbmcgKFB0eSkgTHRkLjEsMCoGA1UEAxMjVGhhd3RlIFBlcnNvbmFsIEZyZWVt YWlsIElzc3VpbmcgQ0EwHhcNMDQxMDE5MDc1NzQ5WhcNMDUxMDE5MDc1NzQ5WjBZMQ0wCwYDVQQE EwRNYWRsMQ8wDQYDVQQqEwZBbGZyZWQxFDASBgNVBAMTC0FsZnJlZCBNYWRsMSEwHwYJKoZIhvcN AQkBFhJBLk1hZGxAdG9nZXRoZXIuYXQwgZ8wDQYJKoZIhvcNAQEBBQADgY0AMIGJAoGBANBysalC vUvBkSMAcjYIBji1JSF0AtToJTTnj2ak2HS7Do06vpurKaJtp2CLetqjHbz4az/FvN75HegNzpa1 gcZzfsbZQteeeuB5q7OaitlDWOX4Ad5kwPtImdwLFpYR4un8y3yTNDnssObj0M4A0Sq4+SgY96Fu NQYNn3YdzgP9AgMBAAGjLzAtMB0GA1UdEQQWMBSBEkEuTWFkbEB0b2dldGhlci5hdDAMBgNVHRMB Af8EAjAAMA0GCSqGSIb3DQEBBAUAA4GBAAwOwJ4CJilXbe6h93SLmu+95WF5KqvNG8928OkZzNNK 5wIRyvfyhA7pdKC3h6at2Hl+HPYSgI9+ksthiolsj5jYgv2LqSW4RmICjJo9pIq7Dx9oIYJehH87 zFU4OPPAl0AM+ZgWrIPyT7hjanMU529LhvPxyGYs11yyek+4MTVsMIIDLTCCApagAwIBAgIBADAN BgkqhkiG9w0BAQQFADCB0TELMAkGA1UEBhMCWkExFTATBgNVBAgTDFdlc3Rlcm4gQ2FwZTESMBAG A1UEBxMJQ2FwZSBUb3duMRowGAYDVQQKExFUaGF3dGUgQ29uc3VsdGluZzEoMCYGA1UECxMfQ2Vy dGlmaWNhdGlvbiBTZXJ2aWNlcyBEaXZpc2lvbjEkMCIGA1UEAxMbVGhhd3RlIFBlcnNvbmFsIEZy ZWVtYWlsIENBMSswKQYJKoZIhvcNAQkBFhxwZXJzb25hbC1mcmVlbWFpbEB0aGF3dGUuY29tMB4X DTk2MDEwMTAwMDAwMFoXDTIwMTIzMTIzNTk1OVowgdExCzAJBgNVBAYTAlpBMRUwEwYDVQQIEwxX ZXN0ZXJuIENhcGUxEjAQBgNVBAcTCUNhcGUgVG93bjEaMBgGA1UEChMRVGhhd3RlIENvbnN1bHRp bmcxKDAmBgNVBAsTH0NlcnRpZmljYXRpb24gU2VydmljZXMgRGl2aXNpb24xJDAiBgNVBAMTG1Ro YXd0ZSBQZXJzb25hbCBGcmVlbWFpbCBDQTErMCkGCSqGSIb3DQEJARYccGVyc29uYWwtZnJlZW1h aWxAdGhhd3RlLmNvbTCBnzANBgkqhkiG9w0BAQEFAAOBjQAwgYkCgYEA1GnX1LCUZFtx6UfYDFG2 6nKRsIRefS0Nj3sS34UldSh0OkIsYyeflXtL734Zhx2G6qPduc6WZBrCFG5ErHzmj+hND3EfQDim AKOHePb5lIZererAXnbr2RSjXW56fAylS1V/Bhkpf56aJtVquzgkCGqYx7Hao5iR/Xnb5VrEHLkC AwEAAaMTMBEwDwYDVR0TAQH/BAUwAwEB/zANBgkqhkiG9w0BAQQFAAOBgQDH7JJ+Tvj1lqVnYiqk 8E0RYNBvjWBYYawmu1I1XAjPMPuoSpaKH2JCI4wXD/S6ZJwXrEcp352YXtJsYHFcoqzceePnbgBH H7UNKOgCneSa/RP0ptl8sfjcXyMmCZGAc9AUG95DqYMl8uacLxXK/qarigd1iwzdUYRr5PjRznei gTCCAz8wggKooAMCAQICAQ0wDQYJKoZIhvcNAQEFBQAwgdExCzAJBgNVBAYTAlpBMRUwEwYDVQQI EwxXZXN0ZXJuIENhcGUxEjAQBgNVBAcTCUNhcGUgVG93bjEaMBgGA1UEChMRVGhhd3RlIENvbnN1 bHRpbmcxKDAmBgNVBAsTH0NlcnRpZmljYXRpb24gU2VydmljZXMgRGl2aXNpb24xJDAiBgNVBAMT G1RoYXd0ZSBQZXJzb25hbCBGcmVlbWFpbCBDQTErMCkGCSqGSIb3DQEJARYccGVyc29uYWwtZnJl ZW1haWxAdGhhd3RlLmNvbTAeFw0wMzA3MTcwMDAwMDBaFw0xMzA3MTYyMzU5NTlaMGIxCzAJBgNV BAYTAlpBMSUwIwYDVQQKExxUaGF3dGUgQ29uc3VsdGluZyAoUHR5KSBMdGQuMSwwKgYDVQQDEyNU aGF3dGUgUGVyc29uYWwgRnJlZW1haWwgSXNzdWluZyBDQTCBnzANBgkqhkiG9w0BAQEFAAOBjQAw gYkCgYEAxKY8VXNV+065yplaHmjAdQRwnd/p/6Me7L3N9VvyGna9fww6YfK/Uc4B1OVQCjDXAmNa LIkVcI7dyfArhVqqP3FWy688Cwfn8R+RNiQqE88r1fOCdz0Dviv+uxg+B79AgAJk16emu59l0cUq VIUPSAR/p7bRPGEEQB5kGXJgt/sCAwEAAaOBlDCBkTASBgNVHRMBAf8ECDAGAQH/AgEAMEMGA1Ud HwQ8MDowOKA2oDSGMmh0dHA6Ly9jcmwudGhhd3RlLmNvbS9UaGF3dGVQZXJzb25hbEZyZWVtYWls Q0EuY3JsMAsGA1UdDwQEAwIBBjApBgNVHREEIjAgpB4wHDEaMBgGA1UEAxMRUHJpdmF0ZUxhYmVs Mi0xMzgwDQYJKoZIhvcNAQEFBQADgYEASIzRUIPqCy7MDaNmrGcPf6+svsIXoUOWlJ1/TCG4+DYf qi2fNi/A9BxQIJNwPP2t4WFiw9k6GX6EsZkbAMUaC4J0niVQlGLH2ydxVyWN3amcOY6MIE9lX5Xa 9/eH1sYITq726jTlEBpbNU1341YheILcIRk13iSx0x1G/11fZU8xggMcMIIDGAIBATBpMGIxCzAJ BgNVBAYTAlpBMSUwIwYDVQQKExxUaGF3dGUgQ29uc3VsdGluZyAoUHR5KSBMdGQuMSwwKgYDVQQD EyNUaGF3dGUgUGVyc29uYWwgRnJlZW1haWwgSXNzdWluZyBDQQIDDUDwMAkGBSsOAwIaBQCgggIJ MBgGCSqGSIb3DQEJAzELBgkqhkiG9w0BBwEwHAYJKoZIhvcNAQkFMQ8XDTA1MDQxNTE3MjIyM1ow IwYJKoZIhvcNAQkEMRYEFPT2V/rdi/M0/GnEnIwHcdUTsD8PMEsGCyqGSIb3DQEJEAIBMTwwOgQd AAAAABAAAADl6Oy8bEkLTp2XiPOmCYxEAQAAAACAAQAwFjAUgRJBLk1hZGxAdG9nZXRoZXIuYXQw ZwYJKoZIhvcNAQkPMVowWDAKBggqhkiG9w0DBzAHBgUrDgMCGjAOBggqhkiG9w0DAgICAIAwDQYI KoZIhvcNAwICAUAwBwYFKw4DAgcwDQYIKoZIhvcNAwICASgwCgYIKoZIhvcNAgUweAYJKwYBBAGC NxAEMWswaTBiMQswCQYDVQQGEwJaQTElMCMGA1UEChMcVGhhd3RlIENvbnN1bHRpbmcgKFB0eSkg THRkLjEsMCoGA1UEAxMjVGhhd3RlIFBlcnNvbmFsIEZyZWVtYWlsIElzc3VpbmcgQ0ECAw1A8DB6 BgsqhkiG9w0BCRACCzFroGkwYjELMAkGA1UEBhMCWkExJTAjBgNVBAoTHFRoYXd0ZSBDb25zdWx0 aW5nIChQdHkpIEx0ZC4xLDAqBgNVBAMTI1RoYXd0ZSBQZXJzb25hbCBGcmVlbWFpbCBJc3N1aW5n IENBAgMNQPAwDQYJKoZIhvcNAQEBBQAEgYCcaN+gumP5omPg/EdE8vBX9Rpp/vJ14y+eaR3AomnZ 8aysDI0AhfCLnuFaGQQbTxD5gronfJZcojbaSKHrfB0xlK4roRTeCiiVtSKKJ/Qvg8tiytwlVGyN Gq8WXA+vNzMnrB6bDkbaTv5KJVg9zDWXPqUrekRAvIOobvauLgcbBgAAAAAAAA== ------=_NextPart_000_002A_01C541F0.73BF98E0--