this information looks like a many to many relationship. It looks like when a package is installed it gets added to
. Then when ubuntu gets upgraded the original source gets commented out if it's not a source ubuntu knows about. At this point the only source for a package might be the status file. Then when you uncomment out the source it will appear in the
table since it parses the files but
still won't say that's where a package is from until you run
. Seems complicated. I guess if I were implementing this I would make a new table to join
somehow then add a column to
that says if and how long ago the index for that source has been updated in order to show that the information in the new table might be wrong. I'm not really sure though.