Relational 729 684 upstream_repositories#ffffff id SMALLINT True True name VARCHAR(64) True False 217 328 compressions#ffffff id SMALLINT True True suffix VARCHAR(8) True False 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 209 83 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 62 8 allowed_email_actions#ffffff id BIGINT True True gpg_key BIGINT True False action MEDIUMINT True False 226 -78 gpg_keys#ffffff id BIGINT True True fingerprint VARCHAR(40) True False owner MEDIUMINT True False public_key TEXT True False 218 17 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 -44 372 failed_builds#ffffff id BIGINT 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 153 447 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 80 160 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 320 118 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 compression SMALLINT False False signing_key BIGINT False False 619 112 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 103 694 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 upstream_flag_date TIMESTAMP False 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 -42 529 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 524 62 versions#ffffff id BIGINT True True order BIGINT True False epoch MEDIUMINT True False version VARCHAR(32) True False -31 605 toolchain_order#ffffff number SMALLINT True True pkgbase VARCHAR(64) True False requires_all_dependencies_built BIT 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.333 180 478 415.5 0 OneToOne Mandatory Mandatory 1 0 656 410.667 180 478 403 0 OneToOne Mandatory Mandatory 2 0 342 768 0 729 709 180 OneToOne Mandatory Mandatory 4 0 803 322.333 180 478 390.5 0 OneToOne Mandatory Mandatory 4 0 912.5 575 270 828.333 684 90 OneToOne Mandatory Mandatory 3 0 700.5 618 270 778.667 684 90 OneToOne Mandatory Mandatory 6 0 263.5 83 90 254 67 270 OneToOne Mandatory Mandatory 1 0 152 160 90 263.5 147 270 OneToOne Mandatory Mandatory 2 0 -9 48 270 -5.5 70 90 OneToOne Optional Mandatory 3 0 62 40 180 43 95 0 OneToOne Mandatory Mandatory 2 0 136 8 90 226 -26 180 OneToOne Mandatory Mandatory 1 0 37 -12 0 226 -52 180 OneToOne Optional Mandatory 5 0 262.333 0 270 254 17 90 OneToOne Mandatory Mandatory 2 0 951 -32.3333 0 971 -38.3333 180 OneToOne Mandatory Mandatory 0 0 951 -15.6667 0 971 -7.66667 180 OneToOne Mandatory Mandatory 1 0 940 121 270 935.667 168 90 OneToOne Mandatory Mandatory 2 0 878 121 270 882.333 168 90 OneToOne Mandatory Mandatory 1 0 7.66667 372 90 5.5 345 270 OneToOne Mandatory Mandatory 4 0 111 432 0 153 496.333 180 OneToOne Mandatory Mandatory 2 0 59.3333 372 90 128 322 270 OneToOne Mandatory Mandatory 1 0 122 561 0 153 545.667 180 OneToOne Mandatory Mandatory 2 0 176 322 270 201.667 447 90 OneToOne Optional Mandatory 3 0 376.333 336 270 250.333 447 90 OneToOne Mandatory Mandatory 1 0 299 521 0 414 428 270 OneToOne Mandatory Mandatory 2 0 226 595 270 262.333 694 90 OneToOne Mandatory Mandatory 1 0 619 173.333 180 489 190.667 0 OneToOne Mandatory Mandatory 1 0 713.5 112 90 703 71 270 OneToOne Mandatory Mandatory 2 0 888.5 261 90 909 232 270 OneToOne Mandatory Mandatory 2 0 432.667 336 270 430 378 90 OneToOne Mandatory Mandatory 9 0 872.667 497 90 860 353 270 OneToOne Mandatory Mandatory 2 0 952.333 497 90 917 353 270 OneToOne Mandatory Mandatory 1 0 61 194 0 80 241 180 OneToOne Optional Mandatory 2 0 525 261 180 489 263.333 0 OneToOne Mandatory Mandatory 1 0 396.667 35 270 432.667 118 90 OneToOne Mandatory Mandatory 1 0 734 261 0 803 291.667 180 OneToMany Optional Optional 2 0 500 -0.333333 0 653 46 180 OneToOne Mandatory Mandatory 2 0 500 -35.6667 0 580 -32 180 OneToOne Mandatory Mandatory 3 0 619 142.667 180 608 101 0 OneToOne Mandatory Mandatory 3 0 448.333 35 270 524 101 180 OneToOne Mandatory Mandatory 4 0 95 669 270 182.667 694 90 OneToOne Optional Optional 1 1 485.5 455 90 446 428 270 OneToMany Optional Optional 14 0 320 227 180 266 328 90 OneToOne Optional Mandatory 12 0 376.333 118 90 298.667 0 270 OneToMany Mandatory Optional 13 0