Relational 817 461 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 29 569 toolchain_order#ffffff number SMALLINT True True pkgbase VARCHAR(64) True False 483 57 versions#ffffff id BIGINT True True order BIGINT True False epoch MEDIUMINT True False version VARCHAR(32) 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 546 188 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 -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 -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 570 404 repository_moves#ffffff id MEDIUMINT True True from_repository MEDIUMINT True False to_repository MEDIUMINT True False upstream_package_repository SMALLINT True False 899 390 repository_stabilities#ffffff id SMALLINT True True name VARCHAR(32) True False bugtracker_category VARCHAR(32) False False 69 483 build_dependency_loops#ffffff id BIGINT True True loop MEDIUMINT True False build_assignment BIGINT 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 653 21 install_targets#ffffff id BIGINT True True name VARCHAR(64) True False 395 313 architectures#ffffff id SMALLINT True True name VARCHAR(16) True False 248 499 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 528 571 upstream_repositories#ffffff id SMALLINT True True name VARCHAR(64) True False git_repository SMALLINT True False 817 586 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 694 300 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 613 86 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 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 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 196 326 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 -17 342 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 -53 240 fail_reasons#ffffff id SMALLINT True True name VARCHAR(32) True False identifier VARCHAR(64) True False severity SMALLINT True False 883 288 repository_stability_relations#ffffff id MEDIUMINT True True more_stable MEDIUMINT True False less_stable MEDIUMINT True False 826 33 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 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 821 -49 todo_links#ffffff dependent BIGINT True False depending_on BIGINT True False 240 -66 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 42 allowed_email_actions#ffffff id BIGINT True True gpg_key BIGINT True False action MEDIUMINT True False -54 70 email_actions#ffffff id MEDIUMINT True True name VARCHAR(32) True False 229 20 ssh_keys#ffffff id BIGINT True True owner MEDIUMINT True False fingerprint TEXT True False 371 392 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 961 462 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 826 148.922 180 490.5 329.615 0 OneToMany Optional Optional 14 0 817 520.922 180 678.984 592.281 0 OneToOne Mandatory Mandatory 6 0 138.656 593.922 0 248 565.922 180 OneToOne Optional Optional 1 1 447.167 34.8438 270 525.008 57 90 OneToOne Mandatory Mandatory 4 0 613 116.615 180 567.016 95.9219 0 OneToOne Mandatory Mandatory 3 0 498.25 -35.7188 0 580 -32.0781 180 OneToOne Mandatory Mandatory 3 0 498.25 -0.4375 0 653 45.9219 180 OneToOne Mandatory Mandatory 2 0 652.008 279.844 270 779.547 300 90 OneToMany Optional Optional 2 0 396.083 34.8438 270 382.773 99 90 OneToOne Mandatory Mandatory 1 0 546 233.922 180 466.547 225.562 0 OneToOne Mandatory Mandatory 1 0 60.6406 179.922 0 118 221.922 180 OneToOne Mandatory Mandatory 2 0 689.336 481.844 270 603.492 571 90 OneToOne Mandatory Mandatory 3 0 649.557 404 90 808.062 391.844 270 OneToOne Mandatory Mandatory 1 0 729.115 404 90 751.031 391.844 270 OneToOne Mandatory Mandatory 2 0 410.698 288.844 270 442.75 313 90 OneToOne Mandatory Mandatory 9 0 865.094 345.922 0 899 421.922 180 OneToOne Mandatory Mandatory 2 0 707.117 86 90 703.516 70.8438 270 OneToOne Mandatory Mandatory 2 0 613 147.229 180 466.547 162.281 0 OneToOne Mandatory Mandatory 1 0 486.672 565.922 0 528 602.922 180 OneToOne Mandatory Mandatory 4 0 678.984 613.562 0 817 631.922 180 OneToOne Mandatory Mandatory 2 0 290.906 459.844 270 367.336 499 90 OneToOne Mandatory Mandatory 1 0 338.359 392.922 0 395 337.922 180 OneToOne Mandatory Mandatory 2 0 354.849 288.844 270 290.906 326 90 OneToOne Mandatory Mandatory 1 0 213.26 295.844 270 243.453 326 90 OneToOne Mandatory Mandatory 3 0 151.016 483 90 243.453 459.844 270 OneToOne Mandatory Mandatory 2 0 85.1458 342 90 165.63 295.844 270 OneToOne Mandatory Mandatory 1 0 136.219 401.922 0 196 392.922 180 OneToOne Mandatory Mandatory 2 0 34.0729 342 90 -4.80469 317.844 270 OneToOne Mandatory Mandatory 4 0 1009.6 351.844 270 952.182 390 90 OneToOne Mandatory Mandatory 1 0 946.302 351.844 270 1005.36 390 90 OneToOne Mandatory Mandatory 2 0 949.578 -32.3854 0 971 -7.77083 180 OneToOne Mandatory Mandatory 1 0 949.578 -15.7708 0 971 -38.3854 180 OneToOne Mandatory Mandatory 0 0 213.297 -19.0781 0 240 -41.0781 180 OneToOne Mandatory Mandatory 2 0 36.1719 -12.0781 0 106 -19.0781 180 OneToOne Mandatory Mandatory 5 0 143.531 42 90 159.648 12.8438 270 OneToOne Mandatory Mandatory 1 0 68 73.9219 180 44.4062 94.9219 0 OneToOne Mandatory Mandatory 2 0 -9.41406 47.8438 270 -4.79688 70 90 OneToOne Mandatory Mandatory 3 0 189.445 148 90 282.648 83.8438 270 OneToOne Mandatory Mandatory 2 0 282.648 20 90 275.641 -16.1562 270 OneToOne Mandatory Mandatory 1 0 694 345.922 180 490.5 346.229 0 OneToOne Mandatory Mandatory 4 0 434.854 392 90 458.667 362.844 270 OneToOne Mandatory Mandatory 2 0 498.708 392 90 426.833 362.844 270 OneToOne Mandatory Mandatory 1 0