Dumped on 2015-08-30

Index of database - debsources

public

binaries
binary_names
checksums
copyright
ctags
files
history_copyright
history_size
history_sloccount
metrics
package_names
packages
sloccounts
suites
suites_aliases
suites_info

Table: binaries

binaries Structure
F-Key	Name	Type	Description
	id	serial	PRIMARY KEY
	version	character varying
binary_names.id	name_id	integer	NOT NULL
packages.id	package_id	integer	NOT NULL

ix_binaries_name_id name_id ix_binaries_package_id package_id

Index - Schema public

Table: binary_names

binary_names Structure
F-Key	Name	Type	Description
	id	serial	PRIMARY KEY
	name	character varying

Tables referencing this one via Foreign Key Constraints:

binaries

Index - Schema public

Table: checksums

checksums Structure
F-Key	Name	Type	Description
	id	serial	PRIMARY KEY
packages.id	package_id	integer	UNIQUE#1 NOT NULL
files.id	file_id	integer	UNIQUE#1 NOT NULL
	sha256	character varying(64)	NOT NULL

ix_checksums_file_id file_id ix_checksums_package_id package_id ix_checksums_sha256 sha256

Index - Schema public

Table: copyright

copyright Structure
F-Key	Name	Type	Description
	id	serial	PRIMARY KEY
files.id	file_id	integer	NOT NULL
	oracle	copyright_oracles	NOT NULL
	license	character varying

ix_copyright_file_id file_id

Index - Schema public

Table: ctags

ctags Structure
F-Key	Name	Type	Description
	id	serial	PRIMARY KEY
packages.id	package_id	integer	NOT NULL
	tag	character varying	NOT NULL
files.id	file_id	integer	NOT NULL
	line	integer	NOT NULL
	kind	character varying
	language	ctags_languages

ix_ctags_file_id file_id ix_ctags_package_id package_id ix_ctags_tag tag

Index - Schema public

Table: files

files Structure
F-Key	Name	Type	Description
	id	serial	PRIMARY KEY
packages.id	package_id	integer	UNIQUE#1 NOT NULL
	path	bytea	UNIQUE#1 NOT NULL

Tables referencing this one via Foreign Key Constraints:

checksums

ctags

ix_files_package_id package_id ix_files_path path

Index - Schema public

Table: history_copyright

history_copyright Structure
Name	Type	Description
id	serial	PRIMARY KEY
timestamp	timestamp without time zone	NOT NULL
suite	character varying	NOT NULL
license	character varying
files	integer

ix_history_copyright_suite suite ix_history_copyright_timestamp "timestamp"

Index - Schema public

Table: history_size

history_size Structure
Name	Type	Description
timestamp	timestamp without time zone	PRIMARY KEY
suite	character varying	PRIMARY KEY
source_packages	integer
binary_packages	integer
disk_usage	integer
source_files	integer
ctags	integer

ix_history_size_suite suite ix_history_size_timestamp "timestamp"

Index - Schema public

Table: history_sloccount

history_sloccount Structure
Name	Type	Description
timestamp	timestamp without time zone	PRIMARY KEY
suite	character varying	PRIMARY KEY
lang_ada	integer
lang_ansic	integer
lang_asm	integer
lang_awk	integer
lang_cobol	integer
lang_cpp	integer
lang_cs	integer
lang_csh	integer
lang_erlang	integer
lang_exp	integer
lang_f90	integer
lang_fortran	integer
lang_haskell	integer
lang_java	integer
lang_jsp	integer
lang_lex	integer
lang_lisp	integer
lang_makefile	integer
lang_ml	integer
lang_modula3	integer
lang_objc	integer
lang_pascal	integer
lang_perl	integer
lang_php	integer
lang_python	integer
lang_ruby	integer
lang_sed	integer
lang_sh	integer
lang_sql	integer
lang_tcl	integer
lang_vhdl	integer
lang_xml	integer
lang_yacc	integer

ix_history_sloccount_suite suite ix_history_sloccount_timestamp "timestamp"

Index - Schema public

Table: metrics

metrics Structure
F-Key	Name	Type	Description
	id	serial	PRIMARY KEY
packages.id	package_id	integer	UNIQUE#1 NOT NULL
	metric	metric_types	UNIQUE#1 NOT NULL
	value_	integer	NOT NULL

ix_metrics_package_id package_id

Index - Schema public

Table: package_names

package_names Structure
F-Key	Name	Type	Description
	id	serial	PRIMARY KEY
	name	character varying

Tables referencing this one via Foreign Key Constraints:

packages

Index - Schema public

Table: packages

packages Structure
F-Key	Name	Type	Description
	id	serial	PRIMARY KEY
	version	character varying
package_names.id	name_id	integer	NOT NULL
	area	character varying(8)
	vcs_type	vcs_types
	vcs_url	character varying
	vcs_browser	character varying
	sticky	boolean	NOT NULL

Tables referencing this one via Foreign Key Constraints:

binaries

checksums

ctags

files

metrics

sloccounts

suites

ix_packages_area area ix_packages_name_id name_id ix_packages_name_id_version name_id, version ix_packages_version version

Index - Schema public

Table: sloccounts

sloccounts Structure
F-Key	Name	Type	Description
	id	serial	PRIMARY KEY
packages.id	package_id	integer	UNIQUE#1 NOT NULL
	language	language_names	UNIQUE#1 NOT NULL
	count	integer	NOT NULL

ix_sloccounts_package_id package_id

Index - Schema public

Table: suites

suites Structure
F-Key	Name	Type	Description
	id	serial	PRIMARY KEY
packages.id	package_id	integer	UNIQUE#1 NOT NULL
	suite	character varying	UNIQUE#1

ix_suites_package_id package_id ix_suites_suite suite

Index - Schema public

Table: suites_aliases

suites_aliases Structure
F-Key	Name	Type	Description
	alias	character varying	PRIMARY KEY
suites_info.name	suite	character varying

Index - Schema public

Table: suites_info

suites_info Structure
Name	Type	Description
name	character varying	PRIMARY KEY
version	character varying
release_date	date
sticky	boolean	NOT NULL

Tables referencing this one via Foreign Key Constraints:

suites_aliases

Index - Schema public

Generated by PostgreSQL Autodoc

W3C HTML 4.01 Strict