schema.pdf

List of tables

arch

(Physical Name: arch)

Logical Column NamePhysical Column NameTypePKNullable
id (PK)idINTEGERPKNOT NULL
namenameLONGVARCHARNOT NULL

Referenced By

buildclients

(Physical Name: buildclients)

Logical Column NamePhysical Column NameTypePKNullable
id (PK)idINTEGERPKNOT NULL
namenameLONGVARCHARNOT NULL

Referenced By

buildenv

(Physical Name: buildenv)

Logical Column NamePhysical Column NameTypePKNullable
id (PK)idINTEGERPKNOT NULL
namenameLONGVARCHARNOT NULL

Referenced By

buildenvsuitearch

(Physical Name: buildenvsuitearch)

Logical Column NamePhysical Column NameTypePKNullable
id (PK)  (FK) idINTEGERPKNOT NULL
buildenv_id  (FK) buildenv_idBIGINTNOT NULL
suitearch_id  (FK) suitearch_idINTEGERNOT NULL

References

buildrequest

(Physical Name: buildrequest)

BuildRequest is used to log build details so they can in future be requeued.

Logical Column NamePhysical Column NameTypePKNullable
id (PK)idINTEGERPKNOT NULL
job  (FK) jobINTEGERNOT NULL
methodmethodLONGVARCHARNOT NULL
uriuriLONGVARCHARNOT NULL
vcs_idvcs_idLONGVARCHARNOT NULL
buildenv_namebuildenv_nameLONGVARCHAR

References

distribution

(Physical Name: distribution)

For example this could be Debian Squeeze, Ubuntu, Windows 7

Logical Column NamePhysical Column NameTypePKNullable
id (PK)idINTEGERPKNOT NULL
namenameLONGVARCHARNOT NULL

Referenced By

format

(Physical Name: format)

This is the format of the package instance, for example MSI, deb, rpm, tarball

Logical Column NamePhysical Column NameTypePKNullable
id (PK)idINTEGERPKNOT NULL
namenameLONGVARCHARNOT NULL

Referenced By

job

(Physical Name: job)

A Job is how we build a given package instance, multiple jobs may be submitted for a single package.

Logical Column NamePhysical Column NameTypePKNullable
id (PK)idINTEGERPKNOT NULL
packageinstance_id  (FK) packageinstance_idBIGINTNOT NULL
buildclient_id  (FK) buildclient_idBIGINT

References

Referenced By

jobstatus

(Physical Name: jobstatus)

Logical Column NamePhysical Column NameTypePKNullable
id (PK)  (FK) idINTEGERPKNOT NULL
job_idjob_idBIGINTNOT NULL
status_id  (FK) status_idBIGINTNOT NULL
timetimeTIMESTAMPNOT NULL

References

package

(Physical Name: package)

Logical Column NamePhysical Column NameTypePKNullable
id (PK)idINTEGERPKNOT NULL
versionversionLONGVARCHARNOT NULL
namenameLONGVARCHARNOT NULL

Referenced By

packageinstance

(Physical Name: packageinstance)

Logical Column NamePhysical Column NameTypePKNullable
id (PK)idINTEGERPKNOT NULL
package_id  (FK) package_idBIGINTNOT NULL
buildenv_id  (FK) buildenv_idBIGINT
arch_id  (FK) arch_idBIGINTNOT NULL
suite_idsuite_idINTEGERNOT NULL
dist_id  (FK) dist_idBIGINTNOT NULL
format_id  (FK) format_idBIGINTNOT NULL
mastermasterBOOLEANNOT NULL
Master tell us if this instance is the first submitted for a given package, this information is acted on by certain build clients

References

Referenced By

status

(Physical Name: status)

Logical Column NamePhysical Column NameTypePKNullable
id (PK)idINTEGERPKNOT NULL
namenameLONGVARCHARNOT NULL

Referenced By

suite

(Physical Name: suite)

Logical Column NamePhysical Column NameTypePKNullable
ididINTEGERNOT NULL
namenameLONGVARCHARNOT NULL

Referenced By

suitearches

(Physical Name: suitearches)

Logical Column NamePhysical Column NameTypePKNullable
id (PK)idINTEGERPKNOT NULL
id (PK)idINTEGERPKNOT NULL
suite_idsuite_idBIGINTNOT NULL
arch_id  (FK) arch_idBIGINTNOT NULL
master_weightmaster_weightBIGINTNOT NULL

References

Referenced By