From 44583908b0ea2ab4febbc28c6a6334f2b00282bb Mon Sep 17 00:00:00 2001 From: Mattia Rizzolo Date: Thu, 26 Feb 2015 03:09:18 +0100 Subject: reproducible: add reproducible_schema.svg, drawing the main part of the reproducible build project database --- reproducible_schema.svg | 1 + 1 file changed, 1 insertion(+) create mode 100644 reproducible_schema.svg diff --git a/reproducible_schema.svg b/reproducible_schema.svg new file mode 100644 index 00000000..c4b1a75b --- /dev/null +++ b/reproducible_schema.svg @@ -0,0 +1 @@ +
results
[Not supported by viewer]
  • id (int, PK)
  • package_id (int, not null, FK)
  • version (text, not null)
  • status (text)
  • build_date (text)
  • build_duration (text)
  • unique (package, version)
[Not supported by viewer]
sources
[Not supported by viewer]
  • id (int, PK)
  • name (text)
  • version (text)
  • suite (text)
  • architecture (text)
  • unique (name, suite, architecture)
[Not supported by viewer]
schema
[Not supported by viewer]
  • version (int, PK)
  • date (text, not null)
[Not supported by viewer]
schedule
[Not supported by viewer]
  • id (int, PK)
  • package_id (text, not null, FK)
  • date_scheduled (text, not null)
  • date_build_started (text, not null)
  • save_artifacts (int)
  • unique (package, version)
[Not supported by viewer]
stats_builds
[Not supported by viewer]
  • id (int, PK)
  • name (text, not null)
  • version (text, not null)
  • suite (text, not null)
  • architecture (text, not null)
  • status (text, not null)
  • build_date (text, not null)
  • build_duration (text, not null)
  • unique (name, version, suite, architecture, build_date)
[Not supported by viewer]
This table is quite the same of results, but
it is meant to keep record of all builds.
The choice of duplicating data in this way is done for
performarce reasones.
[Not supported by viewer] \ No newline at end of file -- cgit v1.2.3-70-g09d2