Logical Column Name	Physical Column Name	Type	PK	Nullable
id (PK)	id	INTEGER	PK	NOT NULL
name	name	LONGVARCHAR		NOT NULL

Referenced By

packageinstance referencing (id)
suitearches referencing (id)

Logical Column Name	Physical Column Name	Type	PK	Nullable
id (PK)	id	INTEGER	PK	NOT NULL
name	name	LONGVARCHAR		NOT NULL

Referenced By

job referencing (id)

Logical Column Name	Physical Column Name	Type	PK	Nullable
id (PK)	id	INTEGER	PK	NOT NULL
name	name	LONGVARCHAR		NOT NULL

Referenced By

buildenvsuitearch referencing (id)
packageinstance referencing (id)

Logical Column Name	Physical Column Name	Type	PK	Nullable
id (PK) (FK)	id	INTEGER	PK	NOT NULL
buildenv_id (FK)	buildenv_id	BIGINT		NOT NULL
suitearch_id (FK)	suitearch_id	INTEGER		NOT NULL

References

buildenv through (buildenv_id)
suitearches through (suitearch_id, id)

buildrequest

(Physical Name: buildrequest)

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

Logical Column Name	Physical Column Name	Type	PK	Nullable
id (PK)	id	INTEGER	PK	NOT NULL
job (FK)	job	INTEGER		NOT NULL
method	method	LONGVARCHAR		NOT NULL
uri	uri	LONGVARCHAR		NOT NULL
vcs_id	vcs_id	LONGVARCHAR		NOT NULL
buildenv_name	buildenv_name	LONGVARCHAR

References

job through (job)

Logical Column Name	Physical Column Name	Type	PK	Nullable
id (PK)	id	INTEGER	PK	NOT NULL
name	name	LONGVARCHAR		NOT NULL

Referenced By

packageinstance referencing (id)

format

(Physical Name: format)

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

Logical Column Name	Physical Column Name	Type	PK	Nullable
id (PK)	id	INTEGER	PK	NOT NULL
name	name	LONGVARCHAR		NOT NULL

Referenced By

packageinstance referencing (id)

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 Name	Physical Column Name	Type	PK	Nullable
id (PK)	id	INTEGER	PK	NOT NULL
packageinstance_id (FK)	packageinstance_id	BIGINT		NOT NULL
buildclient_id (FK)	buildclient_id	BIGINT

References

buildclients through (buildclient_id)
packageinstance through (packageinstance_id)

Referenced By

buildrequest referencing (id)
jobstatus referencing (id)

Logical Column Name	Physical Column Name	Type	PK	Nullable
id (PK) (FK)	id	INTEGER	PK	NOT NULL
job_id	job_id	BIGINT		NOT NULL
status_id (FK)	status_id	BIGINT		NOT NULL
time	time	TIMESTAMP		NOT NULL

References

job through (id)
status through (status_id)

Logical Column Name	Physical Column Name	Type	PK	Nullable
id (PK)	id	INTEGER	PK	NOT NULL
version	version	LONGVARCHAR		NOT NULL
name	name	LONGVARCHAR		NOT NULL

Referenced By

packageinstance referencing (id)

Logical Column Name	Physical Column Name	Type	PK	Nullable
id (PK)	id	INTEGER	PK	NOT NULL
package_id (FK)	package_id	BIGINT		NOT NULL
buildenv_id (FK)	buildenv_id	BIGINT
arch_id (FK)	arch_id	BIGINT		NOT NULL
suite_id	suite_id	INTEGER		NOT NULL
dist_id (FK)	dist_id	BIGINT		NOT NULL
format_id (FK)	format_id	BIGINT		NOT NULL
master	master	BOOLEAN		NOT 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

arch through (arch_id)
buildenv through (buildenv_id)
distribution through (dist_id)
format through (format_id)
package through (package_id)
suite through ()

Referenced By

job referencing (id)

Logical Column Name	Physical Column Name	Type	PK	Nullable
id (PK)	id	INTEGER	PK	NOT NULL
name	name	LONGVARCHAR		NOT NULL

Referenced By

jobstatus referencing (id)

Logical Column Name	Physical Column Name	Type	PK	Nullable
id	id	INTEGER		NOT NULL
name	name	LONGVARCHAR		NOT NULL

Referenced By

packageinstance referencing ()

Logical Column Name	Physical Column Name	Type	PK	Nullable
id (PK)	id	INTEGER	PK	NOT NULL
id (PK)	id	INTEGER	PK	NOT NULL
suite_id	suite_id	BIGINT		NOT NULL
arch_id (FK)	arch_id	BIGINT		NOT NULL
master_weight	master_weight	BIGINT		NOT NULL

References

arch through (arch_id)

Referenced By

buildenvsuitearch referencing (id, id)

schema.pdf

List of tables

arch

(Physical Name: arch)

buildclients

(Physical Name: buildclients)

buildenv

(Physical Name: buildenv)

buildenvsuitearch

(Physical Name: buildenvsuitearch)

buildrequest

(Physical Name: buildrequest)

distribution

(Physical Name: distribution)

format

(Physical Name: format)

job

(Physical Name: job)

jobstatus

(Physical Name: jobstatus)

package

(Physical Name: package)

packageinstance

(Physical Name: packageinstance)

status

(Physical Name: status)

suite

(Physical Name: suite)

suitearches

(Physical Name: suitearches)