Relational
-
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
-
-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
-
481
395
repository_moves
#ffffff
id
MEDIUMINT
True
True
from_repository
MEDIUMINT
True
False
to_repository
MEDIUMINT
True
False
upstream_package_repository
SMALLINT
True
False
-
763
241
repository_stabilities
#ffffff
id
SMALLINT
True
True
name
VARCHAR(32)
True
False
bugtracker_category
VARCHAR(32)
False
False
-
52
516
build_dependency_loops
#ffffff
id
BIGINT
True
True
loop
MEDIUMINT
True
False
build_assignment
BIGINT
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
-
348
-60
dependencies
#ffffff
id
BIGINT
True
True
dependent
BIGINT
True
False
depending_on
BIGINT
True
False
dependency_type
SMALLINT
True
False
-
563
42
install_targets
#ffffff
id
BIGINT
True
True
name
VARCHAR(64)
True
False
-
415
321
architectures
#ffffff
id
SMALLINT
True
True
name
VARCHAR(16)
True
False
-
229
471
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
-
539
533
upstream_repositories
#ffffff
id
SMALLINT
True
True
name
VARCHAR(64)
True
False
git_repository
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
-
529
273
repositories
#ffffff
id
MEDIUMINT
True
True
name
VARCHAR(64)
True
False
stability
SMALLINT
True
False
is_on_master_mirror
BIT
True
False
-
553
131
install_target_providers
#ffffff
id
BIGINT
True
True
package
BIGINT
True
False
install_target
BIGINT
True
False
-
375
54
binary_packages
#ffffff
id
BIGINT
True
True
build_assignment
BIGINT
True
False
repository
MEDIUMINT
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
is_to_be_deleted
BIT
True
False
pkgname
VARCHAR(64)
True
False
architecture
SMALLINT
True
False
sha512sum
VARCHAR(128)
False
False
-
186
137
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
-
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
-
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
-
-62
370
fail_reasons
#ffffff
id
SMALLINT
True
True
name
VARCHAR(32)
True
False
identifier
VARCHAR(64)
True
False
severity
SMALLINT
True
False
-
754
399
repository_stability_relations
#ffffff
id
MEDIUMINT
True
True
more_stable
MEDIUMINT
True
False
less_stable
MEDIUMINT
True
False
-
737
38
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
-
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
-
788
-60
todo_links
#ffffff
dependent
BIGINT
True
False
depending_on
BIGINT
True
False
-
258
-44
persons
#ffffff
id
MEDIUMINT
True
True
name
VARCHAR(32)
True
False
-
106
-51
gpg_keys
#ffffff
id
BIGINT
True
True
fingerprint
VARCHAR(40)
True
False
owner
MEDIUMINT
True
False
-
68
49
allowed_email_actions
#ffffff
id
BIGINT
True
True
gpg_key
BIGINT
True
False
action
MEDIUMINT
True
False
-
-68
71
email_actions
#ffffff
id
MEDIUMINT
True
True
name
VARCHAR(32)
True
False
-
237
40
ssh_keys
#ffffff
id
BIGINT
True
True
owner
MEDIUMINT
True
False
fingerprint
TEXT
True
False
-
153.531
180.906
0
186
196.906
180
OneToMany
Mandatory
Mandatory
2
0
-
599.133
472.812
270
613.727
533
90
OneToMany
Mandatory
Mandatory
3
0
-
559.755
395
90
585.469
350.812
270
OneToMany
Mandatory
Mandatory
1
0
-
638.51
395
90
641.938
350.812
270
OneToMany
Mandatory
Mandatory
2
0
-
476.146
257.812
270
462.273
321
90
OneToMany
Mandatory
Mandatory
11
0
-
499.672
-34.0625
0
540
-25.0938
180
OneToMany
Mandatory
Mandatory
3
0
-
698.406
311.906
0
763
272.906
180
OneToMany
Mandatory
Mandatory
2
0
-
499.672
-8.125
0
563
66.9062
180
OneToMany
Mandatory
Mandatory
2
0
-
631.109
131
90
613.016
91.8125
270
OneToMany
Mandatory
Mandatory
2
0
-
423.836
17.8125
270
450.859
54
90
OneToMany
Mandatory
Mandatory
1
0
-
553
162.906
180
526.719
121.938
0
OneToMany
Mandatory
Mandatory
1
0
-
459.531
537.906
0
539
564.906
180
OneToMany
Mandatory
Mandatory
4
0
-
526.719
189.875
0
613.703
273
90
OneToMany
Mandatory
Mandatory
2
0
-
688.453
564.906
0
770
553.906
180
OneToMany
Mandatory
Mandatory
2
0
-
340.948
410.812
270
344.266
471
90
OneToMany
Mandatory
Mandatory
1
0
-
387.922
350.906
0
415
345.906
180
OneToMany
Mandatory
Mandatory
2
0
-
425.573
257.812
270
340.948
291
90
OneToMany
Mandatory
Mandatory
1
0
-
280.302
256.812
270
293.974
291
90
OneToMany
Mandatory
Mandatory
3
0
-
133.195
516
90
293.974
410.812
270
OneToMany
Mandatory
Mandatory
2
0
-
128.859
346
90
233.151
256.812
270
OneToMany
Mandatory
Mandatory
1
0
-
204.719
398.906
0
247
350.906
180
OneToMany
Mandatory
Mandatory
2
0
-
53
398.906
180
33.4375
408.906
0
OneToMany
Mandatory
Mandatory
4
0
-
816.656
399
90
815.635
304.812
270
OneToMany
Mandatory
Mandatory
1
0
-
879.312
399
90
868.271
304.812
270
OneToMany
Mandatory
Mandatory
2
0
-
915.234
-43.3958
0
945
-39.3958
180
OneToMany
Mandatory
Mandatory
1
0
-
915.234
-26.7917
0
945
-8.79167
180
OneToMany
Mandatory
Mandatory
0
0
-
212.219
-19.0938
0
258
-19.0938
180
OneToMany
Mandatory
Mandatory
2
0
-
35.2969
-12.0938
0
106
-19.0938
180
OneToMany
Mandatory
Mandatory
5
0
-
142.789
49
90
159.109
12.8125
270
OneToMany
Mandatory
Mandatory
1
0
-
68
80.9062
180
29.4531
95.9062
0
OneToMany
Mandatory
Mandatory
2
0
-
-9.85156
47.8125
270
-19.2734
71
90
OneToMany
Mandatory
Mandatory
3
0
-
256.727
137
90
290.109
103.812
270
OneToMany
Mandatory
Mandatory
2
0
-
290.109
40
90
293.289
5.8125
270
OneToMany
Mandatory
Mandatory
1
0