Relational 543 182 binary_packages_in_repositories#ffffff id BIGINT True True package BIGINT True False repository MEDIUMINT True False 42 135 ssh_log#ffffff id BIGINT True True date DATETIME True False build_slave MEDIUMINT False False action VARCHAR(32) True False parameters TEXT True False -55 -72 email_log#ffffff id BIGINT True True date DATETIME True False success BIT True False action MEDIUMINT False False count MEDIUMINT False False gpg_key BIGINT False False comment TEXT 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 763 241 repository_stabilities#ffffff id SMALLINT True True name VARCHAR(32) True False bugtracker_category VARCHAR(32) False False 53 501 build_dependency_loops#ffffff id BIGINT True True loop MEDIUMINT True False build_assignment BIGINT 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 348 -60 dependencies#ffffff id BIGINT True True dependent BIGINT True False depending_on BIGINT True False dependency_type SMALLINT True False 557 30 install_targets#ffffff id BIGINT True True name VARCHAR(64) True False 415 321 architectures#ffffff id SMALLINT True True name VARCHAR(16) 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 DATETIME True False 539 533 upstream_repositories#ffffff id SMALLINT True True name VARCHAR(64) True False git_repository 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 529 273 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 549 105 install_target_providers#ffffff id BIGINT True True package BIGINT True False install_target BIGINT True False 360 56 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 last_moved DATETIME 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 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 DATETIME False 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 -62 370 fail_reasons#ffffff id SMALLINT True True name VARCHAR(32) True False identifier VARCHAR(64) True False severity SMALLINT True False 754 399 repository_stability_relations#ffffff id MEDIUMINT True True more_stable MEDIUMINT True False less_stable MEDIUMINT True False 777 32 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 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 788 -60 todo_links#ffffff dependent BIGINT True False depending_on BIGINT True False 258 -44 persons#ffffff id MEDIUMINT True True name VARCHAR(32) True False 106 -51 gpg_keys#ffffff id BIGINT True True fingerprint VARCHAR(40) True False owner MEDIUMINT True False 68 49 allowed_email_actions#ffffff id BIGINT True True gpg_key BIGINT True False action MEDIUMINT True False -68 71 email_actions#ffffff id MEDIUMINT True True name VARCHAR(32) True False 237 40 ssh_keys#ffffff id BIGINT True True owner MEDIUMINT True False fingerprint TEXT True False 647.922 245.812 270 613.703 273 90 OneToMany Optional Optional 2 0 543 213.906 180 511.719 201.208 0 OneToOne Mandatory Mandatory 1 0 153.531 180.906 0 186 196.906 180 OneToOne Mandatory Mandatory 2 0 599.133 472.812 270 613.727 533 90 OneToOne Mandatory Mandatory 3 0 559.755 395 90 585.469 364.812 270 OneToOne Mandatory Mandatory 1 0 638.51 395 90 641.938 364.812 270 OneToOne Mandatory Mandatory 2 0 461.146 273.812 270 462.273 321 90 OneToOne Mandatory Mandatory 11 0 499.672 -34.0625 0 540 -25.0938 180 OneToOne Mandatory Mandatory 3 0 698.406 318.906 0 763 272.906 180 OneToOne Mandatory Mandatory 2 0 499.672 -8.125 0 557 54.9062 180 OneToOne Mandatory Mandatory 2 0 627.109 105 90 607.016 79.8125 270 OneToOne Mandatory Mandatory 2 0 423.836 17.8125 270 435.859 56 90 OneToOne Mandatory Mandatory 1 0 549 136.906 180 511.719 128.604 0 OneToOne Mandatory Mandatory 1 0 456.531 539.906 0 539 564.906 180 OneToOne Mandatory Mandatory 4 0 688.453 564.906 0 770 553.906 180 OneToOne Mandatory Mandatory 2 0 340.948 424.812 270 341.266 473 90 OneToOne Mandatory Mandatory 1 0 387.922 357.906 0 415 345.906 180 OneToOne Mandatory Mandatory 2 0 410.573 273.812 270 340.948 291 90 OneToOne Mandatory Mandatory 1 0 280.302 256.812 270 293.974 291 90 OneToOne Mandatory Mandatory 3 0 134.195 501 90 293.974 424.812 270 OneToOne Mandatory Mandatory 2 0 128.859 346 90 233.151 256.812 270 OneToOne Mandatory Mandatory 1 0 204.719 398.906 0 247 357.906 180 OneToOne Mandatory Mandatory 2 0 53 398.906 180 33.4375 408.906 0 OneToOne Mandatory Mandatory 4 0 816.656 399 90 815.635 304.812 270 OneToOne Mandatory Mandatory 1 0 879.312 399 90 868.271 304.812 270 OneToOne Mandatory Mandatory 2 0 915.234 -43.3958 0 945 -39.3958 180 OneToOne Mandatory Mandatory 1 0 915.234 -26.7917 0 945 -8.79167 180 OneToOne Mandatory Mandatory 0 0 212.219 -19.0938 0 258 -19.0938 180 OneToOne Mandatory Mandatory 2 0 35.2969 -12.0938 0 106 -19.0938 180 OneToOne Mandatory Mandatory 5 0 142.789 49 90 159.109 12.8125 270 OneToOne Mandatory Mandatory 1 0 68 80.9062 180 29.4531 95.9062 0 OneToOne Mandatory Mandatory 2 0 -9.85156 47.8125 270 -19.2734 71 90 OneToOne Mandatory Mandatory 3 0 256.727 137 90 290.109 103.812 270 OneToOne Mandatory Mandatory 2 0 290.109 40 90 293.289 5.8125 270 OneToOne Mandatory Mandatory 1 0 529 318.906 180 509.547 345.906 0 OneToOne Mandatory Mandatory 4 0