Le 19.06.2006 18:29, DongInn Kim a écrit :
Hi Jean,
I finally saw your scheme. Thank you for posting your idea. :-)
BTW, I have a question for you.
What relation are "Package_servicelists" and "Package_rpmlists" involved
in between "Groups" and "Packages" entities?
In my scheme, there should not be any relationship that they can make
from the two entities (Groups and Packages) .
Any reason to have the two realtions (Package_servicelists and
Package_rpmlists) betwen Groups and Packages?
In the script oscar_table.sql, I have the following:
CREATE TABLE IF NOT EXISTS Packages_rpmlists(
...
CONSTRAINT Packages_rpmlists_ibfk_1 FOREIGN KEY (package_id)
REFERENCES Packages (id) ON DELETE CASCADE,
CONSTRAINT Packages_rpmlists_ibfk_2 FOREIGN KEY (group_name)
REFERENCES Groups (name) ON DELETE CASCADE ON UPDATE CASCADE
)TYPE=INNODB;
CREATE TABLE IF NOT EXISTS Packages_servicelists(
...
CONSTRAINT Packages_servicelists_ibfk_1 FOREIGN KEY (package_id)
REFERENCES Packages (id) ON DELETE CASCADE,
CONSTRAINT Packages_servicelists_ibfk_2 FOREIGN KEY (group_name)
REFERENCES Groups (name) ON DELETE CASCADE ON UPDATE CASCADE
)TYPE=INNODB;
Btw, for performance issues, it is not good to reference a VARCHAR
column (Groups(name)). Furthermore, the Groups table has an 'id' column.
Regards, Jean
Regards,
- DongInn
Jean Parpaillon wrote:
Hi,
I've just uploaded a new version of the ODA relationnal outline.
It's on the wiki:
http://svn.oscar.openclustergroup.org/trac/oscar/attachment/wiki/DevODA_architecture/oscar_oda.svg
For those who have issues with svg, here it is a png version:
http://svn.oscar.openclustergroup.org/trac/oscar/attachment/wiki/DevODA_architecture/oscar_oda.png
Regards, Jean
Le 16.06.2006 17:33, Jean Parpaillon a écrit :
Hi,
I've made an up-to-date relationnal schema of OSCAR ODA. May it be
included in the trac wiki :
http://svn.oscar.openclustergroup.org/trac/oscar/wiki/DevODA_architecture
?
Regards, Jean
--
------------------------------------------------------------------------
Kerrighed inside
http://www.kerrighed.org/
------------------------------------------------------------------------
Jean PARPAILLON - Engineer - PARIS group - Office E217
IRISA-INRIA, Campus de Beaulieu, 35042 Rennes cedex, France
Tél: +33 2 99 84 22 33, Fax: +33 2 99 84 71 71
begin:vcard
fn:Parpaillon Jean
n:Jean;Parpaillon
org:IRISA - INRIA;Kerrighed Project
adr:;;Campus de Beaulieu;Rennes Cedex;;35042;France
email;internet:[EMAIL PROTECTED]
tel;work:+33299842233
tel;fax:+33299847171
version:2.1
end:vcard
_______________________________________________
Oscar-devel mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/oscar-devel
