Dumped on 2015-02-21

Index of database - debsources


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:

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: 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:

ix_files_package_id package_id ix_files_path path

Index - Schema public


Table: history_size

history_size Structure
F-Key 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
F-Key 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:

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:

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_info

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

Index - Schema public

Generated by PostgreSQL Autodoc

W3C HTML 4.01 Strict