Relational 237 40 ssh_keys#ffffff id BIGINT True True owner MEDIUMINT True False fingerprint TEXT True False -68 71 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 754 399 repository_stability_relations#ffffff id MEDIUMINT True True more_stable MEDIUMINT True False less_stable MEDIUMINT True False -62 370 fail_reasons#ffffff id SMALLINT True True name VARCHAR(32) True False identifier VARCHAR(64) True False severity SMALLINT True False 53 346 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 247 291 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 549 105 install_target_providers#ffffff id BIGINT True True package BIGINT True False install_target BIGINT True False 549 301 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 770 508 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 539 533 upstream_repositories#ffffff id SMALLINT True True name VARCHAR(64) True False git_repository SMALLINT True False 226 473 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 415 321 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 53 501 build_dependency_loops#ffffff id BIGINT True True loop MEDIUMINT True False build_assignment BIGINT True False 788 281 repository_stabilities#ffffff id SMALLINT True True name VARCHAR(32) True False bugtracker_category VARCHAR(32) False False 494 427 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 42 135 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 549 346.906 180 509.547 345.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 -19.2734 71 90 OneToOne Mandatory Mandatory 3 0 68 80.9062 180 29.4531 95.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 816.656 399 90 840.635 344.812 270 OneToOne Mandatory Mandatory 2 0 879.312 399 90 893.271 344.812 270 OneToOne Mandatory Mandatory 1 0 53 398.906 180 33.4375 408.906 0 OneToOne Mandatory Mandatory 4 0 204.719 398.906 0 247 357.906 180 OneToOne Mandatory Mandatory 2 0 128.859 346 90 232.151 269.812 270 OneToOne Mandatory Mandatory 1 0 134.195 501 90 293.974 424.812 270 OneToOne Mandatory Mandatory 2 0 279.302 269.812 270 293.974 291 90 OneToOne Mandatory Mandatory 3 0 410.573 231.812 270 340.948 291 90 OneToOne Mandatory Mandatory 1 0 387.922 357.906 0 415 345.906 180 OneToOne Mandatory Mandatory 2 0 340.948 424.812 270 341.266 473 90 OneToOne Mandatory Mandatory 1 0 688.453 564.906 0 770 553.906 180 OneToOne Mandatory Mandatory 2 0 456.531 539.906 0 539 564.906 180 OneToOne Mandatory Mandatory 4 0 549 136.906 180 511.719 114.604 0 OneToOne Mandatory Mandatory 1 0 423.836 17.8125 270 435.859 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 718.406 346.906 0 788 312.906 180 OneToOne Mandatory Mandatory 2 0 499.672 -34.0625 0 540 -25.0938 180 OneToOne Mandatory Mandatory 3 0 461.146 231.812 270 462.273 321 90 OneToOne Mandatory Mandatory 9 0 572.755 427 90 605.469 392.812 270 OneToOne Mandatory Mandatory 2 0 651.51 427 90 661.938 392.812 270 OneToOne Mandatory Mandatory 1 0 612.133 504.812 270 613.727 533 90 OneToOne Mandatory Mandatory 3 0 153.531 180.906 0 185 195.906 180 OneToOne Mandatory Mandatory 2 0 543 227.906 180 511.719 173.208 0 OneToOne Mandatory Mandatory 1 0 647.922 273.812 270 633.703 301 90 OneToMany Optional Optional 2 0