Relational 952 253 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 375 369 architecture_compatibilities#ffffff id MEDIUMINT True True built_for SMALLINT True False runs_on SMALLINT True False fully_compatible BIT True False 237 40 ssh_keys#ffffff id BIGINT True True owner MEDIUMINT True False fingerprint TEXT True False -59 73 email_actions#ffffff id MEDIUMINT True True name VARCHAR(32) True False 68 49 allowed_email_actions#ffffff id BIGINT True True gpg_key BIGINT True False action MEDIUMINT True False 106 -51 gpg_keys#ffffff id BIGINT True True fingerprint VARCHAR(40) True False owner MEDIUMINT True False 258 -44 persons#ffffff id MEDIUMINT True True name VARCHAR(32) True False 788 -60 todo_links#ffffff dependent BIGINT True False depending_on BIGINT True False 945 -70 todos#ffffff id BIGINT True True file VARCHAR(64) True False line MEDIUMINT True False description TEXT True False importance SMALLINT False False 777 32 statitstics#ffffff id BIGINT True True date TIMESTAMP True False stable_packages_count MEDIUMINT True False pending_tasks_count MEDIUMINT True False staging_packages_count MEDIUMINT True False testing_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 756 452 repository_stability_relations#ffffff id MEDIUMINT True True more_stable MEDIUMINT True False less_stable MEDIUMINT 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 -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 187 311 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 185 122 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 360 56 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 549 105 install_target_providers#ffffff id BIGINT True True package BIGINT True False install_target BIGINT True False 566 299 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 803 533 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 535 562 upstream_repositories#ffffff id SMALLINT True True name VARCHAR(64) True False git_repository SMALLINT True False 175 497 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 commit_time TIMESTAMP True False 399 289 architectures#ffffff id SMALLINT True True name VARCHAR(16) True False 557 30 install_targets#ffffff id BIGINT True True name VARCHAR(64) True False 348 -60 dependencies#ffffff id BIGINT True True dependent BIGINT True False depending_on BIGINT True False dependency_type SMALLINT True False 540 -64 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 -21 537 build_dependency_loops#ffffff id BIGINT True True loop MEDIUMINT True False build_assignment BIGINT True False 770 345 repository_stabilities#ffffff id SMALLINT True True name VARCHAR(32) True False bugtracker_category VARCHAR(32) False False 492 459 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 543 182 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 435.714 369 90 430.516 338.812 270 OneToOne Mandatory Mandatory 1 0 496.427 369 90 462.031 338.812 270 OneToOne Mandatory Mandatory 2 0 566 344.906 180 493.547 313.906 0 OneToOne Mandatory Mandatory 4 0 290.109 40 90 293.289 5.8125 270 OneToOne Mandatory Mandatory 1 0 255.727 122 90 290.109 103.812 270 OneToOne Mandatory Mandatory 2 0 -9.85156 47.8125 270 -10.2734 73 90 OneToOne Mandatory Mandatory 3 0 68 80.9062 180 38.4531 97.9062 0 OneToOne Mandatory Mandatory 2 0 142.789 49 90 159.109 12.8125 270 OneToOne Mandatory Mandatory 1 0 35.2969 -12.0938 0 106 -19.0938 180 OneToOne Mandatory Mandatory 5 0 212.219 -19.0938 0 258 -19.0938 180 OneToOne Mandatory Mandatory 2 0 915.234 -43.3958 0 945 -39.3958 180 OneToOne Mandatory Mandatory 0 0 915.234 -26.7917 0 945 -8.79167 180 OneToOne Mandatory Mandatory 1 0 818.656 452 90 822.635 408.812 270 OneToOne Mandatory Mandatory 2 0 881.312 452 90 875.271 408.812 270 OneToOne Mandatory Mandatory 1 0 33.5729 342 90 -5.28125 317.812 270 OneToOne Mandatory Mandatory 4 0 134.719 401.906 0 187 377.906 180 OneToOne Mandatory Mandatory 2 0 84.1458 342 90 232.151 269.812 270 OneToOne Mandatory Mandatory 1 0 60.1953 537 90 233.974 444.812 270 OneToOne Mandatory Mandatory 2 0 279.302 269.812 270 233.974 311 90 OneToOne Mandatory Mandatory 3 0 415.286 245.812 270 280.948 311 90 OneToOne Mandatory Mandatory 1 0 327.922 377.906 0 399 313.906 180 OneToOne Mandatory Mandatory 2 0 280.948 444.812 270 290.266 497 90 OneToOne Mandatory Mandatory 1 0 684.453 593.906 0 803 578.906 180 OneToOne Mandatory Mandatory 2 0 405.531 563.906 0 535 593.906 180 OneToOne Mandatory Mandatory 4 0 549 136.906 180 525.859 119.271 0 OneToOne Mandatory Mandatory 1 0 423.836 17.8125 270 442.93 56 90 OneToOne Mandatory Mandatory 1 0 627.109 105 90 607.016 79.8125 270 OneToOne Mandatory Mandatory 2 0 499.672 -8.125 0 557 54.9062 180 OneToOne Mandatory Mandatory 2 0 735.406 344.906 0 770 376.906 180 OneToOne Mandatory Mandatory 2 0 499.672 -34.0625 0 540 -25.0938 180 OneToOne Mandatory Mandatory 3 0 470.573 245.812 270 446.273 289 90 OneToOne Mandatory Mandatory 9 0 570.755 459 90 622.469 390.812 270 OneToOne Mandatory Mandatory 2 0 649.51 459 90 678.938 390.812 270 OneToOne Mandatory Mandatory 1 0 610.133 536.812 270 609.727 562 90 OneToOne Mandatory Mandatory 3 0 59.5312 179.906 0 185 195.906 180 OneToOne Mandatory Mandatory 2 0 543 227.906 180 525.859 182.542 0 OneToOne Mandatory Mandatory 1 0 647.922 273.812 270 650.703 299 90 OneToMany Optional Optional 2 0