Relational
-
901
641
mirror_statuses
#ffffff
id
BIGINT
True
True
protocol
VARCHAR(8)
True
False
url
VARCHAR(128)
True
False
country
VARCHAR(64)
True
False
country_code
VARCHAR(4)
True
False
last_sync
BIGINT
True
False
start
FLOAT
True
False
stop
FLOAT
True
False
isos
BIT
True
False
ipv4
BIT
True
False
ipv6
BIT
True
False
active
BIT
True
False
-
656
380
architecture_compatibilities
#ffffff
id
MEDIUMINT
True
True
built_for
SMALLINT
True
False
runs_on
SMALLINT
True
False
fully_compatible
BIT
True
False
build_slave_compatible
BIT(n)
True
False
-
229
20
ssh_keys
#ffffff
id
BIGINT
True
True
owner
MEDIUMINT
True
False
fingerprint
TEXT
True
False
-
-54
70
email_actions
#ffffff
id
MEDIUMINT
True
True
name
VARCHAR(32)
True
False
-
68
42
allowed_email_actions
#ffffff
id
BIGINT
True
True
gpg_key
BIGINT
True
False
action
MEDIUMINT
True
False
-
92
-69
gpg_keys
#ffffff
id
BIGINT
True
True
fingerprint
VARCHAR(40)
True
False
owner
MEDIUMINT
True
False
public_key
TEXT
True
False
-
240
-66
persons
#ffffff
id
MEDIUMINT
True
True
name
VARCHAR(32)
True
False
-
821
-49
todo_links
#ffffff
dependent
BIGINT
True
False
depending_on
BIGINT
True
False
-
971
-69
todos
#ffffff
id
BIGINT
True
True
file
VARCHAR(64)
True
False
line
MEDIUMINT
True
False
description
TEXT
True
False
importance
SMALLINT
False
False
-
357
455
statitstics
#ffffff
id
BIGINT
True
True
date
TIMESTAMP
True
False
stable_packages_count
MEDIUMINT
True
False
pending_tasks_count
MEDIUMINT
True
False
pending_packages_count
MEDIUMINT
True
False
staging_packages_count
MEDIUMINT
True
False
testing_packages_count
MEDIUMINT
True
False
tested_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
architecture
SMALLINT
True
False
-
816
57
repository_stability_relations
#ffffff
id
MEDIUMINT
True
True
more_stable
MEDIUMINT
True
False
less_stable
MEDIUMINT
True
False
-
-43
267
fail_reasons
#ffffff
id
SMALLINT
True
True
name
VARCHAR(32)
True
False
identifier
VARCHAR(64)
True
False
severity
SMALLINT
True
False
-
-22
374
failed_builds
#ffffff
id
MEDIUMINT
True
True
build_slave
MEDIUMINT
True
False
build_assignment
BIGINT
True
False
date
TIMESTAMP
True
False
reason
SMALLINT
True
False
log_file
VARCHAR(512)
True
False
log_file_exists
BIT
True
False
-
164
408
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
TIMESTAMP
False
False
currently_blocking
MEDIUMINT
False
False
-
118
148
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
is_sane
BIT
True
False
access_allowed
BIT(n)
True
False
-
299
99
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
sub_pkgrel_omitted
BIT
True
False
-
604
88
install_target_providers
#ffffff
id
BIGINT
True
True
package
BIGINT
True
False
install_target
BIGINT
True
False
version
BIGINT
True
False
install_target_is_group
BIT
True
False
-
803
261
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
-
598
736
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
-
729
684
upstream_repositories
#ffffff
id
SMALLINT
True
True
name
VARCHAR(64)
True
False
git_repository
SMALLINT
True
False
-
173
709
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
upstream_package_repository
SMALLINT
True
False
uses_upstream
BIT
True
False
uses_modification
BIT
True
False
commit_time
TIMESTAMP
True
False
-
382
378
architectures
#ffffff
id
SMALLINT
True
True
name
VARCHAR(16)
True
False
-
653
21
install_targets
#ffffff
id
BIGINT
True
True
name
VARCHAR(64)
True
False
-
580
-71
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
-
-8
572
build_dependency_loops
#ffffff
id
BIGINT
True
True
loop
MEDIUMINT
True
False
build_assignment
BIGINT
True
False
-
829
168
repository_stabilities
#ffffff
id
SMALLINT
True
True
name
VARCHAR(32)
True
False
bugtracker_category
VARCHAR(32)
False
False
-
793
497
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
TIMESTAMP
True
False
success
BIT
True
False
action
MEDIUMINT
False
False
count
MEDIUMINT
False
False
gpg_key
BIGINT
False
False
comment
TEXT
False
False
-
-52
134
ssh_log
#ffffff
id
BIGINT
True
True
date
TIMESTAMP
True
False
build_slave
MEDIUMINT
False
False
action
VARCHAR(32)
True
False
parameters
TEXT
True
False
duration
MEDIUMINT
False
False
exit_code
MEDIUMINT
False
False
-
525
215
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
TIMESTAMP
True
False
-
345
-71
dependencies
#ffffff
id
BIGINT
True
True
dependent
BIGINT
True
False
depending_on
BIGINT
True
False
dependency_type
SMALLINT
True
False
version
BIGINT
True
False
version_relation
VARCHAR(2)
True
False
-
483
57
versions
#ffffff
id
BIGINT
True
True
order
BIGINT
True
False
epoch
MEDIUMINT
True
False
version
VARCHAR(32)
True
False
-
-23
750
toolchain_order
#ffffff
number
SMALLINT
True
True
pkgbase
VARCHAR(64)
True
False
-
632
498
upstream_packages
#ffffff
id
BIGINT
True
True
pkgname
VARCHAR(64)
True
False
epoch
MEDIUMINT
True
False
pkgver
VARCHAR(64)
True
False
pkgrel
MEDIUMINT
True
False
architecture
VARCHAR(6)
True
False
repository
SMALLINT
True
False
-
977
378
command_log
#ffffff
id
BIGINT
True
True
date
TIMESTAMP
True
False
command
VARCHAR(64)
True
False
parameters
TEXT
True
False
shell
BIT
True
False
-
656
441.875
180
476.547
416.109
0
OneToOne
Mandatory
Mandatory
1
0
-
656
410.938
180
476.547
403.406
0
OneToOne
Mandatory
Mandatory
2
0
-
803
322.875
180
476.547
390.703
0
OneToOne
Mandatory
Mandatory
4
0
-
282.328
20
90
275.289
-15.1875
270
OneToOne
Mandatory
Mandatory
1
0
-
188.727
148
90
282.328
84.8125
270
OneToOne
Mandatory
Mandatory
2
0
-
-9.85156
48.8125
270
-5.27344
70
90
OneToOne
Mandatory
Mandatory
3
0
-
68
74.4063
180
43.4531
95.4063
0
OneToOne
Mandatory
Mandatory
2
0
-
142.789
42
90
145.328
9.8125
270
OneToOne
Mandatory
Mandatory
1
0
-
35.2969
-11.5938
0
92
-29.5938
180
OneToOne
Mandatory
Mandatory
5
0
-
198.656
-29.5938
0
240
-40.5938
180
OneToOne
Mandatory
Mandatory
2
0
-
948.234
-32.0625
0
971
-38.0625
180
OneToOne
Mandatory
Mandatory
0
0
-
948.234
-15.125
0
971
-7.125
180
OneToOne
Mandatory
Mandatory
1
0
-
941.313
121.813
270
934.271
168
90
OneToOne
Mandatory
Mandatory
2
0
-
878.656
121.813
270
881.635
168
90
OneToOne
Mandatory
Mandatory
1
0
-
28.5729
374
90
4.9375
345.813
270
OneToOne
Mandatory
Mandatory
4
0
-
129.719
434.406
0
164
457.604
180
OneToOne
Mandatory
Mandatory
2
0
-
79.1458
374
90
165.151
310.813
270
OneToOne
Mandatory
Mandatory
1
0
-
73.1953
572
90
164
507.208
180
OneToOne
Mandatory
Mandatory
2
0
-
212.302
310.813
270
211.927
408
90
OneToOne
Mandatory
Mandatory
3
0
-
354.286
289.813
270
259.854
408
90
OneToOne
Mandatory
Mandatory
1
0
-
307.781
482.406
0
382
403.406
180
OneToOne
Mandatory
Mandatory
2
0
-
235.891
556.813
270
291.133
709
90
OneToOne
Mandatory
Mandatory
1
0
-
803.727
748.813
270
705.609
782.406
0
OneToOne
Mandatory
Mandatory
2
0
-
409.266
776.406
0
729
716.406
180
OneToOne
Mandatory
Mandatory
4
0
-
604
149.875
180
464.859
162.604
0
OneToOne
Mandatory
Mandatory
1
0
-
697.203
88
90
703.016
71.8125
270
OneToOne
Mandatory
Mandatory
2
0
-
887.703
261
90
907.953
232.813
270
OneToOne
Mandatory
Mandatory
2
0
-
409.573
289.813
270
429.273
378
90
OneToOne
Mandatory
Mandatory
9
0
-
871.755
497
90
859.469
353.813
270
OneToOne
Mandatory
Mandatory
2
0
-
950.51
497
90
915.938
353.813
270
OneToOne
Mandatory
Mandatory
1
0
-
911.133
575.813
270
828.635
684
90
OneToOne
Mandatory
Mandatory
3
0
-
59.5313
194.406
0
118
229.406
180
OneToOne
Mandatory
Mandatory
2
0
-
525
261.406
180
464.859
226.208
0
OneToOne
Mandatory
Mandatory
1
0
-
395.557
35.8125
270
381.93
99
90
OneToOne
Mandatory
Mandatory
1
0
-
734.844
261.406
0
803
291.938
180
OneToMany
Optional
Optional
2
0
-
496.672
0.208333
0
653
46.4063
180
OneToOne
Mandatory
Mandatory
2
0
-
496.672
-35.3958
0
580
-31.5938
180
OneToOne
Mandatory
Mandatory
3
0
-
604
118.938
180
566.188
96.4063
0
OneToOne
Mandatory
Mandatory
3
0
-
446.115
35.8125
270
524.594
57
90
OneToOne
Mandatory
Mandatory
4
0
-
85.5469
775.406
0
173
776.406
180
OneToOne
Optional
Optional
1
1
-
699.898
618.813
270
778.818
684
90
OneToOne
Mandatory
Mandatory
6
0
-
483.75
455
90
429.273
428.813
270
OneToMany
Optional
Optional
14
0