Dumped on 2021-10-12

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_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		PRIMARY KEY

Tables referencing this one via Foreign Key Constraints:

sources

stats_build

Index - Schema public

View: dsources

dsources Structure
F-Key	Name	Type	Description

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		PRIMARY KEY

Index - Schema public

Table: manual_scheduler

manual_scheduler Structure
F-Key	Name	Type	Description
	id		PRIMARY KEY

Index - Schema public

Table: notes

notes Structure
F-Key	Name	Type	Description
sources.id	package_id		PRIMARY KEY

Index - Schema public

Table: rb_schema

rb_schema Structure
F-Key	Name	Type	Description
	version		PRIMARY KEY

Index - Schema public

Table: removed_packages

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

Index - Schema public

Table: results

results Structure
F-Key	Name	Type	Description
sources.id	package_id		UNIQUE
	id		PRIMARY KEY

Index - Schema public

Table: schedule

schedule Structure
F-Key	Name	Type	Description
sources.id	package_id		UNIQUE
	id		PRIMARY KEY

Index - Schema public

Table: sources

sources Structure
F-Key	Name	Description
	id	PRIMARY KEY
distributions.id	distribution
	name	UNIQUE#1
	architecture	UNIQUE#1
	suite	UNIQUE#1

Tables referencing this one via Foreign Key Constraints:

notes

results

schedule

Index - Schema public

Table: stats_breakages

stats_breakages Structure
F-Key	Name	Type	Description
	datum		PRIMARY KEY

Index - Schema public

Table: stats_bugs

stats_bugs Structure
F-Key	Name	Type	Description
	datum		PRIMARY KEY

Index - Schema public

Table: stats_build

stats_build Structure
F-Key	Name	Description
	name	UNIQUE#1
	build_date	UNIQUE#1
	version	UNIQUE#1
	suite	UNIQUE#1
	id	PRIMARY KEY
distributions.id	distribution
	architecture	UNIQUE#1

Index - Schema public

Table: stats_builds_age

stats_builds_age Structure
F-Key	Name	Type	Description
	datum		PRIMARY KEY
	architecture		PRIMARY KEY
	suite		PRIMARY KEY

Index - Schema public

Table: stats_builds_per_day

stats_builds_per_day Structure
F-Key	Name	Type	Description
	datum		PRIMARY KEY
	architecture		PRIMARY KEY
	suite		PRIMARY KEY

Index - Schema public

Table: stats_issues

stats_issues Structure
F-Key	Name	Type	Description
	datum		PRIMARY KEY

Index - Schema public

Table: stats_meta_pkg_state

stats_meta_pkg_state Structure
F-Key	Name	Type	Description
	architecture		PRIMARY KEY
	suite		PRIMARY KEY
	datum		PRIMARY KEY
	meta_pkg		PRIMARY KEY

Index - Schema public

Table: stats_notes

stats_notes Structure
F-Key	Name	Type	Description
	datum		PRIMARY KEY

Index - Schema public

Table: stats_pkg_state

stats_pkg_state Structure
F-Key	Name	Type	Description
	suite		PRIMARY KEY
	architecture		PRIMARY KEY
	datum		PRIMARY KEY

Index - Schema public

Generated by PostgreSQL Autodoc

W3C HTML 4.01 Strict