Relational 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_condition CHAR(1) 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 282 497 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 21 510 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 499.573 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 550.359 -38.7292 0 637 -31.0938 180 OneToOne Mandatory Mandatory 3 0 550.359 -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.786 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 645.51 475 90 678.938 390.812 270 OneToOne Mandatory Mandatory 1 0 566.755 475 90 622.469 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 251.531 576.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 242.974 459.812 270 136.266 510 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 363.195 497 90 289.948 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