[newdak/master] theory
added a bit theory about the sql
Signed-off-by: Joerg Jaspert <joerg@debian.org>
---
sql/theory.txt | 110 ++++++++++++++++++++++++++++++++++++++++++++++++++++++++
1 files changed, 110 insertions(+), 0 deletions(-)
create mode 100644 sql/theory.txt
diff --git a/sql/theory.txt b/sql/theory.txt
new file mode 100644
index 0000000..f42aef3
--- /dev/null
+++ b/sql/theory.txt
@@ -0,0 +1,110 @@
+glossary/examples:
+suite: etch, lenny, sid
+component: main, non-free, non-clint, main/debian-installer
+architecture: m68k, i386
+binary: mailfilter, tor, pornview
+binary set: all binary packages build from one particular source debian revision at one binary revision.
+source: glibc, debian-installer
+mirrorfiles: libc6_1.2.3.4-42_i386.deb, pxelinux.0
+type: deb, udeb, tdeb, prondeb, source, misc
+section: admin, utils, mail
+maintainer: joerg@debian.org, joerg@ganneff.de
+fingerprint: E37DFA02F9231A49195DE8C1B61CADF50E95EE4B, 327870A01696E1903AEF0DD182C15B02E5F13196
+uid: joerg, mhy, sgran
+path: /bin/bash, /usr/bin/ruby1.8
+queue: NEW, p-u-NEW, byhand, embargoed, unembargoed, ...
+visibility: everyone can see it, ftpteam only, security only, ...
+location: /srv/ftp.debian.org/ftp/pool/main, /srv/ftp.debian.org/ftp/pool/contrib, /srv/tmp/broken/, ...
+
+(current queue list: Accepted Byhand ProposedUpdates OldProposedUpdates
+Done Holding New Reject Unchecked BTSVersionTrack Embargoed
+Unembargoed Disembargo)
+
+(proposed-queue-list: $suite-proposed-updates, new, byhand,
+$suite-security-secret, $suite-security-open)
+
+
+
+[] mark things that most likely should be triggers or application level.
+
+# archive
+An archive has one or more suites.
+
+# suite
+A suite has one or more components.
+[A suite has one or more architectures (allowed).]
+A suite has one location.
+A suite has one or more queues.
+
+# component
+A component is part of one or more suites.
+A component meets the DFSG - or doesnt.
+
+# location
+A location is a filesystem path.
+[A location has a visibility.]
+
+# queue
+A queue has one or more locations.
+A queue has a default location.
+
+# source
+A source is part of one or more suites.
+A source is part of one component.
+A source builds one or more binary sets.
+A source has one or more mirrorfiles.
+A source has one section.
+A source has one priority.
+A source belongs to one changes file.
+
+# binary set
+A binary set has a binary revision.
+A binary set has one or more binaries.
+A binary set belongs to one source.
+
+# binary
+A binary is part of one or more suites.
+A binary belongs to one binary set.
+A binary has one architecture.
+A binary has one or more mirrorfiles.
+A binary belongs to one section.
+A binary has one prionity.
+A binary has a description.
+A binary belongs to a changes file.
+
+# mirrorfile
+A mirrorfile belongs to one or more binary or one or more sources.
+A mirrorfile has one or more checksums.
+A mirrorfile has one or more locations and/or is in a queue.
+A mirrorfile has a type.
+A mirrorFile has one or many paths.
+
+# path
+A path may be in one or more mirrorfiles.
+A path has one or more checksums.
+
+# description
+A description belongs to one or more binaries.
+A description has zero or more translations.
+
+# translation
+A translation has one language.
+
+# changes file
+A changes file has zero or one sources.
+A changes file has one or more binaries.
+A changes file has one fingerprint.
+
+# fingerprint
+A fingerprint belongs to one or more maintainers.
+A fingerprint belongs to one or more keyrings.
+
+# keyring
+A keyring has one or more fingerprints.
+
+# maintainer
+A maintainer has one or more fingerprints.
+A maintainer belongs to zero or one uids.
+
+# uid
+A uid is a username
--
1.5.6.5
Reply to: