This table is taken from src.DataDictionary
| Alternatives |
altname |
Name of a group of alternative packages. Any package in this group satisfies the dependency |
| Alternatives |
id |
Package ID, an integer signifying a version of a package |
| Alternatives |
optname |
Foreign key to Options.name |
| Alternatives |
pkgname |
Name of a package (without a version number) on which the Package may depend |
| Categories |
category |
Category to which the package belongs |
| Categories |
id |
Package ID, an integer signifying a version of a package |
| Conflicts |
groupname |
[probably should be just another ID] |
| Conflicts |
how |
Conflicts either only with that particular package, or any whose version is greater or lesser |
| Conflicts |
id |
Package ID, an integer signifying a version of a package |
| Dependencies |
canover_max |
(exclusive) maximum canonical version (cf. Packages) that satisfies the dependency |
| Dependencies |
canover_min |
minimum canonical version (cf. Packages) that satisfies the dependency |
| Dependencies |
dep |
The Package ID upon which this ID depends |
| Dependencies |
how |
Depends either only with that particular package, or any whose version is greater or lesser |
| Dependencies |
id |
Package ID, an integer signifying a version of a package |
| Dependencies |
optname |
Foreign key to Options.name |
| Dependencies |
pkgname |
Name of a package (without a version number) on which the Package may depend |
| Descriptions |
id |
Package ID, an integer signifying a version of a package |
| Descriptions |
iline |
Line number of the DESCR file |
| Descriptions |
text |
Line of text from the DESCR file |
| Distfiles |
id |
Package ID, an integer signifying a version of a package |
| Distfiles |
localname |
Name of distribution file as stored locally |
| Distfiles |
md5 |
MD5 digest of the distribution file |
| Distfiles |
name |
Name of distribution file |
| Distfiles |
optname |
Foreign key to Options.name |
| Options |
id |
Package ID, an integer signifying a version of a package |
| Options |
name |
Name of the option, e.g. '--prefix' |
| Options |
status |
One of: 'recommended', 'required', 'optional' |
| Options |
type |
One of: 'configure', 'install' |
| Options |
value |
Value of the option, e.g. '/usr/pkg' |
| Packages |
canover |
"canonical version" a lexically sortable string derived from the packages's version |
| Packages |
comment |
1-line short description of Package |
| Packages |
homepage |
Package's home on the www, if any |
| Packages |
id |
Package ID, an integer signifying a version of a package |
| Packages |
maintainer |
email address of Package's maintainer |
| Packages |
name |
Name of package, e.g. 'samba' |
| Packages |
version |
Version of package, e.g. '1.2.4b' |
| Plist |
filename |
Plist is deprecated |
| Plist |
id |
Package ID, an integer signifying a version of a package |
| Preferences |
id |
Package ID, an integer signifying a version of a package |
| Preferences |
optname |
Foreign key to Options.name |
| Preferences |
preference |
A meta-option that can be set in site.Options that causes this option (optname) to be used for Package |
| Releases |
id |
Package ID, an integer signifying a version of a package |
| Releases |
release |
The pkgsrc release e.g., '2007Q4' |
| Scripts |
id |
Package ID, an integer signifying a version of a package |
| Scripts |
name |
Name of the Script |
| Scripts |
optname |
Foreign key to Options.name |
| Scripts |
rank |
Ordinal used by the build process to know when to run this Script |
| Scripts |
rcs_string |
As versioned in CVS |
| Scripts |
value |
The actual script. |
| Urls |
distfile |
Foreign key to Distfiles.name |
| Urls |
id |
Package ID, an integer signifying a version of a package |
| Urls |
url |
ftp/http location of this distfile |