Re: Bug#703402: PTS: link to the blends website for packages involved in blends

[Michael Banck <mbanck@debian.org>]

On Wed, Mar 20, 2013 at 05:05:33PM +0100, Andreas Tille wrote:
> Well, machine readable file is one thing.  At first we need to define
> the SQL table layout.  Currently the philosophy in UDD is to have the
> tables not normalised but I think it makes sense to normalise to some
> extend into three tables because it simplifies things we intend to do:
> 
>   CREATE TABLE blends_packages (
>   -- fieldname  type,   --  example_value
>      blend      TEXT REFERENCES blends_metadata,
>      task       TEXT REFERENCES blends_tasks,
>      package    TEXT,   --  'gromacs'

Shouldn't/couldn't that be a foreign key to a general binary-packages
table, assuming that exists?

>      PRIMARY KEY (blend, task, package)
>   )


Michael