Dumped on 2021-10-12
distributions Structure
F-Key |
Name |
Type |
Description |
|
id |
|
PRIMARY KEY
|
Tables referencing this one via Foreign Key Constraints:
Index -
Schema public
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
issues Structure
F-Key |
Name |
Type |
Description |
|
name |
|
PRIMARY KEY
|
Index -
Schema public
manual_scheduler Structure
F-Key |
Name |
Type |
Description |
|
id |
|
PRIMARY KEY
|
Index -
Schema public
notes Structure
F-Key |
Name |
Type |
Description |
sources.id
|
package_id |
|
PRIMARY KEY
|
Index -
Schema public
rb_schema Structure
F-Key |
Name |
Type |
Description |
|
version |
|
PRIMARY KEY
|
Index -
Schema public
removed_packages Structure
F-Key |
Name |
Type |
Description |
|
name |
|
PRIMARY KEY
|
|
suite |
|
PRIMARY KEY
|
|
architecture |
|
PRIMARY KEY
|
Index -
Schema public
results Structure
F-Key |
Name |
Type |
Description |
sources.id
|
package_id |
|
UNIQUE
|
|
id |
|
PRIMARY KEY
|
Index -
Schema public
schedule Structure
F-Key |
Name |
Type |
Description |
sources.id
|
package_id |
|
UNIQUE
|
|
id |
|
PRIMARY KEY
|
Index -
Schema public
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
stats_breakages Structure
F-Key |
Name |
Type |
Description |
|
datum |
|
PRIMARY KEY
|
Index -
Schema public
stats_bugs Structure
F-Key |
Name |
Type |
Description |
|
datum |
|
PRIMARY KEY
|
Index -
Schema public
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
stats_builds_age Structure
F-Key |
Name |
Type |
Description |
|
datum |
|
PRIMARY KEY
|
|
architecture |
|
PRIMARY KEY
|
|
suite |
|
PRIMARY KEY
|
Index -
Schema public
stats_builds_per_day Structure
F-Key |
Name |
Type |
Description |
|
datum |
|
PRIMARY KEY
|
|
architecture |
|
PRIMARY KEY
|
|
suite |
|
PRIMARY KEY
|
Index -
Schema public
stats_issues Structure
F-Key |
Name |
Type |
Description |
|
datum |
|
PRIMARY KEY
|
Index -
Schema public
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
stats_notes Structure
F-Key |
Name |
Type |
Description |
|
datum |
|
PRIMARY KEY
|
Index -
Schema public
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