Relational 237 40 ssh_keys#ffffff id BIGINT True True owner MEDIUMINT True False fingerprint TEXT True False -69 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 257 -44 persons#ffffff id MEDIUMINT True True name VARCHAR(32) True False 974 255 todo_links#ffffff dependent BIGINT True False depending_on BIGINT True False 1142 235 todos#ffffff id BIGINT True True file VARCHAR(64) True False line MEDIUMINT True False description TEXT True False importance SMALLINT False False 1002 9 statitstics#ffffff id BIGINT True True date DATETIME 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 51 244 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 DATETIME 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 186 137 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 375 54 binary_packages#ffffff id BIGINT True True build_assignment BIGINT True False repository MEDIUMINT 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 is_to_be_deleted BIT True False pkgname VARCHAR(64) True False architecture SMALLINT True False sha512sum VARCHAR(128) False False 553 131 install_target_providers#ffffff id BIGINT True True package BIGINT True False install_target BIGINT True False 529 273 repositories#ffffff id MEDIUMINT True True name VARCHAR(64) True False stability SMALLINT True False is_on_master_mirror BIT 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 229 471 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 DATETIME True False 415 321 architectures#ffffff id SMALLINT True True name VARCHAR(16) True False 795 148 install_targets#ffffff id BIGINT True True name VARCHAR(64) True False 564 22 dependencies#ffffff id BIGINT True True dependent BIGINT True False depending_on BIGINT True False dependency_type SMALLINT True False 744 17 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 52 516 build_dependency_loops#ffffff id BIGINT True True loop MEDIUMINT True False build_assignment BIGINT True False 763 241 repository_stabilities#ffffff id SMALLINT True True name VARCHAR(32) True False bugtracker_category VARCHAR(32) False False 481 395 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 mail_log#ffffff id BIGINT True True date DATETIME True False success BIT True False action ENUM 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 DATETIME True False build_slave MEDIUMINT True False action ENUM True False parameters TEXT True False 290.109 40 90 292.289 5.8125 270 OneToMany Mandatory Mandatory 1 0 256.727 137 90 290.109 103.812 270 OneToMany Mandatory Mandatory 2 0 -9.85156 47.8125 270 -20.2734 71 90 OneToMany Mandatory Mandatory 3 0 68 80.9062 180 28.4531 95.9062 0 OneToMany Mandatory Mandatory 2 0 142.789 49 90 159.109 12.8125 270 OneToMany Mandatory Mandatory 1 0 35.2969 -12.0938 0 106 -19.0938 180 OneToMany Mandatory Mandatory 5 0 212.219 -19.0938 0 257 -19.0938 180 OneToMany Mandatory Mandatory 2 0 1101.23 271.604 0 1142 265.604 180 OneToMany Mandatory Mandatory 0 0 1101.23 288.208 0 1142 296.208 180 OneToMany Mandatory Mandatory 1 0 816.656 399 90 815.635 304.812 270 OneToMany Mandatory Mandatory 2 0 879.312 399 90 868.271 304.812 270 OneToMany Mandatory Mandatory 1 0 103.573 346 90 98.7188 321.812 270 OneToMany Mandatory Mandatory 4 0 204.719 398.906 0 247 350.906 180 OneToMany Mandatory Mandatory 2 0 154.146 346 90 233.151 256.812 270 OneToMany Mandatory Mandatory 1 0 133.195 516 90 293.974 410.812 270 OneToMany Mandatory Mandatory 2 0 280.302 256.812 270 293.974 291 90 OneToMany Mandatory Mandatory 3 0 425.573 257.812 270 340.948 291 90 OneToMany Mandatory Mandatory 1 0 387.922 350.906 0 415 345.906 180 OneToMany Mandatory Mandatory 2 0 340.948 410.812 270 344.266 471 90 OneToMany Mandatory Mandatory 1 0 688.453 564.906 0 770 553.906 180 OneToMany Mandatory Mandatory 2 0 526.719 206.859 0 613.703 273 90 OneToMany Mandatory Mandatory 2 0 459.531 537.906 0 539 564.906 180 OneToMany Mandatory Mandatory 4 0 553 162.906 180 526.719 155.906 0 OneToMany Mandatory Mandatory 1 0 564 60.9062 180 526.719 104.953 0 OneToMany Mandatory Mandatory 1 0 709.219 162.906 0 795 172.906 180 OneToMany Mandatory Mandatory 2 0 639.836 99.8125 270 845.016 148 90 OneToMany Mandatory Mandatory 2 0 698.406 311.906 0 763 272.906 180 OneToMany Mandatory Mandatory 2 0 715.672 60.9062 0 744 55.9062 180 OneToMany Mandatory Mandatory 3 0 476.146 257.812 270 462.273 321 90 OneToMany Mandatory Mandatory 11 0 559.755 395 90 585.469 350.812 270 OneToMany Mandatory Mandatory 2 0 638.51 395 90 641.938 350.812 270 OneToMany Mandatory Mandatory 1 0 599.133 472.812 270 613.727 533 90 OneToMany Mandatory Mandatory 3 0 153.531 180.906 0 186 196.906 180 OneToMany Mandatory Mandatory 2 0