Re: Alpha coordination and building
On Fri, 11 Jun 1999, Bart Warmerdam wrote:
> Possible dB model:
>
>
> Packages
> ---------------------
>
> +--- pkgID long PK
> | pkgName text
> | pgkVersion text
> | pkgDebRelease text
> | pkgBuildsOk bool
> | dateInstall date/time
> | uploader text (example: Bart Warmerdam <bartw@xs4all.nl>)
> | btsNotificationDate date/time
> |
> |
> | ReportedBugs
> | ---------------------
> |
> | btsBugNr long PK
> +--- pkgID long
> |
> |
> | Patches
> | ---------------------
> |
> | bugID long PK
> +--- pkgID long
> url text
Wouldn't it make more sense to put the btsNotificationDate field in the
ReportedBugs table? Maybe just the sheer existance of a record in
ReportedBugs for a package could be enough to trigger a checkbox or "View
Bug Report Info" button on a query reponce.
C
Reply to: