On 22/07/08 at 23:06 +0200, Christian von Essen wrote: > On Tue, Jul 22, 2008 at 03:31:58PM -0500, Raphael Geissert wrote: > > > > Hi, > > > > Is the database structure available somewhere? In a nice presentation format > > I mean :) > > Not yet, as it is not in any way final :) > > > > > The above question is because I don't understand very well why the name of > > the table in this case is popcon_max; instead of something like popcon > > where the package's popcon history is stored where the max values could be > > gathered using MAX() > > > > There is a table named popcon, structured (package, vote, old, recent, > nofiles). Here package names a binary package. > > popcon_max on the other hand has (package, score) as the structure, > and here package names a source package. > popcon_max actually is a view. For line (<package>, <score>), <score> is the > maximum popcon score of all binaries build from source <package>.
Maybe it would make sense to name it popcon_source or popcon_src. popcon_max is indeed not very clear :-) -- | Lucas Nussbaum | [EMAIL PROTECTED] http://www.lucas-nussbaum.net/ | | jabber: [EMAIL PROTECTED] GPG: 1024D/023B3F4F | -- To UNSUBSCRIBE, email to [EMAIL PROTECTED] with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]
