--
--    This table maintains the list of all package instances in the sytem. 
-- 
CREATE TABLE apm_packages (
	package_id	 integer PRIMARY KEY NOT NULL,
	package_key	 varchar(100),
	--
	--    This column enables a name to associated with each instance of package.  This enables the storage
	-- of a human-readable distinction between different package instances.  This is useful
	-- if a site admin wishes to name an instance of an application, e.g. bboard, for a subsite.  The admin
	-- might create one instance, "Boston Public Bboard" for managing public forums for the Boston subsite,
	-- and "Boston Private Bboard" for managing private forums for the Boston subsite.
	-- 
	instance_name	 varchar(300) NOT NULL,
	default_locale	 varchar(30),
	CONSTRAINT apm_packages_package_id_fk REFERENCES acs_objects (),
	CONSTRAINT apm_packages_package_key_fk REFERENCES apm_package_types ()
);

CREATE INDEX apm_packages_package_key_idx ON apm_packages (package_key);

-- Tables with foreign keys that refer to apm_packages:
--application_groups(application_groups_package_id_fk)
--ad_locale_user_prefs(lang_package_l_u_package_id_fk)
--attachments_fs_root_folder_map(attach_fldr_map_package_id_fk)
--bt_projects(bt_projects_apm_packages_fk)
--calendars(calendars_package_id_fk)
--xowiki_package(xowiki_package_package_id_fkey)
--contact_groups_allowed_rels(contact_groups_package_id_fk)
--acs_mail_lite_queue(amlq_package_id_fk)
--logger_project_pkg_map(logger_project_pkg_map_pa_fk)
--contact_groups(contact_groups_package_id_fk)
--acs_objects(acs_objects_package_id_fk)
--iv_default_objects(iv_default_objects_fk)
--logger_variables(logger_project_var_map_pi_fk)
--apm_applications(apm_applications_aplt_id_fk)
--cr_folders(cr_folders_package_id_fk)
--fs_root_folders(fs_root_folder_package_id_fk)
--bt_auto_bugs(bt_auto_package_id_fk)
--apm_parameter_values(apm_parameter_values_pk_id_fk)
--acs_named_objects(acs_named_objs_package_id_fk)
--apm_services(apm_services_service_id_fk)

-- Table size: 8,192 bytes
-- Table rows: 54

Tables: