Relational
-
792
155
file_providers
#ffffff
id
BIGINT
True
True
package
BIGINT
True
False
file
BIGINT
True
False
-
785
6
files
#ffffff
id
BIGINT
True
True
path
TEXT
True
False
name
TEXT
True
False
name_hash
VARCHAR(128)
True
False
absolute_name_hash
VARCHAR(128)
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
110
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
-
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
-
656
82
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
-
792
190.812
180
475.969
184.975
0
OneToMany
Mandatory
Mandatory
1
0
-
834.562
155
90
869.336
109.625
270
OneToMany
Optional
Optional
2
0
-
799.115
399
90
801.13
312.625
270
OneToMany
Mandatory
Mandatory
2
0
-
844.229
399
90
839.26
312.625
270
OneToMany
Mandatory
Mandatory
1
0
-
93.9896
287
90
98.3438
190.625
270
OneToMany
Mandatory
Mandatory
4
0
-
191.969
346.812
0
245
376.208
180
OneToMany
Mandatory
Mandatory
2
0
-
142.979
287
90
207.635
229.625
270
OneToMany
Mandatory
Mandatory
1
0
-
125.484
516
90
245
421.417
180
OneToMany
Mandatory
Mandatory
2
0
-
252.271
229.625
270
290.391
331
90
OneToMany
Mandatory
Mandatory
4
0
-
377.99
277.625
270
335.781
331
90
OneToMany
Mandatory
Mandatory
1
0
-
381.172
398.812
0
421
348.812
180
OneToMany
Mandatory
Mandatory
2
0
-
313.086
466.625
270
341.891
487
90
OneToMany
Mandatory
Mandatory
1
0
-
661.781
568.812
0
770
559.812
180
OneToMany
Mandatory
Mandatory
2
0
-
475.969
231.3
0
598.328
246
90
OneToMany
Mandatory
Mandatory
2
0
-
454.781
554.812
0
539
568.812
180
OneToMany
Mandatory
Mandatory
4
0
-
656
117.812
180
475.969
138.65
0
OneToMany
Mandatory
Mandatory
1
0
-
569.461
81.625
270
475.969
92.325
0
OneToMany
Mandatory
Mandatory
1
0
-
715.289
82
90
716.156
58.625
270
OneToMany
Mandatory
Mandatory
2
0
-
642.922
37.8125
0
680
30.8125
180
OneToMany
Mandatory
Mandatory
2
0
-
680.656
289.812
0
763
276.812
180
OneToMany
Mandatory
Mandatory
2
0
-
496
37.8125
180
280.094
35.8125
0
OneToMany
Mandatory
Mandatory
3
0
-
426.979
277.625
270
453.914
321
90
OneToMany
Mandatory
Mandatory
11
0
-
558.172
395
90
570.885
333.625
270
OneToMany
Mandatory
Mandatory
2
0
-
635.344
395
90
625.771
333.625
270
OneToMany
Mandatory
Mandatory
1
0
-
596.758
482.625
270
600.391
533
90
OneToMany
Mandatory
Mandatory
3
0