Dumped on 2021-01-25

Index of database - reproducibledb

Table: distributions

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

Tables referencing this one via Foreign Key Constraints:

Index - Schema public

View: dsources

dsources Structure
F-Key Name Type Description
package_id integer
name text
version text
suite text
architecture text
notify_maintainer integer
distribution character varying 
SELECT s.id AS package_id
,
    s.name
,
    s.version
,
    s.suite
,
    s.architecture
,
    s.notify_maintainer
,
    d.name AS distribution
   
FROM (sources s
     
  JOIN distributions d 
    ON (
           (s.distribution = d.id)
     )
);

Index - Schema public

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('public.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('public.results_id_seq'::regclass)
sources.id package_id integer UNIQUE NOT NULL
version text NOT NULL
status text NOT NULL
build_date timestamp without time zone NOT NULL
build_duration integer
node1 text
node2 text
job text NOT NULL
build_type build_type NOT NULL DEFAULT 'ci_build'::build_type

Index - Schema public

Table: schedule

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

Index - Schema public

Table: sources

sources Structure
F-Key Name Type Description
id integer PRIMARY KEY DEFAULT nextval('public.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
distributions.id distribution integer DEFAULT 1

Tables referencing this one via Foreign Key Constraints:

Index - Schema public

Table: stats_breakages

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

Index - Schema public

Table: stats_bugs

stats_bugs Structure
F-Key Name Type Description
datum date 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
open_usrmerge integer
done_usrmerge integer
open_fixfilepath integer
done_fixfilepath integer
open_shell integer
done_shell integer
open_filesystem integer
done_filesystem integer
open_hashordering integer
done_hashordering integer

Index - Schema public

Table: stats_build

stats_build Structure
F-Key Name Type Description
id integer PRIMARY KEY DEFAULT nextval('public.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 timestamp without time zone UNIQUE#1 NOT NULL
build_duration integer NOT NULL
node1 text NOT NULL DEFAULT ''::text
node2 text NOT NULL DEFAULT ''::text
job text NOT NULL
distributions.id distribution integer DEFAULT 1
build_type build_type NOT NULL DEFAULT 'ci_build'::build_type

Index - Schema public

Table: stats_builds_age

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

Index - Schema public

Table: stats_builds_per_day

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

Index - Schema public

Table: stats_issues

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

Index - Schema public

Table: stats_meta_pkg_state

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

Index - Schema public

Table: stats_notes

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

Index - Schema public

Table: stats_pkg_state

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

Index - Schema public

Generated by PostgreSQL Autodoc

W3C HTML 4.01 Strict