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
-
53
501
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
-
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
-
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
-
554
117
install_target_providers
#ffffff
id
BIGINT
True
True
package
BIGINT
True
False
install_target
BIGINT
True
False
-
360
56
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
last_moved
DATETIME
True
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
return_date
DATETIME
False
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
-
148.781
186.812
0
186
204.812
180
OneToMany
Mandatory
Mandatory
2
0
-
596.758
482.625
270
600.391
533
90
OneToMany
Mandatory
Mandatory
3
0
-
558.172
395
90
583.885
360.625
270
OneToMany
Mandatory
Mandatory
1
0
-
635.344
395
90
638.771
360.625
270
OneToMany
Mandatory
Mandatory
2
0
-
433.484
303.625
270
447.914
321
90
OneToMany
Mandatory
Mandatory
11
0
-
494.922
-30.7917
0
540
-20.1875
180
OneToMany
Mandatory
Mandatory
3
0
-
693.656
316.812
0
763
276.812
180
OneToMany
Mandatory
Mandatory
2
0
-
494.922
-1.58333
0
563
69.8125
180
OneToMany
Mandatory
Mandatory
2
0
-
613.289
117
90
599.156
97.625
270
OneToMany
Mandatory
Mandatory
2
0
-
421.461
27.625
270
433.484
56
90
OneToMany
Mandatory
Mandatory
1
0
-
554
152.812
180
506.969
138.542
0
OneToMany
Mandatory
Mandatory
1
0
-
451.781
548.812
0
539
568.812
180
OneToMany
Mandatory
Mandatory
4
0
-
506.969
221.083
0
611.328
273
90
OneToMany
Mandatory
Mandatory
2
0
-
661.781
568.812
0
770
559.812
180
OneToMany
Mandatory
Mandatory
2
0
-
315.086
442.625
270
338.891
473
90
OneToMany
Mandatory
Mandatory
1
0
-
383.172
366.812
0
415
348.812
180
OneToMany
Mandatory
Mandatory
2
0
-
360
179.812
180
337.781
291
90
OneToMany
Mandatory
Mandatory
1
0
-
275.271
272.625
270
292.391
291
90
OneToMany
Mandatory
Mandatory
3
0
-
126.484
501
90
247
392.083
180
OneToMany
Mandatory
Mandatory
2
0
-
126.484
346
90
230.635
272.625
270
OneToMany
Mandatory
Mandatory
1
0
-
199.969
405.812
0
247
341.542
180
OneToMany
Mandatory
Mandatory
2
0
-
53
405.812
180
28.6875
413.812
0
OneToMany
Mandatory
Mandatory
4
0
-
799.115
399
90
801.13
312.625
270
OneToMany
Mandatory
Mandatory
1
0
-
844.229
399
90
839.26
312.625
270
OneToMany
Mandatory
Mandatory
2
0
-
910.484
-41.4583
0
945
-35.4583
180
OneToMany
Mandatory
Mandatory
1
0
-
910.484
-22.9167
0
945
-0.916667
180
OneToMany
Mandatory
Mandatory
0
0
-
207.469
-15.1875
0
258
-16.1875
180
OneToMany
Mandatory
Mandatory
2
0
-
25.875
-4.1875
0
106
-15.1875
180
OneToMany
Mandatory
Mandatory
5
0
-
121.914
49
90
156.734
20.625
270
OneToMany
Mandatory
Mandatory
1
0
-
68
84.8125
180
0.75
98.8125
0
OneToMany
Mandatory
Mandatory
2
0
-
-14.5625
63.625
270
-33.625
71
90
OneToMany
Mandatory
Mandatory
3
0
-
252.953
137
90
287.734
111.625
270
OneToMany
Mandatory
Mandatory
2
0
-
287.734
40
90
290.914
11.625
270
OneToMany
Mandatory
Mandatory
1
0