Relational 29 569 toolchain_order#ffffff number SMALLINT True True pkgbase VARCHAR(64) True False 483 57 versions#ffffff id BIGINT True True order BIGINT True False epoch MEDIUMINT True False version VARCHAR(32) True False 398 -74 dependencies#ffffff id BIGINT True True dependent BIGINT True False depending_on BIGINT True False dependency_type SMALLINT True False version BIGINT True False version_relation VARCHAR(2) True False 546 188 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 -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 -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 488 475 repository_moves#ffffff id MEDIUMINT True True from_repository MEDIUMINT True False to_repository MEDIUMINT True False upstream_package_repository SMALLINT True False 770 345 repository_stabilities#ffffff id SMALLINT True True name VARCHAR(32) True False bugtracker_category VARCHAR(32) False False 69 483 build_dependency_loops#ffffff id BIGINT True True loop MEDIUMINT True False build_assignment BIGINT True False 637 -70 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 653 21 install_targets#ffffff id BIGINT True True name VARCHAR(64) True False 395 313 architectures#ffffff id SMALLINT True True name VARCHAR(16) True False 248 499 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 528 571 upstream_repositories#ffffff id SMALLINT True True name VARCHAR(64) True False git_repository SMALLINT True False 811 553 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 566 299 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 618 100 install_target_providers#ffffff id BIGINT True True package BIGINT True False install_target BIGINT True False version BIGINT True False 299 99 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 118 148 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 196 326 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 -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 log_file_exists BIT 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 756 452 repository_stability_relations#ffffff id MEDIUMINT True True more_stable MEDIUMINT True False less_stable MEDIUMINT True False 820 145 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 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 940 71 todo_links#ffffff dependent BIGINT True False depending_on BIGINT True False 240 -66 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 42 allowed_email_actions#ffffff id BIGINT True True gpg_key BIGINT True False action MEDIUMINT True False -54 70 email_actions#ffffff id MEDIUMINT True True name VARCHAR(32) True False 229 20 ssh_keys#ffffff id BIGINT True True owner MEDIUMINT True False fingerprint TEXT True False 373 388 architecture_compatibilities#ffffff id MEDIUMINT True True built_for SMALLINT True False runs_on SMALLINT True False fully_compatible BIT True False 956 420 mirror_statuses#ffffff id BIGINT True True protocol VARCHAR(8) True False url VARCHAR(128) True False country VARCHAR(64) True False country_code VARCHAR(4) True False last_sync BIGINT True False start FLOAT True False stop FLOAT True False isos BIT True False ipv4 BIT True False ipv6 BIT True False active BIT True False 137.547 593.906 0 248 565.906 180 OneToOne Optional Optional 1 1 499.115 31.8125 270 524.594 57 90 OneToOne Mandatory Mandatory 4 0 618 125.938 180 566.188 95.9062 0 OneToOne Mandatory Mandatory 3 0 549.672 -38.7292 0 637 -31.0938 180 OneToOne Mandatory Mandatory 3 0 549.672 -3.45833 0 653 45.9062 180 OneToOne Mandatory Mandatory 2 0 650.922 279.812 270 650.703 299 90 OneToMany Optional Optional 2 0 448.557 31.8125 270 381.93 99 90 OneToOne Mandatory Mandatory 1 0 546 233.906 180 464.859 225.542 0 OneToOne Mandatory Mandatory 1 0 59.5312 179.906 0 118 221.906 180 OneToOne Mandatory Mandatory 2 0 606.133 552.812 270 602.727 571 90 OneToOne Mandatory Mandatory 3 0 566.755 475 90 622.469 390.812 270 OneToOne Mandatory Mandatory 1 0 645.51 475 90 678.938 390.812 270 OneToOne Mandatory Mandatory 2 0 409.573 288.812 270 442.273 313 90 OneToOne Mandatory Mandatory 9 0 735.406 344.906 0 770 376.906 180 OneToOne Mandatory Mandatory 2 0 696.109 100 90 703.016 70.8125 270 OneToOne Mandatory Mandatory 2 0 618 151.875 180 464.859 162.271 0 OneToOne Mandatory Mandatory 1 0 478.531 565.906 0 528 602.906 180 OneToOne Mandatory Mandatory 4 0 677.453 602.906 0 811 598.906 180 OneToOne Mandatory Mandatory 2 0 289.948 459.812 270 363.266 499 90 OneToOne Mandatory Mandatory 1 0 336.922 392.906 0 395 337.906 180 OneToOne Mandatory Mandatory 2 0 354.286 288.812 270 289.948 326 90 OneToOne Mandatory Mandatory 1 0 212.302 295.812 270 242.974 326 90 OneToOne Mandatory Mandatory 3 0 150.195 483 90 242.974 459.812 270 OneToOne Mandatory Mandatory 2 0 84.1458 342 90 165.151 295.812 270 OneToOne Mandatory Mandatory 1 0 134.719 401.906 0 196 392.906 180 OneToOne Mandatory Mandatory 2 0 33.5729 342 90 -5.28125 317.812 270 OneToOne Mandatory Mandatory 4 0 818.656 452 90 822.635 408.812 270 OneToOne Mandatory Mandatory 1 0 881.312 452 90 875.271 408.812 270 OneToOne Mandatory Mandatory 2 0 982.411 71 90 981.495 21.8125 270 OneToOne Mandatory Mandatory 1 0 1024.82 71 90 1017.99 21.8125 270 OneToOne Mandatory Mandatory 0 0 212.219 -19.0938 0 240 -41.0938 180 OneToOne Mandatory Mandatory 2 0 35.2969 -12.0938 0 106 -19.0938 180 OneToOne Mandatory Mandatory 5 0 142.789 42 90 159.109 12.8125 270 OneToOne Mandatory Mandatory 1 0 68 73.9062 180 43.4531 94.9062 0 OneToOne Mandatory Mandatory 2 0 -9.85156 47.8125 270 -5.27344 70 90 OneToOne Mandatory Mandatory 3 0 188.727 148 90 282.109 83.8125 270 OneToOne Mandatory Mandatory 2 0 282.109 20 90 275.289 -16.1875 270 OneToOne Mandatory Mandatory 1 0 566 344.906 180 489.547 337.906 0 OneToOne Mandatory Mandatory 4 0 494.427 388 90 458.031 362.812 270 OneToOne Mandatory Mandatory 2 0 433.714 388 90 426.516 362.812 270 OneToOne Mandatory Mandatory 1 0