package

3 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id text 2147483647 null
dcpr_error_report.metadata_record dcpr_error_report_metadata_record_fkeyR
error_report.metadata_record error_report_metadata_record_fkeyR
harvest_object.package_id harvest_object_package_id_fkeyR
package_extra.package_id package_extra_package_id_fkeyR
package_member.package_id package_member_package_id_fkeyR
package_relationship.object_package_id package_relationship_object_package_id_fkeyR
package_relationship.subject_package_id package_relationship_subject_package_id_fkeyR
package_relationship_revision.object_package_id package_relationship_revision_object_package_id_fkeyR
package_relationship_revision.subject_package_id package_relationship_revision_subject_package_id_fkeyR
package_tag.package_id package_tag_package_id_fkeyR
rating.package_id rating_package_id_fkeyR
user_following_dataset.object_id user_following_dataset_object_id_fkeyC
name varchar 100 null
title text 2147483647 √ null
version varchar 100 √ null
url text 2147483647 √ null
notes text 2147483647 √ null
author text 2147483647 √ null
author_email text 2147483647 √ null
maintainer text 2147483647 √ null
maintainer_email text 2147483647 √ null
state text 2147483647 √ null
license_id text 2147483647 √ null
type text 2147483647 √ null
owner_org text 2147483647 √ null
private bool 1 √ false
metadata_modified timestamp 29,6 √ null
creator_user_id text 2147483647 √ null
metadata_created timestamp 29,6 √ null

Indexes

Constraint Name Type Sort Column(s)
package_pkey Primary key Asc id
idx_package_creator_user_id Performance Asc creator_user_id
idx_pkg_id Performance Asc id
idx_pkg_lname Performance
idx_pkg_name Performance Asc name
idx_pkg_sid Performance Asc/Asc id + state
idx_pkg_slname Performance Asc state
idx_pkg_sname Performance Asc/Asc name + state
idx_pkg_stitle Performance Asc/Asc title + state
idx_pkg_suname Performance Asc state
idx_pkg_title Performance Asc title
idx_pkg_uname Performance
package_name_key Must be unique Asc name

Relationships

Close relationships within degrees of separation