geodb Database

TABLES 55

COLUMNS 769

Constraints 66

Anomalies 0

Routines 95

Database Properties

Database Type: PostgreSQL - 12.16 (Ubuntu 12.16-1.pgdg20.04+1)

Schema public

standard public schema

Tables

Table / View	Children	Parents	Columns	Type
tdis_model_model_type	0	2	2	Table
tdis_model	1	2	5	Table
tdis_data_stage	1	0	3	Table
tdis_session	0	1	6	Table
tdis_element_contact	0	3	3	Table
tdis_member	5	17	26	Table
tdis_member_jurisdiction	0	2	2	Table
tdis_notification_type	1	0	2	Table
tdis_model_type	1	0	3	Table
tdis_attribute	0	2	6	Table
tdis_element_history	0	2	7	Table
tdis_dimension	1	0	3	Table
tdis_class_type	1	0	2	Table
tdis_controlled_vocabulary	1	0	5	Table
tdis_user	8	1	8	Table
tdis_class_term	1	0	2	Table
tdis_domain_type	1	0	2	Table
tdis_scale	1	0	3	Table
tdis_jurisdiction_type	3	0	6	Table
tdis_collection	1	3	3	Table
tdis_user_role	1	0	2	Table
tdis_agency	4	0	4	Table
tdis_spatial_accuracy	1	0	3	Table
tdis_project	3	0	2	Table
tdis_layer	1	2	8	Table
tdis_update_interval	1	0	2	Table
tdis_horizontal_projection	1	0	4	Table
tdis_upload_type	1	0	2	Table
tdis_software	1	0	7	Table
tdis_spatial_data_type	1	0	3	Table
tdis_status	2	0	2	Table
tdis_artifact	1	5	8	Table
tdis_project_jurisdiction	0	2	2	Table
tdis_accessibility	1	0	3	Table
tdis_completeness	1	0	3	Table
tdis_vertical_projection	1	0	3	Table
tdis_distribution_method	1	0	2	Table
tdis_element	5	3	18	Table
tdis_notification	0	4	7	Table
tdis_upload	1	3	10	Table
tdis_file_format	1	0	3	Table
tdis_horizontal_datum	1	0	3	Table
tdis_endpoint_type	1	0	3	Table
tdis_user_project_role	0	3	3	Table
tdis_user_keyword	0	1	3	Table
tdis_contact	2	1	9	Table
tdis_vertical_datum	1	0	3	Table
tdis_user_report	0	1	4	Table
tdis_user_search	0	1	4	Table
tdis_constraint	1	0	2	Table
tdis_collection_method	0	0	5	Table
tdis_member_constraint	0	2	2	Table
tdis_contact_role	1	0	4	Table
tdis_jurisdiction	3	1	6	Table
tdis_jurisdiction_type_distributor	0	2	2	Table
tdis_element_identifiers_geom	0	0	3	View
tdis_upload_conflicts	0	0	11	View
tdis_element_contacts	0	0	12	View
tdis_artifacts	0	0	51	View
tdis_messages	0	0	7	View
tdis_layers	0	0	69	View
tdis_layers_ids	0	0	88	View
tdis_collections	0	0	24	View
tdis_uploads	0	0	14	View
tdis_models	0	0	54	View
tdis_latest_status_updates	0	0	2	View
tdis_users	0	0	14	View
tdis_artifacts_ids	0	0	65	View
tdis_contacts	0	0	10	View
tdis_models_ids	0	0	71	View
tdis_notifications	0	0	8	View
tdis_element_identifiers	0	0	2	View
tdis_project_jurisdictions	0	0	8	View
tdis_jurisdictions	0	0	6	View