SchemaSpy - Table alter.public.apm_package_types

This table holds additional knowledge level attributes for the
apm_package type and its subtypes.

Generated by
SchemaSpy

Legend:

Primary key columns

Columns with indexes

Implied relationships

Excluded column relationships

Dashed lines show
implied relationships

< n > number of related tables

Please support this project

apm_packages.package_key	apm_packages_package_key_fk
mis_packages.package_key	Implied Constraint

The package_key is what we call the package on this system.

The package URI indicates where the package can be downloaded and
is a unique identifier for the package.

The path to the package specification file.

spec_file_mtime

The last time a spec file was modified. This information is maintained in the
database so that if a user changes the specification file by editing the file
(as opposed to using the UI, the system can read the .info file and update
the information in the database appropriately.

initial_install_p

Indicates if the package should be installed during initial installation,
in other words whether or not this package is part of the OpenACS core.

Indicates if the package can be used for subsites. If this is set to
't', the package can be enabled for any subsite. Otherwise, it is
restricted to the acs-admin/ subsite.

Table contained 39 rows at Fri Feb 29 12:05 CET 2008

Indexes:

Column(s)	Type	Sort	Constraint Name	Anomalies
package_key	Primary key	Asc	apm_package_types_p_key_pk
pretty_name	Must be unique	Asc	apm_package_types_pretty_n_un
pretty_plural	Must be unique	Asc	apm_package_types_pretty_pl_un	This unique column is also nullable
package_uri	Must be unique	Asc	apm_packages_types_p_uri_un