Relational 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) False False line MEDIUMINT False False description VARCHAR(512) False 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 796 131 file_providers#ffffff id BIGINT True True package BIGINT True False file BIGINT True False file_name_hash MEDIUMINT True False 785 6 files#ffffff id BIGINT True True path TEXT True False name TEXT True False name_hash MEDIUMINT True False absolute_name_hash VARCHAR(54) True False 754 399 repository_stability_relations#ffffff id MEDIUMINT True True more_stable MEDIUMINT True False less_stable MEDIUMINT True False 53 103 fail_reasons#ffffff id SMALLINT True True name VARCHAR(32) True False identifier VARCHAR(64) True False severity SMALLINT True False 45 287 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 163 88 build_slaves#ffffff id MEDIUMINT True True name VARCHAR(32) True False ssh_key VARCHAR(1024) True False operator VARCHAR(32) True False currently_building BIGINT False False last_connection TIME True False logged_lines BIGINT False False last_action VARCHAR(32) False False 329 46 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 611 89 install_target_providers#ffffff id BIGINT True True package BIGINT True False install_target BIGINT True False 516 246 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 680 3 install_targets#ffffff id BIGINT True True name VARCHAR(64) True False 496 -6 dependencies#ffffff id BIGINT True True dependent BIGINT True False depending_on BIGINT True False dependency_type SMALLINT True False 51 -8 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 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 796 169.906 180 480.719 168.288 0 OneToMany Mandatory Mandatory 1 0 864 131 90 871.711 97.8125 270 OneToMany Optional Optional 2 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 95.5729 287 90 100.719 180.812 270 OneToMany Mandatory Mandatory 4 0 196.719 339.906 0 247 350.906 180 OneToMany Mandatory Mandatory 2 0 146.146 287 90 210.151 221.812 270 OneToMany Mandatory Mandatory 1 0 133.195 516 90 293.974 410.812 270 OneToMany Mandatory Mandatory 2 0 257.302 221.812 270 293.974 291 90 OneToMany Mandatory Mandatory 4 0 379.573 249.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 480.719 209.05 0 600.703 246 90 OneToMany Mandatory Mandatory 2 0 459.531 537.906 0 539 564.906 180 OneToMany Mandatory Mandatory 4 0 611 120.906 180 480.719 127.525 0 OneToMany Mandatory Mandatory 1 0 571.836 71.8125 270 480.719 86.7625 0 OneToMany Mandatory Mandatory 1 0 689.109 89 90 730.016 52.8125 270 OneToMany Mandatory Mandatory 2 0 647.672 32.9062 0 680 27.9062 180 OneToMany Mandatory Mandatory 2 0 685.406 284.906 0 763 272.906 180 OneToMany Mandatory Mandatory 2 0 496 32.9062 180 284.844 30.9062 0 OneToMany Mandatory Mandatory 3 0 430.146 249.812 270 462.273 321 90 OneToMany Mandatory Mandatory 11 0 638.51 395 90 628.938 323.812 270 OneToMany Mandatory Mandatory 2 0 559.755 395 90 572.469 323.812 270 OneToMany Mandatory Mandatory 1 0 599.133 472.812 270 613.727 533 90 OneToMany Mandatory Mandatory 3 0