Table alter.public.apm_package_types
This table holds additional knowledge level attributes for the
apm_package type and its subtypes.

Generated by
SchemaSpy
Implied relationships Related columns Constraint names Comments Legend
Legend: SourceForge.net
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 
Column Type Size Nulls Auto Default Children Parents Comments
package_key varchar 100
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.
pretty_name varchar 100
pretty_plural varchar 100  √  null
package_uri varchar 1500 The package URI indicates where the package can be downloaded and
is a unique identifier for the package.
package_type varchar 300  √  null
spec_file_path varchar 1500  √  null The path to the package specification file.
spec_file_mtime int4 10  √  null 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 bool 1 false Indicates if the package should be installed during initial installation,
in other words whether or not this package is part of the OpenACS core.
singleton_p bool 1 false 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  

Close relationships  within one two degrees of separation :