digraph g { graph [ rankdir = "LR", concentrate = true, ratio = auto ]; node [ fontsize = "10", shape = record ]; edge [ ]; "history.sources_count" [shape = plaintext, label = <

\N
ts	timestamp without time zone	PK
total_sid_main	integer
total_sid_contrib	integer
total_sid_nonfree	integer
vcstype_arch	integer
vcstype_bzr	integer
vcstype_cvs	integer
vcstype_darcs	integer
vcstype_git	integer
vcstype_hg	integer
vcstype_mtn	integer
vcstype_svn	integer
format_3native	integer
format_3quilt	integer

> ]; "public.archived_bugs" [shape = plaintext, label = <

\N
id	integer	PK
package	text
source	text
arrival	timestamp without time zone
status	text
severity	bugs_severity
submitter	text
submitter_name	text
submitter_email	text
owner	text
owner_name	text
owner_email	text
done	text
done_name	text
done_email	text
title	text
last_modified	timestamp without time zone
forwarded	text
affects_oldstable	boolean
affects_stable	boolean
affects_testing	boolean
affects_unstable	boolean
affects_experimental	boolean
affected_packages	text
affected_sources	text

> ]; "public.archived_bugs_blockedby" [shape = plaintext, label = <

\N
id	integer	PK	FK
blocker	integer	PK

> ]; "public.archived_bugs_blocks" [shape = plaintext, label = <

\N
id	integer	PK	FK
blocked	integer	PK

> ]; "public.archived_bugs_fixed_in" [shape = plaintext, label = <

\N
id	integer	PK	FK
version	text	PK

> ]; "public.archived_bugs_found_in" [shape = plaintext, label = <

\N
id	integer	PK	FK
version	text	PK

> ]; "public.archived_bugs_merged_with" [shape = plaintext, label = <

\N
id	integer	PK	FK
merged_with	integer	PK

> ]; "public.archived_bugs_packages" [shape = plaintext, label = <

\N
id	integer	PK	FK
package	text	PK
source	text

> ]; "public.archived_bugs_stamps" [shape = plaintext, label = <

\N
id	integer	PK
update_requested	bigint
db_updated	bigint

> ]; "public.archived_bugs_tags" [shape = plaintext, label = <

\N
id	integer	PK	FK
tag	text	PK

> ]; "public.archived_descriptions" [shape = plaintext, label = <

\N
package	text	PK
distribution	text	PK
release	text	PK
component	text	PK
language	text	PK
description	text	PK
long_description	text
description_md5	text	PK

> ]; "public.archived_packages" [shape = plaintext, label = <

\N
package	text	PK	FK
version	debversion	PK	FK
architecture	text	PK
maintainer	text
maintainer_name	text
maintainer_email	text
description	text
description_md5	text
source	text
source_version	debversion
essential	text
depends	text
recommends	text
suggests	text
enhances	text
pre_depends	text
breaks	text
installed_size	bigint
homepage	text
size	bigint
build_essential	text
origin	text
sha1	text
replaces	text
section	text
md5sum	text
bugs	text
priority	text
tag	text
task	text
python_version	text
ruby_versions	text
provides	text
conflicts	text
sha256	text
original_maintainer	text
distribution	text	PK	FK
release	text	PK	FK
component	text	PK	FK
multi_arch	text
package_type	text
filename	text

> ]; "public.archived_packages_distrelcomparch" [shape = plaintext, label = <

	\N
	distribution	text
	release	text
	component	text
	architecture	text

> ]; "public.archived_packages_summary" [shape = plaintext, label = <

\N
package	text	PK
version	debversion	PK
source	text
source_version	debversion
maintainer	text
maintainer_name	text
maintainer_email	text
distribution	text	PK
release	text	PK
component	text	PK

> ]; "public.archived_sources" [shape = plaintext, label = <

\N
source	text	PK
version	debversion	PK
maintainer	text
maintainer_name	text
maintainer_email	text
format	text
files	text
uploaders	text
bin	text
architecture	text
standards_version	text
homepage	text
build_depends	text
build_depends_indep	text
build_conflicts	text
build_conflicts_indep	text
priority	text
section	text
distribution	text	PK
release	text	PK
component	text	PK
vcs_type	text
vcs_url	text
vcs_browser	text
python_version	text
ruby_versions	text
checksums_sha1	text
checksums_sha256	text
original_maintainer	text
dm_upload_allowed	boolean
testsuite	text
autobuild	text
extra_source_only	boolean
build_depends_arch	text
build_conflicts_arch	text
testsuite_triggers	text
dgit	text
git_tag_info	text
git_tag_tagger	text

> ]; "public.archived_uploaders" [shape = plaintext, label = <

	\N
	source	text
	version	debversion
	distribution	text
	release	text
	component	text
	uploader	text
	name	text
	email	text

> ]; "public.bibref" [shape = plaintext, label = <

\N
source	text	PK
key	text	PK
value	text
package	text	PK
rank	integer	PK

> ]; "public.blends_dependencies" [shape = plaintext, label = <

\N
blend	text	PK	FK
task	text	PK
package	text	PK
dependency	character(1)
distribution	text
component	text
provides	boolean

> ]; "public.blends_dependencies_alternatives" [shape = plaintext, label = <

\N
blend	text	PK	FK
task	text	PK
alternatives	text	PK
dependency	character(1)
distribution	text
component	text
contains_provides	boolean

> ]; "public.blends_dependencies_priorities" [shape = plaintext, label = <

	\N
	dependency	character(1)
	priority	integer

> ]; "public.blends_metadata" [shape = plaintext, label = <

\N
blend	text	PK
blendname	text
projecturl	text
tasksprefix	text
homepage	text
aliothurl	text
projectlist	text
logourl	text
outputdir	text
datadir	text
vcsdir	text
css	text
advertising	text
pkglist	text
dehsmail	text
distribution	text

> ]; "public.blends_prospectivepackages" [shape = plaintext, label = <

\N
blend	text
package	text	PK
source	text
maintainer	text
maintainer_name	text
maintainer_email	text
changed_by	text
changed_by_name	text
changed_by_email	text
uploaders	text
description	text
long_description	text
description_md5	text
homepage	text
component	text
section	text
priority	text
vcs_type	text
vcs_url	text
vcs_browser	text
wnpp	integer
wnpp_type	text
wnpp_desc	text
license	text
chlog_date	text
chlog_version	debversion

> ]; "public.blends_remarks" [shape = plaintext, label = <

\N
blend	text	PK
task	text	PK
package	text	PK
remark	text

> ]; "public.blends_tasks" [shape = plaintext, label = <

\N
blend	text	PK	FK
task	text	PK
title	text
metapackage	boolean
metapackage_name	text
section	text
enhances	text
leaf	text
test_always_lang	text
description	text
long_description	text
hashkey	text

> ]; "public.blends_unknown_packages" [shape = plaintext, label = <

\N
package	text	PK
pkg_url	text
wnpp	integer
maintainer	text
maintainer_name	text
maintainer_email	text
description	text
long_description	text
homepage	text
license	text
language	text
vcs_type	text
vcs_url	text
vcs_browser	text
blend	text
task	text

> ]; "public.bts_tags" [shape = plaintext, label = <

	\N
	tag	text
	tag_type	text

> ]; "public.bugs" [shape = plaintext, label = <

\N
id	integer	PK
package	text
source	text
arrival	timestamp without time zone
status	text
severity	bugs_severity
submitter	text
submitter_name	text
submitter_email	text
owner	text
owner_name	text
owner_email	text
done	text
done_name	text
done_email	text
title	text
last_modified	timestamp without time zone
forwarded	text
affects_oldstable	boolean
affects_stable	boolean
affects_testing	boolean
affects_unstable	boolean
affects_experimental	boolean
affected_packages	text
affected_sources	text

> ]; "public.bugs_blockedby" [shape = plaintext, label = <

\N
id	integer	PK	FK
blocker	integer	PK

> ]; "public.bugs_blocks" [shape = plaintext, label = <

\N
id	integer	PK	FK
blocked	integer	PK

> ]; "public.bugs_fixed_in" [shape = plaintext, label = <

\N
id	integer	PK	FK
version	text	PK

> ]; "public.bugs_found_in" [shape = plaintext, label = <

\N
id	integer	PK	FK
version	text	PK

> ]; "public.bugs_merged_with" [shape = plaintext, label = <

\N
id	integer	PK	FK
merged_with	integer	PK

> ]; "public.bugs_packages" [shape = plaintext, label = <

\N
id	integer	PK	FK
package	text	PK
source	text

> ]; "public.bugs_stamps" [shape = plaintext, label = <

\N
id	integer	PK
update_requested	bigint
db_updated	bigint

> ]; "public.bugs_tags" [shape = plaintext, label = <

\N
id	integer	PK	FK
tag	text	PK

> ]; "public.bugs_usertags" [shape = plaintext, label = <

	\N
	email	text
	tag	text
	id	integer

> ]; "public.carnivore_emails" [shape = plaintext, label = <

\N
id	integer	PK
email	text	PK

> ]; "public.carnivore_keys" [shape = plaintext, label = <

\N
id	integer
key	text	PK
key_type	text	PK

> ]; "public.carnivore_login" [shape = plaintext, label = <

\N
id	integer	PK
login	text

> ]; "public.carnivore_names" [shape = plaintext, label = <

\N
id	integer	PK
name	text	PK

> ]; "public.ci" [shape = plaintext, label = <

\N
suite	text	PK
arch	text	PK
source	text	PK
version	debversion
date	timestamp without time zone
run_id	text
status	text
previous_status	text
duration	integer
message	text

> ]; "public.debaudit" [shape = plaintext, label = <

	\N
	source	text
	version	debversion
	dsc	text
	dsc_sha256	text
	component	text
	release	text
	checker	text
	diagnostic	text
	diagnostic_short	text
	ts	timestamp without time zone

> ]; "public.debian_maintainers" [shape = plaintext, label = <

	\N
	maintainer	text
	maintainer_name	text
	maintainer_email	text
	fingerprint	text
	package	text
	granted_by_fingerprint	text

> ]; "public.debtags" [shape = plaintext, label = <

	\N
	package	text
	tag	text

> ]; "public.deferred" [shape = plaintext, label = <

\N
source	text	PK
version	debversion	PK
distribution	text
urgency	text
date	timestamp with time zone
delayed_until	timestamp without time zone
delay_remaining	interval
changed_by	text
changed_by_name	text
changed_by_email	text
maintainer	text
maintainer_name	text
maintainer_email	text
changes	text

> ]; "public.deferred_architecture" [shape = plaintext, label = <

\N
source	text	PK
version	debversion	PK
architecture	text	PK

> ]; "public.deferred_binary" [shape = plaintext, label = <

\N
source	text	PK
version	debversion	PK
package	text	PK

> ]; "public.deferred_closes" [shape = plaintext, label = <

\N
source	text	PK
version	debversion	PK
id	integer	PK

> ]; "public.dehs" [shape = plaintext, label = <

\N
source	text	PK
unstable_version	debversion
unstable_upstream	text
unstable_parsed_version	text
unstable_status	dehs_status
unstable_last_uptodate	timestamp without time zone
experimental_version	debversion
experimental_upstream	text
experimental_parsed_version	text
experimental_status	dehs_status
experimental_last_uptodate	timestamp without time zone

> ]; "public.derivatives_descriptions" [shape = plaintext, label = <

\N
package	text	PK
distribution	text	PK
release	text	PK
component	text	PK
language	text	PK
description	text	PK
long_description	text
description_md5	text	PK

> ]; "public.derivatives_packages" [shape = plaintext, label = <

\N
package	text	PK	FK
version	debversion	PK	FK
architecture	text	PK
maintainer	text
maintainer_name	text
maintainer_email	text
description	text
description_md5	text
source	text
source_version	debversion
essential	text
depends	text
recommends	text
suggests	text
enhances	text
pre_depends	text
breaks	text
installed_size	bigint
homepage	text
size	bigint
build_essential	text
origin	text
sha1	text
replaces	text
section	text
md5sum	text
bugs	text
priority	text
tag	text
task	text
python_version	text
ruby_versions	text
provides	text
conflicts	text
sha256	text
original_maintainer	text
distribution	text	PK	FK
release	text	PK	FK
component	text	PK	FK
multi_arch	text
package_type	text
filename	text

> ]; "public.derivatives_packages_distrelcomparch" [shape = plaintext, label = <

	\N
	distribution	text
	release	text
	component	text
	architecture	text

> ]; "public.derivatives_packages_summary" [shape = plaintext, label = <

\N
package	text	PK
version	debversion	PK
source	text
source_version	debversion
maintainer	text
maintainer_name	text
maintainer_email	text
distribution	text	PK
release	text	PK
component	text	PK

> ]; "public.derivatives_sources" [shape = plaintext, label = <

\N
source	text	PK
version	debversion	PK
maintainer	text
maintainer_name	text
maintainer_email	text
format	text
files	text
uploaders	text
bin	text
architecture	text
standards_version	text
homepage	text
build_depends	text
build_depends_indep	text
build_conflicts	text
build_conflicts_indep	text
priority	text
section	text
distribution	text	PK
release	text	PK
component	text	PK
vcs_type	text
vcs_url	text
vcs_browser	text
python_version	text
ruby_versions	text
checksums_sha1	text
checksums_sha256	text
original_maintainer	text
dm_upload_allowed	boolean
testsuite	text
autobuild	text
extra_source_only	boolean
build_depends_arch	text
build_conflicts_arch	text
testsuite_triggers	text
dgit	text
git_tag_info	text
git_tag_tagger	text

> ]; "public.derivatives_uploaders" [shape = plaintext, label = <

	\N
	source	text
	version	debversion
	distribution	text
	release	text
	component	text
	uploader	text
	name	text
	email	text

> ]; "public.description_imports" [shape = plaintext, label = <

\N
distribution	text	PK
release	text	PK
component	text	PK
language	text	PK
translationfile	text
translationfile_sha1	text
import_date	timestamp without time zone

> ]; "public.descriptions" [shape = plaintext, label = <

\N
package	text	PK
distribution	text	PK
release	text	PK
component	text	PK
language	text	PK
description	text	PK
long_description	text
description_md5	text	PK

> ]; "public.duck_raw" [shape = plaintext, label = <

	\N
	source	text
	version	debversion
	component	text
	status	boolean
	error	text
	data	jsonb

> ]; "public.duck_url_status" [shape = plaintext, label = <

\N
url	text	PK
checkmethod	text	PK
status_code	integer
response_time_ms	integer
error_message	text
last_checked	timestamp with time zone
redirect_url	text
content_type	text
is_ok	boolean

> ]; "public.duck_urls" [shape = plaintext, label = <

	\N
	source	text
	version	debversion
	component	text
	url	text
	checkmethod	text
	filename	text
	override	boolean
	type	text

> ]; "public.edam" [shape = plaintext, label = <

\N
source	text	PK
package	text	PK
topics	text[]
scopes	jsonb

> ]; "public.ftp_autorejects" [shape = plaintext, label = <

\N
tag	text	PK
autoreject_type	ftp_autoreject_type
autoreject_level	ftp_autoreject_level

> ]; "public.hints" [shape = plaintext, label = <

	\N
	source	text
	version	debversion
	architecture	text
	type	text
	argument	text
	file	text
	comment	text

> ]; "public.key_packages" [shape = plaintext, label = <

\N
source	text	PK
reason	text

> ]; "public.ldap" [shape = plaintext, label = <

\N
uid	numeric	PK
login	text
cn	text
sn	text
expire	boolean
location	text
country	text
activity_from	timestamp with time zone
activity_from_info	text
activity_pgp	timestamp with time zone
activity_pgp_info	text
gecos	text
birthdate	date
gender	numeric
fingerprint	text

> ]; "public.lintian_logs" [shape = plaintext, label = <

	\N
	ts	timestamp without time zone
	lintian_version	debversion
	source	text
	version	debversion
	package	text
	package_version	debversion
	architecture	text
	result	text
	duration	integer
	message	text

> ]; "public.lintian_results" [shape = plaintext, label = <

	\N
	lintian_version	debversion
	source	text
	version	debversion
	package	text
	package_version	debversion
	architecture	text
	tag_type	lintian_tagtype
	tag	text
	information	text

> ]; "public.lintian_tags_descriptions" [shape = plaintext, label = <

	\N
	lintian_version	debversion
	tag_type	lintian_tagtype
	tag	text
	description	text

> ]; "public.mentors_raw_uploads" [shape = plaintext, label = <

\N
id	numeric	PK
changes	text
closes	text
component	text
distribution	text
package	text
uploaded	timestamp without time zone
uploader	text
version	text

> ]; "public.migration_excuses" [shape = plaintext, label = <

\N
item_name	text	PK
source	text
migration_policy_verdict	text
old_version	debversion
new_version	debversion
is_candidate	boolean
excuses	text[]
reason	text[]
hints	jsonb
policy_info	jsonb
dependencies	jsonb
invalidated_by_other_package	boolean
missing_builds	jsonb
old_binaries	jsonb

> ]; "public.migration_excuses_experimental" [shape = plaintext, label = <

\N
item_name	text	PK
source	text
migration_policy_verdict	text
old_version	debversion
new_version	debversion
is_candidate	boolean
excuses	text[]
reason	text[]
hints	jsonb
policy_info	jsonb
dependencies	jsonb
invalidated_by_other_package	boolean
missing_builds	jsonb
old_binaries	jsonb

> ]; "public.migrations" [shape = plaintext, label = <

\N
source	text	PK
in_testing	date
testing_version	debversion
in_unstable	date
unstable_version	debversion
sync	date
sync_version	debversion
first_seen	date

> ]; "public.multiarch_hints" [shape = plaintext, label = <

\N
package	text	PK
version	debversion
source	text
description	text
link	text
severity	text

> ]; "public.new_packages" [shape = plaintext, label = <

\N
package	text	PK
version	text	PK
architecture	text	PK
maintainer	text
description	text
source	text
depends	text
recommends	text
suggests	text
enhances	text
pre_depends	text
breaks	text
replaces	text
provides	text
conflicts	text
installed_size	integer
homepage	text
long_description	text
section	text
component	text
distribution	text
license	text

> ]; "public.new_sources" [shape = plaintext, label = <

\N
source	text	PK
version	text	PK
maintainer	text
maintainer_name	text
maintainer_email	text
format	text
files	text
uploaders	text
binaries	text
changed_by	text
architecture	text
homepage	text
vcs_type	text
vcs_url	text
vcs_browser	text
section	text
component	text
distribution	text	PK
closes	integer
license	text
last_modified	timestamp without time zone
queue	text

> ]; "public.orphaned_packages" [shape = plaintext, label = <

\N
source	text	PK
type	text
bug	integer
description	text
orphaned_time	timestamp without time zone

> ]; "public.package_removal" [shape = plaintext, label = <

\N
batch_id	integer	PK	FK
name	text	PK
version	debversion	PK
arch_array	text[]

> ]; "public.package_removal_batch" [shape = plaintext, label = <

\N
id	integer	PK
time	timestamp without time zone
ftpmaster	text
distribution	text
requestor	text
reasons	text

> ]; "public.packages" [shape = plaintext, label = <

\N
package	text	PK
version	debversion	PK
architecture	text	PK
maintainer	text
maintainer_name	text
maintainer_email	text
description	text
description_md5	text
source	text
source_version	debversion
essential	text
depends	text
recommends	text
suggests	text
enhances	text
pre_depends	text
breaks	text
installed_size	bigint
homepage	text
size	bigint
build_essential	text
origin	text
sha1	text
replaces	text
section	text
md5sum	text
bugs	text
priority	text
tag	text
task	text
python_version	text
ruby_versions	text
provides	text
conflicts	text
sha256	text
original_maintainer	text
distribution	text	PK
release	text	PK
component	text	PK
multi_arch	text
package_type	text
filename	text

> ]; "public.packages_distrelcomparch" [shape = plaintext, label = <

	\N
	distribution	text
	release	text
	component	text
	architecture	text

> ]; "public.packages_summary" [shape = plaintext, label = <

\N
package	text	PK
version	debversion	PK
source	text
source_version	debversion
maintainer	text
maintainer_name	text
maintainer_email	text
distribution	text	PK
release	text	PK
component	text	PK

> ]; "public.patches" [shape = plaintext, label = <

	\N
	hash	text
	file	text
	patch	text
	description	text
	forwarded	text
	last_update	timestamp without time zone
	author	text
	origin	text
	forwarded_short	text
	headers	text
	upstream_bug	text
	debian_bug	text
	forwarded_url	text
	invalid_reason	text
	applied_upstream	text
	upstream_status	text
	upstream_status_info	text

> ]; "public.patches_status" [shape = plaintext, label = <

	\N
	hash	text
	file	text
	status	text

> ]; "public.piuparts_status" [shape = plaintext, label = <

	\N
	section	text
	source	text
	version	text
	status	text

> ]; "public.popcon" [shape = plaintext, label = <

\N
package	text	PK
insts	integer
vote	integer
olde	integer
recent	integer
nofiles	integer

> ]; "public.popcon_src" [shape = plaintext, label = <

\N
source	text	PK
insts	integer
vote	integer
olde	integer
recent	integer
nofiles	integer

> ]; "public.popcon_src_average" [shape = plaintext, label = <

\N
source	text	PK
insts	integer
vote	integer
olde	integer
recent	integer
nofiles	integer

> ]; "public.ports_descriptions" [shape = plaintext, label = <

\N
package	text	PK
distribution	text	PK
release	text	PK
component	text	PK
language	text	PK
description	text	PK
long_description	text
description_md5	text	PK

> ]; "public.ports_packages" [shape = plaintext, label = <

\N
package	text	PK
version	debversion	PK
architecture	text	PK
maintainer	text
maintainer_name	text
maintainer_email	text
description	text
description_md5	text
source	text
source_version	debversion
essential	text
depends	text
recommends	text
suggests	text
enhances	text
pre_depends	text
breaks	text
installed_size	bigint
homepage	text
size	bigint
build_essential	text
origin	text
sha1	text
replaces	text
section	text
md5sum	text
bugs	text
priority	text
tag	text
task	text
python_version	text
ruby_versions	text
provides	text
conflicts	text
sha256	text
original_maintainer	text
distribution	text	PK
release	text	PK
component	text	PK
multi_arch	text
package_type	text
filename	text

> ]; "public.ports_packages_distrelcomparch" [shape = plaintext, label = <

	\N
	distribution	text
	release	text
	component	text
	architecture	text

> ]; "public.ports_packages_summary" [shape = plaintext, label = <

\N
package	text	PK
version	debversion	PK
source	text
source_version	debversion
maintainer	text
maintainer_name	text
maintainer_email	text
distribution	text	PK
release	text	PK
component	text	PK

> ]; "public.ports_sources" [shape = plaintext, label = <

\N
source	text	PK
version	debversion	PK
maintainer	text
maintainer_name	text
maintainer_email	text
format	text
files	text
uploaders	text
bin	text
architecture	text
standards_version	text
homepage	text
build_depends	text
build_depends_indep	text
build_conflicts	text
build_conflicts_indep	text
priority	text
section	text
distribution	text	PK
release	text	PK
component	text	PK
vcs_type	text
vcs_url	text
vcs_browser	text
python_version	text
ruby_versions	text
checksums_sha1	text
checksums_sha256	text
original_maintainer	text
dm_upload_allowed	boolean
testsuite	text
autobuild	text
extra_source_only	boolean
build_depends_arch	text
build_conflicts_arch	text
testsuite_triggers	text
dgit	text
git_tag_info	text
git_tag_tagger	text

> ]; "public.ports_uploaders" [shape = plaintext, label = <

	\N
	source	text
	version	debversion
	distribution	text
	release	text
	component	text
	uploader	text
	name	text
	email	text

> ]; "public.potential_bug_closures" [shape = plaintext, label = <

	\N
	id	integer
	source	text
	distribution	text
	origin	text

> ]; "public.pseudo_packages" [shape = plaintext, label = <

\N
package	text	PK
maintainer	text
maintainer_name	text
maintainer_email	text
description	text

> ]; "public.registry" [shape = plaintext, label = <

\N
source	text	PK
name	text	PK
entry	text	PK

> ]; "public.releases" [shape = plaintext, label = <

\N
release	text	PK
releasedate	date
role	text
releaseversion	text
distribution	text
sort	integer

> ]; "public.reproduce" [shape = plaintext, label = <

\N
package	text	PK
version	debversion	PK
distribution	text	PK
release	text	PK
component	text	PK
architecture	text	PK
status	text
build_id	integer
artifact_id	integer
data	jsonb

> ]; "public.reproducible" [shape = plaintext, label = <

\N
source	text	PK
version	debversion
release	text	PK
architecture	text	PK
status	text

> ]; "public.reproducible_issues" [shape = plaintext, label = <

\N
name	text	PK
description	text
url	text
deterministic	boolean

> ]; "public.reproducible_notes" [shape = plaintext, label = <

\N
source	text	PK
version	debversion
comments	text
issues	text[]
bugs	integer[]

> ]; "public.salsa_projects" [shape = plaintext, label = <

	\N
	project	text
	last_check	timestamp without time zone
	status	boolean
	http_code	integer
	info	jsonb
	branches	text[]
	ci_config_path	text
	ci_config	text
	gbp_conf	text
	salsa_group	text
	default_branch	text
	latest_pipeline	jsonb
	latest_pipeline_jobs	jsonb
	gitattributes	text

> ]; "public.screenshots" [shape = plaintext, label = <

\N
package	text
version	text
homepage	text
maintainer_name	text
maintainer_email	text
description	text
section	text
screenshot_url	text
large_image_url	text
small_image_url	text	PK

> ]; "public.security_issues" [shape = plaintext, label = <

\N
source	text	PK
issue	text	PK
description	text
scope	security_issues_scope
bug	integer

> ]; "public.security_issues_releases" [shape = plaintext, label = <

\N
source	text	PK
issue	text	PK
release	text	PK
fixed_version	text
status	security_issues_releases_status
urgency	text
nodsa	text
nodsa_reason	text
next_point_update	boolean

> ]; "public.sources" [shape = plaintext, label = <

\N
source	text	PK
version	debversion	PK
maintainer	text
maintainer_name	text
maintainer_email	text
format	text
files	text
uploaders	text
bin	text
architecture	text
standards_version	text
homepage	text
build_depends	text
build_depends_indep	text
build_conflicts	text
build_conflicts_indep	text
priority	text
section	text
distribution	text	PK
release	text	PK
component	text	PK
vcs_type	text
vcs_url	text
vcs_browser	text
python_version	text
ruby_versions	text
checksums_sha1	text
checksums_sha256	text
original_maintainer	text
dm_upload_allowed	boolean
testsuite	text
autobuild	text
extra_source_only	boolean
build_depends_arch	text
build_conflicts_arch	text
testsuite_triggers	text
dgit	text
git_tag_info	text
git_tag_tagger	text

> ]; "public.sources_files" [shape = plaintext, label = <

	\N
	source	text
	version	debversion
	distribution	text
	release	text
	component	text
	format	text
	hash	text
	size	bigint
	file	text

> ]; "public.sources_salsa_projects" [shape = plaintext, label = <

	\N
	source	text
	version	debversion
	vcs_url	text
	project	text
	branch	text
	path	text

> ]; "public.testing_autoremovals" [shape = plaintext, label = <

	\N
	source	text
	version	text
	bugs	text
	first_seen	bigint
	last_checked	bigint
	removal_time	bigint
	rdeps	text
	buggy_deps	text
	bugs_deps	text
	rdeps_popcon	bigint

> ]; "public.timestamps" [shape = plaintext, label = <

\N
id	serial	PK
source	text
command	text
start_time	timestamp without time zone
end_time	timestamp without time zone

> ]; "public.ubuntu_bugs" [shape = plaintext, label = <

\N
bug	integer	PK
title	text
reporter_login	text
reporter_name	text
duplicate_of	integer
date_reported	text
date_updated	text
security	boolean
patches	boolean

> ]; "public.ubuntu_bugs_duplicates" [shape = plaintext, label = <

\N
bug	integer	PK	FK
duplicate	integer	PK

> ]; "public.ubuntu_bugs_subscribers" [shape = plaintext, label = <

\N
bug	integer	FK
subscriber_login	text
subscriber_name	text

> ]; "public.ubuntu_bugs_tags" [shape = plaintext, label = <

\N
bug	integer	PK	FK
tag	text	PK

> ]; "public.ubuntu_bugs_tasks" [shape = plaintext, label = <

\N
bug	integer	PK	FK
package	text	PK
distro	text	PK
status	text
importance	text
component	text
milestone	text
date_created	text
date_assigned	text
date_closed	text
date_incomplete	text
date_confirmed	text
date_inprogress	text
date_fix_committed	text
date_fix_released	text
date_left_new	text
date_triaged	text
date_left_closed	text
watch	text
reporter_login	text
reporter_name	text
assignee_login	text
assignee_name	text

> ]; "public.ubuntu_description_imports" [shape = plaintext, label = <

\N
distribution	text	PK
release	text	PK
component	text	PK
language	text	PK
translationfile	text
translationfile_sha1	text
import_date	timestamp without time zone

> ]; "public.ubuntu_descriptions" [shape = plaintext, label = <

\N
package	text	PK
distribution	text	PK
release	text	PK
component	text	PK
language	text	PK
description	text	PK
long_description	text
description_md5	text	PK

> ]; "public.ubuntu_packages" [shape = plaintext, label = <

\N
package	text	PK	FK
version	debversion	PK	FK
architecture	text	PK
maintainer	text
maintainer_name	text
maintainer_email	text
description	text
description_md5	text
source	text
source_version	debversion
essential	text
depends	text
recommends	text
suggests	text
enhances	text
pre_depends	text
breaks	text
installed_size	bigint
homepage	text
size	bigint
build_essential	text
origin	text
sha1	text
replaces	text
section	text
md5sum	text
bugs	text
priority	text
tag	text
task	text
python_version	text
ruby_versions	text
provides	text
conflicts	text
sha256	text
original_maintainer	text
distribution	text	PK	FK
release	text	PK	FK
component	text	PK	FK
multi_arch	text
package_type	text
filename	text

> ]; "public.ubuntu_packages_distrelcomparch" [shape = plaintext, label = <

	\N
	distribution	text
	release	text
	component	text
	architecture	text

> ]; "public.ubuntu_packages_summary" [shape = plaintext, label = <

\N
package	text	PK
version	debversion	PK
source	text
source_version	debversion
maintainer	text
maintainer_name	text
maintainer_email	text
distribution	text	PK
release	text	PK
component	text	PK

> ]; "public.ubuntu_popcon" [shape = plaintext, label = <

\N
package	text	PK
insts	integer
vote	integer
olde	integer
recent	integer
nofiles	integer

> ]; "public.ubuntu_popcon_src" [shape = plaintext, label = <

\N
source	text	PK
insts	integer
vote	integer
olde	integer
recent	integer
nofiles	integer

> ]; "public.ubuntu_popcon_src_average" [shape = plaintext, label = <

\N
source	text	PK
insts	integer
vote	integer
olde	integer
recent	integer
nofiles	integer

> ]; "public.ubuntu_sources" [shape = plaintext, label = <

\N
source	text	PK
version	debversion	PK
maintainer	text
maintainer_name	text
maintainer_email	text
format	text
files	text
uploaders	text
bin	text
architecture	text
standards_version	text
homepage	text
build_depends	text
build_depends_indep	text
build_conflicts	text
build_conflicts_indep	text
priority	text
section	text
distribution	text	PK
release	text	PK
component	text	PK
vcs_type	text
vcs_url	text
vcs_browser	text
python_version	text
ruby_versions	text
checksums_sha1	text
checksums_sha256	text
original_maintainer	text
dm_upload_allowed	boolean
testsuite	text
autobuild	text
extra_source_only	boolean
build_depends_arch	text
build_conflicts_arch	text
testsuite_triggers	text
dgit	text
git_tag_info	text
git_tag_tagger	text

> ]; "public.ubuntu_upload_history" [shape = plaintext, label = <

\N
source	text	PK
version	debversion	PK
date	timestamp with time zone
changed_by	text
changed_by_name	text
changed_by_email	text
maintainer	text
maintainer_name	text
maintainer_email	text
nmu	boolean
signed_by	text
signed_by_name	text
signed_by_email	text
key_id	text
distribution	text
component	text
file	text
fingerprint	text
original_maintainer	text
original_maintainer_name	text
original_maintainer_email	text
git_tag_info	text
git_tag_tagger	text
git_tag_tagger_name	text
git_tag_tagger_email	text
git_tag_info_tag	text
git_tag_info_fp	text
uploaded_by	text
uploaded_by_name	text
uploaded_by_email	text
uploaded_by_fingerprint	text

> ]; "public.ubuntu_upload_history_closes" [shape = plaintext, label = <

\N
source	text	PK
version	debversion	PK
bug	integer	PK
file	text

> ]; "public.ubuntu_upload_history_launchpad_closes" [shape = plaintext, label = <

\N
source	text	PK
version	debversion	PK
bug	integer	PK
file	text

> ]; "public.ubuntu_uploaders" [shape = plaintext, label = <

	\N
	source	text
	version	debversion
	distribution	text
	release	text
	component	text
	uploader	text
	name	text
	email	text

> ]; "public.udd_logs" [shape = plaintext, label = <

\N
importer	text	PK
time	timestamp with time zone	PK
duration	integer
status	integer
log	text

> ]; "public.unofficial_descriptions" [shape = plaintext, label = <

\N
package	text	PK
distribution	text	PK
release	text	PK
component	text	PK
language	text	PK
description	text	PK
long_description	text
description_md5	text	PK

> ]; "public.unofficial_packages" [shape = plaintext, label = <

\N
package	text	PK	FK
version	debversion	PK	FK
architecture	text	PK
maintainer	text
maintainer_name	text
maintainer_email	text
description	text
description_md5	text
source	text
source_version	debversion
essential	text
depends	text
recommends	text
suggests	text
enhances	text
pre_depends	text
breaks	text
installed_size	bigint
homepage	text
size	bigint
build_essential	text
origin	text
sha1	text
replaces	text
section	text
md5sum	text
bugs	text
priority	text
tag	text
task	text
python_version	text
ruby_versions	text
provides	text
conflicts	text
sha256	text
original_maintainer	text
distribution	text	PK	FK
release	text	PK	FK
component	text	PK	FK
multi_arch	text
package_type	text
filename	text

> ]; "public.unofficial_packages_distrelcomparch" [shape = plaintext, label = <

	\N
	distribution	text
	release	text
	component	text
	architecture	text

> ]; "public.unofficial_packages_summary" [shape = plaintext, label = <

\N
package	text	PK
version	debversion	PK
source	text
source_version	debversion
maintainer	text
maintainer_name	text
maintainer_email	text
distribution	text	PK
release	text	PK
component	text	PK

> ]; "public.unofficial_sources" [shape = plaintext, label = <

\N
source	text	PK
version	debversion	PK
maintainer	text
maintainer_name	text
maintainer_email	text
format	text
files	text
uploaders	text
bin	text
architecture	text
standards_version	text
homepage	text
build_depends	text
build_depends_indep	text
build_conflicts	text
build_conflicts_indep	text
priority	text
section	text
distribution	text	PK
release	text	PK
component	text	PK
vcs_type	text
vcs_url	text
vcs_browser	text
python_version	text
ruby_versions	text
checksums_sha1	text
checksums_sha256	text
original_maintainer	text
dm_upload_allowed	boolean
testsuite	text
autobuild	text
extra_source_only	boolean
build_depends_arch	text
build_conflicts_arch	text
testsuite_triggers	text
dgit	text
git_tag_info	text
git_tag_tagger	text

> ]; "public.unofficial_uploaders" [shape = plaintext, label = <

	\N
	source	text
	version	debversion
	distribution	text
	release	text
	component	text
	uploader	text
	name	text
	email	text

> ]; "public.upload_history" [shape = plaintext, label = <

\N
source	text	PK
version	debversion	PK
date	timestamp with time zone
changed_by	text
changed_by_name	text
changed_by_email	text
maintainer	text
maintainer_name	text
maintainer_email	text
nmu	boolean
signed_by	text
signed_by_name	text
signed_by_email	text
key_id	text
distribution	text
file	text
fingerprint	text
git_tag_info	text
git_tag_tagger	text
git_tag_tagger_name	text
git_tag_tagger_email	text
git_tag_info_tag	text
git_tag_info_fp	text
uploaded_by	text
uploaded_by_name	text
uploaded_by_email	text
uploaded_by_fingerprint	text

> ]; "public.upload_history_architecture" [shape = plaintext, label = <

\N
source	text	PK
version	debversion	PK
architecture	text	PK
file	text

> ]; "public.upload_history_closes" [shape = plaintext, label = <

\N
source	text	PK
version	debversion	PK
bug	integer	PK
file	text

> ]; "public.uploaders" [shape = plaintext, label = <

	\N
	source	text
	version	debversion
	distribution	text
	release	text
	component	text
	uploader	text
	name	text
	email	text

> ]; "public.upstream" [shape = plaintext, label = <

\N
source	text	PK
version	debversion	PK
distribution	text	PK
release	text	PK
component	text	PK
watch_file	text
metadata	text
debian_uversion	text
debian_mangled_uversion	text
upstream_version	text
upstream_url	text
errors	text
warnings	text
status	text
last_check	timestamp without time zone

> ]; "public.upstream_metadata" [shape = plaintext, label = <

\N
source	text	PK
key	text	PK
value	text

> ]; "public.vcs" [shape = plaintext, label = <

\N
source	text	PK
team	text
version	debversion
distribution	text

> ]; "public.vcswatch" [shape = plaintext, label = <

\N
source	text	PK
version	debversion
vcs	text
url	text
branch	text
browser	text
last_scan	timestamp with time zone
next_scan	timestamp with time zone
status	text
debian_dir	boolean
changelog_version	debversion
changelog_distribution	text
changelog	text
error	text
commit_id	text
ci_url	text
ci_status	text
issues	integer
merge_requests	integer
blocked	integer

> ]; "public.wannabuild" [shape = plaintext, label = <

\N
source	text	PK
distribution	text	PK
architecture	text	PK
version	debversion
state	text
installed_version	debversion
previous_state	text
state_change	timestamp without time zone
binary_nmu_version	numeric
notes	text
vancouvered	boolean

> ]; "public.archived_bugs_blockedby":rtcol1 -> "public.archived_bugs":ltcol1 [label="archived_bugs_blockedby_id_fkey"]; "public.archived_bugs_blocks":rtcol1 -> "public.archived_bugs":ltcol1 [label="archived_bugs_blocks_id_fkey"]; "public.archived_bugs_fixed_in":rtcol1 -> "public.archived_bugs":ltcol1 [label="archived_bugs_fixed_in_id_fkey"]; "public.archived_bugs_found_in":rtcol1 -> "public.archived_bugs":ltcol1 [label="archived_bugs_found_in_id_fkey"]; "public.archived_bugs_merged_with":rtcol1 -> "public.archived_bugs":ltcol1 [label="archived_bugs_merged_with_id_fkey"]; "public.archived_bugs_packages":rtcol1 -> "public.archived_bugs":ltcol1 [label="archived_bugs_packages_id_fkey"]; "public.archived_bugs_tags":rtcol1 -> "public.archived_bugs":ltcol1 [label="archived_bugs_tags_id_fkey"]; "public.archived_packages":rtcol0 -> "public.archived_packages_summary":ltcol0 [label="archived_packages_package_fkey"]; "public.blends_dependencies":rtcol1 -> "public.blends_metadata":ltcol1 [label="blends_dependencies_blend_fkey"]; "public.blends_dependencies_alternatives":rtcol1 -> "public.blends_metadata":ltcol1 [label="blends_dependencies_alternatives_blend_fkey"]; "public.blends_tasks":rtcol1 -> "public.blends_metadata":ltcol1 [label="blends_tasks_blend_fkey"]; "public.bugs_blockedby":rtcol1 -> "public.bugs":ltcol1 [label="bugs_blockedby_id_fkey"]; "public.bugs_blocks":rtcol1 -> "public.bugs":ltcol1 [label="bugs_blocks_id_fkey"]; "public.bugs_fixed_in":rtcol1 -> "public.bugs":ltcol1 [label="bugs_fixed_in_id_fkey"]; "public.bugs_found_in":rtcol1 -> "public.bugs":ltcol1 [label="bugs_found_in_id_fkey"]; "public.bugs_merged_with":rtcol1 -> "public.bugs":ltcol1 [label="bugs_merged_with_id_fkey"]; "public.bugs_packages":rtcol1 -> "public.bugs":ltcol1 [label="bugs_packages_id_fkey"]; "public.bugs_tags":rtcol1 -> "public.bugs":ltcol1 [label="bugs_tags_id_fkey"]; "public.deferred_architecture":rtcol0 -> "public.deferred":ltcol0 [label="deferred_architecture_source_fkey"]; "public.deferred_binary":rtcol0 -> "public.deferred":ltcol0 [label="deferred_binary_source_fkey"]; "public.deferred_closes":rtcol0 -> "public.deferred":ltcol0 [label="deferred_closes_source_fkey"]; "public.derivatives_packages":rtcol0 -> "public.derivatives_packages_summary":ltcol0 [label="derivatives_packages_package_fkey"]; "public.package_removal":rtcol1 -> "public.package_removal_batch":ltcol1 [label="package_removal_batch_id_fkey"]; "public.security_issues_releases":rtcol0 -> "public.security_issues":ltcol0 [label="security_issues_releases_source_fkey"]; "public.ubuntu_bugs_duplicates":rtcol1 -> "public.ubuntu_bugs":ltcol1 [label="ubuntu_bugs_duplicates_bug_fkey"]; "public.ubuntu_bugs_subscribers":rtcol1 -> "public.ubuntu_bugs":ltcol1 [label="ubuntu_bugs_subscribers_bug_fkey"]; "public.ubuntu_bugs_tags":rtcol1 -> "public.ubuntu_bugs":ltcol1 [label="ubuntu_bugs_tags_bug_fkey"]; "public.ubuntu_bugs_tasks":rtcol1 -> "public.ubuntu_bugs":ltcol1 [label="ubuntu_bugs_tasks_bug_fkey"]; "public.ubuntu_packages":rtcol0 -> "public.ubuntu_packages_summary":ltcol0 [label="ubuntu_packages_package_fkey"]; "public.ubuntu_upload_history_closes":rtcol0 -> "public.ubuntu_upload_history":ltcol0 [label="ubuntu_upload_history_closes_source_fkey"]; "public.ubuntu_upload_history_launchpad_closes":rtcol0 -> "public.ubuntu_upload_history":ltcol0 [label="ubuntu_upload_history_launchpad_closes_source_fkey"]; "public.unofficial_packages":rtcol0 -> "public.unofficial_packages_summary":ltcol0 [label="unofficial_packages_package_fkey"]; "public.upload_history_architecture":rtcol0 -> "public.upload_history":ltcol0 [label="upload_history_architecture_source_fkey"]; "public.upload_history_closes":rtcol0 -> "public.upload_history":ltcol0 [label="upload_history_closes_source_fkey"]; }