Date: Thu, 26 Aug 2004 21:23:49 -0400 From: "Dan Langille" <dan@langille.org> To: freebsd-vuxml@freebsd.org Subject: FreshPorts - VuXML tables - diagram Message-ID: <412E54E5.5382.6016DEA@localhost>
next in thread | raw e-mail | index | archive | help
Here's the diagram of the tables I'm considering. This should duplicate the entire contents of the VuXML table. http://beta.freshports.org/tmp/FreshPorts-VuXML-tables.jpg The commit_log_ports_vuxml table relates each entry in the vuxml table to one or more commits and to specific ports within that commit. The actual PORTREVISION, PORTVERSION, PORTEPOCH etc, are stored in another table (commit_log_ports), which is not shown. Why another table just for vuxml? It keep the vuxml separate from the FreshPorts data. The table I would put this information it is the commit_log_ports table (which has about 138,718 rows). I expect the commit_log_ports_vuxml table to have about 1000 rows (i.e. significantly less rows). I'd consider merging the data if the number of vuxml rows started to approach 30% of commit_log_ports... but I don't see that happening. cheers -- Dan Langille : http://www.langille.org/
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?412E54E5.5382.6016DEA>