Relational
-
796
131
file_providers
#ffffff
id
BIGINT
True
True
package
BIGINT
True
False
file
BIGINT
True
False
file_name_hash
MEDIUMINT
True
False
-
785
6
files
#ffffff
id
BIGINT
True
True
path
TEXT
True
False
name
TEXT
True
False
name_hash
MEDIUMINT
True
False
absolute_name_hash
VARCHAR(54)
True
False
-
754
399
repository_stability_relations
#ffffff
id
MEDIUMINT
True
True
more_stable
MEDIUMINT
True
False
less_stable
MEDIUMINT
True
False
-
53
103
fail_reasons
#ffffff
id
SMALLINT
True
True
name
VARCHAR(32)
True
False
identifier
VARCHAR(64)
True
False
severity
SMALLINT
True
False
-
45
287
failed_builds
#ffffff
id
MEDIUMINT
True
True
build_slave
MEDIUMINT
True
False
build_assignment
BIGINT
True
False
date
TIME
True
False
reason
SMALLINT
True
False
log_file
VARCHAR(512)
True
False
-
245
331
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
-
163
88
build_slaves
#ffffff
id
MEDIUMINT
True
True
name
VARCHAR(32)
True
False
ssh_key
VARCHAR(1024)
True
False
operator
VARCHAR(32)
True
False
currently_building
BIGINT
False
False
last_connection
TIME
True
False
logged_lines
BIGINT
False
False
last_action
VARCHAR(32)
False
False
-
329
46
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
-
611
89
install_target_providers
#ffffff
id
BIGINT
True
True
package
BIGINT
True
False
install_target
BIGINT
True
False
-
516
246
repositories
#ffffff
id
MEDIUMINT
True
True
name
VARCHAR(64)
True
False
stability
SMALLINT
True
False
is_on_master_mirror
BIT
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
-
229
487
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
-
421
321
architectures
#ffffff
id
SMALLINT
True
True
name
VARCHAR(16)
True
False
-
680
3
install_targets
#ffffff
id
BIGINT
True
True
name
VARCHAR(64)
True
False
-
496
-6
dependencies
#ffffff
id
BIGINT
True
True
dependent
BIGINT
True
False
depending_on
BIGINT
True
False
dependency_type
SMALLINT
True
False
-
51
-8
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
-
52
516
build_dependency_loops
#ffffff
id
BIGINT
True
True
loop
MEDIUMINT
True
False
build_assignment
BIGINT
True
False
-
763
241
repository_stabilities
#ffffff
id
SMALLINT
True
True
name
VARCHAR(32)
True
False
bugtracker_category
VARCHAR(32)
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
-
796
169.906
180
480.719
168.288
0
OneToMany
Mandatory
Mandatory
1
0
-
864
131
90
871.711
97.8125
270
OneToMany
Optional
Optional
2
0
-
816.656
399
90
815.635
304.812
270
OneToMany
Mandatory
Mandatory
2
0
-
879.312
399
90
868.271
304.812
270
OneToMany
Mandatory
Mandatory
1
0
-
95.5729
287
90
100.719
180.812
270
OneToMany
Mandatory
Mandatory
4
0
-
196.719
339.906
0
245
390.906
180
OneToMany
Mandatory
Mandatory
2
0
-
146.146
287
90
210.151
221.812
270
OneToMany
Mandatory
Mandatory
1
0
-
133.195
516
90
291.974
450.812
270
OneToMany
Mandatory
Mandatory
2
0
-
257.302
221.812
270
291.974
331
90
OneToMany
Mandatory
Mandatory
4
0
-
379.573
249.812
270
338.948
331
90
OneToMany
Mandatory
Mandatory
1
0
-
385.922
390.906
0
421
345.906
180
OneToMany
Mandatory
Mandatory
2
0
-
338.948
450.812
270
344.266
487
90
OneToMany
Mandatory
Mandatory
1
0
-
688.453
564.906
0
770
553.906
180
OneToMany
Mandatory
Mandatory
2
0
-
480.719
209.05
0
600.703
246
90
OneToMany
Mandatory
Mandatory
2
0
-
459.531
546.906
0
539
564.906
180
OneToMany
Mandatory
Mandatory
4
0
-
611
120.906
180
480.719
127.525
0
OneToMany
Mandatory
Mandatory
1
0
-
571.836
71.8125
270
480.719
86.7625
0
OneToMany
Mandatory
Mandatory
1
0
-
689.109
89
90
730.016
52.8125
270
OneToMany
Mandatory
Mandatory
2
0
-
647.672
32.9062
0
680
27.9062
180
OneToMany
Mandatory
Mandatory
2
0
-
685.406
284.906
0
763
272.906
180
OneToMany
Mandatory
Mandatory
2
0
-
496
32.9062
180
284.844
30.9062
0
OneToMany
Mandatory
Mandatory
3
0
-
430.146
249.812
270
468.273
321
90
OneToMany
Mandatory
Mandatory
11
0
-
638.51
395
90
628.938
323.812
270
OneToMany
Mandatory
Mandatory
2
0
-
559.755
395
90
572.469
323.812
270
OneToMany
Mandatory
Mandatory
1
0
-
599.133
472.812
270
613.727
533
90
OneToMany
Mandatory
Mandatory
3
0