Dumped on 2021-10-12

Index of database - reproducibledb


Table: distributions

distributions Structure
F-Key Name Type Description
id PRIMARY KEY

Tables referencing this one via Foreign Key Constraints:

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 Type Description
id PRIMARY KEY
distributions.id distribution
name UNIQUE#1
architecture UNIQUE#1
suite UNIQUE#1

Tables referencing this one via Foreign Key Constraints:

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