Database Properties
Database Type: PostgreSQL - 12.10
Schema public
standard public schema
Tables
Table / View | Children | Parents | Columns | Rows | Type | Comments |
---|---|---|---|---|---|---|
iedakeywords | 0 | 0 | 4 | 63 | Table | unique values for new IEDA keywords, created october 2017. |
funding_source_external_identifier | 0 | 2 | 5 | 0 | Table | |
spatial_ref_sys | 3 | 0 | 5 | 8500 | Table | |
temp_geousers | 0 | 0 | 10 | 4644 | Table | |
bridge_person_num_distinctname | 0 | 1 | 7 | 1070 | Table | |
author_list | 0 | 2 | 4 | 5491 | Table | |
archive_file_checksum | 0 | 1 | 5 | 468 | Table | |
dataset_group | 2 | 0 | 2 | 13 | Table | |
grl_user | 2 | 2 | 13 | 659 | Table | |
person_external_identifier | 2 | 0 | 4 | 4766 | Table | |
data_file_format_system_mapping | 0 | 2 | 3 | 78 | Table | This table lists all allowable data file formats for different dataset group (or system) |
keyword_type | 1 | 0 | 4 | 32 | Table | classifiers for keywords, use to group in user interface facets. |
status | 1 | 0 | 3 | 6 | Table | |
country | 2 | 0 | 3 | 241 | Table | |
eclkeyword | 1 | 1 | 5 | 1385 | Table | compilation of all keywords from ECL database tables, including additions parsed from updates with IEDA keywords by Megan Carter: |
external_identifier_system | 2 | 1 | 6 | 7 | Table | |
dataset_relation | 0 | 2 | 5 | 29 | Table | |
dataset_file_list | 1 | 2 | 10 | 2386 | Table | |
dataset_types | 1 | 0 | 2 | 12 | Table | |
submission_coverage_scopes | 1 | 0 | 3 | 4 | Table | |
data_type | 1 | 0 | 3 | 16 | Table | |
license | 1 | 0 | 5 | 5 | Table | Table to hold different license information |
submission_external_identifier | 0 | 2 | 5 | 44763 | Table | External_identifier_description extra information for the external_identifier_name. |
submissions | 11 | 8 | 31 | 1687 | Table | |
submission_keyword_map | 0 | 1 | 2 | 4959 | Table | simple correlation table, maps keywords from either eclKeywords or iedakeywords table to submissions; compound key (submission_id, keyword_id) |
person | 7 | 0 | 9 | 5142 | Table | |
system_dataset_types | 0 | 0 | 2 | 0 | Table | |
funding_source | 2 | 0 | 4 | 11 | Table | |
submission_relation | 0 | 2 | 7 | 1143 | Table | |
fundings | 0 | 2 | 8 | 1583 | Table | |
keyword_types | 0 | 0 | 3 | 2 | Table | |
languages | 1 | 0 | 4 | 22 | Table | |
download_stats | 0 | 1 | 6 | 13690 | Table | |
data_file_formats | 2 | 0 | 6 | 40 | Table | |
dataset_file_geometry | 0 | 1 | 5 | 110114 | Table | |
data_type_list | 0 | 2 | 4 | 2286 | Table | |
submission_geometry | 0 | 2 | 4 | 37844 | Table | |
keywords | 0 | 0 | 2 | 0 | Table | |
geography_columns | 0 | 1 | 7 | 0 | View | |
unique_user_submission_count | 0 | 0 | 3 | 0 | View | |
unique_user_published_submission_count | 0 | 0 | 3 | 0 | View | |
long_term_archive_json_input | 0 | 0 | 2 | 0 | View | |
person_orcid | 0 | 1 | 4 | 0 | View | |
person_submitted_dataset_last_three_month | 0 | 0 | 3 | 0 | View | |
ecl_geom | 0 | 0 | 3 | 0 | View | |
person_submission_download_stats | 0 | 0 | 5 | 0 | View | The view contains life time download count for a submission with its contributor or lead author name |
person_submissions2 | 0 | 1 | 5 | 0 | View | |
geometry_columns | 0 | 1 | 7 | 0 | View | |
person_submission_download_stats2 | 0 | 1 | 6 | 0 | View | |
person_submissions | 0 | 0 | 4 | 0 | View | The view is about the lead author of a submission or the contributor of a submission |
ecl_geom3 | 0 | 0 | 3 | 0 | View | |
dataset_un_released | 0 | 0 | 7 | 0 | View | |
person_submissions_licenses | 0 | 1 | 5 | 0 | View | |
person_scopus | 0 | 1 | 4 | 0 | View | |
download_counts | 0 | 0 | 2 | 0 | View | |
unique_users_by_country | 0 | 0 | 3 | 0 | View |