Relational
-
237
40
ssh_keys
#ffffff
id
BIGINT
True
True
owner
MEDIUMINT
True
False
fingerprint
TEXT
True
False
-
-68
71
email_actions
#ffffff
id
MEDIUMINT
True
True
name
VARCHAR(32)
True
False
-
68
49
allowed_email_actions
#ffffff
id
BIGINT
True
True
gpg_key
BIGINT
True
False
action
MEDIUMINT
True
False
-
106
-51
gpg_keys
#ffffff
id
BIGINT
True
True
fingerprint
VARCHAR(40)
True
False
owner
MEDIUMINT
True
False
-
258
-44
persons
#ffffff
id
MEDIUMINT
True
True
name
VARCHAR(32)
True
False
-
788
-60
todo_links
#ffffff
dependent
BIGINT
True
False
depending_on
BIGINT
True
False
-
945
-70
todos
#ffffff
id
BIGINT
True
True
file
VARCHAR(64)
True
False
line
MEDIUMINT
True
False
description
TEXT
True
False
importance
SMALLINT
False
False
-
777
32
statitstics
#ffffff
id
BIGINT
True
True
date
DATETIME
True
False
stable_packages_count
MEDIUMINT
True
False
pending_tasks_count
MEDIUMINT
True
False
staging_packages_count
MEDIUMINT
True
False
testing_packages_count
MEDIUMINT
True
False
broken_tasks_count
MEDIUMINT
True
False
dependency_loops_count
MEDIUMINT
True
False
dependency_looped_tasks_count
MEDIUMINT
True
False
locked_tasks_count
MEDIUMINT
True
False
blocked_tasks_count
MEDIUMINT
True
False
next_tasks_count
MEDIUMINT
True
False
-
754
399
repository_stability_relations
#ffffff
id
MEDIUMINT
True
True
more_stable
MEDIUMINT
True
False
less_stable
MEDIUMINT
True
False
-
-62
370
fail_reasons
#ffffff
id
SMALLINT
True
True
name
VARCHAR(32)
True
False
identifier
VARCHAR(64)
True
False
severity
SMALLINT
True
False
-
53
346
failed_builds
#ffffff
id
MEDIUMINT
True
True
build_slave
MEDIUMINT
True
False
build_assignment
BIGINT
True
False
date
DATETIME
True
False
reason
SMALLINT
True
False
log_file
VARCHAR(512)
True
False
-
247
291
build_assignments
#ffffff
id
BIGINT
True
True
package_source
BIGINT
True
False
architecture
SMALLINT
True
False
is_blocked
VARCHAR(128)
False
False
is_black_listed
VARCHAR(128)
False
False
is_broken
BIT
True
False
priority
SMALLINT
True
False
return_date
DATETIME
False
False
-
187
130
build_slaves
#ffffff
id
MEDIUMINT
True
True
name
VARCHAR(32)
True
False
ssh_key
BIGINT
True
False
currently_building
BIGINT
False
False
last_connection
TIME
True
False
logged_lines
BIGINT
False
False
last_action
VARCHAR(32)
False
False
trials
MEDIUMINT
False
False
-
360
56
binary_packages
#ffffff
id
BIGINT
True
True
build_assignment
BIGINT
True
False
epoch
MEDIUMINT
True
False
pkgver
VARCHAR(64)
True
False
pkgrel
MEDIUMINT
True
False
sub_pkgrel
MEDIUMINT
True
False
has_issues
BIT
True
False
is_tested
BIT
True
False
pkgname
VARCHAR(64)
True
False
architecture
SMALLINT
True
False
sha512sum
VARCHAR(128)
False
False
-
549
105
install_target_providers
#ffffff
id
BIGINT
True
True
package
BIGINT
True
False
install_target
BIGINT
True
False
-
549
301
repositories
#ffffff
id
MEDIUMINT
True
True
name
VARCHAR(64)
True
False
stability
SMALLINT
True
False
is_on_master_mirror
BIT
True
False
architecture
SMALLINT
True
False
-
770
508
git_repositories
#ffffff
id
SMALLINT
True
True
name
VARCHAR(64)
True
False
url
VARCHAR(128)
True
False
directory
VARCHAR(128)
True
False
head
VARCHAR(40)
True
False
-
539
533
upstream_repositories
#ffffff
id
SMALLINT
True
True
name
VARCHAR(64)
True
False
git_repository
SMALLINT
True
False
-
226
473
package_sources
#ffffff
id
BIGINT
True
True
pkgbase
VARCHAR(64)
True
False
git_revision
VARCHAR(40)
True
False
mod_git_revision
VARCHAR(40)
True
False
upsream_package_repository
SMALLINT
True
False
uses_upstream
BIT
True
False
uses_modification
BIT
True
False
commit_time
DATETIME
True
False
-
415
321
architectures
#ffffff
id
SMALLINT
True
True
name
VARCHAR(16)
True
False
-
557
30
install_targets
#ffffff
id
BIGINT
True
True
name
VARCHAR(64)
True
False
-
348
-60
dependencies
#ffffff
id
BIGINT
True
True
dependent
BIGINT
True
False
depending_on
BIGINT
True
False
dependency_type
SMALLINT
True
False
-
540
-64
dependency_types
#ffffff
id
SMALLINT
True
True
name
VARCHAR(32)
True
False
relevant_for_building
BIT
True
False
relevant_for_binary_packages
BIT
True
False
-
53
501
build_dependency_loops
#ffffff
id
BIGINT
True
True
loop
MEDIUMINT
True
False
build_assignment
BIGINT
True
False
-
788
281
repository_stabilities
#ffffff
id
SMALLINT
True
True
name
VARCHAR(32)
True
False
bugtracker_category
VARCHAR(32)
False
False
-
494
427
repository_moves
#ffffff
id
MEDIUMINT
True
True
from_repository
MEDIUMINT
True
False
to_repository
MEDIUMINT
True
False
upstream_package_repository
SMALLINT
True
False
-
-55
-72
email_log
#ffffff
id
BIGINT
True
True
date
DATETIME
True
False
success
BIT
True
False
action
MEDIUMINT
False
False
count
MEDIUMINT
False
False
gpg_key
BIGINT
False
False
comment
TEXT
False
False
-
42
135
ssh_log
#ffffff
id
BIGINT
True
True
date
DATETIME
True
False
build_slave
MEDIUMINT
False
False
action
VARCHAR(32)
True
False
parameters
TEXT
True
False
-
543
182
binary_packages_in_repositories
#ffffff
id
BIGINT
True
True
package
BIGINT
True
False
repository
MEDIUMINT
True
False
is_to_be_deleted
BIT
True
False
last_moved
DATETIME
True
False
-
549
346.906
180
509.547
345.906
0
OneToOne
Mandatory
Mandatory
4
0
-
290.109
40
90
293.289
5.8125
270
OneToOne
Mandatory
Mandatory
1
0
-
257.727
130
90
290.109
103.812
270
OneToOne
Mandatory
Mandatory
2
0
-
-9.85156
47.8125
270
-19.2734
71
90
OneToOne
Mandatory
Mandatory
3
0
-
68
80.9062
180
29.4531
95.9062
0
OneToOne
Mandatory
Mandatory
2
0
-
142.789
49
90
159.109
12.8125
270
OneToOne
Mandatory
Mandatory
1
0
-
35.2969
-12.0938
0
106
-19.0938
180
OneToOne
Mandatory
Mandatory
5
0
-
212.219
-19.0938
0
258
-19.0938
180
OneToOne
Mandatory
Mandatory
2
0
-
915.234
-26.7917
0
945
-8.79167
180
OneToOne
Mandatory
Mandatory
0
0
-
915.234
-43.3958
0
945
-39.3958
180
OneToOne
Mandatory
Mandatory
1
0
-
816.656
399
90
840.635
344.812
270
OneToOne
Mandatory
Mandatory
2
0
-
879.312
399
90
893.271
344.812
270
OneToOne
Mandatory
Mandatory
1
0
-
53
398.906
180
33.4375
408.906
0
OneToOne
Mandatory
Mandatory
4
0
-
204.719
398.906
0
247
357.906
180
OneToOne
Mandatory
Mandatory
2
0
-
128.859
346
90
234.151
263.812
270
OneToOne
Mandatory
Mandatory
1
0
-
134.195
501
90
293.974
424.812
270
OneToOne
Mandatory
Mandatory
2
0
-
281.302
263.812
270
293.974
291
90
OneToOne
Mandatory
Mandatory
3
0
-
410.573
231.812
270
340.948
291
90
OneToOne
Mandatory
Mandatory
1
0
-
387.922
357.906
0
415
345.906
180
OneToOne
Mandatory
Mandatory
2
0
-
340.948
424.812
270
341.266
473
90
OneToOne
Mandatory
Mandatory
1
0
-
688.453
564.906
0
770
553.906
180
OneToOne
Mandatory
Mandatory
2
0
-
456.531
539.906
0
539
564.906
180
OneToOne
Mandatory
Mandatory
4
0
-
549
136.906
180
511.719
114.604
0
OneToOne
Mandatory
Mandatory
1
0
-
423.836
17.8125
270
435.859
56
90
OneToOne
Mandatory
Mandatory
1
0
-
627.109
105
90
607.016
79.8125
270
OneToOne
Mandatory
Mandatory
2
0
-
499.672
-8.125
0
557
54.9062
180
OneToOne
Mandatory
Mandatory
2
0
-
718.406
346.906
0
788
312.906
180
OneToOne
Mandatory
Mandatory
2
0
-
499.672
-34.0625
0
540
-25.0938
180
OneToOne
Mandatory
Mandatory
3
0
-
461.146
231.812
270
462.273
321
90
OneToOne
Mandatory
Mandatory
9
0
-
572.755
427
90
605.469
392.812
270
OneToOne
Mandatory
Mandatory
2
0
-
651.51
427
90
661.938
392.812
270
OneToOne
Mandatory
Mandatory
1
0
-
612.133
504.812
270
613.727
533
90
OneToOne
Mandatory
Mandatory
3
0
-
153.531
180.906
0
187
196.906
180
OneToOne
Mandatory
Mandatory
2
0
-
543
227.906
180
511.719
173.208
0
OneToOne
Mandatory
Mandatory
1
0
-
647.922
273.812
270
633.703
301
90
OneToMany
Optional
Optional
2
0