Dumped on 2023-10-03

Index of database - reproducibledb

public

distributions
dsources
issues
manual_scheduler
notes
rb_schema
removed_packages
results
schedule
sources
stats_breakages
stats_bugs
stats_build
stats_buildinfo
stats_builds_age
stats_builds_per_day
stats_issues
stats_meta_pkg_state
stats_notes
stats_pkg_state

Table: distributions

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

Tables referencing this one via Foreign Key Constraints:

sources

stats_build

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
Name	Type	Description
name	text	PRIMARY KEY
description	text	NOT NULL
url	text

Index - Schema public

Table: manual_scheduler

manual_scheduler Structure
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
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	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('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('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:

notes

results

schedule

Index - Schema public

Table: stats_breakages

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

Index - Schema public

Table: stats_bugs

stats_bugs Structure
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('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_buildinfo

stats_buildinfo Structure
Name	Type	Description
datum	text	PRIMARY KEY
suite	text	PRIMARY KEY
architecture	text	PRIMARY KEY
with_buildinfo	integer
without_buildinfo	integer

Index - Schema public

Table: stats_builds_age

stats_builds_age Structure
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
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
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
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