← Back to branch summary

~launchpad-pqm/launchpad/devel

« back to all changes in this revision

Viewing changes to database/schema/diagram.cfg

  • Committer: Stuart Bishop
  • Date: 2005-11-24 07:47:19 UTC
  • mto: This revision was merged to the branch mainline in revision 2851.
  • Revision ID: stuart.bishop@canonical.com-20051124074719-1f14a54a1d23e0ff
Update database diagrams and documentation

Show diffs side-by-side

added added

removed removed

Lines of Context:
database/schema/diagram.cfg
28
28
[registry]
29
29
tables=product++, potemplate-, productbugassignment-, bugtask-, person-, projectrelationship, projectrole, productbounty-, productrelease, productreleasefile, ticket-, specification-, milestone-
30
30
 
 
31
[subscriptions]
 
32
tables=branchsubscription, bugsubscription, specificationsubscription, ticketsubscription, bountysubscription, person, message, messagechunk
 
33
 
31
34
[foaf]
32
 
tables=person+, emailaddress, gpgkey, ircid, jabberid, karma, logintoken, personlabel, personlanguage, sshkey, teammembership, teamparticipation, wikiname, personlabel-, signedcodeofconduct, calendarsubscription, karmaaction, karmacache, libraryfilealias-
 
35
tables=person+, emailaddress, gpgkey, ircid, jabberid, karma, logintoken, personlabel, personlanguage, sshkey, teammembership, teamparticipation, wikiname, personlabel-, signedcodeofconduct, calendarsubscription, karmaaction, karmacache, libraryfilealias-, karmacategory
33
36
 
34
37
[voting]
35
38
tables=person, votecast, poll, vote, polloption
38
41
tables=calendar++
39
42
 
40
43
[malone]
41
 
tables=bug++, bugtask+, projectbugtracker, bugtrackertype, bugtracker, person-, bugattachment, binarypackagename-, distribution-, distrorelease-, sourcepackagename-, product-, cve, cvereference, specificationbug-, ticketbug-
 
44
tables=bug++, bugtask+, projectbugtracker, bugtrackertype, bugtracker, person-, bugattachment, binarypackagename-, distribution-, distrorelease-, sourcepackagename-, product-, cve, cvereference, specificationbug-, ticketbug-, packagebugcontact
42
45
 
43
46
[rosetta]
44
47
tables=potemplate+, pofile++, potranslation++, potmsgset++, person-, country, spokenin, translationeffort, posubscription, translationeffortpotemplate, sourcepackagename-, distrorelease-, sourcepackagerelease-, binarypackagename-, productrelease-, libraryfilealias-, license, poselection, translator, translationgroup
46
49
license=
47
50
 
48
51
[misc]
49
 
tables=libraryfilealias, libraryfilecontent, launchpaddatabaserevision, label, person, personlabel, processor, processorfamily, launchpadstatistic, message, messagechunk
50
 
message=messagechunk
 
52
tables=libraryfilealias, libraryfilecontent, launchpaddatabaserevision, label, person, personlabel, processor, processorfamily, launchpadstatistic, schema
51
53
libraryfilecontent=libraryfilealias
52
54
libraryfilealias=libraryfilecontent
53
55
 
54
56
[soyuz]
55
 
tables=distribution+, distrorelease+, sourcepackagename, packagepublishing, sourcepackagepublishing, distrorelease, distroarchrelease,  section, osfileinpackage, component, binarypackage, sourcepackage, sourcepackagelabel, sourcepackagereleasefile, sourcepackagerelationship, sectionselection, componentselection, distributionrole, packageselection, distroreleaserole, binarypackagefile, sourcepackagerelease, packagepublishinghistory, maintainership, packaging, mirrorsourcecontent, sourcepackagepublishinghistory, osfile, person-, binarypackagename, distroreleasequeue-, mirrorsourcecontent-, build, pocketchroot, distroreleaselanguage, pocketchroot-, binarypackagerelease, securesourcepackagepublishinghistory, securebinarypackagepublishinghistory
 
57
tables=distribution+, distrorelease+, sourcepackagename, packagepublishing, sourcepackagepublishing, distrorelease, distroarchrelease,  section, osfileinpackage, component, binarypackage, sourcepackage, sourcepackagelabel, sourcepackagereleasefile, sourcepackagerelationship, sectionselection, componentselection, distributionrole, packageselection, distroreleaserole, binarypackagefile, sourcepackagerelease, packagepublishinghistory, maintainership, packaging, mirrorsourcecontent, sourcepackagepublishinghistory, osfile, person-, binarypackagename, distroreleasequeue-, mirrorsourcecontent-, build, pocketchroot, distroreleaselanguage, pocketchroot-, binarypackagerelease, securesourcepackagepublishinghistory, securebinarypackagepublishinghistory, distroreleasepackagecache, distributionsourcepackagecache
56
58
sourcepackagename=
57
59
binarypackagename=
58
60
component=
59
61
section=
60
62
 
61
63
[build]
62
 
tables=build, distroreleasequeuebuild, buildqueue, builder, processor, distroreleasequeuesource, distroreleasequeue, distroarchrelease, pocketchroot, distrorelease, processorfamily, binarypackagerelease
 
64
tables=build, distroreleasequeuebuild, buildqueue, builder, processor, distroreleasequeuesource, distroreleasequeue, distroarchrelease, pocketchroot, distrorelease, processorfamily, binarypackagerelease, distroreleasequeuecustom, distrocomponentuploader, distribution, component, section
63
65
 
64
66
[mirrors]
65
67
tables=mirror+, mirrorcontent, mirrorsourcecontent, person-, component+, pushmirroraccess
66
68
 
67
69
[buttress]
68
 
tables=sourcesource, archconfigentry, branchlabel, archarchive, archuserid, changeset, manifestentry, manifest, archnamespace, archarchivelocationsigner, branchrelationship, archarchivelocation, changesetfilename, archconfig, changesetfile, branch, changesetfilehash, developmentmanifest, manifestancestry
 
70
tables=sourcesource, archconfigentry, branchlabel, archarchive, archuserid, changeset, manifestentry, manifest, archnamespace, archarchivelocationsigner, branchrelationship, archarchivelocation, changesetfilename, archconfig, changesetfile, branch, changesetfilehash, developmentmanifest, manifestancestry, revisionparent, revisionauthor, revision, revisionnumber
69
71
 
70
72
[bounty]
71
73
tables=bounty++, bountysubscription, bountymessage,
72
74
 
73
75
[specifications]
74
 
tables=specification, specificationbug, specificationreview, specificationsubscription, specificationdependency
 
76
tables=specification, specificationbug, specificationreview, specificationsubscription, specificationdependency, specificationfeedback
75
77
 
76
78
[ticketing]
77
79
tables=ticket, ticketmessage, ticketsubscription, ticketbug, ticketreopening