Dumped on 2017-05-23

Index of database - reproducibledb


Table: issues

issues Structure
F-Key Name Type Description
name text PRIMARY KEY
description text NOT NULL
url text

Index - Schema public


Table: manual_scheduler

manual_scheduler Structure
F-Key Name Type Description
id integer PRIMARY KEY DEFAULT nextval('manual_scheduler_id_seq'::regclass)
package_id integer NOT NULL
requester text NOT NULL
date_request integer NOT NULL

Index - Schema public


Table: notes

notes Structure
F-Key Name Type Description
sources.id package_id integer PRIMARY KEY
version text NOT NULL
issues text
bugs text
comments text

Index - Schema public


Table: rb_schema

rb_schema Structure
F-Key Name Type Description
version integer PRIMARY KEY
date text NOT NULL

Index - Schema public


Table: removed_packages

removed_packages Structure
F-Key Name Type Description
name text PRIMARY KEY
suite text PRIMARY KEY
architecture text PRIMARY KEY

Index - Schema public


Table: results

results Structure
F-Key Name Type Description
id integer PRIMARY KEY DEFAULT nextval('results_id_seq'::regclass)
sources.id package_id integer UNIQUE NOT NULL
version text NOT NULL
status text NOT NULL
build_date text NOT NULL
build_duration integer
node1 text
node2 text
job text NOT NULL

Index - Schema public


Table: schedule

schedule Structure
F-Key Name Type Description
id integer PRIMARY KEY DEFAULT nextval('schedule_id_seq'::regclass)
sources.id package_id integer UNIQUE NOT NULL
date_scheduled text NOT NULL
scheduler text
date_build_started text
job text
notify text NOT NULL DEFAULT ''::text
save_artifacts integer
message text

Index - Schema public


Table: sources

sources Structure
F-Key Name Type Description
id integer PRIMARY KEY DEFAULT nextval('sources_id_seq'::regclass)
name text UNIQUE#1 NOT NULL
version text NOT NULL
suite text UNIQUE#1 NOT NULL
architecture text UNIQUE#1 NOT NULL
notify_maintainer integer NOT NULL

Tables referencing this one via Foreign Key Constraints:

Index - Schema public


Table: stats_breakages

stats_breakages Structure
F-Key Name Type Description
datum text PRIMARY KEY
diffoscope_timeouts integer
diffoscope_crashes integer

Index - Schema public


Table: stats_bugs

stats_bugs Structure
F-Key Name Type Description
datum text PRIMARY KEY
open_toolchain integer
done_toolchain integer
open_infrastructure integer
done_infrastructure integer
open_timestamps integer
done_timestamps integer
open_fileordering integer
done_fileordering integer
open_buildpath integer
done_buildpath integer
open_username integer
done_username integer
open_hostname integer
done_hostname integer
open_uname integer
done_uname integer
open_randomness integer
done_randomness integer
open_buildinfo integer
done_buildinfo integer
open_cpu integer
done_cpu integer
open_signatures integer
done_signatures integer
open_environment integer
done_environment integer
open_umask integer
done_umask integer
open_ftbfs integer
done_ftbfs integer
open_locale integer
done_locale integer

Index - Schema public


Table: stats_build

stats_build Structure
F-Key Name Type Description
id integer PRIMARY KEY DEFAULT nextval('stats_build_id_seq'::regclass)
name text UNIQUE#1 NOT NULL
version text UNIQUE#1 NOT NULL
suite text UNIQUE#1 NOT NULL
architecture text UNIQUE#1 NOT NULL
status text NOT NULL
build_date text UNIQUE#1 NOT NULL
build_duration text NOT NULL
node1 text NOT NULL DEFAULT ''::text
node2 text NOT NULL DEFAULT ''::text
job text NOT NULL
schedule_message text NOT NULL DEFAULT ''::text

Index - Schema public


Table: stats_builds_age

stats_builds_age Structure
F-Key Name Type Description
datum text PRIMARY KEY
suite text PRIMARY KEY
architecture text PRIMARY KEY
oldest_reproducible real
oldest_unreproducible real
oldest_ftbfs real

Index - Schema public


Table: stats_builds_per_day

stats_builds_per_day Structure
F-Key Name Type Description
datum text PRIMARY KEY
suite text PRIMARY KEY
architecture text PRIMARY KEY
reproducible integer
unreproducible integer
ftbfs integer
other integer

Index - Schema public


Table: stats_issues

stats_issues Structure
F-Key Name Type Description
datum text PRIMARY KEY
known_issues integer

Index - Schema public


Table: stats_meta_pkg_state

stats_meta_pkg_state Structure
F-Key Name Type Description
datum text PRIMARY KEY
suite text PRIMARY KEY
architecture text PRIMARY KEY
meta_pkg text PRIMARY KEY
reproducible integer
unreproducible integer
ftbfs integer
other integer

Index - Schema public


Table: stats_notes

stats_notes Structure
F-Key Name Type Description
datum text PRIMARY KEY
packages_with_notes integer

Index - Schema public


Table: stats_pkg_state

stats_pkg_state Structure
F-Key Name Type Description
datum text PRIMARY KEY
suite text PRIMARY KEY
architecture text PRIMARY KEY
untested integer
reproducible integer
unreproducible integer
ftbfs integer
other integer

Index - Schema public

Generated by PostgreSQL Autodoc

W3C HTML 4.01 Strict