Relational 360 400 architecture_compatibilities#ffffff id MEDIUMINT True True built_for SMALLINT True False runs_on SMALLINT 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 844 427 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 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 625 307 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 906 532 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 856 280 repository_stabilities#ffffff id SMALLINT True True name VARCHAR(32) True False bugtracker_category VARCHAR(32) False False 585 455 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 420.714 400 90 430.516 338.812 270 OneToOne Mandatory Mandatory 1 0 481.427 400 90 462.031 338.812 270 OneToOne Mandatory Mandatory 2 0 625 352.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 906.656 427 90 908.635 343.812 270 OneToOne Mandatory Mandatory 2 0 969.312 427 90 961.271 343.812 270 OneToOne Mandatory Mandatory 1 0 33.5729 342 90 -5.28125 317.812 270 OneToOne Mandatory Mandatory 4 0 134.719 394.906 0 187 377.906 180 OneToOne Mandatory Mandatory 2 0 84.1458 342 90 185 220.542 180 OneToOne Mandatory Mandatory 1 0 60.1953 537 90 233.974 444.812 270 OneToOne Mandatory Mandatory 2 0 255.727 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 906 577.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 794.406 352.906 0 856 311.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 663.755 455 90 681.469 398.812 270 OneToOne Mandatory Mandatory 2 0 742.51 455 90 737.938 398.812 270 OneToOne Mandatory Mandatory 1 0 703.133 532.812 270 609.727 562 90 OneToOne Mandatory Mandatory 3 0 59.5312 179.906 0 185 171.271 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 709.703 307 90 OneToMany Optional Optional 2 0