Yohz Software - Home

Document TitleSample documentationServer: 192.168.1.112Database: sportsdbcreated on May 12 2017 21:06Copyright 2014 - 2017 Yohz Software(or replace with your company name)Table of ContentsServer properties - 192.168.1.1128Database - sportsdb16Schemas17Schema: public18Largest TablesLargest Indexes21Tables (109)22addresses26affiliation_phases28affiliations30affiliations_documents32affiliations_events33affiliations_media34american_football_action_participants35american_football_action_plays37american_football_defensive_stats39american_football_down_progress_stats41american_football_event_states43american_football_fumbles_stats45american_football_offensive_stats47american_football_passing_stats49american_football_penalties_stats51american_football_rushing_stats52american_football_sacks_against_stats54american_football_scoring_stats55american_football_special_teams_stats57attachments59baseball_action_contact_details60baseball_action_pitches62baseball_action_plays64baseball_action_substitutions66baseball_defensive_group68baseball_defensive_players69baseball_defensive_stats71baseball_event_states73baseball_offensive_stats75baseball_pitching_stats77basketball_defensive_stats79basketball_event_states80basketball_offensive_stats822Table of Contentsbasketball_rebounding_stats84basketball_team_stats86bookmakers87core_person_stats89core_stats91db_info92display_names93document_classes95document_contents96document_fixtures98document_fixtures_events100document_package_entry102document_packages104documents105documents_media107events109events_documents111events_media112events_sub_seasons113ice_hockey_action_participants114ice_hockey_action_plays115ice_hockey_defensive_stats116ice_hockey_event_states118ice_hockey_offensive_stats120ice_hockey_player_stats122injury_phases123key_aliases125key_roots126latest_revisions127locations129media130media_captions132media_contents134media_keywords136motor_racing_event_states137motor_racing_qualifying_stats139motor_racing_race_stats141outcome_totals143participants_events145periods147person_event_metadata149person_phases151persons1533Table of Contentspersons_documents155persons_media156positions157publishers159roles160seasons161sites163soccer_defensive_stats165soccer_event_states167soccer_foul_stats169soccer_offensive_stats171sportsdb_table173standing_subgroups174standings175stats177sub_periods179sub_seasons181team_american_football_stats183team_phases184teams186teams_documents188teams_media189tennis_action_points190tennis_action_volleys191tennis_event_states193tennis_return_stats195tennis_service_stats197wagering_moneylines199wagering_odds_lines201wagering_runlines203wagering_straight_spread_lines205wagering_total_score_lines207weather_conditions209Domains (1)211primary_id212Sequences (97)213addresses_id_seq216affiliation_phases_id_seq217affiliations_id_seq218american_football_action_participants_id_seq219american_football_action_plays_id_seq2204Table of Contentsamerican_football_defensive_stats_id_seq221american_football_down_progress_stats_id_seq222american_football_event_states_id_seq223american_football_fumbles_stats_id_seq224american_football_offensive_stats_id_seq225american_football_passing_stats_id_seq226american_football_penalties_stats_id_seq227american_football_rushing_stats_id_seq228american_football_sacks_against_stats_id_seq229american_football_scoring_stats_id_seq230american_football_special_teams_stats_id_seq231attachments_id_seq232baseball_action_contact_details_id_seq233baseball_action_pitches_id_seq234baseball_action_plays_id_seq235baseball_action_substitutions_id_seq236baseball_defensive_group_id_seq237baseball_defensive_players_id_seq238baseball_defensive_stats_id_seq239baseball_event_states_id_seq240baseball_offensive_stats_id_seq241baseball_pitching_stats_id_seq242basketball_defensive_stats_id_seq243basketball_event_states_id_seq244basketball_offensive_stats_id_seq245basketball_rebounding_stats_id_seq246basketball_team_stats_id_seq247bookmakers_id_seq248core_person_stats_id_seq249core_stats_id_seq250display_names_id_seq251document_classes_id_seq252document_contents_id_seq253document_fixtures_events_id_seq254document_fixtures_id_seq255document_package_entry_id_seq256document_packages_id_seq257documents_id_seq258documents_media_id_seq259events_id_seq260ice_hockey_action_participants_id_seq261ice_hockey_action_plays_id_seq2625Table of Contentsice_hockey_defensive_stats_id_seq263ice_hockey_event_states_id_seq264ice_hockey_offensive_stats_id_seq265ice_hockey_player_stats_id_seq266injury_phases_id_seq267key_aliases_id_seq268key_roots_id_seq269latest_revisions_id_seq270locations_id_seq271media_captions_id_seq272media_contents_id_seq273media_id_seq274media_keywords_id_seq275motor_racing_event_states_id_seq276motor_racing_qualifying_stats_id_seq277motor_racing_race_stats_id_seq278outcome_totals_id_seq279participants_events_id_seq280periods_id_seq281person_event_metadata_id_seq282person_phases_id_seq283persons_id_seq284positions_id_seq285publishers_id_seq286roles_id_seq287seasons_id_seq288sites_id_seq289soccer_defensive_stats_id_seq290soccer_event_states_id_seq291soccer_foul_stats_id_seq292soccer_offensive_stats_id_seq293standing_subgroups_id_seq294standings_id_seq295stats_id_seq296sub_periods_id_seq297sub_seasons_id_seq298team_american_football_stats_id_seq299team_phases_id_seq300teams_id_seq301tennis_action_points_id_seq302tennis_action_volleys_id_seq303tennis_event_states_id_seq3046Table of Contentstennis_return_stats_id_seq305tennis_service_stats_id_seq306wagering_moneylines_id_seq307wagering_odds_lines_id_seq308wagering_runlines_id_seq309wagering_straight_spread_lines_id_seq310wagering_total_score_lines_id_seq311weather_conditions_id_seq3127Server PropertiesPropertyValueServer name192.168.1.112VersionPostgreSQL 9.3.2, compiled by Visual C++ build 1600, 64-bitlc_collateEnglish_United States.1252lc_ctypeEnglish_United States.1252server_encodingUTF8block_size8192integer_datetimesonmax_function_args100max_identifier_length63max_index_keys32segment_size131072server_version9.3.2server_version_num90302wal_block_size8192wal_segment_size2048effective_io_concurrency0SettingsCategoryPropertyValueAutovacuumautovacuumonautovacuum_analyze_scale_factor0.1autovacuum_analyze_threshold50autovacuum_freeze_max_age200000000autovacuum_max_workers3autovacuum_naptime60autovacuum_vacuum_cost_delay20autovacuum_vacuum_cost_limit-1autovacuum_vacuum_scale_factor0.2autovacuum_vacuum_threshold50Client Connection Defaults / Locale and Formattingclient_encodingUTF88SettingsCategoryPropertyValueDateStyleISO, MDYdefault_text_search_configpg_catalog.englishextra_float_digits0IntervalStylepostgreslc_messagesEnglish_United States.1252lc_monetaryEnglish_United States.1252lc_numericEnglish_United States.1252lc_timeEnglish_United States.1252TimeZoneAsia/Kuala_Lumpurtimezone_abbreviationsDefaultClient Connection Defaults / Other Defaultsdynamic_library_path$libdirgin_fuzzy_search_limit0local_preload_librariestcp_keepalives_count0tcp_keepalives_idle-1tcp_keepalives_interval-1Client Connection Defaults / Statement Behaviorbytea_outputhexcheck_function_bodiesondefault_tablespacedefault_transaction_deferrableoffdefault_transaction_isolationread committeddefault_transaction_read_onlyofflock_timeout0search_path"$user",publicsession_replication_roleoriginstatement_timeout0temp_tablespacestransaction_deferrableofftransaction_isolationread committedtransaction_read_onlyoff9SettingsCategoryPropertyValuevacuum_freeze_min_age50000000vacuum_freeze_table_age150000000xmlbinarybase64xmloptioncontentConnections and Authentication / Connection Settingsbonjouroffbonjour_namelisten_addresses*max_connections100port5433superuser_reserved_connections3unix_socket_directoriesunix_socket_groupunix_socket_permissions0777Connections and Authentication / Security and Authenticationauthentication_timeout60db_user_namespaceoffkrb_caseins_usersoffkrb_server_keyfilekrb_srvnamepostgrespassword_encryptiononssloffssl_ca_filessl_cert_fileserver.crtssl_ciphersDEFAULT:!LOW:!EXP:!MD5:@STRENGTHssl_crl_filessl_key_fileserver.keyssl_renegotiation_limit524288Developer Optionsallow_system_table_modsoffdebug_assertionsoffignore_checksum_failureoffignore_system_indexesoff10SettingsCategoryPropertyValuepost_auth_delay0pre_auth_delay0trace_notifyofftrace_recovery_messageslogtrace_sortoffzero_damaged_pagesoffError Handlingexit_on_erroroffrestart_after_crashonFile Locationsconfig_fileE:/Program Files/PostgreSQL/9.3/data/postgresql.confdata_directoryE:/Program Files/PostgreSQL/9.3/dataexternal_pid_filehba_fileE:/Program Files/PostgreSQL/9.3/data/pg_hba.confident_fileE:/Program Files/PostgreSQL/9.3/data/pg_ident.confLock Managementdeadlock_timeout1000max_locks_per_transaction256max_pred_locks_per_transaction64Query Tuning / Genetic Query Optimizergeqoongeqo_effort5geqo_generations0geqo_pool_size0geqo_seed0geqo_selection_bias2geqo_threshold12Query Tuning / Other Planner Optionsconstraint_exclusionpartitioncursor_tuple_fraction0.1default_statistics_target100from_collapse_limit8join_collapse_limit811SettingsCategoryPropertyValueQuery Tuning / Planner Cost Constantscpu_index_tuple_cost0.005cpu_operator_cost0.0025cpu_tuple_cost0.01effective_cache_size16384random_page_cost4seq_page_cost1Query Tuning / Planner Method Configurationenable_bitmapscanonenable_hashaggonenable_hashjoinonenable_indexonlyscanonenable_indexscanonenable_materialonenable_mergejoinonenable_nestlooponenable_seqscanonenable_sortonenable_tidscanonReplication / Master Serversynchronous_standby_namesvacuum_defer_cleanup_age0Replication / Sending Serversmax_wal_senders0wal_keep_segments0wal_sender_timeout60000Replication / Standby Servershot_standbyoffhot_standby_feedbackoffmax_standby_archive_delay30000max_standby_streaming_delay30000wal_receiver_status_interval10wal_receiver_timeout60000Reporting and Logging / What to Logapplication_namedebug_pretty_printon12SettingsCategoryPropertyValuedebug_print_parseoffdebug_print_planoffdebug_print_rewrittenofflog_autovacuum_min_duration-1log_checkpointsofflog_connectionsofflog_disconnectionsofflog_durationofflog_error_verbositydefaultlog_hostnameofflog_line_prefix%t log_lock_waitsofflog_statementnonelog_temp_files-1log_timezoneAsia/Kuala_LumpurReporting and Logging / When to Logclient_min_messagesnoticelog_min_duration_statement-1log_min_error_statementerrorlog_min_messageswarningReporting and Logging / Where to Logevent_sourcePostgreSQLlog_destinationstderrlog_directorypg_loglog_file_mode0600log_filenamepostgresql-%Y-%m-%d_%H%M%S.loglog_rotation_age1440log_rotation_size10240log_truncate_on_rotationofflogging_collectoronsyslog_facilitynonesyslog_identpostgres13SettingsCategoryPropertyValueResource Usage / Background Writerbgwriter_delay200bgwriter_lru_maxpages100bgwriter_lru_multiplier2Resource Usage / Cost-Based Vacuum Delayvacuum_cost_delay0vacuum_cost_limit200vacuum_cost_page_dirty20vacuum_cost_page_hit1vacuum_cost_page_miss10Resource Usage / Disktemp_file_limit-1Resource Usage / Kernel Resourcesmax_files_per_process1000shared_preload_librariesResource Usage / Memorymaintenance_work_mem16384max_prepared_transactions0max_stack_depth2048shared_buffers16384temp_buffers1024track_activity_query_size1024work_mem1024Statistics / Monitoringlog_executor_statsofflog_parser_statsofflog_planner_statsofflog_statement_statsoffStatistics / Query and Index Statistics Collectorstats_temp_directorypg_stat_tmptrack_activitiesontrack_countsontrack_functionsnonetrack_io_timingoffupdate_process_titleonVersion and Platform Compatibility / Other Platforms and Clientstransform_null_equalsoff14SettingsCategoryPropertyValueVersion and Platform Compatibility / Previous PostgreSQL Versionsarray_nullsonbackslash_quotesafe_encodingdefault_with_oidsoffescape_string_warningonlo_compat_privilegesoffquote_all_identifiersoffsql_inheritanceonstandard_conforming_stringsonsynchronize_seqscansonWrite-Ahead Log / Archivingarchive_command(disabled)archive_modeoffarchive_timeout0Write-Ahead Log / Checkpointscheckpoint_completion_target0.5checkpoint_segments3checkpoint_timeout300checkpoint_warning30Write-Ahead Log / Settingscommit_delay0commit_siblings5fsynconfull_page_writesonsynchronous_commitonwal_buffers512wal_levelminimalwal_sync_methodopen_datasyncwal_writer_delay20015Database PropertiesPropertyValueNamesportsdbEncodingUTF8Default tablespacepg_defaultSize96.987 MBIs templateFalseAllow connectionTrueComment Database Statisticsxact_commit20498xact_rollback0blks_read1089blks_hit1022609tup_returned13897203tup_fetched362176tup_inserted0tup_updated0tup_deleted0conflicts0temp_files0temp_bytes0deadlocks0blk_read_time0blk_write_time0stats_reset4/21/2017 2:09:20 PM16SchemasNameOIDOwnerTablesCommentpublic2200postgres109standard public schema17Schema: publicPropertyValueOID2200OwnerpostgresCommentstandard public schemaObjectsTables109Views0Domains1Sequences97Functions0Trigger Functions018Largest tables in public schema 20 largest tables by total sizeNameSizeEst. rowsTable sizeIndexes sizeToast size1.attachments73.883 MB08.0 KB0 bytes73.875 MB2.stats3.031 MB9398984.0 KB2.07 MB0 bytes3.participants_events1.836 MB8700584.0 KB1.266 MB0 bytes4.events992.0 KB4350456.0 KB528.0 KB8.0 KB5.person_event_metadata992.0 KB4002264.0 KB728.0 KB0 bytes6.document_fixtures_events736.0 KB4428256.0 KB480.0 KB0 bytes7.persons664.0 KB3937288.0 KB376.0 KB0 bytes8.affiliations_events488.0 KB13052488.0 KB0 bytes0 bytes9.display_names488.0 KB3958376.0 KB104.0 KB8.0 KB10.documents376.0 KB41496.0 KB272.0 KB8.0 KB11.injury_phases336.0 KB77188.0 KB240.0 KB8.0 KB12.events_documents312.0 KB0312.0 KB0 bytes0 bytes13.baseball_offensive_stats256.0 KB1528192.0 KB56.0 KB8.0 KB14.events_sub_seasons184.0 KB0184.0 KB0 bytes0 bytes15.baseball_defensive_stats160.0 KB152896.0 KB56.0 KB8.0 KB16.baseball_pitching_stats160.0 KB752112.0 KB40.0 KB8.0 KB17.core_person_stats144.0 KB158288.0 KB56.0 KB0 bytes18.american_football_action_plays136.0 KB17948.0 KB80.0 KB8.0 KB19.document_contents136.0 KB41464.0 KB64.0 KB8.0 KB20.american_football_action_participants120.0 KB21340.0 KB80.0 KB0 bytes 20 largest tables by estimated rowsNameSizeEst. rowsTable sizeIndexes sizeToast size1.affiliations_events488.0 KB13052488.0 KB0 bytes0 bytes2.stats3.031 MB9398984.0 KB2.07 MB0 bytes3.participants_events1.836 MB8700584.0 KB1.266 MB0 bytes4.document_fixtures_events736.0 KB4428256.0 KB480.0 KB0 bytes5.events992.0 KB4350456.0 KB528.0 KB8.0 KB6.person_event_metadata992.0 KB4002264.0 KB728.0 KB0 bytes7.display_names488.0 KB3958376.0 KB104.0 KB8.0 KB8.persons664.0 KB3937288.0 KB376.0 KB0 bytes9.core_person_stats144.0 KB158288.0 KB56.0 KB0 bytes10.baseball_offensive_stats256.0 KB1528192.0 KB56.0 KB8.0 KB11.baseball_defensive_stats160.0 KB152896.0 KB56.0 KB8.0 KB12.affiliations_documents72.0 KB123472.0 KB0 bytes0 bytes13.ice_hockey_offensive_stats120.0 KB83972.0 KB40.0 KB8.0 KB14.ice_hockey_player_stats96.0 KB81756.0 KB40.0 KB0 bytes15.injury_phases336.0 KB77188.0 KB240.0 KB8.0 KB16.baseball_pitching_stats160.0 KB752112.0 KB40.0 KB8.0 KB19 20 largest tables by estimated rowsNameSizeEst. rowsTable sizeIndexes sizeToast size17.american_football_scoring_stats96.0 KB64056.0 KB32.0 KB8.0 KB18.american_football_defensive_stats104.0 KB57064.0 KB32.0 KB8.0 KB19.periods112.0 KB54848.0 KB64.0 KB0 bytes20.documents376.0 KB41496.0 KB272.0 KB8.0 KB 20 largest tables by indexes sizeNameSizeEst. rowsTable sizeIndexes sizeToast size1.stats3.031 MB9398984.0 KB2.07 MB0 bytes2.participants_events1.836 MB8700584.0 KB1.266 MB0 bytes3.person_event_metadata992.0 KB4002264.0 KB728.0 KB0 bytes4.events992.0 KB4350456.0 KB528.0 KB8.0 KB5.document_fixtures_events736.0 KB4428256.0 KB480.0 KB0 bytes6.persons664.0 KB3937288.0 KB376.0 KB0 bytes7.documents376.0 KB41496.0 KB272.0 KB8.0 KB8.injury_phases336.0 KB77188.0 KB240.0 KB8.0 KB9.display_names488.0 KB3958376.0 KB104.0 KB8.0 KB10.american_football_action_participants120.0 KB21340.0 KB80.0 KB0 bytes11.american_football_action_plays136.0 KB17948.0 KB80.0 KB8.0 KB12.addresses96.0 KB08.0 KB80.0 KB8.0 KB13.periods112.0 KB54848.0 KB64.0 KB0 bytes14.document_contents136.0 KB41464.0 KB64.0 KB8.0 KB15.latest_revisions112.0 KB29548.0 KB64.0 KB0 bytes16.affiliations72.0 KB298.0 KB64.0 KB0 bytes17.document_fixtures72.0 KB128.0 KB64.0 KB0 bytes18.seasons72.0 KB48.0 KB64.0 KB0 bytes19.sub_seasons72.0 KB48.0 KB64.0 KB0 bytes20.core_person_stats144.0 KB158288.0 KB56.0 KB0 bytes20Largest indexes in public schema 20 largest indexes by sizeTableIndex nameSizeDefinition1.statsidx_stats_1456.0 KBbtree (stat_repository_type)2.statsidx_stats_7272.0 KBbtree (context)3.statsidx_stats_5272.0 KBbtree (stat_coverage_type)4.participants_eventsidx_participants_events_4256.0 KBbtree (event_outcome)5.statsstats_id_key224.0 KBbtree (id)6.statsidx_stats_3224.0 KBbtree (stat_holder_type)7.statsidx_stats_2224.0 KBbtree (stat_repository_id)8.statsidx_stats_6224.0 KBbtree (stat_coverage_id)9.statsidx_stats_4224.0 KBbtree (stat_holder_id)10.participants_eventsidx_participants_events_1208.0 KBbtree (participant_type)11.participants_eventsidx_participants_events_2208.0 KBbtree (participant_id)12.participants_eventsidx_participants_events_3208.0 KBbtree (alignment)13.participants_eventsparticipants_events_id_key208.0 KBbtree (id)14.participants_eventsidx_fk_par_eve_eve_id__eve_id208.0 KBbtree (event_id)15.eventsidx_events_1192.0 KBbtree (event_key)16.personsidx_persons_1168.0 KBbtree (person_key)17.document_fixtures_eventsidx_fk_doc_fix_eve_doc_fix_id__doc_fix_id120.0 KBbtree (document_fixture_id)18.document_fixtures_eventsidx_fk_doc_fix_eve_eve_id__eve_id120.0 KBbtree (event_id)19.document_fixtures_eventsdocument_fixtures_events_id_key120.0 KBbtree (id)20.document_fixtures_eventsidx_fk_doc_fix_eve_lat_doc_id__doc_id120.0 KBbtree (latest_document_id)21public schema: Tables (109)TableOIDOwnerSizeEst. rowsaddresses24692postgres96.0 KB0affiliation_phases24701postgres24.0 KB55affiliations24707postgres72.0 KB29affiliations_documents24711postgres72.0 KB1234affiliations_events24714postgres488.0 KB13052affiliations_media24717postgres0 bytes0american_football_action_participants24722postgres120.0 KB213american_football_action_plays24728postgres136.0 KB179american_football_defensive_stats24737postgres104.0 KB570american_football_down_progress_stats24746postgres32.0 KB26american_football_event_states24755postgres88.0 KB193american_football_fumbles_stats24761postgres32.0 KB91american_football_offensive_stats24770postgres32.0 KB26american_football_passing_stats24779postgres64.0 KB227american_football_penalties_stats24788postgres24.0 KB26american_football_rushing_stats24794postgres32.0 KB124american_football_sacks_against_stats24803postgres24.0 KB56american_football_scoring_stats24809postgres96.0 KB640american_football_special_teams_stats24818postgres32.0 KB110attachments178391postgres73.883 MB0baseball_action_contact_details24827postgres16.0 KB0baseball_action_pitches24836postgres40.0 KB0baseball_action_plays24845postgres64.0 KB17baseball_action_substitutions24854postgres8.0 KB0baseball_defensive_group24860postgres8.0 KB0baseball_defensive_players24866postgres8.0 KB0baseball_defensive_stats24872postgres160.0 KB1528baseball_event_states24881postgres56.0 KB17baseball_offensive_stats24887postgres256.0 KB1528baseball_pitching_stats24896postgres160.0 KB752basketball_defensive_stats24905postgres24.0 KB128basketball_event_states24911postgres16.0 KB0basketball_offensive_stats24917postgres64.0 KB128basketball_rebounding_stats24926postgres32.0 KB128basketball_team_stats24935postgres8.0 KB022public schema: Tables (109)TableOIDOwnerSizeEst. rowsbookmakers24941postgres8.0 KB0core_person_stats24947postgres144.0 KB1582core_stats24953postgres16.0 KB0db_info24960postgres8.0 KB0display_names24966postgres488.0 KB3958document_classes24975postgres40.0 KB6document_contents24981postgres136.0 KB414document_fixtures24990postgres72.0 KB12document_fixtures_events24996postgres736.0 KB4428document_package_entry25002postgres8.0 KB0document_packages25008postgres8.0 KB0documents25014postgres376.0 KB414documents_media25023postgres8.0 KB0events25029postgres992.0 KB4350events_documents25036postgres312.0 KB0events_media25039postgres0 bytes0events_sub_seasons25042postgres184.0 KB0ice_hockey_action_participants25047postgres24.0 KB138ice_hockey_action_plays25053postgres32.0 KB51ice_hockey_defensive_stats25062postgres32.0 KB46ice_hockey_event_states25071postgres24.0 KB51ice_hockey_offensive_stats25077postgres120.0 KB839ice_hockey_player_stats25086postgres96.0 KB817injury_phases25092postgres336.0 KB771key_aliases25101postgres16.0 KB0key_roots25107postgres16.0 KB0latest_revisions25113postgres112.0 KB295locations25119postgres40.0 KB0media25125postgres8.0 KB0media_captions25131postgres8.0 KB0media_contents25137postgres16.0 KB0media_keywords25146postgres8.0 KB0motor_racing_event_states25152postgres16.0 KB0motor_racing_qualifying_stats25158postgres16.0 KB0motor_racing_race_stats25167postgres16.0 KB023public schema: Tables (109)TableOIDOwnerSizeEst. rowsoutcome_totals25176postgres16.0 KB0participants_events25185postgres1.836 MB8700periods25191postgres112.0 KB548person_event_metadata25197postgres992.0 KB4002person_phases25203postgres48.0 KB0persons25209postgres664.0 KB3937persons_documents25213postgres0 bytes0persons_media25216postgres0 bytes0positions25221postgres56.0 KB73publishers25227postgres40.0 KB1roles25233postgres16.0 KB0seasons25239postgres72.0 KB4sites25245postgres32.0 KB0soccer_defensive_stats25251postgres16.0 KB0soccer_event_states25260postgres24.0 KB0soccer_foul_stats25269postgres16.0 KB0soccer_offensive_stats25278postgres16.0 KB0sportsdb_table178383postgres8.0 KB0standing_subgroups25287postgres8.0 KB0standings25293postgres16.0 KB0stats25302postgres3.031 MB9398sub_periods25308postgres16.0 KB0sub_seasons25314postgres72.0 KB4team_american_football_stats25320postgres32.0 KB26team_phases25329postgres80.0 KB368teams25335postgres24.0 KB128teams_documents25339postgres40.0 KB0teams_media25342postgres0 bytes0tennis_action_points25347postgres8.0 KB0tennis_action_volleys25353postgres16.0 KB0tennis_event_states25362postgres24.0 KB0tennis_return_stats25371postgres16.0 KB0tennis_service_stats25380postgres16.0 KB0wagering_moneylines25389postgres16.0 KB0wagering_odds_lines25398postgres16.0 KB024public schema: Tables (109)TableOIDOwnerSizeEst. rowswagering_runlines25407postgres16.0 KB0wagering_straight_spread_lines25416postgres16.0 KB0wagering_total_score_lines25425postgres16.0 KB0weather_conditions25434postgres24.0 KB025Table - public > addresses Table PropertiesPropertyValuePropertyValueTotal size96.0 KBOID24692Table size8.0 KBOwnerpostgresIndexes size80.0 KBTablespacepg_defaultToast size8.0 KBPrimary key(s)Estimated rows0Comment Table Statisticsseq_scan0n_dead_tup0seq_tup_read0last_vacuum-idx_scan0last_autocvacuum-idx_tup_fetch0last_analyze-n_tup_ins0last_autoanalyze-n_tup_upd0vacuum_count0n_tup_del0autovacuum_count0n_tup_hot_upd0analyze_count0n_live_tup0autoanalyze_count0 ColumnsNameTypeLengthDefault valueNullableCommentidinteger-1nextval('addresses_id_seq'::regclass)Falselocation_idinteger-1Falselanguagecharacter varying100Truesuitecharacter varying100Truefloorcharacter varying100Truebuildingcharacter varying100Truestreet_numbercharacter varying100Truestreet_prefixcharacter varying100Truestreetcharacter varying100Truestreet_suffixcharacter varying100Trueneighborhoodcharacter varying100Truedistrictcharacter varying100Truelocalitycharacter varying100Truecountycharacter varying100Trueregioncharacter varying100Truepostal_codecharacter varying100Truecountrycharacter varying100True IndexesName (scan, tup_read, tup_fetch)PrimaryUniqueClusteredSizeDefinition26 IndexesName (scan, tup_read, tup_fetch)PrimaryUniqueClusteredSizeDefinition[Index."IndexName"] ([Index."StatIdx_Scan"], [Index."StatIdx_Tup_Read"], [Index."StatIdx_Tup_Fetch"])FalseTrueFalse16.0 KBbtree (id)idx_addresses_1 (0, 0, 0)FalseFalseFalse16.0 KBbtree (locality)idx_fk_add_loc_id__loc_id (0, 0, 0)FalseFalseFalse16.0 KBbtree (location_id)idx_addresses_2 (0, 0, 0)FalseFalseFalse16.0 KBbtree (region)idx_addresses_3 (0, 0, 0)FalseFalseFalse16.0 KBbtree (postal_code) Unique ConstraintsNameColumns Commentaddresses_id_keyid Foreign KeysNameKeys Reference tableReference keysfk_add_loc_id__loc_idlocation_idlocationsid27Table - public > affiliation_phases Table PropertiesPropertyValuePropertyValueTotal size24.0 KBOID24701Table size8.0 KBOwnerpostgresIndexes size16.0 KBTablespacepg_defaultToast size0 bytesPrimary key(s)Estimated rows55Comment Table Statisticsseq_scan0n_dead_tup0seq_tup_read0last_vacuum-idx_scan0last_autocvacuum-idx_tup_fetch0last_analyze-n_tup_ins0last_autoanalyze-n_tup_upd0vacuum_count0n_tup_del0autovacuum_count0n_tup_hot_upd0analyze_count0n_live_tup0autoanalyze_count0 ColumnsNameTypeLengthDefault valueNullableCommentidinteger-1nextval('affiliation_phases_id_seq'::regclass)FalseUnique identifieraffiliation_idinteger-1FalseImmediate affiliate.ancestor_affiliation_idinteger-1TrueMain affiliate.start_season_idinteger-1Truestart_date_timetimestamp without time zone-1Trueend_season_idinteger-1Trueend_date_timetimestamp without time zone-1True IndexesName (scan, tup_read, tup_fetch)PrimaryUniqueClusteredSizeDefinitionaffiliation_phases_id_key (0, 0, 0)FalseTrueFalse16.0 KBbtree (id) Unique ConstraintsNameColumns Commentaffiliation_phases_id_keyid28 Foreign KeysNameKeys Reference tableReference keysfk_seasons_affiliation_phases1end_season_idseasonsidfk_affiliations_affiliation_phasesaffiliation_idaffiliationsidfk_affiliations_affiliation_phases1ancestor_affiliation_idaffiliationsidfk_seasons_affiliation_phasesstart_season_idseasonsid29Table - public > affiliations Table PropertiesPropertyValuePropertyValueTotal size72.0 KBOID24707Table size8.0 KBOwnerpostgresIndexes size64.0 KBTablespacepg_defaultToast size0 bytesPrimary key(s)Estimated rows29Comment Table Statisticsseq_scan0n_dead_tup0seq_tup_read0last_vacuum-idx_scan0last_autocvacuum-idx_tup_fetch0last_analyze-n_tup_ins0last_autoanalyze-n_tup_upd0vacuum_count0n_tup_del0autovacuum_count0n_tup_hot_upd0analyze_count0n_live_tup0autoanalyze_count0 ColumnsNameTypeLengthDefault valueNullableCommentidinteger-1nextval('affiliations_id_seq'::regclass)Falseaffiliation_keycharacter varying100Falseaffiliation_typecharacter varying100Truepublisher_idinteger-1False IndexesName (scan, tup_read, tup_fetch)PrimaryUniqueClusteredSizeDefinitionidx_affiliations_2 (0, 0, 0)FalseFalseFalse16.0 KBbtree (affiliation_type)affiliations_id_key (0, 0, 0)FalseTrueFalse16.0 KBbtree (id)idx_affiliations_1 (0, 0, 0)FalseFalseFalse16.0 KBbtree (affiliation_key)idx_fk_aff_pub_id__pub_id (0, 0, 0)FalseFalseFalse16.0 KBbtree (publisher_id) Unique ConstraintsNameColumns Commentaffiliations_id_keyid30 Foreign KeysNameKeys Reference tableReference keysfk_aff_pub_id__pub_idpublisher_idpublishersid31Table - public > affiliations_documents Table PropertiesPropertyValuePropertyValueTotal size72.0 KBOID24711Table size72.0 KBOwnerpostgresIndexes size0 bytesTablespacepg_defaultToast size0 bytesPrimary key(s)Estimated rows1234Comment Table Statisticsseq_scan0n_dead_tup0seq_tup_read0last_vacuum-idx_scan0last_autocvacuum-idx_tup_fetch0last_analyze-n_tup_ins0last_autoanalyze-n_tup_upd0vacuum_count0n_tup_del0autovacuum_count0n_tup_hot_upd0analyze_count0n_live_tup0autoanalyze_count0 ColumnsNameTypeLengthDefault valueNullableCommentaffiliation_idinteger-1Falsedocument_idinteger-1False Foreign KeysNameKeys Reference tableReference keysfk_aff_doc_doc_id__doc_iddocument_iddocumentsidfk_aff_doc_aff_id__aff_idaffiliation_idaffiliationsid32Table - public > affiliations_events Table PropertiesPropertyValuePropertyValueTotal size488.0 KBOID24714Table size488.0 KBOwnerpostgresIndexes size0 bytesTablespacepg_defaultToast size0 bytesPrimary key(s)Estimated rows13052Comment Table Statisticsseq_scan0n_dead_tup0seq_tup_read0last_vacuum-idx_scan0last_autocvacuum-idx_tup_fetch0last_analyze-n_tup_ins0last_autoanalyze-n_tup_upd0vacuum_count0n_tup_del0autovacuum_count0n_tup_hot_upd0analyze_count0n_live_tup0autoanalyze_count0 ColumnsNameTypeLengthDefault valueNullableCommentaffiliation_idinteger-1Falseevent_idinteger-1False Foreign KeysNameKeys Reference tableReference keysfk_aff_eve_aff_id__aff_idaffiliation_idaffiliationsidfk_aff_eve_eve_id__eve_idevent_ideventsid33Table - public > affiliations_media Table PropertiesPropertyValuePropertyValueTotal size0 bytesOID24717Table size0 bytesOwnerpostgresIndexes size0 bytesTablespacepg_defaultToast size0 bytesPrimary key(s)Estimated rows0Comment Table Statisticsseq_scan0n_dead_tup0seq_tup_read0last_vacuum-idx_scan0last_autocvacuum-idx_tup_fetch0last_analyze-n_tup_ins0last_autoanalyze-n_tup_upd0vacuum_count0n_tup_del0autovacuum_count0n_tup_hot_upd0analyze_count0n_live_tup0autoanalyze_count0 ColumnsNameTypeLengthDefault valueNullableCommentaffiliation_idinteger-1Falsemedia_idinteger-1False Foreign KeysNameKeys Reference tableReference keysfk_aff_med_aff_id__aff_idaffiliation_idaffiliationsidfk_aff_med_med_id__med_idmedia_idmediaid34Table - public > american_football_action_participants Table PropertiesPropertyValuePropertyValueTotal size120.0 KBOID24722Table size40.0 KBOwnerpostgresIndexes size80.0 KBTablespacepg_defaultToast size0 bytesPrimary key(s)Estimated rows213Comment Table Statisticsseq_scan0n_dead_tup0seq_tup_read0last_vacuum-idx_scan0last_autocvacuum-idx_tup_fetch0last_analyze-n_tup_ins0last_autoanalyze-n_tup_upd0vacuum_count0n_tup_del0autovacuum_count0n_tup_hot_upd0analyze_count0n_live_tup0autoanalyze_count0 ColumnsNameTypeLengthDefault valueNullableCommentidinteger-1nextval('american_football_action_participants_id_seq'::regclass)Falseamerican_football_action_play_idinteger-1Falseperson_idinteger-1Falseparticipant_rolecharacter varying100Falsescore_typecharacter varying100Truefield_lineinteger-1Trueyardageinteger-1Truescore_creditinteger-1Trueyards_gainedinteger-1True IndexesName (scan, tup_read, tup_fetch)PrimaryUniqueClusteredSizeDefinitionidx_fk_ame_foo_act_par_ame_foo_act_pla_id__ame_foo_act_pla_id (0, 0, 0)FalseFalseFalse16.0 KBbtree (american_football_action_play_id)american_football_action_participants_id_key (0, 0, 0)FalseTrueFalse16.0 KBbtree (id)idx_american_football_action_participants_1 (0, 0, 0)FalseFalseFalse16.0 KBbtree (participant_role)35 IndexesName (scan, tup_read, tup_fetch)PrimaryUniqueClusteredSizeDefinition[Index."IndexName"] ([Index."StatIdx_Scan"], [Index."StatIdx_Tup_Read"], [Index."StatIdx_Tup_Fetch"])FalseFalseFalse16.0 KBbtree (score_type)idx_fk_ame_foo_act_par_per_id__per_id (0, 0, 0)FalseFalseFalse16.0 KBbtree (person_id) Unique ConstraintsNameColumns Commentamerican_football_action_participants_id_keyid Foreign KeysNameKeys Reference tableReference keysfk_ame_foo_act_par_ame_foo_act_pla_id__ame_foo_act_pla_idamerican_football_action_play_idamerican_football_action_playsidfk_ame_foo_act_par_per_id__per_idperson_idpersonsid36Table - public > american_football_action_plays Table PropertiesPropertyValuePropertyValueTotal size136.0 KBOID24728Table size48.0 KBOwnerpostgresIndexes size80.0 KBTablespacepg_defaultToast size8.0 KBPrimary key(s)Estimated rows179Comment Table Statisticsseq_scan0n_dead_tup0seq_tup_read0last_vacuum-idx_scan0last_autocvacuum-idx_tup_fetch0last_analyze-n_tup_ins0last_autoanalyze-n_tup_upd0vacuum_count0n_tup_del0autovacuum_count0n_tup_hot_upd0analyze_count0n_live_tup0autoanalyze_count0 ColumnsNameTypeLengthDefault valueNullableCommentidinteger-1nextval('american_football_action_plays_id_seq'::regclass)Falseamerican_football_event_state_idinteger-1Falseplay_typecharacter varying100Truescore_attempt_typecharacter varying100Truedrive_resultcharacter varying100Truepointsinteger-1Truecommentcharacter varying255True IndexesName (scan, tup_read, tup_fetch)PrimaryUniqueClusteredSizeDefinitionidx_american_football_action_plays_1 (0, 0, 0)FalseFalseFalse16.0 KBbtree (play_type)american_football_action_plays_id_key (0, 0, 0)FalseTrueFalse16.0 KBbtree (id)idx_fk_ame_foo_act_pla_ame_foo_eve_sta_id__ame_foo_eve_sta_id (0, 0, 0)FalseFalseFalse16.0 KBbtree (american_football_event_state_id)37 IndexesName (scan, tup_read, tup_fetch)PrimaryUniqueClusteredSizeDefinition[Index."IndexName"] ([Index."StatIdx_Scan"], [Index."StatIdx_Tup_Read"], [Index."StatIdx_Tup_Fetch"])FalseFalseFalse16.0 KBbtree (drive_result)idx_american_football_action_plays_2 (0, 0, 0)FalseFalseFalse16.0 KBbtree (score_attempt_type) Unique ConstraintsNameColumns Commentamerican_football_action_plays_id_keyid Foreign KeysNameKeys Reference tableReference keysfk_ame_foo_act_pla_ame_foo_eve_sta_id__ame_foo_eve_sta_idamerican_football_event_state_idamerican_football_event_statesid38Table - public > american_football_defensive_stats Table PropertiesPropertyValuePropertyValueTotal size104.0 KBOID24737Table size64.0 KBOwnerpostgresIndexes size32.0 KBTablespacepg_defaultToast size8.0 KBPrimary key(s)Estimated rows570Comment Table Statisticsseq_scan0n_dead_tup0seq_tup_read0last_vacuum-idx_scan0last_autocvacuum-idx_tup_fetch0last_analyze-n_tup_ins0last_autoanalyze-n_tup_upd0vacuum_count0n_tup_del0autovacuum_count0n_tup_hot_upd0analyze_count0n_live_tup0autoanalyze_count0 ColumnsNameTypeLengthDefault valueNullableCommentidinteger-1nextval('american_football_defensive_stats_id_seq'::regclass)Falsetackles_totalcharacter varying100Truetackles_solocharacter varying100Truetackles_assistscharacter varying100Trueinterceptions_totalcharacter varying100Trueinterceptions_yardscharacter varying100Trueinterceptions_averagecharacter varying100Trueinterceptions_longestcharacter varying100Trueinterceptions_touchdowncharacter varying100Truequarterback_hurriescharacter varying100Truesacks_totalcharacter varying100Truesacks_yardscharacter varying100Truepasses_defensedcharacter varying100True39 IndexesName (scan, tup_read, tup_fetch)PrimaryUniqueClusteredSizeDefinitionamerican_football_defensive_stats_id_key (0, 0, 0)FalseTrueFalse32.0 KBbtree (id) Unique ConstraintsNameColumns Commentamerican_football_defensive_stats_id_keyid40Table - public > american_football_down_progress_stats Table PropertiesPropertyValuePropertyValueTotal size32.0 KBOID24746Table size8.0 KBOwnerpostgresIndexes size16.0 KBTablespacepg_defaultToast size8.0 KBPrimary key(s)Estimated rows26Comment Table Statisticsseq_scan0n_dead_tup0seq_tup_read0last_vacuum-idx_scan0last_autocvacuum-idx_tup_fetch0last_analyze-n_tup_ins0last_autoanalyze-n_tup_upd0vacuum_count0n_tup_del0autovacuum_count0n_tup_hot_upd0analyze_count0n_live_tup0autoanalyze_count0 ColumnsNameTypeLengthDefault valueNullableCommentidinteger-1nextval('american_football_down_progress_stats_id_seq'::regclass)Falsefirst_downs_totalcharacter varying100Truefirst_downs_passcharacter varying100Truefirst_downs_runcharacter varying100Truefirst_downs_penaltycharacter varying100Trueconversions_third_downcharacter varying100Trueconversions_third_down_attemptscharacter varying100Trueconversions_third_down_percentagecharacter varying100Trueconversions_fourth_downcharacter varying100Trueconversions_fourth_down_attemptscharacter varying100Trueconversions_fourth_down_percentagecharacter varying100True41 ColumnsNameTypeLengthDefault valueNullableComment IndexesName (scan, tup_read, tup_fetch)PrimaryUniqueClusteredSizeDefinitionamerican_football_down_progress_stats_id_key (0, 0, 0)FalseTrueFalse16.0 KBbtree (id) Unique ConstraintsNameColumns Commentamerican_football_down_progress_stats_id_keyid42Table - public > american_football_event_states Table PropertiesPropertyValuePropertyValueTotal size88.0 KBOID24755Table size40.0 KBOwnerpostgresIndexes size48.0 KBTablespacepg_defaultToast size0 bytesPrimary key(s)Estimated rows193Comment Table Statisticsseq_scan0n_dead_tup0seq_tup_read0last_vacuum-idx_scan0last_autocvacuum-idx_tup_fetch0last_analyze-n_tup_ins0last_autoanalyze-n_tup_upd0vacuum_count0n_tup_del0autovacuum_count0n_tup_hot_upd0analyze_count0n_live_tup0autoanalyze_count0 ColumnsNameTypeLengthDefault valueNullableCommentidinteger-1nextval('american_football_event_states_id_seq'::regclass)Falseevent_idinteger-1Falsecurrent_statesmallint-1Truesequence_numberinteger-1Trueperiod_valueinteger-1Trueperiod_time_elapsedcharacter varying100Trueperiod_time_remainingcharacter varying100Trueclock_statecharacter varying100Truedowninteger-1Trueteam_in_possession_idinteger-1Truedistance_for_1st_downinteger-1Truefield_sidecharacter varying100Truefield_lineinteger-1Truecontextcharacter varying40True43 IndexesName (scan, tup_read, tup_fetch)PrimaryUniqueClusteredSizeDefinitionamerican_football_event_states_id_key (0, 0, 0)FalseTrueFalse16.0 KBbtree (id)idx_american_football_event_states_1 (0, 0, 0)FalseFalseFalse16.0 KBbtree (current_state)idx_fk_ame_foo_eve_sta_eve_id__eve_id (0, 0, 0)FalseFalseFalse16.0 KBbtree (event_id) Unique ConstraintsNameColumns Commentamerican_football_event_states_id_keyid Foreign KeysNameKeys Reference tableReference keysfk_ame_foo_eve_sta_tea_in_pos_id__tea_idteam_in_possession_idteamsidfk_ame_foo_eve_sta_eve_id__eve_idevent_ideventsid44Table - public > american_football_fumbles_stats Table PropertiesPropertyValuePropertyValueTotal size32.0 KBOID24761Table size8.0 KBOwnerpostgresIndexes size16.0 KBTablespacepg_defaultToast size8.0 KBPrimary key(s)Estimated rows91Comment Table Statisticsseq_scan0n_dead_tup0seq_tup_read0last_vacuum-idx_scan0last_autocvacuum-idx_tup_fetch0last_analyze-n_tup_ins0last_autoanalyze-n_tup_upd0vacuum_count0n_tup_del0autovacuum_count0n_tup_hot_upd0analyze_count0n_live_tup0autoanalyze_count0 ColumnsNameTypeLengthDefault valueNullableCommentidinteger-1nextval('american_football_fumbles_stats_id_seq'::regclass)Falsefumbles_committedcharacter varying100Truefumbles_forcedcharacter varying100Truefumbles_recoveredcharacter varying100Truefumbles_lostcharacter varying100Truefumbles_yards_gainedcharacter varying100Truefumbles_own_committedcharacter varying100Truefumbles_own_recoveredcharacter varying100Truefumbles_own_lostcharacter varying100Truefumbles_own_yards_gainedcharacter varying100Truefumbles_opposing_committedcharacter varying100Truefumbles_opposing_recoveredcharacter varying100Truefumbles_opposing_lostcharacter varying100True45 ColumnsNameTypeLengthDefault valueNullableCommentfumbles_opposing_yards_gainedcharacter varying100True IndexesName (scan, tup_read, tup_fetch)PrimaryUniqueClusteredSizeDefinitionamerican_football_fumbles_stats_id_key (0, 0, 0)FalseTrueFalse16.0 KBbtree (id) Unique ConstraintsNameColumns Commentamerican_football_fumbles_stats_id_keyid46Table - public > american_football_offensive_stats Table PropertiesPropertyValuePropertyValueTotal size32.0 KBOID24770Table size8.0 KBOwnerpostgresIndexes size16.0 KBTablespacepg_defaultToast size8.0 KBPrimary key(s)Estimated rows26Comment Table Statisticsseq_scan0n_dead_tup0seq_tup_read0last_vacuum-idx_scan0last_autocvacuum-idx_tup_fetch0last_analyze-n_tup_ins0last_autoanalyze-n_tup_upd0vacuum_count0n_tup_del0autovacuum_count0n_tup_hot_upd0analyze_count0n_live_tup0autoanalyze_count0 ColumnsNameTypeLengthDefault valueNullableCommentidinteger-1nextval('american_football_offensive_stats_id_seq'::regclass)Falseoffensive_plays_yardscharacter varying100Trueoffensive_plays_numbercharacter varying100Trueoffensive_plays_average_yards_percharacter varying100Truepossession_durationcharacter varying100Trueturnovers_giveawaycharacter varying100True IndexesName (scan, tup_read, tup_fetch)PrimaryUniqueClusteredSizeDefinitionamerican_football_offensive_stats_id_key (0, 0, 0)FalseTrueFalse16.0 KBbtree (id) Unique ConstraintsNameColumns Comment47 Unique ConstraintsNameColumns Commentamerican_football_offensive_stats_id_keyid48Table - public > american_football_passing_stats Table PropertiesPropertyValuePropertyValueTotal size64.0 KBOID24779Table size40.0 KBOwnerpostgresIndexes size16.0 KBTablespacepg_defaultToast size8.0 KBPrimary key(s)Estimated rows227Comment Table Statisticsseq_scan0n_dead_tup0seq_tup_read0last_vacuum-idx_scan0last_autocvacuum-idx_tup_fetch0last_analyze-n_tup_ins0last_autoanalyze-n_tup_upd0vacuum_count0n_tup_del0autovacuum_count0n_tup_hot_upd0analyze_count0n_live_tup0autoanalyze_count0 ColumnsNameTypeLengthDefault valueNullableCommentidinteger-1nextval('american_football_passing_stats_id_seq'::regclass)Falsepasses_attemptscharacter varying100Truepasses_completionscharacter varying100Truepasses_percentagecharacter varying100Truepasses_yards_grosscharacter varying100Truepasses_yards_netcharacter varying100Truepasses_yards_lostcharacter varying100Truepasses_touchdownscharacter varying100Truepasses_touchdowns_percentagecharacter varying100Truepasses_interceptionscharacter varying100Truepasses_interceptions_percentagecharacter varying100Truepasses_longestcharacter varying100True49 ColumnsNameTypeLengthDefault valueNullableCommentpasses_average_yards_percharacter varying100Truepasser_ratingcharacter varying100Truereceptions_totalcharacter varying100Truereceptions_yardscharacter varying100Truereceptions_touchdownscharacter varying100Truereceptions_first_downcharacter varying100Truereceptions_longestcharacter varying100Truereceptions_average_yards_percharacter varying100True IndexesName (scan, tup_read, tup_fetch)PrimaryUniqueClusteredSizeDefinitionamerican_football_passing_stats_id_key (0, 0, 0)FalseTrueFalse16.0 KBbtree (id) Unique ConstraintsNameColumns Commentamerican_football_passing_stats_id_keyid50Table - public > american_football_penalties_stats Table PropertiesPropertyValuePropertyValueTotal size24.0 KBOID24788Table size8.0 KBOwnerpostgresIndexes size16.0 KBTablespacepg_defaultToast size0 bytesPrimary key(s)Estimated rows26Comment Table Statisticsseq_scan0n_dead_tup0seq_tup_read0last_vacuum-idx_scan0last_autocvacuum-idx_tup_fetch0last_analyze-n_tup_ins0last_autoanalyze-n_tup_upd0vacuum_count0n_tup_del0autovacuum_count0n_tup_hot_upd0analyze_count0n_live_tup0autoanalyze_count0 ColumnsNameTypeLengthDefault valueNullableCommentidinteger-1nextval('american_football_penalties_stats_id_seq'::regclass)Falsepenalties_totalcharacter varying100Truepenalty_yardscharacter varying100Truepenalty_first_downscharacter varying100True IndexesName (scan, tup_read, tup_fetch)PrimaryUniqueClusteredSizeDefinitionamerican_football_penalties_stats_id_key (0, 0, 0)FalseTrueFalse16.0 KBbtree (id) Unique ConstraintsNameColumns Commentamerican_football_penalties_stats_id_keyid51Table - public > american_football_rushing_stats Table PropertiesPropertyValuePropertyValueTotal size32.0 KBOID24794Table size8.0 KBOwnerpostgresIndexes size16.0 KBTablespacepg_defaultToast size8.0 KBPrimary key(s)Estimated rows124Comment Table Statisticsseq_scan0n_dead_tup0seq_tup_read0last_vacuum-idx_scan0last_autocvacuum-idx_tup_fetch0last_analyze-n_tup_ins0last_autoanalyze-n_tup_upd0vacuum_count0n_tup_del0autovacuum_count0n_tup_hot_upd0analyze_count0n_live_tup0autoanalyze_count0 ColumnsNameTypeLengthDefault valueNullableCommentidinteger-1nextval('american_football_rushing_stats_id_seq'::regclass)Falserushes_attemptscharacter varying100Truerushes_yardscharacter varying100Truerushes_touchdownscharacter varying100Truerushing_average_yards_percharacter varying100Truerushes_first_downcharacter varying100Truerushes_longestcharacter varying100True IndexesName (scan, tup_read, tup_fetch)PrimaryUniqueClusteredSizeDefinitionamerican_football_rushing_stats_id_key (0, 0, 0)FalseTrueFalse16.0 KBbtree (id) Unique ConstraintsNameColumns Comment52 Unique ConstraintsNameColumns Commentamerican_football_rushing_stats_id_keyid53Table - public > american_football_sacks_against_stats Table PropertiesPropertyValuePropertyValueTotal size24.0 KBOID24803Table size8.0 KBOwnerpostgresIndexes size16.0 KBTablespacepg_defaultToast size0 bytesPrimary key(s)Estimated rows56Comment Table Statisticsseq_scan0n_dead_tup0seq_tup_read0last_vacuum-idx_scan0last_autocvacuum-idx_tup_fetch0last_analyze-n_tup_ins0last_autoanalyze-n_tup_upd0vacuum_count0n_tup_del0autovacuum_count0n_tup_hot_upd0analyze_count0n_live_tup0autoanalyze_count0 ColumnsNameTypeLengthDefault valueNullableCommentidinteger-1nextval('american_football_sacks_against_stats_id_seq'::regclass)Falsesacks_against_yardscharacter varying100Truesacks_against_totalcharacter varying100True IndexesName (scan, tup_read, tup_fetch)PrimaryUniqueClusteredSizeDefinitionamerican_football_sacks_against_stats_id_key (0, 0, 0)FalseTrueFalse16.0 KBbtree (id) Unique ConstraintsNameColumns Commentamerican_football_sacks_against_stats_id_keyid54Table - public > american_football_scoring_stats Table PropertiesPropertyValuePropertyValueTotal size96.0 KBOID24809Table size56.0 KBOwnerpostgresIndexes size32.0 KBTablespacepg_defaultToast size8.0 KBPrimary key(s)Estimated rows640Comment Table Statisticsseq_scan0n_dead_tup0seq_tup_read0last_vacuum-idx_scan0last_autocvacuum-idx_tup_fetch0last_analyze-n_tup_ins0last_autoanalyze-n_tup_upd0vacuum_count0n_tup_del0autovacuum_count0n_tup_hot_upd0analyze_count0n_live_tup0autoanalyze_count0 ColumnsNameTypeLengthDefault valueNullableCommentidinteger-1nextval('american_football_scoring_stats_id_seq'::regclass)Falsetouchdowns_totalcharacter varying100Truetouchdowns_passingcharacter varying100Truetouchdowns_rushingcharacter varying100Truetouchdowns_special_teamscharacter varying100Truetouchdowns_defensivecharacter varying100Trueextra_points_attemptscharacter varying100Trueextra_points_madecharacter varying100Trueextra_points_missedcharacter varying100Trueextra_points_blockedcharacter varying100Truefield_goal_attemptscharacter varying100Truefield_goals_madecharacter varying100True55 ColumnsNameTypeLengthDefault valueNullableCommentfield_goals_missedcharacter varying100Truefield_goals_blockedcharacter varying100Truesafeties_againstcharacter varying100Truetwo_point_conversions_attemptscharacter varying100Truetwo_point_conversions_madecharacter varying100Truetouchbacks_totalcharacter varying100True IndexesName (scan, tup_read, tup_fetch)PrimaryUniqueClusteredSizeDefinitionamerican_football_scoring_stats_id_key (0, 0, 0)FalseTrueFalse32.0 KBbtree (id) Unique ConstraintsNameColumns Commentamerican_football_scoring_stats_id_keyid56Table - public > american_football_special_teams_stats Table PropertiesPropertyValuePropertyValueTotal size32.0 KBOID24818Table size8.0 KBOwnerpostgresIndexes size16.0 KBTablespacepg_defaultToast size8.0 KBPrimary key(s)Estimated rows110Comment Table Statisticsseq_scan0n_dead_tup0seq_tup_read0last_vacuum-idx_scan0last_autocvacuum-idx_tup_fetch0last_analyze-n_tup_ins0last_autoanalyze-n_tup_upd0vacuum_count0n_tup_del0autovacuum_count0n_tup_hot_upd0analyze_count0n_live_tup0autoanalyze_count0 ColumnsNameTypeLengthDefault valueNullableCommentidinteger-1nextval('american_football_special_teams_stats_id_seq'::regclass)Falsereturns_punt_totalcharacter varying100Truereturns_punt_yardscharacter varying100Truereturns_punt_averagecharacter varying100Truereturns_punt_longestcharacter varying100Truereturns_punt_touchdowncharacter varying100Truereturns_kickoff_totalcharacter varying100Truereturns_kickoff_yardscharacter varying100Truereturns_kickoff_averagecharacter varying100Truereturns_kickoff_longestcharacter varying100Truereturns_kickoff_touchdowncharacter varying100Truereturns_totalcharacter varying100Truereturns_yardscharacter varying100True57 ColumnsNameTypeLengthDefault valueNullableCommentpunts_totalcharacter varying100Truepunts_yards_grosscharacter varying100Truepunts_yards_netcharacter varying100Truepunts_longestcharacter varying100Truepunts_inside_20character varying100Truepunts_inside_20_percentagecharacter varying100Truepunts_averagecharacter varying100Truepunts_blockedcharacter varying100Truetouchbacks_totalcharacter varying100Truetouchbacks_total_percentagecharacter varying100Truetouchbacks_kickoffscharacter varying100Truetouchbacks_kickoffs_percentagecharacter varying100Truetouchbacks_puntscharacter varying100Truetouchbacks_punts_percentagecharacter varying100Truetouchbacks_interceptionscharacter varying100Truetouchbacks_interceptions_percentagecharacter varying100Truefair_catchescharacter varying100True IndexesName (scan, tup_read, tup_fetch)PrimaryUniqueClusteredSizeDefinitionamerican_football_special_teams_stats_id_key (0, 0, 0)FalseTrueFalse16.0 KBbtree (id) Unique ConstraintsNameColumns Commentamerican_football_special_teams_stats_id_keyid58Table - public > attachments Table PropertiesPropertyValuePropertyValueTotal size73.883 MBOID178391Table size8.0 KBOwnerpostgresIndexes size0 bytesTablespacepg_defaultToast size73.875 MBPrimary key(s)Estimated rows0Comment Table Statisticsseq_scan0n_dead_tup0seq_tup_read0last_vacuum-idx_scan0last_autocvacuum-idx_tup_fetch0last_analyze-n_tup_ins0last_autoanalyze-n_tup_upd0vacuum_count0n_tup_del0autovacuum_count0n_tup_hot_upd0analyze_count0n_live_tup0autoanalyze_count0 ColumnsNameTypeLengthDefault valueNullableCommentidinteger-1nextval('attachments_id_seq'::regclass)Falsedatabytea-1True59Table - public > baseball_action_contact_details Table PropertiesPropertyValuePropertyValueTotal size16.0 KBOID24827Table size0 bytesOwnerpostgresIndexes size8.0 KBTablespacepg_defaultToast size8.0 KBPrimary key(s)Estimated rows0Comment Table Statisticsseq_scan0n_dead_tup0seq_tup_read0last_vacuum-idx_scan0last_autocvacuum-idx_tup_fetch0last_analyze-n_tup_ins0last_autoanalyze-n_tup_upd0vacuum_count0n_tup_del0autovacuum_count0n_tup_hot_upd0analyze_count0n_live_tup0autoanalyze_count0 ColumnsNameTypeLengthDefault valueNullableCommentidinteger-1nextval('baseball_action_contact_details_id_seq'::regclass)Falsebaseball_action_pitch_idinteger-1Falselocationcharacter varying100Truestrengthcharacter varying100Truevelocityinteger-1Truecommenttext-1Truetrajectory_coordinatescharacter varying100Truetrajectory_formulacharacter varying100True IndexesName (scan, tup_read, tup_fetch)PrimaryUniqueClusteredSizeDefinitionbaseball_action_contact_details_id_key (0, 0, 0)FalseTrueFalse8.0 KBbtree (id) Unique ConstraintsNameColumns Comment60 Unique ConstraintsNameColumns Commentbaseball_action_contact_details_id_keyid Foreign KeysNameKeys Reference tableReference keysfk_bas_act_con_det_bas_act_pit_id__bas_act_pit_idbaseball_action_pitch_idbaseball_action_pitchesid61Table - public > baseball_action_pitches Table PropertiesPropertyValuePropertyValueTotal size40.0 KBOID24836Table size0 bytesOwnerpostgresIndexes size32.0 KBTablespacepg_defaultToast size8.0 KBPrimary key(s)Estimated rows0Comment Table Statisticsseq_scan0n_dead_tup0seq_tup_read0last_vacuum-idx_scan0last_autocvacuum-idx_tup_fetch0last_analyze-n_tup_ins0last_autoanalyze-n_tup_upd0vacuum_count0n_tup_del0autovacuum_count0n_tup_hot_upd0analyze_count0n_live_tup0autoanalyze_count0 ColumnsNameTypeLengthDefault valueNullableCommentidinteger-1nextval('baseball_action_pitches_id_seq'::regclass)Falsebaseball_action_play_idinteger-1Falsesequence_numberinteger-1Truebaseball_defensive_group_idinteger-1Trueumpire_callcharacter varying100Truepitch_locationcharacter varying100Truepitch_typecharacter varying100Truepitch_velocityinteger-1Truecommenttext-1Truetrajectory_coordinatescharacter varying100Truetrajectory_formulacharacter varying100Trueball_typecharacter varying40Truestrike_typecharacter varying40True IndexesName (scan, tup_read, tup_fetch)PrimaryUniqueClusteredSizeDefinition62 IndexesName (scan, tup_read, tup_fetch)PrimaryUniqueClusteredSizeDefinition[Index."IndexName"] ([Index."StatIdx_Scan"], [Index."StatIdx_Tup_Read"], [Index."StatIdx_Tup_Fetch"])FalseTrueFalse8.0 KBbtree (id)idx_fk_bas_act_pit_bas_def_gro_id__bas_def_gro_id (0, 0, 0)FalseFalseFalse8.0 KBbtree (baseball_defensive_group_id)idx_baseball_action_pitches_2 (0, 0, 0)FalseFalseFalse8.0 KBbtree (pitch_type)idx_baseball_action_pitches_1 (0, 0, 0)FalseFalseFalse8.0 KBbtree (umpire_call) Unique ConstraintsNameColumns Commentbaseball_action_pitches_id_keyid Foreign KeysNameKeys Reference tableReference keysfk_baseball_action_plays_baseball_action_pitchesbaseball_action_play_idbaseball_action_playsidfk_bas_act_pit_bas_def_gro_id__bas_def_gro_idbaseball_defensive_group_idbaseball_defensive_groupid63Table - public > baseball_action_plays Table PropertiesPropertyValuePropertyValueTotal size64.0 KBOID24845Table size8.0 KBOwnerpostgresIndexes size48.0 KBTablespacepg_defaultToast size8.0 KBPrimary key(s)Estimated rows17Comment Table Statisticsseq_scan0n_dead_tup0seq_tup_read0last_vacuum-idx_scan0last_autocvacuum-idx_tup_fetch0last_analyze-n_tup_ins0last_autoanalyze-n_tup_upd0vacuum_count0n_tup_del0autovacuum_count0n_tup_hot_upd0analyze_count0n_live_tup0autoanalyze_count0 ColumnsNameTypeLengthDefault valueNullableCommentidinteger-1nextval('baseball_action_plays_id_seq'::regclass)Falsebaseball_event_state_idinteger-1Falseplay_typecharacter varying100Truenotationcharacter varying100Truenotation_yamltext-1Truebaseball_defensive_group_idinteger-1Truecommentcharacter varying255Truerunner_on_first_advanceinteger-1Truerunner_on_second_advanceinteger-1Truerunner_on_third_advanceinteger-1Trueouts_recordedinteger-1Truerbiinteger-1Trueruns_scoredinteger-1Trueearned_runs_scoredcharacter varying100True64 IndexesName (scan, tup_read, tup_fetch)PrimaryUniqueClusteredSizeDefinitionidx_baseball_action_plays_1 (0, 0, 0)FalseFalseFalse16.0 KBbtree (play_type)idx_fk_bas_act_pla_bas_eve_sta_id__bas_eve_sta_id (0, 0, 0)FalseFalseFalse16.0 KBbtree (baseball_event_state_id)baseball_action_plays_id_key (0, 0, 0)FalseTrueFalse16.0 KBbtree (id) Unique ConstraintsNameColumns Commentbaseball_action_plays_id_keyid Foreign KeysNameKeys Reference tableReference keysfk_bas_act_pla_bas_eve_sta_id__bas_eve_sta_idbaseball_event_state_idbaseball_event_statesid65Table - public > baseball_action_substitutions Table PropertiesPropertyValuePropertyValueTotal size8.0 KBOID24854Table size0 bytesOwnerpostgresIndexes size8.0 KBTablespacepg_defaultToast size0 bytesPrimary key(s)Estimated rows0Comment Table Statisticsseq_scan0n_dead_tup0seq_tup_read0last_vacuum-idx_scan0last_autocvacuum-idx_tup_fetch0last_analyze-n_tup_ins0last_autoanalyze-n_tup_upd0vacuum_count0n_tup_del0autovacuum_count0n_tup_hot_upd0analyze_count0n_live_tup0autoanalyze_count0 ColumnsNameTypeLengthDefault valueNullableCommentidinteger-1nextval('baseball_action_substitutions_id_seq'::regclass)Falsebaseball_event_state_idinteger-1Falsesequence_numberinteger-1Trueperson_typecharacter varying100Trueperson_original_idinteger-1Trueperson_original_position_idinteger-1Trueperson_original_lineup_slotinteger-1Trueperson_replacing_idinteger-1Trueperson_replacing_position_idinteger-1Trueperson_replacing_lineup_slotinteger-1Truesubstitution_reasoncharacter varying100Truecommentcharacter varying100True66 IndexesName (scan, tup_read, tup_fetch)PrimaryUniqueClusteredSizeDefinitionbaseball_action_substitutions_id_key (0, 0, 0)FalseTrueFalse8.0 KBbtree (id) Unique ConstraintsNameColumns Commentbaseball_action_substitutions_id_keyid Foreign KeysNameKeys Reference tableReference keysfk_bas_act_sub_per_rep_id__per_idperson_replacing_idpersonsidfk_bas_act_sub_per_rep_pos_id__pos_idperson_replacing_position_idpositionsidfk_bas_act_sub_per_ori_pos_id__pos_idperson_original_position_idpositionsidfk_bas_act_sub_per_ori_id__per_idperson_original_idpersonsidfk_bas_act_sub_bas_eve_sta_id__bas_eve_sta_idbaseball_event_state_idbaseball_event_statesid67Table - public > baseball_defensive_group Table PropertiesPropertyValuePropertyValueTotal size8.0 KBOID24860Table size0 bytesOwnerpostgresIndexes size8.0 KBTablespacepg_defaultToast size0 bytesPrimary key(s)Estimated rows0Comment Table Statisticsseq_scan0n_dead_tup0seq_tup_read0last_vacuum-idx_scan0last_autocvacuum-idx_tup_fetch0last_analyze-n_tup_ins0last_autoanalyze-n_tup_upd0vacuum_count0n_tup_del0autovacuum_count0n_tup_hot_upd0analyze_count0n_live_tup0autoanalyze_count0 ColumnsNameTypeLengthDefault valueNullableCommentidinteger-1nextval('baseball_defensive_group_id_seq'::regclass)False IndexesName (scan, tup_read, tup_fetch)PrimaryUniqueClusteredSizeDefinitionbaseball_defensive_group_id_key (0, 0, 0)FalseTrueFalse8.0 KBbtree (id) Unique ConstraintsNameColumns Commentbaseball_defensive_group_id_keyid68Table - public > baseball_defensive_players Table PropertiesPropertyValuePropertyValueTotal size8.0 KBOID24866Table size0 bytesOwnerpostgresIndexes size8.0 KBTablespacepg_defaultToast size0 bytesPrimary key(s)Estimated rows0Comment Table Statisticsseq_scan0n_dead_tup0seq_tup_read0last_vacuum-idx_scan0last_autocvacuum-idx_tup_fetch0last_analyze-n_tup_ins0last_autoanalyze-n_tup_upd0vacuum_count0n_tup_del0autovacuum_count0n_tup_hot_upd0analyze_count0n_live_tup0autoanalyze_count0 ColumnsNameTypeLengthDefault valueNullableCommentidinteger-1nextval('baseball_defensive_players_id_seq'::regclass)Falsebaseball_defensive_group_idinteger-1Falseplayer_idinteger-1Falseposition_idinteger-1False IndexesName (scan, tup_read, tup_fetch)PrimaryUniqueClusteredSizeDefinitionbaseball_defensive_players_id_key (0, 0, 0)FalseTrueFalse8.0 KBbtree (id) Unique ConstraintsNameColumns Commentbaseball_defensive_players_id_keyid Foreign KeysNameKeys Reference tableReference keys69 Foreign KeysNameKeys Reference tableReference keysfk_bas_def_pla_bas_def_gro_id__bas_def_gro_idbaseball_defensive_group_idbaseball_defensive_groupidfk_bas_def_pla_pla_id__per_idplayer_idpersonsidfk_bas_def_pla_pos_id__pos_idposition_idpositionsid70Table - public > baseball_defensive_stats Table PropertiesPropertyValuePropertyValueTotal size160.0 KBOID24872Table size96.0 KBOwnerpostgresIndexes size56.0 KBTablespacepg_defaultToast size8.0 KBPrimary key(s)Estimated rows1528Comment Table Statisticsseq_scan0n_dead_tup0seq_tup_read0last_vacuum-idx_scan0last_autocvacuum-idx_tup_fetch0last_analyze-n_tup_ins0last_autoanalyze-n_tup_upd0vacuum_count0n_tup_del0autovacuum_count0n_tup_hot_upd0analyze_count0n_live_tup0autoanalyze_count0 ColumnsNameTypeLengthDefault valueNullableCommentidinteger-1nextval('baseball_defensive_stats_id_seq'::regclass)Falsedouble_playsinteger-1Truetriple_playsinteger-1Trueputoutsinteger-1Trueassistsinteger-1Trueerrorsinteger-1Truefielding_percentagenumeric-1Truedefensive_averagenumeric-1Trueerrors_passed_ballinteger-1Trueerrors_catchers_interferenceinteger-1True IndexesName (scan, tup_read, tup_fetch)PrimaryUniqueClusteredSizeDefinitionbaseball_defensive_stats_id_key (0, 0, 0)FalseTrueFalse56.0 KBbtree (id)71 Unique ConstraintsNameColumns Commentbaseball_defensive_stats_id_keyid72Table - public > baseball_event_states Table PropertiesPropertyValuePropertyValueTotal size56.0 KBOID24881Table size8.0 KBOwnerpostgresIndexes size48.0 KBTablespacepg_defaultToast size0 bytesPrimary key(s)Estimated rows17Comment Table Statisticsseq_scan0n_dead_tup0seq_tup_read0last_vacuum-idx_scan0last_autocvacuum-idx_tup_fetch0last_analyze-n_tup_ins0last_autoanalyze-n_tup_upd0vacuum_count0n_tup_del0autovacuum_count0n_tup_hot_upd0analyze_count0n_live_tup0autoanalyze_count0 ColumnsNameTypeLengthDefault valueNullableCommentidinteger-1nextval('baseball_event_states_id_seq'::regclass)Falseevent_idinteger-1Falsecurrent_statesmallint-1Truesequence_numberinteger-1Trueat_bat_numberinteger-1Trueinning_valueinteger-1Trueinning_halfcharacter varying100Trueoutsinteger-1Trueballsinteger-1Truestrikesinteger-1Truerunner_on_first_idinteger-1Truerunner_on_second_idinteger-1Truerunner_on_third_idinteger-1Truerunner_on_firstsmallint-1Truerunner_on_secondsmallint-1Truerunner_on_thirdsmallint-1Trueruns_this_inning_halfinteger-1True73 ColumnsNameTypeLengthDefault valueNullableCommentpitcher_idinteger-1Truebatter_idinteger-1Truebatter_sidecharacter varying100Truecontextcharacter varying40True IndexesName (scan, tup_read, tup_fetch)PrimaryUniqueClusteredSizeDefinitionidx_baseball_event_states_1 (0, 0, 0)FalseFalseFalse16.0 KBbtree (current_state)idx_fk_bas_eve_sta_eve_id__eve_id (0, 0, 0)FalseFalseFalse16.0 KBbtree (event_id)baseball_event_states_id_key (0, 0, 0)FalseTrueFalse16.0 KBbtree (id) Unique ConstraintsNameColumns Commentbaseball_event_states_id_keyid Foreign KeysNameKeys Reference tableReference keysfk_bas_eve_sta_run_on_fir_id__per_idrunner_on_first_idpersonsidfk_bas_eve_sta_bat_id__per_idbatter_idpersonsidfk_bas_eve_sta_run_on_thi_id__per_idrunner_on_third_idpersonsidfk_bas_eve_sta_run_on_sec_id__per_idrunner_on_second_idpersonsidfk_bas_eve_sta_eve_id__eve_idevent_ideventsidfk_bas_eve_sta_pit_id__per_idpitcher_idpersonsid74Table - public > baseball_offensive_stats Table PropertiesPropertyValuePropertyValueTotal size256.0 KBOID24887Table size192.0 KBOwnerpostgresIndexes size56.0 KBTablespacepg_defaultToast size8.0 KBPrimary key(s)Estimated rows1528Comment Table Statisticsseq_scan0n_dead_tup0seq_tup_read0last_vacuum-idx_scan0last_autocvacuum-idx_tup_fetch0last_analyze-n_tup_ins0last_autoanalyze-n_tup_upd0vacuum_count0n_tup_del0autovacuum_count0n_tup_hot_upd0analyze_count0n_live_tup0autoanalyze_count0 ColumnsNameTypeLengthDefault valueNullableCommentidinteger-1nextval('baseball_offensive_stats_id_seq'::regclass)Falseaveragenumeric-1Trueruns_scoredinteger-1Trueat_batsinteger-1Truehitsinteger-1Truerbiinteger-1Truetotal_basesinteger-1Trueslugging_percentagenumeric-1Truebases_on_ballsinteger-1Truestrikeoutsinteger-1Trueleft_on_baseinteger-1Trueleft_in_scoring_positioninteger-1Truesinglesinteger-1Truedoublesinteger-1Truetriplesinteger-1Truehome_runsinteger-1Truegrand_slamsinteger-1Trueat_bats_per_rbinumeric-1Trueplate_appearances_per_rbinumeric-1True75 ColumnsNameTypeLengthDefault valueNullableCommentat_bats_per_home_runnumeric-1Trueplate_appearances_per_home_runnumeric-1Truesac_fliesinteger-1Truesac_buntsinteger-1Truegrounded_into_double_playinteger-1Truemoved_upinteger-1Trueon_base_percentagenumeric-1Truestolen_basesinteger-1Truestolen_bases_caughtinteger-1Truestolen_bases_averagenumeric-1Truehit_by_pitchinteger-1Truedefensive_interferance_reachesinteger-1Trueon_base_plus_sluggingnumeric-1Trueplate_appearancesinteger-1Truehits_extra_baseinteger-1True IndexesName (scan, tup_read, tup_fetch)PrimaryUniqueClusteredSizeDefinitionbaseball_offensive_stats_id_key (0, 0, 0)FalseTrueFalse56.0 KBbtree (id) Unique ConstraintsNameColumns Commentbaseball_offensive_stats_id_keyid76Table - public > baseball_pitching_stats Table PropertiesPropertyValuePropertyValueTotal size160.0 KBOID24896Table size112.0 KBOwnerpostgresIndexes size40.0 KBTablespacepg_defaultToast size8.0 KBPrimary key(s)Estimated rows752Comment Table Statisticsseq_scan0n_dead_tup0seq_tup_read0last_vacuum-idx_scan0last_autocvacuum-idx_tup_fetch0last_analyze-n_tup_ins0last_autoanalyze-n_tup_upd0vacuum_count0n_tup_del0autovacuum_count0n_tup_hot_upd0analyze_count0n_live_tup0autoanalyze_count0 ColumnsNameTypeLengthDefault valueNullableCommentidinteger-1nextval('baseball_pitching_stats_id_seq'::regclass)Falseruns_allowedinteger-1Truesingles_allowedinteger-1Truedoubles_allowedinteger-1Truetriples_allowedinteger-1Truehome_runs_allowedinteger-1Trueinnings_pitchedcharacter varying20Truehitsinteger-1Trueearned_runsinteger-1Trueunearned_runsinteger-1Truebases_on_ballsinteger-1Truebases_on_balls_intentionalinteger-1Truestrikeoutsinteger-1Truestrikeout_to_bb_rationumeric-1Truenumber_of_pitchesinteger-1Trueeranumeric-1Trueinherited_runners_scoredinteger-1True77 ColumnsNameTypeLengthDefault valueNullableCommentpick_offsinteger-1Trueerrors_hit_with_pitchinteger-1Trueerrors_wild_pitchinteger-1Truebalksinteger-1Truewinsinteger-1Truelossesinteger-1Truesavesinteger-1Trueshutoutsinteger-1Truegames_completeinteger-1Truegames_finishedinteger-1Truewinning_percentagenumeric-1Trueevent_creditcharacter varying40Truesave_creditcharacter varying40True IndexesName (scan, tup_read, tup_fetch)PrimaryUniqueClusteredSizeDefinitionbaseball_pitching_stats_id_key (0, 0, 0)FalseTrueFalse40.0 KBbtree (id) Unique ConstraintsNameColumns Commentbaseball_pitching_stats_id_keyid78Table - public > basketball_defensive_stats Table PropertiesPropertyValuePropertyValueTotal size24.0 KBOID24905Table size8.0 KBOwnerpostgresIndexes size16.0 KBTablespacepg_defaultToast size0 bytesPrimary key(s)Estimated rows128Comment Table Statisticsseq_scan0n_dead_tup0seq_tup_read0last_vacuum-idx_scan0last_autocvacuum-idx_tup_fetch0last_analyze-n_tup_ins0last_autoanalyze-n_tup_upd0vacuum_count0n_tup_del0autovacuum_count0n_tup_hot_upd0analyze_count0n_live_tup0autoanalyze_count0 ColumnsNameTypeLengthDefault valueNullableCommentidinteger-1nextval('basketball_defensive_stats_id_seq'::regclass)Falsesteals_totalcharacter varying100Truesteals_per_gamecharacter varying100Trueblocks_totalcharacter varying100Trueblocks_per_gamecharacter varying100True IndexesName (scan, tup_read, tup_fetch)PrimaryUniqueClusteredSizeDefinitionbasketball_defensive_stats_id_key (0, 0, 0)FalseTrueFalse16.0 KBbtree (id) Unique ConstraintsNameColumns Commentbasketball_defensive_stats_id_keyid79Table - public > basketball_event_states Table PropertiesPropertyValuePropertyValueTotal size16.0 KBOID24911Table size0 bytesOwnerpostgresIndexes size16.0 KBTablespacepg_defaultToast size0 bytesPrimary key(s)Estimated rows0Comment Table Statisticsseq_scan0n_dead_tup0seq_tup_read0last_vacuum-idx_scan0last_autocvacuum-idx_tup_fetch0last_analyze-n_tup_ins0last_autoanalyze-n_tup_upd0vacuum_count0n_tup_del0autovacuum_count0n_tup_hot_upd0analyze_count0n_live_tup0autoanalyze_count0 ColumnsNameTypeLengthDefault valueNullableCommentidinteger-1nextval('basketball_event_states_id_seq'::regclass)Falseevent_idinteger-1Falsecurrent_stateinteger-1Truesequence_numberinteger-1Trueperiod_valuecharacter varying100Trueperiod_time_elapsedcharacter varying100Trueperiod_time_remainingcharacter varying100Truecontextcharacter varying40True IndexesName (scan, tup_read, tup_fetch)PrimaryUniqueClusteredSizeDefinitionidx_fk_events_basketball_event_states (0, 0, 0)FalseFalseFalse8.0 KBbtree (event_id)basketball_event_states_id_key (0, 0, 0)FalseTrueFalse8.0 KBbtree (id)80 Unique ConstraintsNameColumns Commentbasketball_event_states_id_keyid Foreign KeysNameKeys Reference tableReference keysfk_bask_eve_sta_eve_id__eve_idevent_ideventsid81Table - public > basketball_offensive_stats Table PropertiesPropertyValuePropertyValueTotal size64.0 KBOID24917Table size40.0 KBOwnerpostgresIndexes size16.0 KBTablespacepg_defaultToast size8.0 KBPrimary key(s)Estimated rows128Comment Table Statisticsseq_scan0n_dead_tup0seq_tup_read0last_vacuum-idx_scan0last_autocvacuum-idx_tup_fetch0last_analyze-n_tup_ins0last_autoanalyze-n_tup_upd0vacuum_count0n_tup_del0autovacuum_count0n_tup_hot_upd0analyze_count0n_live_tup0autoanalyze_count0 ColumnsNameTypeLengthDefault valueNullableCommentidinteger-1nextval('basketball_offensive_stats_id_seq'::regclass)Falsefield_goals_madeinteger-1Truefield_goals_attemptedinteger-1Truefield_goals_percentagecharacter varying100Truefield_goals_per_gamecharacter varying100Truefield_goals_attempted_per_gamecharacter varying100Truefield_goals_percentage_adjustedcharacter varying100Truethree_pointers_madeinteger-1Truethree_pointers_attemptedinteger-1Truethree_pointers_percentagecharacter varying100Truethree_pointers_per_gamecharacter varying100True82 ColumnsNameTypeLengthDefault valueNullableCommentthree_pointers_attempted_per_gamecharacter varying100Truefree_throws_madecharacter varying100Truefree_throws_attemptedcharacter varying100Truefree_throws_percentagecharacter varying100Truefree_throws_per_gamecharacter varying100Truefree_throws_attempted_per_gamecharacter varying100Truepoints_scored_totalcharacter varying100Truepoints_scored_per_gamecharacter varying100Trueassists_totalcharacter varying100Trueassists_per_gamecharacter varying100Trueturnovers_totalcharacter varying100Trueturnovers_per_gamecharacter varying100Truepoints_scored_off_turnoverscharacter varying100Truepoints_scored_in_paintcharacter varying100Truepoints_scored_on_second_chancecharacter varying100Truepoints_scored_on_fast_breakcharacter varying100True IndexesName (scan, tup_read, tup_fetch)PrimaryUniqueClusteredSizeDefinitionbasketball_offensive_stats_id_key (0, 0, 0)FalseTrueFalse16.0 KBbtree (id) Unique ConstraintsNameColumns Commentbasketball_offensive_stats_id_keyid83Table - public > basketball_rebounding_stats Table PropertiesPropertyValuePropertyValueTotal size32.0 KBOID24926Table size8.0 KBOwnerpostgresIndexes size16.0 KBTablespacepg_defaultToast size8.0 KBPrimary key(s)Estimated rows128Comment Table Statisticsseq_scan0n_dead_tup0seq_tup_read0last_vacuum-idx_scan0last_autocvacuum-idx_tup_fetch0last_analyze-n_tup_ins0last_autoanalyze-n_tup_upd0vacuum_count0n_tup_del0autovacuum_count0n_tup_hot_upd0analyze_count0n_live_tup0autoanalyze_count0 ColumnsNameTypeLengthDefault valueNullableCommentidinteger-1nextval('basketball_rebounding_stats_id_seq'::regclass)Falserebounds_totalcharacter varying100Truerebounds_per_gamecharacter varying100Truerebounds_defensivecharacter varying100Truerebounds_offensivecharacter varying100Trueteam_rebounds_totalcharacter varying100Trueteam_rebounds_per_gamecharacter varying100Trueteam_rebounds_defensivecharacter varying100Trueteam_rebounds_offensivecharacter varying100True IndexesName (scan, tup_read, tup_fetch)PrimaryUniqueClusteredSizeDefinitionbasketball_rebounding_stats_id_key (0, 0, 0)FalseTrueFalse16.0 KBbtree (id)84 IndexesName (scan, tup_read, tup_fetch)PrimaryUniqueClusteredSizeDefinition Unique ConstraintsNameColumns Commentbasketball_rebounding_stats_id_keyid85Table - public > basketball_team_stats Table PropertiesPropertyValuePropertyValueTotal size8.0 KBOID24935Table size0 bytesOwnerpostgresIndexes size8.0 KBTablespacepg_defaultToast size0 bytesPrimary key(s)Estimated rows0Comment Table Statisticsseq_scan0n_dead_tup0seq_tup_read0last_vacuum-idx_scan0last_autocvacuum-idx_tup_fetch0last_analyze-n_tup_ins0last_autoanalyze-n_tup_upd0vacuum_count0n_tup_del0autovacuum_count0n_tup_hot_upd0analyze_count0n_live_tup0autoanalyze_count0 ColumnsNameTypeLengthDefault valueNullableCommentidinteger-1nextval('basketball_team_stats_id_seq'::regclass)Falsetimeouts_leftcharacter varying100Truelargest_leadcharacter varying100Truefouls_totalcharacter varying100Trueturnover_margincharacter varying100True IndexesName (scan, tup_read, tup_fetch)PrimaryUniqueClusteredSizeDefinitionbasketball_team_stats_id_key (0, 0, 0)FalseTrueFalse8.0 KBbtree (id) Unique ConstraintsNameColumns Commentbasketball_team_stats_id_keyid86Table - public > bookmakers Table PropertiesPropertyValuePropertyValueTotal size8.0 KBOID24941Table size0 bytesOwnerpostgresIndexes size8.0 KBTablespacepg_defaultToast size0 bytesPrimary key(s)Estimated rows0Comment Table Statisticsseq_scan0n_dead_tup0seq_tup_read0last_vacuum-idx_scan0last_autocvacuum-idx_tup_fetch0last_analyze-n_tup_ins0last_autoanalyze-n_tup_upd0vacuum_count0n_tup_del0autovacuum_count0n_tup_hot_upd0analyze_count0n_live_tup0autoanalyze_count0 ColumnsNameTypeLengthDefault valueNullableCommentidinteger-1nextval('bookmakers_id_seq'::regclass)Falsebookmaker_keycharacter varying100Truepublisher_idinteger-1Falselocation_idinteger-1True IndexesName (scan, tup_read, tup_fetch)PrimaryUniqueClusteredSizeDefinitionbookmakers_id_key (0, 0, 0)FalseTrueFalse8.0 KBbtree (id) Unique ConstraintsNameColumns Commentbookmakers_id_keyid Foreign KeysNameKeys Reference tableReference keysfk_boo_pub_id__pub_idpublisher_idpublishersidfk_boo_loc_id__loc_idlocation_idlocationsid87 Foreign KeysNameKeys Reference tableReference keys88Table - public > core_person_stats Table PropertiesPropertyValuePropertyValueTotal size144.0 KBOID24947Table size88.0 KBOwnerpostgresIndexes size56.0 KBTablespacepg_defaultToast size0 bytesPrimary key(s)Estimated rows1582Comment Table Statisticsseq_scan0n_dead_tup0seq_tup_read0last_vacuum-idx_scan0last_autocvacuum-idx_tup_fetch0last_analyze-n_tup_ins0last_autoanalyze-n_tup_upd0vacuum_count0n_tup_del0autovacuum_count0n_tup_hot_upd0analyze_count0n_live_tup0autoanalyze_count0 ColumnsNameTypeLengthDefault valueNullableCommentidinteger-1nextval('core_person_stats_id_seq'::regclass)Falsetime_played_eventcharacter varying40Truetime_played_totalcharacter varying40Truetime_played_event_averagecharacter varying40Trueevents_playedinteger-1Trueevents_startedinteger-1Trueposition_idinteger-1True IndexesName (scan, tup_read, tup_fetch)PrimaryUniqueClusteredSizeDefinitioncore_person_stats_id_key (0, 0, 0)FalseTrueFalse56.0 KBbtree (id) Unique ConstraintsNameColumns Commentcore_person_stats_id_keyid89 Foreign KeysNameKeys Reference tableReference keysfk_cor_per_sta_pos_id__pos_idposition_idpositionsid90Table - public > core_stats Table PropertiesPropertyValuePropertyValueTotal size16.0 KBOID24953Table size0 bytesOwnerpostgresIndexes size8.0 KBTablespacepg_defaultToast size8.0 KBPrimary key(s)Estimated rows0Comment Table Statisticsseq_scan0n_dead_tup0seq_tup_read0last_vacuum-idx_scan0last_autocvacuum-idx_tup_fetch0last_analyze-n_tup_ins0last_autoanalyze-n_tup_upd0vacuum_count0n_tup_del0autovacuum_count0n_tup_hot_upd0analyze_count0n_live_tup0autoanalyze_count0 ColumnsNameTypeLengthDefault valueNullableCommentidinteger-1nextval('core_stats_id_seq'::regclass)Falsescorecharacter varying100Truescore_opposingcharacter varying100Truescore_attemptscharacter varying100Truescore_attempts_opposingcharacter varying100Truescore_percentagecharacter varying100Truescore_percentage_opposingcharacter varying100True IndexesName (scan, tup_read, tup_fetch)PrimaryUniqueClusteredSizeDefinitioncore_stats_id_key (0, 0, 0)FalseTrueFalse8.0 KBbtree (id) Unique ConstraintsNameColumns Commentcore_stats_id_keyid91Table - public > db_info Table PropertiesPropertyValuePropertyValueTotal size8.0 KBOID24960Table size0 bytesOwnerpostgresIndexes size8.0 KBTablespacepg_defaultToast size0 bytesPrimary key(s)Estimated rows0Comment Table Statisticsseq_scan0n_dead_tup0seq_tup_read0last_vacuum-idx_scan0last_autocvacuum-idx_tup_fetch0last_analyze-n_tup_ins0last_autoanalyze-n_tup_upd0vacuum_count0n_tup_del0autovacuum_count0n_tup_hot_upd0analyze_count0n_live_tup0autoanalyze_count0 ColumnsNameTypeLengthDefault valueNullableCommentversioncharacter varying10016False IndexesName (scan, tup_read, tup_fetch)PrimaryUniqueClusteredSizeDefinitionidx_db_info_1 (0, 0, 0)FalseFalseFalse8.0 KBbtree (version)92Table - public > display_names Table PropertiesPropertyValuePropertyValueTotal size488.0 KBOID24966Table size376.0 KBOwnerpostgresIndexes size104.0 KBTablespacepg_defaultToast size8.0 KBPrimary key(s)Estimated rows3958Comment Table Statisticsseq_scan0n_dead_tup0seq_tup_read0last_vacuum-idx_scan0last_autocvacuum-idx_tup_fetch0last_analyze-n_tup_ins0last_autoanalyze-n_tup_upd0vacuum_count0n_tup_del0autovacuum_count0n_tup_hot_upd0analyze_count0n_live_tup0autoanalyze_count0 ColumnsNameTypeLengthDefault valueNullableCommentidinteger-1nextval('display_names_id_seq'::regclass)Falselanguagecharacter varying100Falseentity_typecharacter varying100Falseentity_idinteger-1Falsefull_namecharacter varying100Truefirst_namecharacter varying100Truemiddle_namecharacter varying100Truelast_namecharacter varying100Truealiascharacter varying100Trueabbreviationcharacter varying100Trueshort_namecharacter varying100Trueprefixcharacter varying20Truesuffixcharacter varying20True IndexesName (scan, tup_read, tup_fetch)PrimaryUniqueClusteredSizeDefinitiondisplay_names_id_key (0, 0, 0)FalseTrueFalse104.0 KBbtree (id)93 Unique ConstraintsNameColumns Commentdisplay_names_id_keyid94Table - public > document_classes Table PropertiesPropertyValuePropertyValueTotal size40.0 KBOID24975Table size8.0 KBOwnerpostgresIndexes size32.0 KBTablespacepg_defaultToast size0 bytesPrimary key(s)Estimated rows6Comment Table Statisticsseq_scan0n_dead_tup0seq_tup_read0last_vacuum-idx_scan0last_autocvacuum-idx_tup_fetch0last_analyze-n_tup_ins0last_autoanalyze-n_tup_upd0vacuum_count0n_tup_del0autovacuum_count0n_tup_hot_upd0analyze_count0n_live_tup0autoanalyze_count0 ColumnsNameTypeLengthDefault valueNullableCommentidinteger-1nextval('document_classes_id_seq'::regclass)Falsenamecharacter varying100True IndexesName (scan, tup_read, tup_fetch)PrimaryUniqueClusteredSizeDefinitionidx_document_classes_1 (0, 0, 0)FalseFalseFalse16.0 KBbtree (name)document_classes_id_key (0, 0, 0)FalseTrueFalse16.0 KBbtree (id) Unique ConstraintsNameColumns Commentdocument_classes_id_keyid95Table - public > document_contents Table PropertiesPropertyValuePropertyValueTotal size136.0 KBOID24981Table size64.0 KBOwnerpostgresIndexes size64.0 KBTablespacepg_defaultToast size8.0 KBPrimary key(s)Estimated rows414Comment Table Statisticsseq_scan0n_dead_tup0seq_tup_read0last_vacuum-idx_scan0last_autocvacuum-idx_tup_fetch0last_analyze-n_tup_ins0last_autoanalyze-n_tup_upd0vacuum_count0n_tup_del0autovacuum_count0n_tup_hot_upd0analyze_count0n_live_tup0autoanalyze_count0 ColumnsNameTypeLengthDefault valueNullableCommentidinteger-1nextval('document_contents_id_seq'::regclass)Falsedocument_idinteger-1Falsesportsmlcharacter varying200Trueabstracttext-1True IndexesName (scan, tup_read, tup_fetch)PrimaryUniqueClusteredSizeDefinitionidx_fk_doc_con_doc_id__doc_id (0, 0, 0)FalseFalseFalse32.0 KBbtree (document_id)document_contents_id_key (0, 0, 0)FalseTrueFalse32.0 KBbtree (id) Unique ConstraintsNameColumns Commentdocument_contents_id_keyid Foreign KeysNameKeys Reference tableReference keys96 Foreign KeysNameKeys Reference tableReference keysfk_doc_con_doc_id__doc_iddocument_iddocumentsid97Table - public > document_fixtures Table PropertiesPropertyValuePropertyValueTotal size72.0 KBOID24990Table size8.0 KBOwnerpostgresIndexes size64.0 KBTablespacepg_defaultToast size0 bytesPrimary key(s)Estimated rows12Comment Table Statisticsseq_scan0n_dead_tup0seq_tup_read0last_vacuum-idx_scan0last_autocvacuum-idx_tup_fetch0last_analyze-n_tup_ins0last_autoanalyze-n_tup_upd0vacuum_count0n_tup_del0autovacuum_count0n_tup_hot_upd0analyze_count0n_live_tup0autoanalyze_count0 ColumnsNameTypeLengthDefault valueNullableCommentidinteger-1nextval('document_fixtures_id_seq'::regclass)Falsefixture_keycharacter varying100Truepublisher_idinteger-1Falsenamecharacter varying100Truedocument_class_idinteger-1False IndexesName (scan, tup_read, tup_fetch)PrimaryUniqueClusteredSizeDefinitionidx_fk_doc_fix_doc_cla_id__doc_cla_id (0, 0, 0)FalseFalseFalse16.0 KBbtree (document_class_id)idx_fk_doc_fix_pub_id__pub_id (0, 0, 0)FalseFalseFalse16.0 KBbtree (publisher_id)idx_document_fixtures_1 (0, 0, 0)FalseFalseFalse16.0 KBbtree (fixture_key)document_fixtures_id_key (0, 0, 0)FalseTrueFalse16.0 KBbtree (id) Unique ConstraintsNameColumns Commentdocument_fixtures_id_keyid98 Unique ConstraintsNameColumns Comment Foreign KeysNameKeys Reference tableReference keysfk_doc_fix_doc_cla_id__doc_cla_iddocument_class_iddocument_classesidfk_doc_fix_pub_id__pub_idpublisher_idpublishersid99Table - public > document_fixtures_events Table PropertiesPropertyValuePropertyValueTotal size736.0 KBOID24996Table size256.0 KBOwnerpostgresIndexes size480.0 KBTablespacepg_defaultToast size0 bytesPrimary key(s)Estimated rows4428Comment Table Statisticsseq_scan0n_dead_tup0seq_tup_read0last_vacuum-idx_scan0last_autocvacuum-idx_tup_fetch0last_analyze-n_tup_ins0last_autoanalyze-n_tup_upd0vacuum_count0n_tup_del0autovacuum_count0n_tup_hot_upd0analyze_count0n_live_tup0autoanalyze_count0 ColumnsNameTypeLengthDefault valueNullableCommentidinteger-1nextval('document_fixtures_events_id_seq'::regclass)Falsedocument_fixture_idinteger-1Falseevent_idinteger-1Falselatest_document_idinteger-1Falselast_updatetimestamp without time zone-1True IndexesName (scan, tup_read, tup_fetch)PrimaryUniqueClusteredSizeDefinitionidx_fk_doc_fix_eve_doc_fix_id__doc_fix_id (0, 0, 0)FalseFalseFalse120.0 KBbtree (document_fixture_id)idx_fk_doc_fix_eve_eve_id__eve_id (0, 0, 0)FalseFalseFalse120.0 KBbtree (event_id)document_fixtures_events_id_key (0, 0, 0)FalseTrueFalse120.0 KBbtree (id)idx_fk_doc_fix_eve_lat_doc_id__doc_id (0, 0, 0)FalseFalseFalse120.0 KBbtree (latest_document_id)100 Unique ConstraintsNameColumns Commentdocument_fixtures_events_id_keyid Foreign KeysNameKeys Reference tableReference keysfk_doc_fix_eve_lat_doc_id__doc_idlatest_document_iddocumentsidfk_doc_fix_eve_doc_fix_id__doc_fix_iddocument_fixture_iddocument_fixturesidfk_doc_fix_eve_eve_id__eve_idevent_ideventsid101Table - public > document_package_entry Table PropertiesPropertyValuePropertyValueTotal size8.0 KBOID25002Table size0 bytesOwnerpostgresIndexes size8.0 KBTablespacepg_defaultToast size0 bytesPrimary key(s)Estimated rows0Comment Table Statisticsseq_scan0n_dead_tup0seq_tup_read0last_vacuum-idx_scan0last_autocvacuum-idx_tup_fetch0last_analyze-n_tup_ins0last_autoanalyze-n_tup_upd0vacuum_count0n_tup_del0autovacuum_count0n_tup_hot_upd0analyze_count0n_live_tup0autoanalyze_count0 ColumnsNameTypeLengthDefault valueNullableCommentidinteger-1nextval('document_package_entry_id_seq'::regclass)Falsedocument_package_idinteger-1Falserankcharacter varying100Truedocument_idinteger-1Falseheadlinecharacter varying100Trueshort_headlinecharacter varying100True IndexesName (scan, tup_read, tup_fetch)PrimaryUniqueClusteredSizeDefinitiondocument_package_entry_id_key (0, 0, 0)FalseTrueFalse8.0 KBbtree (id) Unique ConstraintsNameColumns Commentdocument_package_entry_id_keyid102 Foreign KeysNameKeys Reference tableReference keysfk_doc_pac_ent_doc_id__doc_iddocument_iddocumentsidfk_doc_pac_ent_doc_pac_id__doc_pac_iddocument_package_iddocument_packagesid103Table - public > document_packages Table PropertiesPropertyValuePropertyValueTotal size8.0 KBOID25008Table size0 bytesOwnerpostgresIndexes size8.0 KBTablespacepg_defaultToast size0 bytesPrimary key(s)Estimated rows0Comment Table Statisticsseq_scan0n_dead_tup0seq_tup_read0last_vacuum-idx_scan0last_autocvacuum-idx_tup_fetch0last_analyze-n_tup_ins0last_autoanalyze-n_tup_upd0vacuum_count0n_tup_del0autovacuum_count0n_tup_hot_upd0analyze_count0n_live_tup0autoanalyze_count0 ColumnsNameTypeLengthDefault valueNullableCommentidinteger-1nextval('document_packages_id_seq'::regclass)Falsepackage_keycharacter varying100Truepackage_namecharacter varying100Truedate_timedate-1True IndexesName (scan, tup_read, tup_fetch)PrimaryUniqueClusteredSizeDefinitiondocument_packages_id_key (0, 0, 0)FalseTrueFalse8.0 KBbtree (id) Unique ConstraintsNameColumns Commentdocument_packages_id_keyid104Table - public > documents Table PropertiesPropertyValuePropertyValueTotal size376.0 KBOID25014Table size96.0 KBOwnerpostgresIndexes size272.0 KBTablespacepg_defaultToast size8.0 KBPrimary key(s)Estimated rows414Comment Table Statisticsseq_scan0n_dead_tup0seq_tup_read0last_vacuum-idx_scan0last_autocvacuum-idx_tup_fetch0last_analyze-n_tup_ins0last_autoanalyze-n_tup_upd0vacuum_count0n_tup_del0autovacuum_count0n_tup_hot_upd0analyze_count0n_live_tup0autoanalyze_count0 ColumnsNameTypeLengthDefault valueNullableCommentidinteger-1nextval('documents_id_seq'::regclass)Falsedoc_idcharacter varying75Falsepublisher_idinteger-1Falsedate_timetimestamp without time zone-1Truetitlecharacter varying255Truelanguagecharacter varying100Trueprioritycharacter varying100Truerevision_idcharacter varying75Truestats_coveragecharacter varying100Truedocument_fixture_idinteger-1Falsesource_idinteger-1Truedb_loading_date_timetimestamp without time zone-1True IndexesName (scan, tup_read, tup_fetch)PrimaryUniqueClusteredSizeDefinitionidx_fk_doc_doc_fix_id__doc_fix_id (0, 0, 0)FalseFalseFalse32.0 KBbtree (document_fixture_id)idx_documents_5 (0, 0, 0)FalseFalseFalse40.0 KBbtree (revision_id)105 IndexesName (scan, tup_read, tup_fetch)PrimaryUniqueClusteredSizeDefinition[Index."IndexName"] ([Index."StatIdx_Scan"], [Index."StatIdx_Tup_Read"], [Index."StatIdx_Tup_Fetch"])FalseFalseFalse32.0 KBbtree (priority)idx_documents_3 (0, 0, 0)FalseFalseFalse32.0 KBbtree (date_time)idx_documents_1 (0, 0, 0)FalseFalseFalse40.0 KBbtree (doc_id)idx_fk_doc_sou_id__pub_id (0, 0, 0)FalseFalseFalse32.0 KBbtree (source_id)idx_fk_doc_pub_id__pub_id (0, 0, 0)FalseFalseFalse32.0 KBbtree (publisher_id)documents_id_key (0, 0, 0)FalseTrueFalse32.0 KBbtree (id) Unique ConstraintsNameColumns Commentdocuments_id_keyid Foreign KeysNameKeys Reference tableReference keysfk_doc_sou_id__pub_idsource_idpublishersidfk_doc_doc_fix_id__doc_fix_iddocument_fixture_iddocument_fixturesidfk_doc_pub_id__pub_idpublisher_idpublishersid106Table - public > documents_media Table PropertiesPropertyValuePropertyValueTotal size8.0 KBOID25023Table size0 bytesOwnerpostgresIndexes size8.0 KBTablespacepg_defaultToast size0 bytesPrimary key(s)Estimated rows0Comment Table Statisticsseq_scan0n_dead_tup0seq_tup_read0last_vacuum-idx_scan0last_autocvacuum-idx_tup_fetch0last_analyze-n_tup_ins0last_autoanalyze-n_tup_upd0vacuum_count0n_tup_del0autovacuum_count0n_tup_hot_upd0analyze_count0n_live_tup0autoanalyze_count0 ColumnsNameTypeLengthDefault valueNullableCommentidinteger-1nextval('documents_media_id_seq'::regclass)Falsedocument_idinteger-1Falsemedia_idinteger-1Falsemedia_caption_idinteger-1False IndexesName (scan, tup_read, tup_fetch)PrimaryUniqueClusteredSizeDefinitiondocuments_media_id_key (0, 0, 0)FalseTrueFalse8.0 KBbtree (id) Unique ConstraintsNameColumns Commentdocuments_media_id_keyid Foreign KeysNameKeys Reference tableReference keysfk_doc_med_med_cap_id__med_cap_idmedia_caption_idmedia_captionsid107 Foreign KeysNameKeys Reference tableReference keysfk_doc_med_med_id__med_idmedia_idmediaidfk_doc_med_doc_id__doc_iddocument_iddocumentsid108Table - public > events Table PropertiesPropertyValuePropertyValueTotal size992.0 KBOID25029Table size456.0 KBOwnerpostgresIndexes size528.0 KBTablespacepg_defaultToast size8.0 KBPrimary key(s)Estimated rows4350Comment Table Statisticsseq_scan0n_dead_tup0seq_tup_read0last_vacuum-idx_scan0last_autocvacuum-idx_tup_fetch0last_analyze-n_tup_ins0last_autoanalyze-n_tup_upd0vacuum_count0n_tup_del0autovacuum_count0n_tup_hot_upd0analyze_count0n_live_tup0autoanalyze_count0 ColumnsNameTypeLengthDefault valueNullableCommentidinteger-1nextval('events_id_seq'::regclass)Falseevent_keycharacter varying100Falsepublisher_idinteger-1Falsestart_date_timetimestamp without time zone-1Truesite_idinteger-1Truesite_alignmentcharacter varying100Trueevent_statuscharacter varying100Truedurationcharacter varying100Trueattendancecharacter varying100Truelast_updatetimestamp without time zone-1True IndexesName (scan, tup_read, tup_fetch)PrimaryUniqueClusteredSizeDefinitionevents_id_key (0, 0, 0)FalseTrueFalse112.0 KBbtree (id)idx_fk_eve_pub_id__pub_id (0, 0, 0)FalseFalseFalse112.0 KBbtree (publisher_id)idx_fk_eve_sit_id__sit_id (0, 0, 0)FalseFalseFalse112.0 KBbtree (site_id)idx_events_1 (0, 0, 0)FalseFalseFalse192.0 KBbtree (event_key)109 Unique ConstraintsNameColumns Commentevents_id_keyid Foreign KeysNameKeys Reference tableReference keysfk_eve_pub_id__pub_idpublisher_idpublishersidfk_eve_sit_id__sit_idsite_idsitesid110Table - public > events_documents Table PropertiesPropertyValuePropertyValueTotal size312.0 KBOID25036Table size312.0 KBOwnerpostgresIndexes size0 bytesTablespacepg_defaultToast size0 bytesPrimary key(s)Estimated rows0Comment Table Statisticsseq_scan0n_dead_tup0seq_tup_read0last_vacuum-idx_scan0last_autocvacuum-idx_tup_fetch0last_analyze-n_tup_ins0last_autoanalyze-n_tup_upd0vacuum_count0n_tup_del0autovacuum_count0n_tup_hot_upd0analyze_count0n_live_tup0autoanalyze_count0 ColumnsNameTypeLengthDefault valueNullableCommentevent_idinteger-1Falsedocument_idinteger-1False Foreign KeysNameKeys Reference tableReference keysfk_eve_doc_eve_id__eve_idevent_ideventsidfk_eve_doc_doc_id__doc_iddocument_iddocumentsid111Table - public > events_media Table PropertiesPropertyValuePropertyValueTotal size0 bytesOID25039Table size0 bytesOwnerpostgresIndexes size0 bytesTablespacepg_defaultToast size0 bytesPrimary key(s)Estimated rows0Comment Table Statisticsseq_scan0n_dead_tup0seq_tup_read0last_vacuum-idx_scan0last_autocvacuum-idx_tup_fetch0last_analyze-n_tup_ins0last_autoanalyze-n_tup_upd0vacuum_count0n_tup_del0autovacuum_count0n_tup_hot_upd0analyze_count0n_live_tup0autoanalyze_count0 ColumnsNameTypeLengthDefault valueNullableCommentevent_idinteger-1Falsemedia_idinteger-1False Foreign KeysNameKeys Reference tableReference keysfk_eve_med_eve_id__eve_idevent_ideventsidfk_eve_med_med_id__med_idmedia_idmediaid112Table - public > events_sub_seasons Table PropertiesPropertyValuePropertyValueTotal size184.0 KBOID25042Table size184.0 KBOwnerpostgresIndexes size0 bytesTablespacepg_defaultToast size0 bytesPrimary key(s)Estimated rows0Comment Table Statisticsseq_scan0n_dead_tup0seq_tup_read0last_vacuum-idx_scan0last_autocvacuum-idx_tup_fetch0last_analyze-n_tup_ins0last_autoanalyze-n_tup_upd0vacuum_count0n_tup_del0autovacuum_count0n_tup_hot_upd0analyze_count0n_live_tup0autoanalyze_count0 ColumnsNameTypeLengthDefault valueNullableCommentevent_idinteger-1Falsesub_season_idinteger-1False Foreign KeysNameKeys Reference tableReference keysfk_eve_sub_sea_sub_sea_id__sub_sea_idsub_season_idsub_seasonsidfk_eve_sub_sea_eve_id__eve_idevent_ideventsid113Table - public > ice_hockey_action_participants Table PropertiesPropertyValuePropertyValueTotal size24.0 KBOID25047Table size8.0 KBOwnerpostgresIndexes size16.0 KBTablespacepg_defaultToast size0 bytesPrimary key(s)Estimated rows138Comment Table Statisticsseq_scan0n_dead_tup0seq_tup_read0last_vacuum-idx_scan0last_autocvacuum-idx_tup_fetch0last_analyze-n_tup_ins0last_autoanalyze-n_tup_upd0vacuum_count0n_tup_del0autovacuum_count0n_tup_hot_upd0analyze_count0n_live_tup0autoanalyze_count0 ColumnsNameTypeLengthDefault valueNullableCommentidinteger-1nextval('ice_hockey_action_participants_id_seq'::regclass)Falseice_hockey_action_play_idinteger-1Falseperson_idinteger-1Falseparticipant_rolecharacter varying100Falsepoint_creditinteger-1True IndexesName (scan, tup_read, tup_fetch)PrimaryUniqueClusteredSizeDefinitionice_hockey_action_participants_id_key (0, 0, 0)FalseTrueFalse16.0 KBbtree (id) Unique ConstraintsNameColumns Commentice_hockey_action_participants_id_keyid114Table - public > ice_hockey_action_plays Table PropertiesPropertyValuePropertyValueTotal size32.0 KBOID25053Table size8.0 KBOwnerpostgresIndexes size16.0 KBTablespacepg_defaultToast size8.0 KBPrimary key(s)Estimated rows51Comment Table Statisticsseq_scan0n_dead_tup0seq_tup_read0last_vacuum-idx_scan0last_autocvacuum-idx_tup_fetch0last_analyze-n_tup_ins0last_autoanalyze-n_tup_upd0vacuum_count0n_tup_del0autovacuum_count0n_tup_hot_upd0analyze_count0n_live_tup0autoanalyze_count0 ColumnsNameTypeLengthDefault valueNullableCommentidinteger-1nextval('ice_hockey_action_plays_id_seq'::regclass)Falseice_hockey_event_state_idinteger-1Falseplay_typecharacter varying100Truescore_attempt_typecharacter varying100Trueplay_resultcharacter varying100Truecommentcharacter varying255True IndexesName (scan, tup_read, tup_fetch)PrimaryUniqueClusteredSizeDefinitionice_hockey_action_plays_id_key (0, 0, 0)FalseTrueFalse16.0 KBbtree (id) Unique ConstraintsNameColumns Commentice_hockey_action_plays_id_keyid115Table - public > ice_hockey_defensive_stats Table PropertiesPropertyValuePropertyValueTotal size32.0 KBOID25062Table size8.0 KBOwnerpostgresIndexes size16.0 KBTablespacepg_defaultToast size8.0 KBPrimary key(s)Estimated rows46Comment Table Statisticsseq_scan0n_dead_tup0seq_tup_read0last_vacuum-idx_scan0last_autocvacuum-idx_tup_fetch0last_analyze-n_tup_ins0last_autoanalyze-n_tup_upd0vacuum_count0n_tup_del0autovacuum_count0n_tup_hot_upd0analyze_count0n_live_tup0autoanalyze_count0 ColumnsNameTypeLengthDefault valueNullableCommentidinteger-1nextval('ice_hockey_defensive_stats_id_seq'::regclass)Falseshots_power_play_allowedcharacter varying100Trueshots_penalty_shot_allowedcharacter varying100Truegoals_power_play_allowedcharacter varying100Truegoals_penalty_shot_allowedcharacter varying100Truegoals_against_averagecharacter varying100Truesavescharacter varying100Truesave_percentagecharacter varying100Truepenalty_killing_amountcharacter varying100Truepenalty_killing_percentagecharacter varying100Trueshots_blockedcharacter varying100Truetakeawayscharacter varying100Trueshutoutscharacter varying100Trueminutes_penalty_killingcharacter varying100True116 ColumnsNameTypeLengthDefault valueNullableCommenthitscharacter varying100Truegoals_empty_net_allowedcharacter varying100Truegoals_short_handed_allowedcharacter varying100Truegoals_shootout_allowedcharacter varying100Trueshots_shootout_allowedcharacter varying100True IndexesName (scan, tup_read, tup_fetch)PrimaryUniqueClusteredSizeDefinitionice_hockey_defensive_stats_id_key (0, 0, 0)FalseTrueFalse16.0 KBbtree (id) Unique ConstraintsNameColumns Commentice_hockey_defensive_stats_id_keyid117Table - public > ice_hockey_event_states Table PropertiesPropertyValuePropertyValueTotal size24.0 KBOID25071Table size8.0 KBOwnerpostgresIndexes size16.0 KBTablespacepg_defaultToast size0 bytesPrimary key(s)Estimated rows51Comment Table Statisticsseq_scan0n_dead_tup0seq_tup_read0last_vacuum-idx_scan0last_autocvacuum-idx_tup_fetch0last_analyze-n_tup_ins0last_autoanalyze-n_tup_upd0vacuum_count0n_tup_del0autovacuum_count0n_tup_hot_upd0analyze_count0n_live_tup0autoanalyze_count0 ColumnsNameTypeLengthDefault valueNullableCommentidinteger-1nextval('ice_hockey_event_states_id_seq'::regclass)Falseevent_idinteger-1Falsecurrent_stateinteger-1Truesequence_numberinteger-1Trueperiod_valuecharacter varying100Trueperiod_time_elapsedcharacter varying100Trueperiod_time_remainingcharacter varying100Truecontextcharacter varying40True IndexesName (scan, tup_read, tup_fetch)PrimaryUniqueClusteredSizeDefinitionice_hockey_event_states_id_key (0, 0, 0)FalseTrueFalse16.0 KBbtree (id) Unique ConstraintsNameColumns Comment118 Unique ConstraintsNameColumns Commentice_hockey_event_states_id_keyid Foreign KeysNameKeys Reference tableReference keysfk_ice_hoc_eve_sta_eve_id__eve_idevent_ideventsid119Table - public > ice_hockey_offensive_stats Table PropertiesPropertyValuePropertyValueTotal size120.0 KBOID25077Table size72.0 KBOwnerpostgresIndexes size40.0 KBTablespacepg_defaultToast size8.0 KBPrimary key(s)Estimated rows839Comment Table Statisticsseq_scan0n_dead_tup0seq_tup_read0last_vacuum-idx_scan0last_autocvacuum-idx_tup_fetch0last_analyze-n_tup_ins0last_autoanalyze-n_tup_upd0vacuum_count0n_tup_del0autovacuum_count0n_tup_hot_upd0analyze_count0n_live_tup0autoanalyze_count0 ColumnsNameTypeLengthDefault valueNullableCommentidinteger-1nextval('ice_hockey_offensive_stats_id_seq'::regclass)Falsegoals_game_winningcharacter varying100Truegoals_game_tyingcharacter varying100Truegoals_power_playcharacter varying100Truegoals_short_handedcharacter varying100Truegoals_even_strengthcharacter varying100Truegoals_empty_netcharacter varying100Truegoals_overtimecharacter varying100Truegoals_shootoutcharacter varying100Truegoals_penalty_shotcharacter varying100Trueassistscharacter varying100Truepointscharacter varying100Truepower_play_amountcharacter varying100Truepower_play_percentagecharacter varying100True120 ColumnsNameTypeLengthDefault valueNullableCommentshots_penalty_shot_takencharacter varying100Trueshots_penalty_shot_missedcharacter varying100Trueshots_penalty_shot_percentagecharacter varying100Truegiveawayscharacter varying100Trueminutes_power_playcharacter varying100Truefaceoff_winscharacter varying100Truefaceoff_lossescharacter varying100Truefaceoff_win_percentagecharacter varying100Truescoring_chancescharacter varying100True IndexesName (scan, tup_read, tup_fetch)PrimaryUniqueClusteredSizeDefinitionice_hockey_offensive_stats_id_key (0, 0, 0)FalseTrueFalse40.0 KBbtree (id) Unique ConstraintsNameColumns Commentice_hockey_offensive_stats_id_keyid121Table - public > ice_hockey_player_stats Table PropertiesPropertyValuePropertyValueTotal size96.0 KBOID25086Table size56.0 KBOwnerpostgresIndexes size40.0 KBTablespacepg_defaultToast size0 bytesPrimary key(s)Estimated rows817Comment Table Statisticsseq_scan0n_dead_tup0seq_tup_read0last_vacuum-idx_scan0last_autocvacuum-idx_tup_fetch0last_analyze-n_tup_ins0last_autoanalyze-n_tup_upd0vacuum_count0n_tup_del0autovacuum_count0n_tup_hot_upd0analyze_count0n_live_tup0autoanalyze_count0 ColumnsNameTypeLengthDefault valueNullableCommentidinteger-1nextval('ice_hockey_player_stats_id_seq'::regclass)Falseplus_minuscharacter varying100True IndexesName (scan, tup_read, tup_fetch)PrimaryUniqueClusteredSizeDefinitionice_hockey_player_stats_id_key (0, 0, 0)FalseTrueFalse40.0 KBbtree (id) Unique ConstraintsNameColumns Commentice_hockey_player_stats_id_keyid122Table - public > injury_phases Table PropertiesPropertyValuePropertyValueTotal size336.0 KBOID25092Table size88.0 KBOwnerpostgresIndexes size240.0 KBTablespacepg_defaultToast size8.0 KBPrimary key(s)Estimated rows771Comment Table Statisticsseq_scan0n_dead_tup0seq_tup_read0last_vacuum-idx_scan0last_autocvacuum-idx_tup_fetch0last_analyze-n_tup_ins0last_autoanalyze-n_tup_upd0vacuum_count0n_tup_del0autovacuum_count0n_tup_hot_upd0analyze_count0n_live_tup0autoanalyze_count0 ColumnsNameTypeLengthDefault valueNullableCommentidinteger-1nextval('injury_phases_id_seq'::regclass)Falseperson_idinteger-1Falseinjury_statuscharacter varying100Trueinjury_typecharacter varying100Trueinjury_commentcharacter varying100Truedisabled_listcharacter varying100Truestart_date_timetimestamp without time zone-1Trueend_date_timetimestamp without time zone-1Trueseason_idinteger-1Truephase_typecharacter varying100Trueinjury_sidecharacter varying100True IndexesName (scan, tup_read, tup_fetch)PrimaryUniqueClusteredSizeDefinitionidx_fk_inj_pha_per_id__per_id (0, 0, 0)FalseFalseFalse40.0 KBbtree (person_id)injury_phases_id_key (0, 0, 0)FalseTrueFalse40.0 KBbtree (id)idx_injury_phases_4 (0, 0, 0)FalseFalseFalse40.0 KBbtree (end_date_time)idx_injury_phases_3 (0, 0, 0)FalseFalseFalse40.0 KBbtree (start_date_time)idx_injury_phases_2 (0, 0, 0)FalseFalseFalse40.0 KBbtree (injury_status)123 IndexesName (scan, tup_read, tup_fetch)PrimaryUniqueClusteredSizeDefinition[Index."IndexName"] ([Index."StatIdx_Scan"], [Index."StatIdx_Tup_Read"], [Index."StatIdx_Tup_Fetch"])FalseFalseFalse40.0 KBbtree (season_id) Unique ConstraintsNameColumns Commentinjury_phases_id_keyid Foreign KeysNameKeys Reference tableReference keysfk_inj_pha_per_id__per_idperson_idpersonsidfk_inj_pha_sea_id__sea_idseason_idseasonsid124Table - public > key_aliases Table PropertiesPropertyValuePropertyValueTotal size16.0 KBOID25101Table size0 bytesOwnerpostgresIndexes size16.0 KBTablespacepg_defaultToast size0 bytesPrimary key(s)Estimated rows0Comment Table Statisticsseq_scan0n_dead_tup0seq_tup_read0last_vacuum-idx_scan0last_autocvacuum-idx_tup_fetch0last_analyze-n_tup_ins0last_autoanalyze-n_tup_upd0vacuum_count0n_tup_del0autovacuum_count0n_tup_hot_upd0analyze_count0n_live_tup0autoanalyze_count0 ColumnsNameTypeLengthDefault valueNullableCommentidinteger-1nextval('key_aliases_id_seq'::regclass)Falsekey_idinteger-1Falsekey_root_idinteger-1False IndexesName (scan, tup_read, tup_fetch)PrimaryUniqueClusteredSizeDefinitionkey_aliases_id_key (0, 0, 0)FalseTrueFalse8.0 KBbtree (id)idx_key_aliases_2 (0, 0, 0)FalseFalseFalse8.0 KBbtree (key_id) Unique ConstraintsNameColumns Commentkey_aliases_id_keyid Foreign KeysNameKeys Reference tableReference keysfk_key_roots_key_aliaseskey_root_idkey_rootsid125Table - public > key_roots Table PropertiesPropertyValuePropertyValueTotal size16.0 KBOID25107Table size0 bytesOwnerpostgresIndexes size16.0 KBTablespacepg_defaultToast size0 bytesPrimary key(s)Estimated rows0Comment Table Statisticsseq_scan0n_dead_tup0seq_tup_read0last_vacuum-idx_scan0last_autocvacuum-idx_tup_fetch0last_analyze-n_tup_ins0last_autoanalyze-n_tup_upd0vacuum_count0n_tup_del0autovacuum_count0n_tup_hot_upd0analyze_count0n_live_tup0autoanalyze_count0 ColumnsNameTypeLengthDefault valueNullableCommentidinteger-1nextval('key_roots_id_seq'::regclass)Falsekey_typecharacter varying100True IndexesName (scan, tup_read, tup_fetch)PrimaryUniqueClusteredSizeDefinitionidx_key_aliases_1 (0, 0, 0)FalseFalseFalse8.0 KBbtree (key_type)key_roots_id_key (0, 0, 0)FalseTrueFalse8.0 KBbtree (id) Unique ConstraintsNameColumns Commentkey_roots_id_keyid126Table - public > latest_revisions Table PropertiesPropertyValuePropertyValueTotal size112.0 KBOID25113Table size48.0 KBOwnerpostgresIndexes size64.0 KBTablespacepg_defaultToast size0 bytesPrimary key(s)Estimated rows295Comment Table Statisticsseq_scan0n_dead_tup0seq_tup_read0last_vacuum-idx_scan0last_autocvacuum-idx_tup_fetch0last_analyze-n_tup_ins0last_autoanalyze-n_tup_upd0vacuum_count0n_tup_del0autovacuum_count0n_tup_hot_upd0analyze_count0n_live_tup0autoanalyze_count0 ColumnsNameTypeLengthDefault valueNullableCommentidinteger-1nextval('latest_revisions_id_seq'::regclass)Falserevision_idcharacter varying75Falselatest_document_idinteger-1False IndexesName (scan, tup_read, tup_fetch)PrimaryUniqueClusteredSizeDefinitionidx_latest_revisions_1 (0, 0, 0)FalseFalseFalse32.0 KBbtree (revision_id)idx_fk_lat_rev_lat_doc_id__doc_id (0, 0, 0)FalseFalseFalse16.0 KBbtree (latest_document_id)latest_revisions_id_key (0, 0, 0)FalseTrueFalse16.0 KBbtree (id) Unique ConstraintsNameColumns Commentlatest_revisions_id_keyid Foreign KeysNameKeys Reference tableReference keys127 Foreign KeysNameKeys Reference tableReference keysfk_lat_rev_lat_doc_id__doc_idlatest_document_iddocumentsid128Table - public > locations Table PropertiesPropertyValuePropertyValueTotal size40.0 KBOID25119Table size8.0 KBOwnerpostgresIndexes size32.0 KBTablespacepg_defaultToast size0 bytesPrimary key(s)Estimated rows0Comment Table Statisticsseq_scan0n_dead_tup0seq_tup_read0last_vacuum-idx_scan0last_autocvacuum-idx_tup_fetch0last_analyze-n_tup_ins0last_autoanalyze-n_tup_upd0vacuum_count0n_tup_del0autovacuum_count0n_tup_hot_upd0analyze_count0n_live_tup0autoanalyze_count0 ColumnsNameTypeLengthDefault valueNullableCommentidinteger-1nextval('locations_id_seq'::regclass)Falsetimezonecharacter varying100Truelatitudecharacter varying100Truelongitudecharacter varying100Truecountry_codecharacter varying100True IndexesName (scan, tup_read, tup_fetch)PrimaryUniqueClusteredSizeDefinitionidx_locations_1 (0, 0, 0)FalseFalseFalse16.0 KBbtree (country_code)locations_id_key (0, 0, 0)FalseTrueFalse16.0 KBbtree (id) Unique ConstraintsNameColumns Commentlocations_id_keyid129Table - public > media Table PropertiesPropertyValuePropertyValueTotal size8.0 KBOID25125Table size0 bytesOwnerpostgresIndexes size8.0 KBTablespacepg_defaultToast size0 bytesPrimary key(s)Estimated rows0Comment Table Statisticsseq_scan0n_dead_tup0seq_tup_read0last_vacuum-idx_scan0last_autocvacuum-idx_tup_fetch0last_analyze-n_tup_ins0last_autoanalyze-n_tup_upd0vacuum_count0n_tup_del0autovacuum_count0n_tup_hot_upd0analyze_count0n_live_tup0autoanalyze_count0 ColumnsNameTypeLengthDefault valueNullableCommentidinteger-1nextval('media_id_seq'::regclass)Falseobject_idinteger-1Truesource_idinteger-1Truerevision_idinteger-1Truemedia_typecharacter varying100Truepublisher_idinteger-1Falsedate_timecharacter varying100Truecredit_idinteger-1Falsedb_loading_date_timetimestamp without time zone-1Truecreation_location_idinteger-1False IndexesName (scan, tup_read, tup_fetch)PrimaryUniqueClusteredSizeDefinitionmedia_id_key (0, 0, 0)FalseTrueFalse8.0 KBbtree (id) Unique ConstraintsNameColumns Comment130 Unique ConstraintsNameColumns Commentmedia_id_keyid Foreign KeysNameKeys Reference tableReference keysfk_med_cre_loc_id__loc_idcreation_location_idlocationsidfk_med_cre_id__per_idcredit_idpersonsidfk_med_pub_id__pub_idpublisher_idpublishersid131Table - public > media_captions Table PropertiesPropertyValuePropertyValueTotal size8.0 KBOID25131Table size0 bytesOwnerpostgresIndexes size8.0 KBTablespacepg_defaultToast size0 bytesPrimary key(s)Estimated rows0Comment Table Statisticsseq_scan0n_dead_tup0seq_tup_read0last_vacuum-idx_scan0last_autocvacuum-idx_tup_fetch0last_analyze-n_tup_ins0last_autoanalyze-n_tup_upd0vacuum_count0n_tup_del0autovacuum_count0n_tup_hot_upd0analyze_count0n_live_tup0autoanalyze_count0 ColumnsNameTypeLengthDefault valueNullableCommentidinteger-1nextval('media_captions_id_seq'::regclass)Falsemedia_idinteger-1Falsecaption_typecharacter varying100Truecaptioncharacter varying100Truecaption_author_idinteger-1Falselanguagecharacter varying100Truecaption_sizecharacter varying100True IndexesName (scan, tup_read, tup_fetch)PrimaryUniqueClusteredSizeDefinitionmedia_captions_id_key (0, 0, 0)FalseTrueFalse8.0 KBbtree (id) Unique ConstraintsNameColumns Commentmedia_captions_id_keyid132 Foreign KeysNameKeys Reference tableReference keysfk_med_cap_med_id__med_idmedia_idmediaidfk_med_cap_cap_aut_id__per_idcaption_author_idpersonsid133Table - public > media_contents Table PropertiesPropertyValuePropertyValueTotal size16.0 KBOID25137Table size0 bytesOwnerpostgresIndexes size8.0 KBTablespacepg_defaultToast size8.0 KBPrimary key(s)Estimated rows0Comment Table Statisticsseq_scan0n_dead_tup0seq_tup_read0last_vacuum-idx_scan0last_autocvacuum-idx_tup_fetch0last_analyze-n_tup_ins0last_autoanalyze-n_tup_upd0vacuum_count0n_tup_del0autovacuum_count0n_tup_hot_upd0analyze_count0n_live_tup0autoanalyze_count0 ColumnsNameTypeLengthDefault valueNullableCommentidinteger-1nextval('media_contents_id_seq'::regclass)Falsemedia_idinteger-1Falseobjectcharacter varying100Trueformatcharacter varying100Truemime_typecharacter varying100Trueheightcharacter varying100Truewidthcharacter varying100Truedurationcharacter varying100Truefile_sizecharacter varying100Trueresolutioncharacter varying100True IndexesName (scan, tup_read, tup_fetch)PrimaryUniqueClusteredSizeDefinitionmedia_contents_id_key (0, 0, 0)FalseTrueFalse8.0 KBbtree (id) Unique ConstraintsNameColumns Commentmedia_contents_id_keyid134 Unique ConstraintsNameColumns Comment Foreign KeysNameKeys Reference tableReference keysfk_med_con_med_id__med_idmedia_idmediaid135Table - public > media_keywords Table PropertiesPropertyValuePropertyValueTotal size8.0 KBOID25146Table size0 bytesOwnerpostgresIndexes size8.0 KBTablespacepg_defaultToast size0 bytesPrimary key(s)Estimated rows0Comment Table Statisticsseq_scan0n_dead_tup0seq_tup_read0last_vacuum-idx_scan0last_autocvacuum-idx_tup_fetch0last_analyze-n_tup_ins0last_autoanalyze-n_tup_upd0vacuum_count0n_tup_del0autovacuum_count0n_tup_hot_upd0analyze_count0n_live_tup0autoanalyze_count0 ColumnsNameTypeLengthDefault valueNullableCommentidinteger-1nextval('media_keywords_id_seq'::regclass)Falsekeywordcharacter varying100Truemedia_idinteger-1False IndexesName (scan, tup_read, tup_fetch)PrimaryUniqueClusteredSizeDefinitionmedia_keywords_id_key (0, 0, 0)FalseTrueFalse8.0 KBbtree (id) Unique ConstraintsNameColumns Commentmedia_keywords_id_keyid Foreign KeysNameKeys Reference tableReference keysfk_med_key_med_id__med_idmedia_idmediaid136Table - public > motor_racing_event_states Table PropertiesPropertyValuePropertyValueTotal size16.0 KBOID25152Table size0 bytesOwnerpostgresIndexes size16.0 KBTablespacepg_defaultToast size0 bytesPrimary key(s)Estimated rows0Comment Table Statisticsseq_scan0n_dead_tup0seq_tup_read0last_vacuum-idx_scan0last_autocvacuum-idx_tup_fetch0last_analyze-n_tup_ins0last_autoanalyze-n_tup_upd0vacuum_count0n_tup_del0autovacuum_count0n_tup_hot_upd0analyze_count0n_live_tup0autoanalyze_count0 ColumnsNameTypeLengthDefault valueNullableCommentidinteger-1nextval('motor_racing_event_states_id_seq'::regclass)Falseevent_idinteger-1Falsecurrent_stateinteger-1Truesequence_numberinteger-1Truelapcharacter varying100Truelaps_remainingcharacter varying100Truetime_elapsedcharacter varying100Trueflag_statecharacter varying100Truecontextcharacter varying40True IndexesName (scan, tup_read, tup_fetch)PrimaryUniqueClusteredSizeDefinitionidx_fk_events_motor_racing_event_states (0, 0, 0)FalseFalseFalse8.0 KBbtree (event_id)motor_racing_event_states_id_key (0, 0, 0)FalseTrueFalse8.0 KBbtree (id)137 Unique ConstraintsNameColumns Commentmotor_racing_event_states_id_keyid Foreign KeysNameKeys Reference tableReference keysfk_mot_rac_eve_sta_eve_id__eve_idevent_ideventsid138Table - public > motor_racing_qualifying_stats Table PropertiesPropertyValuePropertyValueTotal size16.0 KBOID25158Table size0 bytesOwnerpostgresIndexes size8.0 KBTablespacepg_defaultToast size8.0 KBPrimary key(s)Estimated rows0Comment Table Statisticsseq_scan0n_dead_tup0seq_tup_read0last_vacuum-idx_scan0last_autocvacuum-idx_tup_fetch0last_analyze-n_tup_ins0last_autoanalyze-n_tup_upd0vacuum_count0n_tup_del0autovacuum_count0n_tup_hot_upd0analyze_count0n_live_tup0autoanalyze_count0 ColumnsNameTypeLengthDefault valueNullableCommentidinteger-1nextval('motor_racing_qualifying_stats_id_seq'::regclass)Falsegridcharacter varying100Truepole_positioncharacter varying100Truepole_winscharacter varying100Truequalifying_speedcharacter varying100Truequalifying_speed_unitscharacter varying100Truequalifying_timecharacter varying100Truequalifying_positioncharacter varying100True IndexesName (scan, tup_read, tup_fetch)PrimaryUniqueClusteredSizeDefinitionmotor_racing_qualifying_stats_id_key (0, 0, 0)FalseTrueFalse8.0 KBbtree (id) Unique ConstraintsNameColumns Comment139 Unique ConstraintsNameColumns Commentmotor_racing_qualifying_stats_id_keyid140Table - public > motor_racing_race_stats Table PropertiesPropertyValuePropertyValueTotal size16.0 KBOID25167Table size0 bytesOwnerpostgresIndexes size8.0 KBTablespacepg_defaultToast size8.0 KBPrimary key(s)Estimated rows0Comment Table Statisticsseq_scan0n_dead_tup0seq_tup_read0last_vacuum-idx_scan0last_autocvacuum-idx_tup_fetch0last_analyze-n_tup_ins0last_autoanalyze-n_tup_upd0vacuum_count0n_tup_del0autovacuum_count0n_tup_hot_upd0analyze_count0n_live_tup0autoanalyze_count0 ColumnsNameTypeLengthDefault valueNullableCommentidinteger-1nextval('motor_racing_race_stats_id_seq'::regclass)Falsetime_behind_leadercharacter varying100Truelaps_behind_leadercharacter varying100Truetime_ahead_followercharacter varying100Truelaps_ahead_followercharacter varying100Truetimecharacter varying100Truepointscharacter varying100Truepoints_rookiecharacter varying100Truebonuscharacter varying100Truelaps_completedcharacter varying100Truelaps_leading_totalcharacter varying100Truedistance_leadingcharacter varying100Truedistance_completedcharacter varying100Truedistance_unitscharacter varying40Truespeed_averagecharacter varying40Truespeed_unitscharacter varying40True141 ColumnsNameTypeLengthDefault valueNullableCommentstatuscharacter varying40Truefinishes_top_5character varying40Truefinishes_top_10character varying40Truestartscharacter varying40Truefinishescharacter varying40Truenon_finishescharacter varying40Truewinscharacter varying40Trueraces_leadingcharacter varying40Truemoneycharacter varying40Truemoney_unitscharacter varying40Trueleads_totalcharacter varying40True IndexesName (scan, tup_read, tup_fetch)PrimaryUniqueClusteredSizeDefinitionmotor_racing_race_stats_id_key (0, 0, 0)FalseTrueFalse8.0 KBbtree (id) Unique ConstraintsNameColumns Commentmotor_racing_race_stats_id_keyid142Table - public > outcome_totals Table PropertiesPropertyValuePropertyValueTotal size16.0 KBOID25176Table size0 bytesOwnerpostgresIndexes size8.0 KBTablespacepg_defaultToast size8.0 KBPrimary key(s)Estimated rows0Comment Table Statisticsseq_scan0n_dead_tup0seq_tup_read0last_vacuum-idx_scan0last_autocvacuum-idx_tup_fetch0last_analyze-n_tup_ins0last_autoanalyze-n_tup_upd0vacuum_count0n_tup_del0autovacuum_count0n_tup_hot_upd0analyze_count0n_live_tup0autoanalyze_count0 ColumnsNameTypeLengthDefault valueNullableCommentidinteger-1nextval('outcome_totals_id_seq'::regclass)Falsestanding_subgroup_idinteger-1Falseoutcome_holder_typecharacter varying100Trueoutcome_holder_idinteger-1Truerankcharacter varying100Truewinscharacter varying100Truelossescharacter varying100Truetiescharacter varying100Trueundecidedscharacter varying100Truewinning_percentagecharacter varying100Truepoints_scored_forcharacter varying100Truepoints_scored_againstcharacter varying100Truepoints_differencecharacter varying100Truestanding_pointscharacter varying100Truestreak_typecharacter varying100Truestreak_durationcharacter varying100True143 ColumnsNameTypeLengthDefault valueNullableCommentstreak_totalcharacter varying100Truestreak_startdate-1Truestreak_enddate-1True IndexesName (scan, tup_read, tup_fetch)PrimaryUniqueClusteredSizeDefinitionoutcome_totals_id_key (0, 0, 0)FalseTrueFalse8.0 KBbtree (id) Unique ConstraintsNameColumns Commentoutcome_totals_id_keyid Foreign KeysNameKeys Reference tableReference keysfk_out_tot_sta_sub_id__sta_sub_idstanding_subgroup_idstanding_subgroupsid144Table - public > participants_events Table PropertiesPropertyValuePropertyValueTotal size1.836 MBOID25185Table size584.0 KBOwnerpostgresIndexes size1.266 MBTablespacepg_defaultToast size0 bytesPrimary key(s)Estimated rows8700Comment Table Statisticsseq_scan0n_dead_tup0seq_tup_read0last_vacuum-idx_scan0last_autocvacuum-idx_tup_fetch0last_analyze-n_tup_ins0last_autoanalyze-n_tup_upd0vacuum_count0n_tup_del0autovacuum_count0n_tup_hot_upd0analyze_count0n_live_tup0autoanalyze_count0 ColumnsNameTypeLengthDefault valueNullableCommentidinteger-1nextval('participants_events_id_seq'::regclass)Falseparticipant_typecharacter varying100Falseparticipant_idinteger-1Falseevent_idinteger-1Falsealignmentcharacter varying100Truescorecharacter varying100Trueevent_outcomecharacter varying100Truerankinteger-1True IndexesName (scan, tup_read, tup_fetch)PrimaryUniqueClusteredSizeDefinitionidx_participants_events_4 (0, 0, 0)FalseFalseFalse256.0 KBbtree (event_outcome)idx_participants_events_1 (0, 0, 0)FalseFalseFalse208.0 KBbtree (participant_type)idx_participants_events_2 (0, 0, 0)FalseFalseFalse208.0 KBbtree (participant_id)idx_participants_events_3 (0, 0, 0)FalseFalseFalse208.0 KBbtree (alignment)participants_events_id_key (0, 0, 0)FalseTrueFalse208.0 KBbtree (id)idx_fk_par_eve_eve_id__eve_id (0, 0, 0)FalseFalseFalse208.0 KBbtree (event_id)145 Unique ConstraintsNameColumns Commentparticipants_events_id_keyid Foreign KeysNameKeys Reference tableReference keysfk_par_eve_eve_id__eve_idevent_ideventsid146Table - public > periods Table PropertiesPropertyValuePropertyValueTotal size112.0 KBOID25191Table size48.0 KBOwnerpostgresIndexes size64.0 KBTablespacepg_defaultToast size0 bytesPrimary key(s)Estimated rows548Comment Table Statisticsseq_scan0n_dead_tup0seq_tup_read0last_vacuum-idx_scan0last_autocvacuum-idx_tup_fetch0last_analyze-n_tup_ins0last_autoanalyze-n_tup_upd0vacuum_count0n_tup_del0autovacuum_count0n_tup_hot_upd0analyze_count0n_live_tup0autoanalyze_count0 ColumnsNameTypeLengthDefault valueNullableCommentidinteger-1nextval('periods_id_seq'::regclass)Falseparticipant_event_idinteger-1Falseperiod_valuecharacter varying100Truescorecharacter varying100True IndexesName (scan, tup_read, tup_fetch)PrimaryUniqueClusteredSizeDefinitionperiods_id_key (0, 0, 0)FalseTrueFalse32.0 KBbtree (id)idx_fk_per_par_eve_id__par_eve_id (0, 0, 0)FalseFalseFalse32.0 KBbtree (participant_event_id) Unique ConstraintsNameColumns Commentperiods_id_keyid Foreign KeysNameKeys Reference tableReference keys147 Foreign KeysNameKeys Reference tableReference keysfk_per_par_eve_id__par_eve_idparticipant_event_idparticipants_eventsid148Table - public > person_event_metadata Table PropertiesPropertyValuePropertyValueTotal size992.0 KBOID25197Table size264.0 KBOwnerpostgresIndexes size728.0 KBTablespacepg_defaultToast size0 bytesPrimary key(s)Estimated rows4002Comment Table Statisticsseq_scan0n_dead_tup0seq_tup_read0last_vacuum-idx_scan0last_autocvacuum-idx_tup_fetch0last_analyze-n_tup_ins0last_autoanalyze-n_tup_upd0vacuum_count0n_tup_del0autovacuum_count0n_tup_hot_upd0analyze_count0n_live_tup0autoanalyze_count0 ColumnsNameTypeLengthDefault valueNullableCommentidinteger-1nextval('person_event_metadata_id_seq'::regclass)Falseperson_idinteger-1Falseevent_idinteger-1Falsestatuscharacter varying100Truehealthcharacter varying100Trueweightcharacter varying100Truerole_idinteger-1Trueposition_idinteger-1Trueteam_idinteger-1Truelineup_slotinteger-1Truelineup_slot_sequenceinteger-1True IndexesName (scan, tup_read, tup_fetch)PrimaryUniqueClusteredSizeDefinitionidx_fk_per_eve_met_pos_id__pos_id (0, 0, 0)FalseFalseFalse104.0 KBbtree (position_id)idx_fk_per_eve_met_per_id__per_id (0, 0, 0)FalseFalseFalse104.0 KBbtree (person_id)idx_person_event_metadata_1 (0, 0, 0)FalseFalseFalse104.0 KBbtree (status)149 IndexesName (scan, tup_read, tup_fetch)PrimaryUniqueClusteredSizeDefinition[Index."IndexName"] ([Index."StatIdx_Scan"], [Index."StatIdx_Tup_Read"], [Index."StatIdx_Tup_Fetch"])FalseTrueFalse104.0 KBbtree (id)idx_fk_teams_person_event_metadata (0, 0, 0)FalseFalseFalse104.0 KBbtree (team_id)idx_fk_per_eve_met_eve_id__eve_id (0, 0, 0)FalseFalseFalse104.0 KBbtree (event_id)idx_fk_per_eve_met_rol_id__rol_id (0, 0, 0)FalseFalseFalse104.0 KBbtree (role_id) Unique ConstraintsNameColumns Commentperson_event_metadata_id_keyid Foreign KeysNameKeys Reference tableReference keysfk_per_eve_met_rol_id__rol_idrole_idrolesidfk_per_eve_met_tea_id__tea_idteam_idteamsidfk_per_eve_met_eve_id__eve_idevent_ideventsidfk_per_eve_met_per_id__per_idperson_idpersonsidfk_per_eve_met_pos_id__pos_idposition_idpositionsid150Table - public > person_phases Table PropertiesPropertyValuePropertyValueTotal size48.0 KBOID25203Table size0 bytesOwnerpostgresIndexes size48.0 KBTablespacepg_defaultToast size0 bytesPrimary key(s)Estimated rows0Comment Table Statisticsseq_scan0n_dead_tup0seq_tup_read0last_vacuum-idx_scan0last_autocvacuum-idx_tup_fetch0last_analyze-n_tup_ins0last_autoanalyze-n_tup_upd0vacuum_count0n_tup_del0autovacuum_count0n_tup_hot_upd0analyze_count0n_live_tup0autoanalyze_count0 ColumnsNameTypeLengthDefault valueNullableCommentidinteger-1nextval('person_phases_id_seq'::regclass)Falseperson_idinteger-1Falsemembership_typecharacter varying40Falsemembership_idinteger-1Falserole_idinteger-1Truerole_statuscharacter varying40Truephase_statuscharacter varying40Trueuniform_numbercharacter varying20Trueregular_position_idinteger-1Trueregular_position_depthcharacter varying40Trueheightcharacter varying100Trueweightcharacter varying100Truestart_date_timetimestamp without time zone-1Truestart_season_idinteger-1Trueend_date_timetimestamp without time zone-1Trueend_season_idinteger-1Trueentry_reasoncharacter varying40True151 ColumnsNameTypeLengthDefault valueNullableCommentexit_reasoncharacter varying40Trueselection_levelinteger-1Trueselection_sublevelinteger-1Trueselection_overallinteger-1True IndexesName (scan, tup_read, tup_fetch)PrimaryUniqueClusteredSizeDefinitionperson_phases_id_key (0, 0, 0)FalseTrueFalse8.0 KBbtree (id)idx_person_phases_2 (0, 0, 0)FalseFalseFalse8.0 KBbtree (membership_id)idx_person_phases_1 (0, 0, 0)FalseFalseFalse8.0 KBbtree (membership_type)idx_fk_per_pha_reg_pos_id__pos_id (0, 0, 0)FalseFalseFalse8.0 KBbtree (regular_position_id)idx_fk_per_pha_per_id__per_id (0, 0, 0)FalseFalseFalse8.0 KBbtree (person_id)idx_person_phases_3 (0, 0, 0)FalseFalseFalse8.0 KBbtree (phase_status) Unique ConstraintsNameColumns Commentperson_phases_id_keyid Foreign KeysNameKeys Reference tableReference keysfk_per_pha_end_sea_id__sea_idend_season_idseasonsidfk_per_pha_per_id__per_idperson_idpersonsidfk_per_pha_reg_pos_id__pos_idregular_position_idpositionsidfk_per_pha_rol_id__rol_idrole_idrolesidfk_per_pha_sta_sea_id__sea_idstart_season_idseasonsid152Table - public > persons Table PropertiesPropertyValuePropertyValueTotal size664.0 KBOID25209Table size288.0 KBOwnerpostgresIndexes size376.0 KBTablespacepg_defaultToast size0 bytesPrimary key(s)Estimated rows3937Comment Table Statisticsseq_scan0n_dead_tup0seq_tup_read0last_vacuum-idx_scan0last_autocvacuum-idx_tup_fetch0last_analyze-n_tup_ins0last_autoanalyze-n_tup_upd0vacuum_count0n_tup_del0autovacuum_count0n_tup_hot_upd0analyze_count0n_live_tup0autoanalyze_count0 ColumnsNameTypeLengthDefault valueNullableCommentidinteger-1nextval('persons_id_seq'::regclass)Falseperson_keycharacter varying100Falsepublisher_idinteger-1Falsegendercharacter varying20Truebirth_datecharacter varying30Truedeath_datecharacter varying30Truebirth_location_idinteger-1Truehometown_location_idinteger-1Trueresidence_location_idinteger-1Truedeath_location_idinteger-1True IndexesName (scan, tup_read, tup_fetch)PrimaryUniqueClusteredSizeDefinitionpersons_id_key (0, 0, 0)FalseTrueFalse104.0 KBbtree (id)idx_fk_per_pub_id__pub_id (0, 0, 0)FalseFalseFalse104.0 KBbtree (publisher_id)idx_persons_1 (0, 0, 0)FalseFalseFalse168.0 KBbtree (person_key)153 Unique ConstraintsNameColumns Commentpersons_id_keyid Foreign KeysNameKeys Reference tableReference keysfk_per_bir_loc_id__loc_idbirth_location_idlocationsidfk_per_hom_loc_id__loc_idhometown_location_idlocationsidfk_per_pub_id__pub_idpublisher_idpublishersidfk_per_dea_loc_id__loc_iddeath_location_idlocationsidfk_per_res_loc_id__loc_idresidence_location_idlocationsid154Table - public > persons_documents Table PropertiesPropertyValuePropertyValueTotal size0 bytesOID25213Table size0 bytesOwnerpostgresIndexes size0 bytesTablespacepg_defaultToast size0 bytesPrimary key(s)Estimated rows0Comment Table Statisticsseq_scan0n_dead_tup0seq_tup_read0last_vacuum-idx_scan0last_autocvacuum-idx_tup_fetch0last_analyze-n_tup_ins0last_autoanalyze-n_tup_upd0vacuum_count0n_tup_del0autovacuum_count0n_tup_hot_upd0analyze_count0n_live_tup0autoanalyze_count0 ColumnsNameTypeLengthDefault valueNullableCommentperson_idinteger-1Falsedocument_idinteger-1False Foreign KeysNameKeys Reference tableReference keysfk_per_doc_per_id__per_idperson_idpersonsidfk_per_doc_doc_id__doc_iddocument_iddocumentsid155Table - public > persons_media Table PropertiesPropertyValuePropertyValueTotal size0 bytesOID25216Table size0 bytesOwnerpostgresIndexes size0 bytesTablespacepg_defaultToast size0 bytesPrimary key(s)Estimated rows0Comment Table Statisticsseq_scan0n_dead_tup0seq_tup_read0last_vacuum-idx_scan0last_autocvacuum-idx_tup_fetch0last_analyze-n_tup_ins0last_autoanalyze-n_tup_upd0vacuum_count0n_tup_del0autovacuum_count0n_tup_hot_upd0analyze_count0n_live_tup0autoanalyze_count0 ColumnsNameTypeLengthDefault valueNullableCommentperson_idinteger-1Falsemedia_idinteger-1False Foreign KeysNameKeys Reference tableReference keysfk_per_med_med_id__med_idmedia_idmediaidfk_per_med_per_id__per_idperson_idpersonsid156Table - public > positions Table PropertiesPropertyValuePropertyValueTotal size56.0 KBOID25221Table size8.0 KBOwnerpostgresIndexes size48.0 KBTablespacepg_defaultToast size0 bytesPrimary key(s)Estimated rows73Comment Table Statisticsseq_scan0n_dead_tup0seq_tup_read0last_vacuum-idx_scan0last_autocvacuum-idx_tup_fetch0last_analyze-n_tup_ins0last_autoanalyze-n_tup_upd0vacuum_count0n_tup_del0autovacuum_count0n_tup_hot_upd0analyze_count0n_live_tup0autoanalyze_count0 ColumnsNameTypeLengthDefault valueNullableCommentidinteger-1nextval('positions_id_seq'::regclass)Falseaffiliation_idinteger-1Falseabbreviationcharacter varying100False IndexesName (scan, tup_read, tup_fetch)PrimaryUniqueClusteredSizeDefinitionidx_fk_pos_aff_id__aff_id (0, 0, 0)FalseFalseFalse16.0 KBbtree (affiliation_id)positions_id_key (0, 0, 0)FalseTrueFalse16.0 KBbtree (id)idx_positions_1 (0, 0, 0)FalseFalseFalse16.0 KBbtree (abbreviation) Unique ConstraintsNameColumns Commentpositions_id_keyid Foreign KeysNameKeys Reference tableReference keysfk_pos_aff_id__aff_idaffiliation_idaffiliationsid157 Foreign KeysNameKeys Reference tableReference keys158Table - public > publishers Table PropertiesPropertyValuePropertyValueTotal size40.0 KBOID25227Table size8.0 KBOwnerpostgresIndexes size32.0 KBTablespacepg_defaultToast size0 bytesPrimary key(s)Estimated rows1Comment Table Statisticsseq_scan0n_dead_tup0seq_tup_read0last_vacuum-idx_scan0last_autocvacuum-idx_tup_fetch0last_analyze-n_tup_ins0last_autoanalyze-n_tup_upd0vacuum_count0n_tup_del0autovacuum_count0n_tup_hot_upd0analyze_count0n_live_tup0autoanalyze_count0 ColumnsNameTypeLengthDefault valueNullableCommentidinteger-1nextval('publishers_id_seq'::regclass)Falsepublisher_keycharacter varying100Falsepublisher_namecharacter varying100True IndexesName (scan, tup_read, tup_fetch)PrimaryUniqueClusteredSizeDefinitionidx_publishers_1 (0, 0, 0)FalseFalseFalse16.0 KBbtree (publisher_key)publishers_id_key (0, 0, 0)FalseTrueFalse16.0 KBbtree (id) Unique ConstraintsNameColumns Commentpublishers_id_keyid159Table - public > roles Table PropertiesPropertyValuePropertyValueTotal size16.0 KBOID25233Table size0 bytesOwnerpostgresIndexes size16.0 KBTablespacepg_defaultToast size0 bytesPrimary key(s)Estimated rows0Comment Table Statisticsseq_scan0n_dead_tup0seq_tup_read0last_vacuum-idx_scan0last_autocvacuum-idx_tup_fetch0last_analyze-n_tup_ins0last_autoanalyze-n_tup_upd0vacuum_count0n_tup_del0autovacuum_count0n_tup_hot_upd0analyze_count0n_live_tup0autoanalyze_count0 ColumnsNameTypeLengthDefault valueNullableCommentidinteger-1nextval('roles_id_seq'::regclass)Falserole_keycharacter varying100Falserole_namecharacter varying100Truecommentcharacter varying100True IndexesName (scan, tup_read, tup_fetch)PrimaryUniqueClusteredSizeDefinitionidx_roles_1 (0, 0, 0)FalseFalseFalse8.0 KBbtree (role_key)roles_id_key (0, 0, 0)FalseTrueFalse8.0 KBbtree (id) Unique ConstraintsNameColumns Commentroles_id_keyid160Table - public > seasons Table PropertiesPropertyValuePropertyValueTotal size72.0 KBOID25239Table size8.0 KBOwnerpostgresIndexes size64.0 KBTablespacepg_defaultToast size0 bytesPrimary key(s)Estimated rows4Comment Table Statisticsseq_scan0n_dead_tup0seq_tup_read0last_vacuum-idx_scan0last_autocvacuum-idx_tup_fetch0last_analyze-n_tup_ins0last_autoanalyze-n_tup_upd0vacuum_count0n_tup_del0autovacuum_count0n_tup_hot_upd0analyze_count0n_live_tup0autoanalyze_count0 ColumnsNameTypeLengthDefault valueNullableCommentidinteger-1nextval('seasons_id_seq'::regclass)Falseseason_keyinteger-1Falsepublisher_idinteger-1Falseleague_idinteger-1Falsestart_date_timetimestamp without time zone-1Trueend_date_timetimestamp without time zone-1True IndexesName (scan, tup_read, tup_fetch)PrimaryUniqueClusteredSizeDefinitionidx_fk_sea_pub_id__pub_id (0, 0, 0)FalseFalseFalse16.0 KBbtree (publisher_id)idx_seasons_1 (0, 0, 0)FalseFalseFalse16.0 KBbtree (season_key)seasons_id_key (0, 0, 0)FalseTrueFalse16.0 KBbtree (id)idx_fk_sea_lea_id__aff_id (0, 0, 0)FalseFalseFalse16.0 KBbtree (league_id) Unique ConstraintsNameColumns Commentseasons_id_keyid161 Unique ConstraintsNameColumns Comment Foreign KeysNameKeys Reference tableReference keysfk_sea_lea_id__aff_idleague_idaffiliationsidfk_sea_pub_id__pub_idpublisher_idpublishersid162Table - public > sites Table PropertiesPropertyValuePropertyValueTotal size32.0 KBOID25245Table size0 bytesOwnerpostgresIndexes size32.0 KBTablespacepg_defaultToast size0 bytesPrimary key(s)Estimated rows0Comment Table Statisticsseq_scan0n_dead_tup0seq_tup_read0last_vacuum-idx_scan0last_autocvacuum-idx_tup_fetch0last_analyze-n_tup_ins0last_autoanalyze-n_tup_upd0vacuum_count0n_tup_del0autovacuum_count0n_tup_hot_upd0analyze_count0n_live_tup0autoanalyze_count0 ColumnsNameTypeLengthDefault valueNullableCommentidinteger-1nextval('sites_id_seq'::regclass)Falsesite_keyinteger-1Falsepublisher_idinteger-1Falselocation_idinteger-1True IndexesName (scan, tup_read, tup_fetch)PrimaryUniqueClusteredSizeDefinitionsites_id_key (0, 0, 0)FalseTrueFalse8.0 KBbtree (id)idx_fk_sit_pub_id__pub_id (0, 0, 0)FalseFalseFalse8.0 KBbtree (publisher_id)idx_sites_1 (0, 0, 0)FalseFalseFalse8.0 KBbtree (site_key)idx_fk_sit_loc_id__loc_id (0, 0, 0)FalseFalseFalse8.0 KBbtree (location_id) Unique ConstraintsNameColumns Commentsites_id_keyid163 Foreign KeysNameKeys Reference tableReference keysfk_sit_loc_id__loc_idlocation_idlocationsidfk_sit_pub_id__pub_idpublisher_idpublishersid164Table - public > soccer_defensive_stats Table PropertiesPropertyValuePropertyValueTotal size16.0 KBOID25251Table size0 bytesOwnerpostgresIndexes size8.0 KBTablespacepg_defaultToast size8.0 KBPrimary key(s)Estimated rows0Comment Table Statisticsseq_scan0n_dead_tup0seq_tup_read0last_vacuum-idx_scan0last_autocvacuum-idx_tup_fetch0last_analyze-n_tup_ins0last_autoanalyze-n_tup_upd0vacuum_count0n_tup_del0autovacuum_count0n_tup_hot_upd0analyze_count0n_live_tup0autoanalyze_count0 ColumnsNameTypeLengthDefault valueNullableCommentidinteger-1nextval('soccer_defensive_stats_id_seq'::regclass)Falseshots_penalty_shot_allowedcharacter varying100Truegoals_penalty_shot_allowedcharacter varying100Truegoals_against_averagecharacter varying100Truegoals_against_totalcharacter varying100Truesavescharacter varying100Truesave_percentagecharacter varying100Truecatches_punchescharacter varying100Trueshots_on_goal_totalcharacter varying100Trueshots_shootout_totalcharacter varying100Trueshots_shootout_allowedcharacter varying100Trueshots_blockedcharacter varying100Trueshutoutscharacter varying100True165 IndexesName (scan, tup_read, tup_fetch)PrimaryUniqueClusteredSizeDefinitionsoccer_defensive_stats_id_key (0, 0, 0)FalseTrueFalse8.0 KBbtree (id) Unique ConstraintsNameColumns Commentsoccer_defensive_stats_id_keyid166Table - public > soccer_event_states Table PropertiesPropertyValuePropertyValueTotal size24.0 KBOID25260Table size0 bytesOwnerpostgresIndexes size16.0 KBTablespacepg_defaultToast size8.0 KBPrimary key(s)Estimated rows0Comment Table Statisticsseq_scan0n_dead_tup0seq_tup_read0last_vacuum-idx_scan0last_autocvacuum-idx_tup_fetch0last_analyze-n_tup_ins0last_autoanalyze-n_tup_upd0vacuum_count0n_tup_del0autovacuum_count0n_tup_hot_upd0analyze_count0n_live_tup0autoanalyze_count0 ColumnsNameTypeLengthDefault valueNullableCommentidinteger-1nextval('soccer_event_states_id_seq'::regclass)Falseevent_idinteger-1Falsecurrent_stateinteger-1Truesequence_numberinteger-1Trueperiod_valuecharacter varying100Trueperiod_time_elapsedcharacter varying100Trueperiod_time_remainingcharacter varying100Trueminutes_elapsedcharacter varying100Trueperiod_minute_elapsedcharacter varying100Truecontextcharacter varying40True IndexesName (scan, tup_read, tup_fetch)PrimaryUniqueClusteredSizeDefinitionsoccer_event_states_id_key (0, 0, 0)FalseTrueFalse8.0 KBbtree (id)idx_fk_events_soccer_event_states (0, 0, 0)FalseFalseFalse8.0 KBbtree (event_id)167 IndexesName (scan, tup_read, tup_fetch)PrimaryUniqueClusteredSizeDefinition Unique ConstraintsNameColumns Commentsoccer_event_states_id_keyid Foreign KeysNameKeys Reference tableReference keysfk_soc_eve_sta_eve_id__eve_idevent_ideventsid168Table - public > soccer_foul_stats Table PropertiesPropertyValuePropertyValueTotal size16.0 KBOID25269Table size0 bytesOwnerpostgresIndexes size8.0 KBTablespacepg_defaultToast size8.0 KBPrimary key(s)Estimated rows0Comment Table Statisticsseq_scan0n_dead_tup0seq_tup_read0last_vacuum-idx_scan0last_autocvacuum-idx_tup_fetch0last_analyze-n_tup_ins0last_autoanalyze-n_tup_upd0vacuum_count0n_tup_del0autovacuum_count0n_tup_hot_upd0analyze_count0n_live_tup0autoanalyze_count0 ColumnsNameTypeLengthDefault valueNullableCommentidinteger-1nextval('soccer_foul_stats_id_seq'::regclass)Falsefouls_sufferedcharacter varying100Truefouls_commitedcharacter varying100Truecautions_totalcharacter varying100Truecautions_pendingcharacter varying100Truecaution_points_totalcharacter varying100Truecaution_points_pendingcharacter varying100Trueejections_totalcharacter varying100True IndexesName (scan, tup_read, tup_fetch)PrimaryUniqueClusteredSizeDefinitionsoccer_foul_stats_id_key (0, 0, 0)FalseTrueFalse8.0 KBbtree (id) Unique ConstraintsNameColumns Commentsoccer_foul_stats_id_keyid169 Unique ConstraintsNameColumns Comment170Table - public > soccer_offensive_stats Table PropertiesPropertyValuePropertyValueTotal size16.0 KBOID25278Table size0 bytesOwnerpostgresIndexes size8.0 KBTablespacepg_defaultToast size8.0 KBPrimary key(s)Estimated rows0Comment Table Statisticsseq_scan0n_dead_tup0seq_tup_read0last_vacuum-idx_scan0last_autocvacuum-idx_tup_fetch0last_analyze-n_tup_ins0last_autoanalyze-n_tup_upd0vacuum_count0n_tup_del0autovacuum_count0n_tup_hot_upd0analyze_count0n_live_tup0autoanalyze_count0 ColumnsNameTypeLengthDefault valueNullableCommentidinteger-1nextval('soccer_offensive_stats_id_seq'::regclass)Falsegoals_game_winningcharacter varying100Truegoals_game_tyingcharacter varying100Truegoals_overtimecharacter varying100Truegoals_shootoutcharacter varying100Truegoals_totalcharacter varying100Trueassists_game_winningcharacter varying100Trueassists_game_tyingcharacter varying100Trueassists_overtimecharacter varying100Trueassists_totalcharacter varying100Truepointscharacter varying100Trueshots_totalcharacter varying100Trueshots_on_goal_totalcharacter varying100Trueshots_hit_framecharacter varying100Trueshots_penalty_shot_takencharacter varying100Trueshots_penalty_shot_scoredcharacter varying100True171 ColumnsNameTypeLengthDefault valueNullableCommentshots_penalty_shot_missedcharacter varying40Trueshots_penalty_shot_percentagecharacter varying40Trueshots_shootout_takencharacter varying40Trueshots_shootout_scoredcharacter varying40Trueshots_shootout_missedcharacter varying40Trueshots_shootout_percentagecharacter varying40Truegiveawayscharacter varying40Trueoffsidescharacter varying40Truecorner_kickscharacter varying40Truehat_trickscharacter varying40True IndexesName (scan, tup_read, tup_fetch)PrimaryUniqueClusteredSizeDefinitionsoccer_offensive_stats_id_key (0, 0, 0)FalseTrueFalse8.0 KBbtree (id) Unique ConstraintsNameColumns Commentsoccer_offensive_stats_id_keyid172Table - public > sportsdb_table Table PropertiesPropertyValuePropertyValueTotal size8.0 KBOID178383Table size8.0 KBOwnerpostgresIndexes size0 bytesTablespacepg_defaultToast size0 bytesPrimary key(s)Estimated rows0Comment Table Statisticsseq_scan0n_dead_tup0seq_tup_read0last_vacuum-idx_scan0last_autocvacuum-idx_tup_fetch0last_analyze-n_tup_ins0last_autoanalyze-n_tup_upd0vacuum_count0n_tup_del0autovacuum_count0n_tup_hot_upd0analyze_count0n_live_tup0autoanalyze_count0 ColumnsNameTypeLengthDefault valueNullableCommentcol1integer-1Truecol2integer-1True173Table - public > standing_subgroups Table PropertiesPropertyValuePropertyValueTotal size8.0 KBOID25287Table size0 bytesOwnerpostgresIndexes size8.0 KBTablespacepg_defaultToast size0 bytesPrimary key(s)Estimated rows0Comment Table Statisticsseq_scan0n_dead_tup0seq_tup_read0last_vacuum-idx_scan0last_autocvacuum-idx_tup_fetch0last_analyze-n_tup_ins0last_autoanalyze-n_tup_upd0vacuum_count0n_tup_del0autovacuum_count0n_tup_hot_upd0analyze_count0n_live_tup0autoanalyze_count0 ColumnsNameTypeLengthDefault valueNullableCommentidinteger-1nextval('standing_subgroups_id_seq'::regclass)Falsestanding_idinteger-1Falseaffiliation_idinteger-1False IndexesName (scan, tup_read, tup_fetch)PrimaryUniqueClusteredSizeDefinitionstanding_subgroups_id_key (0, 0, 0)FalseTrueFalse8.0 KBbtree (id) Unique ConstraintsNameColumns Commentstanding_subgroups_id_keyid Foreign KeysNameKeys Reference tableReference keysfk_sta_sub_sta_id__sta_idstanding_idstandingsidfk_sta_sub_aff_id__aff_idaffiliation_idaffiliationsid174Table - public > standings Table PropertiesPropertyValuePropertyValueTotal size16.0 KBOID25293Table size0 bytesOwnerpostgresIndexes size8.0 KBTablespacepg_defaultToast size8.0 KBPrimary key(s)Estimated rows0Comment Table Statisticsseq_scan0n_dead_tup0seq_tup_read0last_vacuum-idx_scan0last_autocvacuum-idx_tup_fetch0last_analyze-n_tup_ins0last_autoanalyze-n_tup_upd0vacuum_count0n_tup_del0autovacuum_count0n_tup_hot_upd0analyze_count0n_live_tup0autoanalyze_count0 ColumnsNameTypeLengthDefault valueNullableCommentidinteger-1nextval('standings_id_seq'::regclass)Falseaffiliation_idinteger-1Falsestanding_typecharacter varying100Truesub_season_idinteger-1Falselast_updatedcharacter varying100Trueduration_scopecharacter varying100Truecompetition_scopecharacter varying100Truecompetition_scope_idcharacter varying100Truealignment_scopecharacter varying100Truesite_scopecharacter varying100Truescoping_labelcharacter varying100Truepublisher_idinteger-1Falsesourcecharacter varying100True IndexesName (scan, tup_read, tup_fetch)PrimaryUniqueClusteredSizeDefinitionstandings_id_key (0, 0, 0)FalseTrueFalse8.0 KBbtree (id)175 Unique ConstraintsNameColumns Commentstandings_id_keyid Foreign KeysNameKeys Reference tableReference keysfk_sta_pub_id__pub_idpublisher_idpublishersidfk_sta_aff_id__aff_idaffiliation_idaffiliationsidfk_sta_sub_sea_id__sub_sea_idsub_season_idsub_seasonsid176Table - public > stats Table PropertiesPropertyValuePropertyValueTotal size3.031 MBOID25302Table size984.0 KBOwnerpostgresIndexes size2.07 MBTablespacepg_defaultToast size0 bytesPrimary key(s)Estimated rows9398Comment Table Statisticsseq_scan0n_dead_tup0seq_tup_read0last_vacuum-idx_scan0last_autocvacuum-idx_tup_fetch0last_analyze-n_tup_ins0last_autoanalyze-n_tup_upd0vacuum_count0n_tup_del0autovacuum_count0n_tup_hot_upd0analyze_count0n_live_tup0autoanalyze_count0 ColumnsNameTypeLengthDefault valueNullableCommentidinteger-1nextval('stats_id_seq'::regclass)Falsestat_repository_typecharacter varying100Truestat_repository_idinteger-1Falsestat_holder_typecharacter varying100Truestat_holder_idinteger-1Truestat_coverage_typecharacter varying100Truestat_coverage_idinteger-1Truecontextcharacter varying40False IndexesName (scan, tup_read, tup_fetch)PrimaryUniqueClusteredSizeDefinitionstats_id_key (0, 0, 0)FalseTrueFalse224.0 KBbtree (id)idx_stats_3 (0, 0, 0)FalseFalseFalse224.0 KBbtree (stat_holder_type)idx_stats_2 (0, 0, 0)FalseFalseFalse224.0 KBbtree (stat_repository_id)idx_stats_1 (0, 0, 0)FalseFalseFalse456.0 KBbtree (stat_repository_type)idx_stats_7 (0, 0, 0)FalseFalseFalse272.0 KBbtree (context)177 IndexesName (scan, tup_read, tup_fetch)PrimaryUniqueClusteredSizeDefinition[Index."IndexName"] ([Index."StatIdx_Scan"], [Index."StatIdx_Tup_Read"], [Index."StatIdx_Tup_Fetch"])FalseFalseFalse224.0 KBbtree (stat_coverage_id)idx_stats_5 (0, 0, 0)FalseFalseFalse272.0 KBbtree (stat_coverage_type)idx_stats_4 (0, 0, 0)FalseFalseFalse224.0 KBbtree (stat_holder_id) Unique ConstraintsNameColumns Commentstats_id_keyid178Table - public > sub_periods Table PropertiesPropertyValuePropertyValueTotal size16.0 KBOID25308Table size0 bytesOwnerpostgresIndexes size16.0 KBTablespacepg_defaultToast size0 bytesPrimary key(s)Estimated rows0Comment Table Statisticsseq_scan0n_dead_tup0seq_tup_read0last_vacuum-idx_scan0last_autocvacuum-idx_tup_fetch0last_analyze-n_tup_ins0last_autoanalyze-n_tup_upd0vacuum_count0n_tup_del0autovacuum_count0n_tup_hot_upd0analyze_count0n_live_tup0autoanalyze_count0 ColumnsNameTypeLengthDefault valueNullableCommentidinteger-1nextval('sub_periods_id_seq'::regclass)Falseperiod_idinteger-1Falsesub_period_valuecharacter varying100Truescorecharacter varying100True IndexesName (scan, tup_read, tup_fetch)PrimaryUniqueClusteredSizeDefinitionidx_fk_sub_per_per_id__per_id (0, 0, 0)FalseFalseFalse8.0 KBbtree (period_id)sub_periods_id_key (0, 0, 0)FalseTrueFalse8.0 KBbtree (id) Unique ConstraintsNameColumns Commentsub_periods_id_keyid Foreign KeysNameKeys Reference tableReference keys179 Foreign KeysNameKeys Reference tableReference keysfk_sub_per_per_id__per_idperiod_idperiodsid180Table - public > sub_seasons Table PropertiesPropertyValuePropertyValueTotal size72.0 KBOID25314Table size8.0 KBOwnerpostgresIndexes size64.0 KBTablespacepg_defaultToast size0 bytesPrimary key(s)Estimated rows4Comment Table Statisticsseq_scan0n_dead_tup0seq_tup_read0last_vacuum-idx_scan0last_autocvacuum-idx_tup_fetch0last_analyze-n_tup_ins0last_autoanalyze-n_tup_upd0vacuum_count0n_tup_del0autovacuum_count0n_tup_hot_upd0analyze_count0n_live_tup0autoanalyze_count0 ColumnsNameTypeLengthDefault valueNullableCommentidinteger-1nextval('sub_seasons_id_seq'::regclass)Falsesub_season_keycharacter varying100Falseseason_idinteger-1Falsesub_season_typecharacter varying100Falsestart_date_timetimestamp without time zone-1Trueend_date_timetimestamp without time zone-1True IndexesName (scan, tup_read, tup_fetch)PrimaryUniqueClusteredSizeDefinitionidx_fk_sub_sea_sea_id__sea_id (0, 0, 0)FalseFalseFalse16.0 KBbtree (season_id)sub_seasons_id_key (0, 0, 0)FalseTrueFalse16.0 KBbtree (id)idx_sub_seasons_2 (0, 0, 0)FalseFalseFalse16.0 KBbtree (sub_season_type)idx_sub_seasons_1 (0, 0, 0)FalseFalseFalse16.0 KBbtree (sub_season_key)181 Unique ConstraintsNameColumns Commentsub_seasons_id_keyid Foreign KeysNameKeys Reference tableReference keysfk_sub_sea_sea_id__sea_idseason_idseasonsid182Table - public > team_american_football_stats Table PropertiesPropertyValuePropertyValueTotal size32.0 KBOID25320Table size8.0 KBOwnerpostgresIndexes size16.0 KBTablespacepg_defaultToast size8.0 KBPrimary key(s)Estimated rows26Comment Table Statisticsseq_scan0n_dead_tup0seq_tup_read0last_vacuum-idx_scan0last_autocvacuum-idx_tup_fetch0last_analyze-n_tup_ins0last_autoanalyze-n_tup_upd0vacuum_count0n_tup_del0autovacuum_count0n_tup_hot_upd0analyze_count0n_live_tup0autoanalyze_count0 ColumnsNameTypeLengthDefault valueNullableCommentidinteger-1nextval('team_american_football_stats_id_seq'::regclass)Falseyards_per_attemptcharacter varying100Trueaverage_starting_positioncharacter varying100Truetimeoutscharacter varying100Truetime_of_possessioncharacter varying100Trueturnover_ratiocharacter varying100True IndexesName (scan, tup_read, tup_fetch)PrimaryUniqueClusteredSizeDefinitionteam_american_football_stats_id_key (0, 0, 0)FalseTrueFalse16.0 KBbtree (id) Unique ConstraintsNameColumns Commentteam_american_football_stats_id_keyid183Table - public > team_phases Table PropertiesPropertyValuePropertyValueTotal size80.0 KBOID25329Table size48.0 KBOwnerpostgresIndexes size32.0 KBTablespacepg_defaultToast size0 bytesPrimary key(s)Estimated rows368Comment Table Statisticsseq_scan0n_dead_tup0seq_tup_read0last_vacuum-idx_scan0last_autocvacuum-idx_tup_fetch0last_analyze-n_tup_ins0last_autoanalyze-n_tup_upd0vacuum_count0n_tup_del0autovacuum_count0n_tup_hot_upd0analyze_count0n_live_tup0autoanalyze_count0 ColumnsNameTypeLengthDefault valueNullableCommentidinteger-1nextval('team_phases_id_seq'::regclass)Falseteam_idinteger-1Falsestart_season_idinteger-1Trueend_season_idinteger-1Trueaffiliation_idinteger-1Falsestart_date_timecharacter varying100Trueend_date_timecharacter varying100Truephase_statuscharacter varying40Truerole_idinteger-1True IndexesName (scan, tup_read, tup_fetch)PrimaryUniqueClusteredSizeDefinitionteam_phases_id_key (0, 0, 0)FalseTrueFalse32.0 KBbtree (id) Unique ConstraintsNameColumns Commentteam_phases_id_keyid184 Foreign KeysNameKeys Reference tableReference keysfk_tea_aff_pha_end_sea_id__sea_idend_season_idseasonsidfk_tea_aff_pha_sta_sea_id__sea_idstart_season_idseasonsidfk_tea_aff_pha_tea_id__tea_idteam_idteamsidfk_tea_aff_pha_rol_id__rol_idrole_idrolesidfk_tea_aff_pha_aff_id__aff_idaffiliation_idaffiliationsid185Table - public > teams Table PropertiesPropertyValuePropertyValueTotal size24.0 KBOID25335Table size8.0 KBOwnerpostgresIndexes size16.0 KBTablespacepg_defaultToast size0 bytesPrimary key(s)Estimated rows128Comment Table Statisticsseq_scan0n_dead_tup0seq_tup_read0last_vacuum-idx_scan0last_autocvacuum-idx_tup_fetch0last_analyze-n_tup_ins0last_autoanalyze-n_tup_upd0vacuum_count0n_tup_del0autovacuum_count0n_tup_hot_upd0analyze_count0n_live_tup0autoanalyze_count0 ColumnsNameTypeLengthDefault valueNullableCommentidinteger-1nextval('teams_id_seq'::regclass)Falseteam_keycharacter varying100Falsepublisher_idinteger-1Falsehome_site_idinteger-1True IndexesName (scan, tup_read, tup_fetch)PrimaryUniqueClusteredSizeDefinitionteams_id_key (0, 0, 0)FalseTrueFalse16.0 KBbtree (id) Unique ConstraintsNameColumns Commentteams_id_keyid Foreign KeysNameKeys Reference tableReference keysfk_tea_hom_sit_id__sit_idhome_site_idsitesidfk_tea_pub_id__pub_idpublisher_idpublishersid186 Foreign KeysNameKeys Reference tableReference keys187Table - public > teams_documents Table PropertiesPropertyValuePropertyValueTotal size40.0 KBOID25339Table size40.0 KBOwnerpostgresIndexes size0 bytesTablespacepg_defaultToast size0 bytesPrimary key(s)Estimated rows0Comment Table Statisticsseq_scan0n_dead_tup0seq_tup_read0last_vacuum-idx_scan0last_autocvacuum-idx_tup_fetch0last_analyze-n_tup_ins0last_autoanalyze-n_tup_upd0vacuum_count0n_tup_del0autovacuum_count0n_tup_hot_upd0analyze_count0n_live_tup0autoanalyze_count0 ColumnsNameTypeLengthDefault valueNullableCommentteam_idinteger-1Falsedocument_idinteger-1False Foreign KeysNameKeys Reference tableReference keysfk_tea_doc_doc_id__doc_iddocument_iddocumentsidfk_tea_doc_tea_id__tea_idteam_idteamsid188Table - public > teams_media Table PropertiesPropertyValuePropertyValueTotal size0 bytesOID25342Table size0 bytesOwnerpostgresIndexes size0 bytesTablespacepg_defaultToast size0 bytesPrimary key(s)Estimated rows0Comment Table Statisticsseq_scan0n_dead_tup0seq_tup_read0last_vacuum-idx_scan0last_autocvacuum-idx_tup_fetch0last_analyze-n_tup_ins0last_autoanalyze-n_tup_upd0vacuum_count0n_tup_del0autovacuum_count0n_tup_hot_upd0analyze_count0n_live_tup0autoanalyze_count0 ColumnsNameTypeLengthDefault valueNullableCommentteam_idinteger-1Falsemedia_idinteger-1False Foreign KeysNameKeys Reference tableReference keysfk_tea_med_tea_id__tea_idteam_idteamsidfk_tea_med_med_id__med_idmedia_idmediaid189Table - public > tennis_action_points Table PropertiesPropertyValuePropertyValueTotal size8.0 KBOID25347Table size0 bytesOwnerpostgresIndexes size8.0 KBTablespacepg_defaultToast size0 bytesPrimary key(s)Estimated rows0Comment Table Statisticsseq_scan0n_dead_tup0seq_tup_read0last_vacuum-idx_scan0last_autocvacuum-idx_tup_fetch0last_analyze-n_tup_ins0last_autoanalyze-n_tup_upd0vacuum_count0n_tup_del0autovacuum_count0n_tup_hot_upd0analyze_count0n_live_tup0autoanalyze_count0 ColumnsNameTypeLengthDefault valueNullableCommentidinteger-1nextval('tennis_action_points_id_seq'::regclass)Falsesub_period_idcharacter varying100Truesequence_numbercharacter varying100Truewin_typecharacter varying100True IndexesName (scan, tup_read, tup_fetch)PrimaryUniqueClusteredSizeDefinitiontennis_action_points_id_key (0, 0, 0)FalseTrueFalse8.0 KBbtree (id) Unique ConstraintsNameColumns Commenttennis_action_points_id_keyid190Table - public > tennis_action_volleys Table PropertiesPropertyValuePropertyValueTotal size16.0 KBOID25353Table size0 bytesOwnerpostgresIndexes size8.0 KBTablespacepg_defaultToast size8.0 KBPrimary key(s)Estimated rows0Comment Table Statisticsseq_scan0n_dead_tup0seq_tup_read0last_vacuum-idx_scan0last_autocvacuum-idx_tup_fetch0last_analyze-n_tup_ins0last_autoanalyze-n_tup_upd0vacuum_count0n_tup_del0autovacuum_count0n_tup_hot_upd0analyze_count0n_live_tup0autoanalyze_count0 ColumnsNameTypeLengthDefault valueNullableCommentidinteger-1nextval('tennis_action_volleys_id_seq'::regclass)Falsesequence_numbercharacter varying100Truetennis_action_points_idinteger-1Truelanding_locationcharacter varying100Trueswing_typecharacter varying100Trueresultcharacter varying100Truespin_typecharacter varying100Truetrajectory_detailscharacter varying100True IndexesName (scan, tup_read, tup_fetch)PrimaryUniqueClusteredSizeDefinitiontennis_action_volleys_id_key (0, 0, 0)FalseTrueFalse8.0 KBbtree (id) Unique ConstraintsNameColumns Commenttennis_action_volleys_id_keyid191 Unique ConstraintsNameColumns Comment192Table - public > tennis_event_states Table PropertiesPropertyValuePropertyValueTotal size24.0 KBOID25362Table size0 bytesOwnerpostgresIndexes size16.0 KBTablespacepg_defaultToast size8.0 KBPrimary key(s)Estimated rows0Comment Table Statisticsseq_scan0n_dead_tup0seq_tup_read0last_vacuum-idx_scan0last_autocvacuum-idx_tup_fetch0last_analyze-n_tup_ins0last_autoanalyze-n_tup_upd0vacuum_count0n_tup_del0autovacuum_count0n_tup_hot_upd0analyze_count0n_live_tup0autoanalyze_count0 ColumnsNameTypeLengthDefault valueNullableCommentidinteger-1nextval('tennis_event_states_id_seq'::regclass)Falseevent_idinteger-1Falsecurrent_stateinteger-1Truesequence_numberinteger-1Truetennis_setcharacter varying100Truegamecharacter varying100Trueserver_person_idinteger-1Trueserver_scorecharacter varying100Truereceiver_person_idinteger-1Truereceiver_scorecharacter varying100Trueservice_numbercharacter varying100Truecontextcharacter varying40True IndexesName (scan, tup_read, tup_fetch)PrimaryUniqueClusteredSizeDefinitiontennis_event_states_id_key (0, 0, 0)FalseTrueFalse8.0 KBbtree (id)idx_fk_events_tennis_event_states (0, 0, 0)FalseFalseFalse8.0 KBbtree (event_id)193 IndexesName (scan, tup_read, tup_fetch)PrimaryUniqueClusteredSizeDefinition Unique ConstraintsNameColumns Commenttennis_event_states_id_keyid Foreign KeysNameKeys Reference tableReference keysfk_ten_eve_sta_eve_id__eve_idevent_ideventsid194Table - public > tennis_return_stats Table PropertiesPropertyValuePropertyValueTotal size16.0 KBOID25371Table size0 bytesOwnerpostgresIndexes size8.0 KBTablespacepg_defaultToast size8.0 KBPrimary key(s)Estimated rows0Comment Table Statisticsseq_scan0n_dead_tup0seq_tup_read0last_vacuum-idx_scan0last_autocvacuum-idx_tup_fetch0last_analyze-n_tup_ins0last_autoanalyze-n_tup_upd0vacuum_count0n_tup_del0autovacuum_count0n_tup_hot_upd0analyze_count0n_live_tup0autoanalyze_count0 ColumnsNameTypeLengthDefault valueNullableCommentidinteger-1nextval('tennis_return_stats_id_seq'::regclass)Falsereturns_playedcharacter varying100Truematches_playedcharacter varying100Truefirst_service_return_points_woncharacter varying100Truefirst_service_return_points_won_pctcharacter varying100Truesecond_service_return_points_woncharacter varying100Truesecond_service_return_points_won_pctcharacter varying100Truereturn_games_playedcharacter varying100Truereturn_games_woncharacter varying100Truereturn_games_won_pctcharacter varying100Truebreak_points_playedcharacter varying100Truebreak_points_convertedcharacter varying100True195 ColumnsNameTypeLengthDefault valueNullableCommentbreak_points_converted_pctcharacter varying100True IndexesName (scan, tup_read, tup_fetch)PrimaryUniqueClusteredSizeDefinitiontennis_return_stats_id_key (0, 0, 0)FalseTrueFalse8.0 KBbtree (id) Unique ConstraintsNameColumns Commenttennis_return_stats_id_keyid196Table - public > tennis_service_stats Table PropertiesPropertyValuePropertyValueTotal size16.0 KBOID25380Table size0 bytesOwnerpostgresIndexes size8.0 KBTablespacepg_defaultToast size8.0 KBPrimary key(s)Estimated rows0Comment Table Statisticsseq_scan0n_dead_tup0seq_tup_read0last_vacuum-idx_scan0last_autocvacuum-idx_tup_fetch0last_analyze-n_tup_ins0last_autoanalyze-n_tup_upd0vacuum_count0n_tup_del0autovacuum_count0n_tup_hot_upd0analyze_count0n_live_tup0autoanalyze_count0 ColumnsNameTypeLengthDefault valueNullableCommentidinteger-1nextval('tennis_service_stats_id_seq'::regclass)Falseservices_playedcharacter varying100Truematches_playedcharacter varying100Trueacescharacter varying100Truefirst_services_goodcharacter varying100Truefirst_services_good_pctcharacter varying100Truefirst_service_points_woncharacter varying100Truefirst_service_points_won_pctcharacter varying100Truesecond_service_points_woncharacter varying100Truesecond_service_points_won_pctcharacter varying100Trueservice_games_playedcharacter varying100Trueservice_games_woncharacter varying100Trueservice_games_won_pctcharacter varying100True197 ColumnsNameTypeLengthDefault valueNullableCommentbreak_points_playedcharacter varying100Truebreak_points_savedcharacter varying100Truebreak_points_saved_pctcharacter varying100True IndexesName (scan, tup_read, tup_fetch)PrimaryUniqueClusteredSizeDefinitiontennis_service_stats_id_key (0, 0, 0)FalseTrueFalse8.0 KBbtree (id) Unique ConstraintsNameColumns Commenttennis_service_stats_id_keyid198Table - public > wagering_moneylines Table PropertiesPropertyValuePropertyValueTotal size16.0 KBOID25389Table size0 bytesOwnerpostgresIndexes size8.0 KBTablespacepg_defaultToast size8.0 KBPrimary key(s)Estimated rows0Comment Table Statisticsseq_scan0n_dead_tup0seq_tup_read0last_vacuum-idx_scan0last_autocvacuum-idx_tup_fetch0last_analyze-n_tup_ins0last_autoanalyze-n_tup_upd0vacuum_count0n_tup_del0autovacuum_count0n_tup_hot_upd0analyze_count0n_live_tup0autoanalyze_count0 ColumnsNameTypeLengthDefault valueNullableCommentidinteger-1nextval('wagering_moneylines_id_seq'::regclass)Falsebookmaker_idinteger-1Falseevent_idinteger-1Falsedate_timetimestamp without time zone-1Trueteam_idinteger-1Falseperson_idinteger-1Truerotation_keycharacter varying100Truecommentcharacter varying100Truevigorishcharacter varying100Truelinecharacter varying100Trueline_openingcharacter varying100Truepredictioncharacter varying100True IndexesName (scan, tup_read, tup_fetch)PrimaryUniqueClusteredSizeDefinitionwagering_moneylines_id_key (0, 0, 0)FalseTrueFalse8.0 KBbtree (id)199 Unique ConstraintsNameColumns Commentwagering_moneylines_id_keyid Foreign KeysNameKeys Reference tableReference keysfk_wag_mon_eve_id__eve_idevent_ideventsidfk_wag_mon_boo_id__boo_idbookmaker_idbookmakersidfk_wag_mon_tea_id__tea_idteam_idteamsid200Table - public > wagering_odds_lines Table PropertiesPropertyValuePropertyValueTotal size16.0 KBOID25398Table size0 bytesOwnerpostgresIndexes size8.0 KBTablespacepg_defaultToast size8.0 KBPrimary key(s)Estimated rows0Comment Table Statisticsseq_scan0n_dead_tup0seq_tup_read0last_vacuum-idx_scan0last_autocvacuum-idx_tup_fetch0last_analyze-n_tup_ins0last_autoanalyze-n_tup_upd0vacuum_count0n_tup_del0autovacuum_count0n_tup_hot_upd0analyze_count0n_live_tup0autoanalyze_count0 ColumnsNameTypeLengthDefault valueNullableCommentidinteger-1nextval('wagering_odds_lines_id_seq'::regclass)Falsebookmaker_idinteger-1Falseevent_idinteger-1Falsedate_timetimestamp without time zone-1Trueteam_idinteger-1Falseperson_idinteger-1Truerotation_keycharacter varying100Truecommentcharacter varying100Truenumeratorcharacter varying100Truedenominatorcharacter varying100Truepredictioncharacter varying100Truepayout_calculationcharacter varying100Truepayout_amountcharacter varying100True IndexesName (scan, tup_read, tup_fetch)PrimaryUniqueClusteredSizeDefinitionwagering_odds_lines_id_key (0, 0, 0)FalseTrueFalse8.0 KBbtree (id)201 Unique ConstraintsNameColumns Commentwagering_odds_lines_id_keyid Foreign KeysNameKeys Reference tableReference keysfk_wag_odd_lin_boo_id__boo_idbookmaker_idbookmakersidfk_wag_odd_lin_eve_id__eve_idevent_ideventsidfk_wag_odd_lin_tea_id__tea_idteam_idteamsid202Table - public > wagering_runlines Table PropertiesPropertyValuePropertyValueTotal size16.0 KBOID25407Table size0 bytesOwnerpostgresIndexes size8.0 KBTablespacepg_defaultToast size8.0 KBPrimary key(s)Estimated rows0Comment Table Statisticsseq_scan0n_dead_tup0seq_tup_read0last_vacuum-idx_scan0last_autocvacuum-idx_tup_fetch0last_analyze-n_tup_ins0last_autoanalyze-n_tup_upd0vacuum_count0n_tup_del0autovacuum_count0n_tup_hot_upd0analyze_count0n_live_tup0autoanalyze_count0 ColumnsNameTypeLengthDefault valueNullableCommentidinteger-1nextval('wagering_runlines_id_seq'::regclass)Falsebookmaker_idinteger-1Falseevent_idinteger-1Falsedate_timetimestamp without time zone-1Trueteam_idinteger-1Falseperson_idinteger-1Truerotation_keycharacter varying100Truecommentcharacter varying100Truevigorishcharacter varying100Truelinecharacter varying100Trueline_openingcharacter varying100Trueline_valuecharacter varying100Truepredictioncharacter varying100True IndexesName (scan, tup_read, tup_fetch)PrimaryUniqueClusteredSizeDefinitionwagering_runlines_id_key (0, 0, 0)FalseTrueFalse8.0 KBbtree (id)203 Unique ConstraintsNameColumns Commentwagering_runlines_id_keyid Foreign KeysNameKeys Reference tableReference keysfk_wag_run_boo_id__boo_idbookmaker_idbookmakersidfk_wag_run_eve_id__eve_idevent_ideventsidfk_wag_run_tea_id__tea_idteam_idteamsid204Table - public > wagering_straight_spread_lines Table PropertiesPropertyValuePropertyValueTotal size16.0 KBOID25416Table size0 bytesOwnerpostgresIndexes size8.0 KBTablespacepg_defaultToast size8.0 KBPrimary key(s)Estimated rows0Comment Table Statisticsseq_scan0n_dead_tup0seq_tup_read0last_vacuum-idx_scan0last_autocvacuum-idx_tup_fetch0last_analyze-n_tup_ins0last_autoanalyze-n_tup_upd0vacuum_count0n_tup_del0autovacuum_count0n_tup_hot_upd0analyze_count0n_live_tup0autoanalyze_count0 ColumnsNameTypeLengthDefault valueNullableCommentidinteger-1nextval('wagering_straight_spread_lines_id_seq'::regclass)Falsebookmaker_idinteger-1Falseevent_idinteger-1Falsedate_timetimestamp without time zone-1Trueteam_idinteger-1Falseperson_idinteger-1Truerotation_keycharacter varying100Truecommentcharacter varying100Truevigorishcharacter varying100Trueline_valuecharacter varying100Trueline_value_openingcharacter varying100Truepredictioncharacter varying100True IndexesName (scan, tup_read, tup_fetch)PrimaryUniqueClusteredSizeDefinitionwagering_straight_spread_lines_id_key (0, 0, 0)FalseTrueFalse8.0 KBbtree (id)205 Unique ConstraintsNameColumns Commentwagering_straight_spread_lines_id_keyid Foreign KeysNameKeys Reference tableReference keysfk_wag_str_spr_lin_boo_id__boo_idbookmaker_idbookmakersidfk_wag_str_spr_lin_eve_id__eve_idevent_ideventsidfk_wag_str_spr_lin_tea_id__tea_idteam_idteamsid206Table - public > wagering_total_score_lines Table PropertiesPropertyValuePropertyValueTotal size16.0 KBOID25425Table size0 bytesOwnerpostgresIndexes size8.0 KBTablespacepg_defaultToast size8.0 KBPrimary key(s)Estimated rows0Comment Table Statisticsseq_scan0n_dead_tup0seq_tup_read0last_vacuum-idx_scan0last_autocvacuum-idx_tup_fetch0last_analyze-n_tup_ins0last_autoanalyze-n_tup_upd0vacuum_count0n_tup_del0autovacuum_count0n_tup_hot_upd0analyze_count0n_live_tup0autoanalyze_count0 ColumnsNameTypeLengthDefault valueNullableCommentidinteger-1nextval('wagering_total_score_lines_id_seq'::regclass)Falsebookmaker_idinteger-1Falseevent_idinteger-1Falsedate_timetimestamp without time zone-1Trueteam_idinteger-1Falseperson_idinteger-1Truerotation_keycharacter varying100Truecommentcharacter varying100Truevigorishcharacter varying100Trueline_overcharacter varying100Trueline_undercharacter varying100Truetotalcharacter varying100Truetotal_openingcharacter varying100Truepredictioncharacter varying100True IndexesName (scan, tup_read, tup_fetch)PrimaryUniqueClusteredSizeDefinitionwagering_total_score_lines_id_key (0, 0, 0)FalseTrueFalse8.0 KBbtree (id)207 IndexesName (scan, tup_read, tup_fetch)PrimaryUniqueClusteredSizeDefinition Unique ConstraintsNameColumns Commentwagering_total_score_lines_id_keyid Foreign KeysNameKeys Reference tableReference keysfk_wag_tot_sco_lin_boo_id__boo_idbookmaker_idbookmakersidfk_wag_tot_sco_lin_eve_id__eve_idevent_ideventsidfk_wag_tot_sco_lin_tea_id__tea_idteam_idteamsid208Table - public > weather_conditions Table PropertiesPropertyValuePropertyValueTotal size24.0 KBOID25434Table size0 bytesOwnerpostgresIndexes size16.0 KBTablespacepg_defaultToast size8.0 KBPrimary key(s)Estimated rows0Comment Table Statisticsseq_scan0n_dead_tup0seq_tup_read0last_vacuum-idx_scan0last_autocvacuum-idx_tup_fetch0last_analyze-n_tup_ins0last_autoanalyze-n_tup_upd0vacuum_count0n_tup_del0autovacuum_count0n_tup_hot_upd0analyze_count0n_live_tup0autoanalyze_count0 ColumnsNameTypeLengthDefault valueNullableCommentidinteger-1nextval('weather_conditions_id_seq'::regclass)Falseevent_idinteger-1Falsetemperaturecharacter varying100Truetemperature_unitscharacter varying40Truehumiditycharacter varying100Truecloudscharacter varying100Truewind_directioncharacter varying100Truewind_velocitycharacter varying100Trueweather_codecharacter varying100True IndexesName (scan, tup_read, tup_fetch)PrimaryUniqueClusteredSizeDefinitionweather_conditions_id_key (0, 0, 0)FalseTrueFalse8.0 KBbtree (id)idx_fk_wea_con_eve_id__eve_id (0, 0, 0)FalseFalseFalse8.0 KBbtree (event_id) Unique ConstraintsNameColumns Comment209 Unique ConstraintsNameColumns Commentweather_conditions_id_keyid Foreign KeysNameKeys Reference tableReference keysfk_wea_con_eve_id__eve_idevent_ideventsid210public schema: Domains (1)NameOIDOwnerValueprimary_id24689postgres211Domain - public > primary_id Domain PropertiesPropertyValueOID24689OwnerpostgresConstraint nameDefault valueCommentDefinition212public schema: Sequences (97)NameOIDOwnerValueaddresses_id_seq24690postgres2affiliation_phases_id_seq24699postgres75affiliations_id_seq24705postgres29american_football_action_participants_id_seq24720postgres293american_football_action_plays_id_seq24726postgres179american_football_defensive_stats_id_seq24735postgres751american_football_down_progress_stats_id_seq24744postgres36american_football_event_states_id_seq24753postgres249american_football_fumbles_stats_id_seq24759postgres121american_football_offensive_stats_id_seq24768postgres36american_football_passing_stats_id_seq24777postgres301american_football_penalties_stats_id_seq24786postgres36american_football_rushing_stats_id_seq24792postgres175american_football_sacks_against_stats_id_seq24801postgres77american_football_scoring_stats_id_seq24807postgres842american_football_special_teams_stats_id_seq24816postgres142attachments_id_seq178389postgres14baseball_action_contact_details_id_seq24825postgres1baseball_action_pitches_id_seq24834postgres1baseball_action_plays_id_seq24843postgres17baseball_action_substitutions_id_seq24852postgres1baseball_defensive_group_id_seq24858postgres1baseball_defensive_players_id_seq24864postgres1baseball_defensive_stats_id_seq24870postgres1724baseball_event_states_id_seq24879postgres17baseball_offensive_stats_id_seq24885postgres1724baseball_pitching_stats_id_seq24894postgres852basketball_defensive_stats_id_seq24903postgres164basketball_event_states_id_seq24909postgres1basketball_offensive_stats_id_seq24915postgres164basketball_rebounding_stats_id_seq24924postgres164basketball_team_stats_id_seq24933postgres1bookmakers_id_seq24939postgres1core_person_stats_id_seq24945postgres2588core_stats_id_seq24951postgres1213public schema: Sequences (97)NameOIDOwnerValuedisplay_names_id_seq24964postgres3958document_classes_id_seq24973postgres6document_contents_id_seq24979postgres414document_fixtures_events_id_seq24994postgres7915document_fixtures_id_seq24988postgres12document_package_entry_id_seq25000postgres1document_packages_id_seq25006postgres1documents_id_seq25012postgres414documents_media_id_seq25021postgres1events_id_seq25027postgres4350ice_hockey_action_participants_id_seq25045postgres199ice_hockey_action_plays_id_seq25051postgres51ice_hockey_defensive_stats_id_seq25060postgres94ice_hockey_event_states_id_seq25069postgres51ice_hockey_offensive_stats_id_seq25075postgres1112ice_hockey_player_stats_id_seq25084postgres1072injury_phases_id_seq25090postgres771key_aliases_id_seq25099postgres1key_roots_id_seq25105postgres1latest_revisions_id_seq25111postgres295locations_id_seq25117postgres1media_captions_id_seq25129postgres1media_contents_id_seq25135postgres1media_id_seq25123postgres1media_keywords_id_seq25144postgres1motor_racing_event_states_id_seq25150postgres1motor_racing_qualifying_stats_id_seq25156postgres1motor_racing_race_stats_id_seq25165postgres1outcome_totals_id_seq25174postgres1participants_events_id_seq25183postgres8700periods_id_seq25189postgres548person_event_metadata_id_seq25195postgres4002person_phases_id_seq25201postgres1persons_id_seq25207postgres3937positions_id_seq25219postgres73214public schema: Sequences (97)NameOIDOwnerValuepublishers_id_seq25225postgres1roles_id_seq25231postgres1seasons_id_seq25237postgres4sites_id_seq25243postgres1soccer_defensive_stats_id_seq25249postgres1soccer_event_states_id_seq25258postgres1soccer_foul_stats_id_seq25267postgres1soccer_offensive_stats_id_seq25276postgres1standing_subgroups_id_seq25285postgres1standings_id_seq25291postgres1stats_id_seq25300postgres12211sub_periods_id_seq25306postgres1sub_seasons_id_seq25312postgres4team_american_football_stats_id_seq25318postgres36team_phases_id_seq25327postgres368teams_id_seq25333postgres128tennis_action_points_id_seq25345postgres1tennis_action_volleys_id_seq25351postgres1tennis_event_states_id_seq25360postgres1tennis_return_stats_id_seq25369postgres1tennis_service_stats_id_seq25378postgres1wagering_moneylines_id_seq25387postgres1wagering_odds_lines_id_seq25396postgres1wagering_runlines_id_seq25405postgres1wagering_straight_spread_lines_id_seq25414postgres1wagering_total_score_lines_id_seq25423postgres1weather_conditions_id_seq25432postgres1215Sequence - public > addresses_id_seq Sequence PropertiesPropertyValueOID24690Increment1OwnerpostgresMinimum value1ACLMaximum value9223372036854775807Current value2Cache value1Comment Columns using this sequenceSchemaTableColumnpublicaddressesid216Sequence - public > affiliation_phases_id_seq Sequence PropertiesPropertyValueOID24699Increment1OwnerpostgresMinimum value1ACLMaximum value9223372036854775807Current value75Cache value1Comment Columns using this sequenceSchemaTableColumnpublicaffiliation_phasesid217Sequence - public > affiliations_id_seq Sequence PropertiesPropertyValueOID24705Increment1OwnerpostgresMinimum value1ACLMaximum value9223372036854775807Current value29Cache value1Comment Columns using this sequenceSchemaTableColumnpublicaffiliationsid218Sequence - public > american_football_action_participants_id_seq Sequence PropertiesPropertyValueOID24720Increment1OwnerpostgresMinimum value1ACLMaximum value9223372036854775807Current value293Cache value1Comment Columns using this sequenceSchemaTableColumnpublicamerican_football_action_participantsid219Sequence - public > american_football_action_plays_id_seq Sequence PropertiesPropertyValueOID24726Increment1OwnerpostgresMinimum value1ACLMaximum value9223372036854775807Current value179Cache value1Comment Columns using this sequenceSchemaTableColumnpublicamerican_football_action_playsid220Sequence - public > american_football_defensive_stats_id_seq Sequence PropertiesPropertyValueOID24735Increment1OwnerpostgresMinimum value1ACLMaximum value9223372036854775807Current value751Cache value1Comment Columns using this sequenceSchemaTableColumnpublicamerican_football_defensive_statsid221Sequence - public > american_football_down_progress_stats_id_seq Sequence PropertiesPropertyValueOID24744Increment1OwnerpostgresMinimum value1ACLMaximum value9223372036854775807Current value36Cache value1Comment Columns using this sequenceSchemaTableColumnpublicamerican_football_down_progress_statsid222Sequence - public > american_football_event_states_id_seq Sequence PropertiesPropertyValueOID24753Increment1OwnerpostgresMinimum value1ACLMaximum value9223372036854775807Current value249Cache value1Comment Columns using this sequenceSchemaTableColumnpublicamerican_football_event_statesid223Sequence - public > american_football_fumbles_stats_id_seq Sequence PropertiesPropertyValueOID24759Increment1OwnerpostgresMinimum value1ACLMaximum value9223372036854775807Current value121Cache value1Comment Columns using this sequenceSchemaTableColumnpublicamerican_football_fumbles_statsid224Sequence - public > american_football_offensive_stats_id_seq Sequence PropertiesPropertyValueOID24768Increment1OwnerpostgresMinimum value1ACLMaximum value9223372036854775807Current value36Cache value1Comment Columns using this sequenceSchemaTableColumnpublicamerican_football_offensive_statsid225Sequence - public > american_football_passing_stats_id_seq Sequence PropertiesPropertyValueOID24777Increment1OwnerpostgresMinimum value1ACLMaximum value9223372036854775807Current value301Cache value1Comment Columns using this sequenceSchemaTableColumnpublicamerican_football_passing_statsid226Sequence - public > american_football_penalties_stats_id_seq Sequence PropertiesPropertyValueOID24786Increment1OwnerpostgresMinimum value1ACLMaximum value9223372036854775807Current value36Cache value1Comment Columns using this sequenceSchemaTableColumnpublicamerican_football_penalties_statsid227Sequence - public > american_football_rushing_stats_id_seq Sequence PropertiesPropertyValueOID24792Increment1OwnerpostgresMinimum value1ACLMaximum value9223372036854775807Current value175Cache value1Comment Columns using this sequenceSchemaTableColumnpublicamerican_football_rushing_statsid228Sequence - public > american_football_sacks_against_stats_id_seq Sequence PropertiesPropertyValueOID24801Increment1OwnerpostgresMinimum value1ACLMaximum value9223372036854775807Current value77Cache value1Comment Columns using this sequenceSchemaTableColumnpublicamerican_football_sacks_against_statsid229Sequence - public > american_football_scoring_stats_id_seq Sequence PropertiesPropertyValueOID24807Increment1OwnerpostgresMinimum value1ACLMaximum value9223372036854775807Current value842Cache value1Comment Columns using this sequenceSchemaTableColumnpublicamerican_football_scoring_statsid230Sequence - public > american_football_special_teams_stats_id_seq Sequence PropertiesPropertyValueOID24816Increment1OwnerpostgresMinimum value1ACLMaximum value9223372036854775807Current value142Cache value1Comment Columns using this sequenceSchemaTableColumnpublicamerican_football_special_teams_statsid231Sequence - public > attachments_id_seq Sequence PropertiesPropertyValueOID178389Increment1OwnerpostgresMinimum value1ACLMaximum value9223372036854775807Current value14Cache value1Comment Columns using this sequenceSchemaTableColumnpublicattachmentsid232Sequence - public > baseball_action_contact_details_id_seq Sequence PropertiesPropertyValueOID24825Increment1OwnerpostgresMinimum value1ACLMaximum value9223372036854775807Current value1Cache value1Comment Columns using this sequenceSchemaTableColumnpublicbaseball_action_contact_detailsid233Sequence - public > baseball_action_pitches_id_seq Sequence PropertiesPropertyValueOID24834Increment1OwnerpostgresMinimum value1ACLMaximum value9223372036854775807Current value1Cache value1Comment Columns using this sequenceSchemaTableColumnpublicbaseball_action_pitchesid234Sequence - public > baseball_action_plays_id_seq Sequence PropertiesPropertyValueOID24843Increment1OwnerpostgresMinimum value1ACLMaximum value9223372036854775807Current value17Cache value1Comment Columns using this sequenceSchemaTableColumnpublicbaseball_action_playsid235Sequence - public > baseball_action_substitutions_id_seq Sequence PropertiesPropertyValueOID24852Increment1OwnerpostgresMinimum value1ACLMaximum value9223372036854775807Current value1Cache value1Comment Columns using this sequenceSchemaTableColumnpublicbaseball_action_substitutionsid236Sequence - public > baseball_defensive_group_id_seq Sequence PropertiesPropertyValueOID24858Increment1OwnerpostgresMinimum value1ACLMaximum value9223372036854775807Current value1Cache value1Comment Columns using this sequenceSchemaTableColumnpublicbaseball_defensive_groupid237Sequence - public > baseball_defensive_players_id_seq Sequence PropertiesPropertyValueOID24864Increment1OwnerpostgresMinimum value1ACLMaximum value9223372036854775807Current value1Cache value1Comment Columns using this sequenceSchemaTableColumnpublicbaseball_defensive_playersid238Sequence - public > baseball_defensive_stats_id_seq Sequence PropertiesPropertyValueOID24870Increment1OwnerpostgresMinimum value1ACLMaximum value9223372036854775807Current value1724Cache value1Comment Columns using this sequenceSchemaTableColumnpublicbaseball_defensive_statsid239Sequence - public > baseball_event_states_id_seq Sequence PropertiesPropertyValueOID24879Increment1OwnerpostgresMinimum value1ACLMaximum value9223372036854775807Current value17Cache value1Comment Columns using this sequenceSchemaTableColumnpublicbaseball_event_statesid240Sequence - public > baseball_offensive_stats_id_seq Sequence PropertiesPropertyValueOID24885Increment1OwnerpostgresMinimum value1ACLMaximum value9223372036854775807Current value1724Cache value1Comment Columns using this sequenceSchemaTableColumnpublicbaseball_offensive_statsid241Sequence - public > baseball_pitching_stats_id_seq Sequence PropertiesPropertyValueOID24894Increment1OwnerpostgresMinimum value1ACLMaximum value9223372036854775807Current value852Cache value1Comment Columns using this sequenceSchemaTableColumnpublicbaseball_pitching_statsid242Sequence - public > basketball_defensive_stats_id_seq Sequence PropertiesPropertyValueOID24903Increment1OwnerpostgresMinimum value1ACLMaximum value9223372036854775807Current value164Cache value1Comment Columns using this sequenceSchemaTableColumnpublicbasketball_defensive_statsid243Sequence - public > basketball_event_states_id_seq Sequence PropertiesPropertyValueOID24909Increment1OwnerpostgresMinimum value1ACLMaximum value9223372036854775807Current value1Cache value1Comment Columns using this sequenceSchemaTableColumnpublicbasketball_event_statesid244Sequence - public > basketball_offensive_stats_id_seq Sequence PropertiesPropertyValueOID24915Increment1OwnerpostgresMinimum value1ACLMaximum value9223372036854775807Current value164Cache value1Comment Columns using this sequenceSchemaTableColumnpublicbasketball_offensive_statsid245Sequence - public > basketball_rebounding_stats_id_seq Sequence PropertiesPropertyValueOID24924Increment1OwnerpostgresMinimum value1ACLMaximum value9223372036854775807Current value164Cache value1Comment Columns using this sequenceSchemaTableColumnpublicbasketball_rebounding_statsid246Sequence - public > basketball_team_stats_id_seq Sequence PropertiesPropertyValueOID24933Increment1OwnerpostgresMinimum value1ACLMaximum value9223372036854775807Current value1Cache value1Comment Columns using this sequenceSchemaTableColumnpublicbasketball_team_statsid247Sequence - public > bookmakers_id_seq Sequence PropertiesPropertyValueOID24939Increment1OwnerpostgresMinimum value1ACLMaximum value9223372036854775807Current value1Cache value1Comment Columns using this sequenceSchemaTableColumnpublicbookmakersid248Sequence - public > core_person_stats_id_seq Sequence PropertiesPropertyValueOID24945Increment1OwnerpostgresMinimum value1ACLMaximum value9223372036854775807Current value2588Cache value1Comment Columns using this sequenceSchemaTableColumnpubliccore_person_statsid249Sequence - public > core_stats_id_seq Sequence PropertiesPropertyValueOID24951Increment1OwnerpostgresMinimum value1ACLMaximum value9223372036854775807Current value1Cache value1Comment Columns using this sequenceSchemaTableColumnpubliccore_statsid250Sequence - public > display_names_id_seq Sequence PropertiesPropertyValueOID24964Increment1OwnerpostgresMinimum value1ACLMaximum value9223372036854775807Current value3958Cache value1Comment Columns using this sequenceSchemaTableColumnpublicdisplay_namesid251Sequence - public > document_classes_id_seq Sequence PropertiesPropertyValueOID24973Increment1OwnerpostgresMinimum value1ACLMaximum value9223372036854775807Current value6Cache value1Comment Columns using this sequenceSchemaTableColumnpublicdocument_classesid252Sequence - public > document_contents_id_seq Sequence PropertiesPropertyValueOID24979Increment1OwnerpostgresMinimum value1ACLMaximum value9223372036854775807Current value414Cache value1Comment Columns using this sequenceSchemaTableColumnpublicdocument_contentsid253Sequence - public > document_fixtures_events_id_seq Sequence PropertiesPropertyValueOID24994Increment1OwnerpostgresMinimum value1ACLMaximum value9223372036854775807Current value7915Cache value1Comment Columns using this sequenceSchemaTableColumnpublicdocument_fixtures_eventsid254Sequence - public > document_fixtures_id_seq Sequence PropertiesPropertyValueOID24988Increment1OwnerpostgresMinimum value1ACLMaximum value9223372036854775807Current value12Cache value1Comment Columns using this sequenceSchemaTableColumnpublicdocument_fixturesid255Sequence - public > document_package_entry_id_seq Sequence PropertiesPropertyValueOID25000Increment1OwnerpostgresMinimum value1ACLMaximum value9223372036854775807Current value1Cache value1Comment Columns using this sequenceSchemaTableColumnpublicdocument_package_entryid256Sequence - public > document_packages_id_seq Sequence PropertiesPropertyValueOID25006Increment1OwnerpostgresMinimum value1ACLMaximum value9223372036854775807Current value1Cache value1Comment Columns using this sequenceSchemaTableColumnpublicdocument_packagesid257Sequence - public > documents_id_seq Sequence PropertiesPropertyValueOID25012Increment1OwnerpostgresMinimum value1ACLMaximum value9223372036854775807Current value414Cache value1Comment Columns using this sequenceSchemaTableColumnpublicdocumentsid258Sequence - public > documents_media_id_seq Sequence PropertiesPropertyValueOID25021Increment1OwnerpostgresMinimum value1ACLMaximum value9223372036854775807Current value1Cache value1Comment Columns using this sequenceSchemaTableColumnpublicdocuments_mediaid259Sequence - public > events_id_seq Sequence PropertiesPropertyValueOID25027Increment1OwnerpostgresMinimum value1ACLMaximum value9223372036854775807Current value4350Cache value1Comment Columns using this sequenceSchemaTableColumnpubliceventsid260Sequence - public > ice_hockey_action_participants_id_seq Sequence PropertiesPropertyValueOID25045Increment1OwnerpostgresMinimum value1ACLMaximum value9223372036854775807Current value199Cache value1Comment Columns using this sequenceSchemaTableColumnpublicice_hockey_action_participantsid261Sequence - public > ice_hockey_action_plays_id_seq Sequence PropertiesPropertyValueOID25051Increment1OwnerpostgresMinimum value1ACLMaximum value9223372036854775807Current value51Cache value1Comment Columns using this sequenceSchemaTableColumnpublicice_hockey_action_playsid262Sequence - public > ice_hockey_defensive_stats_id_seq Sequence PropertiesPropertyValueOID25060Increment1OwnerpostgresMinimum value1ACLMaximum value9223372036854775807Current value94Cache value1Comment Columns using this sequenceSchemaTableColumnpublicice_hockey_defensive_statsid263Sequence - public > ice_hockey_event_states_id_seq Sequence PropertiesPropertyValueOID25069Increment1OwnerpostgresMinimum value1ACLMaximum value9223372036854775807Current value51Cache value1Comment Columns using this sequenceSchemaTableColumnpublicice_hockey_event_statesid264Sequence - public > ice_hockey_offensive_stats_id_seq Sequence PropertiesPropertyValueOID25075Increment1OwnerpostgresMinimum value1ACLMaximum value9223372036854775807Current value1112Cache value1Comment Columns using this sequenceSchemaTableColumnpublicice_hockey_offensive_statsid265Sequence - public > ice_hockey_player_stats_id_seq Sequence PropertiesPropertyValueOID25084Increment1OwnerpostgresMinimum value1ACLMaximum value9223372036854775807Current value1072Cache value1Comment Columns using this sequenceSchemaTableColumnpublicice_hockey_player_statsid266Sequence - public > injury_phases_id_seq Sequence PropertiesPropertyValueOID25090Increment1OwnerpostgresMinimum value1ACLMaximum value9223372036854775807Current value771Cache value1Comment Columns using this sequenceSchemaTableColumnpublicinjury_phasesid267Sequence - public > key_aliases_id_seq Sequence PropertiesPropertyValueOID25099Increment1OwnerpostgresMinimum value1ACLMaximum value9223372036854775807Current value1Cache value1Comment Columns using this sequenceSchemaTableColumnpublickey_aliasesid268Sequence - public > key_roots_id_seq Sequence PropertiesPropertyValueOID25105Increment1OwnerpostgresMinimum value1ACLMaximum value9223372036854775807Current value1Cache value1Comment Columns using this sequenceSchemaTableColumnpublickey_rootsid269Sequence - public > latest_revisions_id_seq Sequence PropertiesPropertyValueOID25111Increment1OwnerpostgresMinimum value1ACLMaximum value9223372036854775807Current value295Cache value1Comment Columns using this sequenceSchemaTableColumnpubliclatest_revisionsid270Sequence - public > locations_id_seq Sequence PropertiesPropertyValueOID25117Increment1OwnerpostgresMinimum value1ACLMaximum value9223372036854775807Current value1Cache value1Comment Columns using this sequenceSchemaTableColumnpubliclocationsid271Sequence - public > media_captions_id_seq Sequence PropertiesPropertyValueOID25129Increment1OwnerpostgresMinimum value1ACLMaximum value9223372036854775807Current value1Cache value1Comment Columns using this sequenceSchemaTableColumnpublicmedia_captionsid272Sequence - public > media_contents_id_seq Sequence PropertiesPropertyValueOID25135Increment1OwnerpostgresMinimum value1ACLMaximum value9223372036854775807Current value1Cache value1Comment Columns using this sequenceSchemaTableColumnpublicmedia_contentsid273Sequence - public > media_id_seq Sequence PropertiesPropertyValueOID25123Increment1OwnerpostgresMinimum value1ACLMaximum value9223372036854775807Current value1Cache value1Comment Columns using this sequenceSchemaTableColumnpublicmediaid274Sequence - public > media_keywords_id_seq Sequence PropertiesPropertyValueOID25144Increment1OwnerpostgresMinimum value1ACLMaximum value9223372036854775807Current value1Cache value1Comment Columns using this sequenceSchemaTableColumnpublicmedia_keywordsid275Sequence - public > motor_racing_event_states_id_seq Sequence PropertiesPropertyValueOID25150Increment1OwnerpostgresMinimum value1ACLMaximum value9223372036854775807Current value1Cache value1Comment Columns using this sequenceSchemaTableColumnpublicmotor_racing_event_statesid276Sequence - public > motor_racing_qualifying_stats_id_seq Sequence PropertiesPropertyValueOID25156Increment1OwnerpostgresMinimum value1ACLMaximum value9223372036854775807Current value1Cache value1Comment Columns using this sequenceSchemaTableColumnpublicmotor_racing_qualifying_statsid277Sequence - public > motor_racing_race_stats_id_seq Sequence PropertiesPropertyValueOID25165Increment1OwnerpostgresMinimum value1ACLMaximum value9223372036854775807Current value1Cache value1Comment Columns using this sequenceSchemaTableColumnpublicmotor_racing_race_statsid278Sequence - public > outcome_totals_id_seq Sequence PropertiesPropertyValueOID25174Increment1OwnerpostgresMinimum value1ACLMaximum value9223372036854775807Current value1Cache value1Comment Columns using this sequenceSchemaTableColumnpublicoutcome_totalsid279Sequence - public > participants_events_id_seq Sequence PropertiesPropertyValueOID25183Increment1OwnerpostgresMinimum value1ACLMaximum value9223372036854775807Current value8700Cache value1Comment Columns using this sequenceSchemaTableColumnpublicparticipants_eventsid280Sequence - public > periods_id_seq Sequence PropertiesPropertyValueOID25189Increment1OwnerpostgresMinimum value1ACLMaximum value9223372036854775807Current value548Cache value1Comment Columns using this sequenceSchemaTableColumnpublicperiodsid281Sequence - public > person_event_metadata_id_seq Sequence PropertiesPropertyValueOID25195Increment1OwnerpostgresMinimum value1ACLMaximum value9223372036854775807Current value4002Cache value1Comment Columns using this sequenceSchemaTableColumnpublicperson_event_metadataid282Sequence - public > person_phases_id_seq Sequence PropertiesPropertyValueOID25201Increment1OwnerpostgresMinimum value1ACLMaximum value9223372036854775807Current value1Cache value1Comment Columns using this sequenceSchemaTableColumnpublicperson_phasesid283Sequence - public > persons_id_seq Sequence PropertiesPropertyValueOID25207Increment1OwnerpostgresMinimum value1ACLMaximum value9223372036854775807Current value3937Cache value1Comment Columns using this sequenceSchemaTableColumnpublicpersonsid284Sequence - public > positions_id_seq Sequence PropertiesPropertyValueOID25219Increment1OwnerpostgresMinimum value1ACLMaximum value9223372036854775807Current value73Cache value1Comment Columns using this sequenceSchemaTableColumnpublicpositionsid285Sequence - public > publishers_id_seq Sequence PropertiesPropertyValueOID25225Increment1OwnerpostgresMinimum value1ACLMaximum value9223372036854775807Current value1Cache value1Comment Columns using this sequenceSchemaTableColumnpublicpublishersid286Sequence - public > roles_id_seq Sequence PropertiesPropertyValueOID25231Increment1OwnerpostgresMinimum value1ACLMaximum value9223372036854775807Current value1Cache value1Comment Columns using this sequenceSchemaTableColumnpublicrolesid287Sequence - public > seasons_id_seq Sequence PropertiesPropertyValueOID25237Increment1OwnerpostgresMinimum value1ACLMaximum value9223372036854775807Current value4Cache value1Comment Columns using this sequenceSchemaTableColumnpublicseasonsid288Sequence - public > sites_id_seq Sequence PropertiesPropertyValueOID25243Increment1OwnerpostgresMinimum value1ACLMaximum value9223372036854775807Current value1Cache value1Comment Columns using this sequenceSchemaTableColumnpublicsitesid289Sequence - public > soccer_defensive_stats_id_seq Sequence PropertiesPropertyValueOID25249Increment1OwnerpostgresMinimum value1ACLMaximum value9223372036854775807Current value1Cache value1Comment Columns using this sequenceSchemaTableColumnpublicsoccer_defensive_statsid290Sequence - public > soccer_event_states_id_seq Sequence PropertiesPropertyValueOID25258Increment1OwnerpostgresMinimum value1ACLMaximum value9223372036854775807Current value1Cache value1Comment Columns using this sequenceSchemaTableColumnpublicsoccer_event_statesid291Sequence - public > soccer_foul_stats_id_seq Sequence PropertiesPropertyValueOID25267Increment1OwnerpostgresMinimum value1ACLMaximum value9223372036854775807Current value1Cache value1Comment Columns using this sequenceSchemaTableColumnpublicsoccer_foul_statsid292Sequence - public > soccer_offensive_stats_id_seq Sequence PropertiesPropertyValueOID25276Increment1OwnerpostgresMinimum value1ACLMaximum value9223372036854775807Current value1Cache value1Comment Columns using this sequenceSchemaTableColumnpublicsoccer_offensive_statsid293Sequence - public > standing_subgroups_id_seq Sequence PropertiesPropertyValueOID25285Increment1OwnerpostgresMinimum value1ACLMaximum value9223372036854775807Current value1Cache value1Comment Columns using this sequenceSchemaTableColumnpublicstanding_subgroupsid294Sequence - public > standings_id_seq Sequence PropertiesPropertyValueOID25291Increment1OwnerpostgresMinimum value1ACLMaximum value9223372036854775807Current value1Cache value1Comment Columns using this sequenceSchemaTableColumnpublicstandingsid295Sequence - public > stats_id_seq Sequence PropertiesPropertyValueOID25300Increment1OwnerpostgresMinimum value1ACLMaximum value9223372036854775807Current value12211Cache value1Comment Columns using this sequenceSchemaTableColumnpublicstatsid296Sequence - public > sub_periods_id_seq Sequence PropertiesPropertyValueOID25306Increment1OwnerpostgresMinimum value1ACLMaximum value9223372036854775807Current value1Cache value1Comment Columns using this sequenceSchemaTableColumnpublicsub_periodsid297Sequence - public > sub_seasons_id_seq Sequence PropertiesPropertyValueOID25312Increment1OwnerpostgresMinimum value1ACLMaximum value9223372036854775807Current value4Cache value1Comment Columns using this sequenceSchemaTableColumnpublicsub_seasonsid298Sequence - public > team_american_football_stats_id_seq Sequence PropertiesPropertyValueOID25318Increment1OwnerpostgresMinimum value1ACLMaximum value9223372036854775807Current value36Cache value1Comment Columns using this sequenceSchemaTableColumnpublicteam_american_football_statsid299Sequence - public > team_phases_id_seq Sequence PropertiesPropertyValueOID25327Increment1OwnerpostgresMinimum value1ACLMaximum value9223372036854775807Current value368Cache value1Comment Columns using this sequenceSchemaTableColumnpublicteam_phasesid300Sequence - public > teams_id_seq Sequence PropertiesPropertyValueOID25333Increment1OwnerpostgresMinimum value1ACLMaximum value9223372036854775807Current value128Cache value1Comment Columns using this sequenceSchemaTableColumnpublicteamsid301Sequence - public > tennis_action_points_id_seq Sequence PropertiesPropertyValueOID25345Increment1OwnerpostgresMinimum value1ACLMaximum value9223372036854775807Current value1Cache value1Comment Columns using this sequenceSchemaTableColumnpublictennis_action_pointsid302Sequence - public > tennis_action_volleys_id_seq Sequence PropertiesPropertyValueOID25351Increment1OwnerpostgresMinimum value1ACLMaximum value9223372036854775807Current value1Cache value1Comment Columns using this sequenceSchemaTableColumnpublictennis_action_volleysid303Sequence - public > tennis_event_states_id_seq Sequence PropertiesPropertyValueOID25360Increment1OwnerpostgresMinimum value1ACLMaximum value9223372036854775807Current value1Cache value1Comment Columns using this sequenceSchemaTableColumnpublictennis_event_statesid304Sequence - public > tennis_return_stats_id_seq Sequence PropertiesPropertyValueOID25369Increment1OwnerpostgresMinimum value1ACLMaximum value9223372036854775807Current value1Cache value1Comment Columns using this sequenceSchemaTableColumnpublictennis_return_statsid305Sequence - public > tennis_service_stats_id_seq Sequence PropertiesPropertyValueOID25378Increment1OwnerpostgresMinimum value1ACLMaximum value9223372036854775807Current value1Cache value1Comment Columns using this sequenceSchemaTableColumnpublictennis_service_statsid306Sequence - public > wagering_moneylines_id_seq Sequence PropertiesPropertyValueOID25387Increment1OwnerpostgresMinimum value1ACLMaximum value9223372036854775807Current value1Cache value1Comment Columns using this sequenceSchemaTableColumnpublicwagering_moneylinesid307Sequence - public > wagering_odds_lines_id_seq Sequence PropertiesPropertyValueOID25396Increment1OwnerpostgresMinimum value1ACLMaximum value9223372036854775807Current value1Cache value1Comment Columns using this sequenceSchemaTableColumnpublicwagering_odds_linesid308Sequence - public > wagering_runlines_id_seq Sequence PropertiesPropertyValueOID25405Increment1OwnerpostgresMinimum value1ACLMaximum value9223372036854775807Current value1Cache value1Comment Columns using this sequenceSchemaTableColumnpublicwagering_runlinesid309Sequence - public > wagering_straight_spread_lines_id_seq Sequence PropertiesPropertyValueOID25414Increment1OwnerpostgresMinimum value1ACLMaximum value9223372036854775807Current value1Cache value1Comment Columns using this sequenceSchemaTableColumnpublicwagering_straight_spread_linesid310Sequence - public > wagering_total_score_lines_id_seq Sequence PropertiesPropertyValueOID25423Increment1OwnerpostgresMinimum value1ACLMaximum value9223372036854775807Current value1Cache value1Comment Columns using this sequenceSchemaTableColumnpublicwagering_total_score_linesid311Sequence - public > weather_conditions_id_seq Sequence PropertiesPropertyValueOID25432Increment1OwnerpostgresMinimum value1ACLMaximum value9223372036854775807Current value1Cache value1Comment Columns using this sequenceSchemaTableColumnpublicweather_conditionsid312 ................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download