Tables


SchemaSpy Analysis of postgres

Generated on Fri Apr 02 01:06 UTC 2021

XML Representation
Insertion Order Deletion Order
TABLES 277
VIEWS 0
COLUMNS 2548
Constraints 200
Anomalies 0
Routines 0

Database Properties

Database Type: PostgreSQL - 11.11

Schema public

standard public schema

Tables

Table / View Children Parents Columns Rows Type Comments
aws_redshift_cluster_parameter_group_statuses 1 1 4 0 Table
aws_rds_db_subnet_group_subnets 0 1 6 0 Table
aws_elasticbeanstalk_environment_listeners 0 1 4 0 Table
aws_ec2_customer_gateways 1 0 10 0 Table
gcp_compute_forwarding_rule_metadata_filter_label_matches 0 1 4 0 Table
gcp_compute_firewall_target_tags 0 1 3 0 Table
gcp_compute_ssl_certificates 2 0 14 0 Table
azure_keyvault_tags 0 1 4 0 Table
gcp_compute_instance_attached_disk 2 1 19 0 Table
okta_user_types 0 0 9 0 Table
aws_emr_clusters 0 0 14 0 Table
aws_rds_cluster_members 0 1 6 0 Table
gcp_compute_addresses 1 0 18 0 Table
aws_ec2_security_group_user_id_group_paris 0 1 9 0 Table
aws_autoscaling_launch_configuration_block_device_mapping 0 1 11 0 Table
aws_ec2_security_groups 2 0 8 0 Table
azure_network_subnet_address_prefixes 0 1 3 0 Table
aws_iam_user_tags 0 1 4 0 Table
aws_directconnect_gateways 0 0 9 0 Table
aws_elbv2_load_balancer_av_zones 1 1 5 0 Table
azure_postgresql_server_private_endpoint_connections 0 1 8 0 Table
azure_network_virtual_networks 6 0 16 0 Table
gcp_compute_vpn_gateway_interfaces 0 1 4 0 Table
aws_ec2_instance_block_device_mappings 0 1 7 0 Table
aws_redshift_cluster_parameter_statuses 0 1 5 0 Table
aws_ec2_security_group_tags 0 1 4 0 Table
gcp_sql_db_instances 3 0 88 0 Table
gcp_iam_service_accounts 0 0 11 0 Table
gcp_storage_bucket_policy_bindings 1 1 7 0 Table
azure_sql_server_tags 0 1 4 0 Table
aws_cloudtrail_trails 1 0 37 0 Table
azure_compute_disk_encryption_settings 0 1 6 0 Table
aws_ecs_clusters 4 0 12 0 Table
gcp_storage_bucket_labels 0 1 4 0 Table
aws_ec2_route_table_associations 0 1 8 0 Table
okta_applications 0 0 10 0 Table
aws_ec2_vpc_peering_connection_acc_ipv6_cidr_blocks 0 1 3 0 Table
aws_ec2_image_product_codes 0 1 4 0 Table
gcp_compute_autoscaler_policy_custom_metrics 0 1 7 0 Table
gcp_compute_firewalls 8 0 14 0 Table
gcp_compute_forwarding_rule_metadata_filters 1 1 3 0 Table
aws_ec2_network_acls 3 0 7 0 Table
gcp_compute_image_licenses 0 1 3 0 Table
aws_redshift_cluster_deferred_maintenance_windows 0 1 5 0 Table
gcp_compute_subnetwork_log_config_metadata_fields 0 1 3 0 Table
gcp_compute_ssl_certificate_subject_alternative_names 0 1 3 0 Table
aws_iam_groups 1 0 7 0 Table
azure_postgresql_servers 3 0 31 0 Table
aws_fsx_backups 1 0 13 0 Table
gcp_compute_image_guest_os_features 0 1 3 0 Table
aws_iam_role_tags 0 1 4 0 Table
aws_iam_group_policies 0 1 4 0 Table
gcp_compute_interconnects 3 0 21 0 Table
gcp_compute_interconnect_circuit_info 0 1 5 0 Table
aws_ec2_vpcs 3 0 10 0 Table
aws_ec2_instance_license_configurations 0 1 3 0 Table
aws_cloudwatch_metric_alarm_actions 0 1 3 0 Table
gcp_crm_projects 1 0 8 0 Table
aws_ec2_vpc_cidr_block_associations 0 1 6 0 Table
azure_keyvault_keys 1 1 18 0 Table
okta_groups 1 0 7 0 Table
okta_application_users 0 0 12 0 Table
gcp_compute_firewall_allowed 1 1 3 0 Table
aws_rds_certificates 0 0 11 0 Table
aws_redshift_cluster_iam_roles 0 1 4 0 Table
gcp_cloudfunctions_functions 0 0 29 0 Table
gcp_kms_key_google_partition_certs 0 1 3 0 Table
aws_ec2_vpc_peering_connection_tags 0 1 4 0 Table
aws_s3_bucket_grants 0 1 8 0 Table
gcp_storage_bucket_cors 3 1 3 0 Table
azure_keyvault_vault_access_policy_certificate_permissions 0 1 3 0 Table
gcp_compute_vpn_gateway_label 0 1 4 0 Table
aws_cloudwatchlogs_metric_filters 1 0 7 0 Table
azure_network_virtual_network_dns_servers 0 1 3 0 Table
gcp_compute_instance_metadata_items 0 1 6 0 Table
aws_redshift_cluster_subnet_groups 2 0 7 0 Table
gcp_compute_instance_access_configs 0 1 9 0 Table
gcp_storage_bucket_cors_response_headers 0 1 3 0 Table
aws_redshift_cluster_subnet_group_supported_platforms 0 1 3 0 Table
azure_network_subnets 1 1 12 0 Table
gcp_compute_forwarding_rule_ports 0 1 3 0 Table
aws_ec2_subnet_ipv6_cidr_block_associations 0 1 6 0 Table
azure_keyvault_vault_ip_rules 0 1 3 0 Table
gcp_compute_instance_network_interfaces 2 1 9 0 Table
okta_users 1 0 41 0 Table
aws_iam_roles 2 0 14 0 Table
aws_iam_user_groups 0 1 7 0 Table
azure_sql_databases 2 0 30 0 Table
aws_ec2_vpc_tags 0 1 4 0 Table
aws_ec2_image_block_device_mappings 0 1 12 0 Table
aws_ec2_instance_elastic_gpu_associations 0 1 6 0 Table
gcp_compute_firewall_source_tags 0 1 3 0 Table
aws_ec2_instance_elastic_inference_accelerator_associations 0 1 6 0 Table
aws_ec2_customer_gateway_tags 0 1 4 0 Table
aws_ec2_internet_gateway_tags 0 1 4 0 Table
aws_ecr_repositories 1 0 12 0 Table
aws_iam_user_attached_policies 0 1 4 0 Table
aws_ec2_subnet_tags 0 1 4 0 Table
aws_ec2_vpc_ipv6_cidr_block_associations 0 1 8 0 Table
aws_kms_key_encryption_algorithms 0 1 2 0 Table
gcp_firewall_destination_ranges 0 1 3 0 Table
aws_ec2_network_acl_entries 0 1 12 0 Table
azure_keyvault_vault_access_policy_secret_permissions 0 1 3 0 Table
aws_ec2_nat_gateway_tags 0 1 4 0 Table
aws_eks_cluster_tags 0 1 4 0 Table
aws_ecs_service_subnets 0 1 3 0 Table
gcp_storage_bucket_policy_binding_members 0 1 3 0 Table
gcp_compute_address_users 0 1 3 0 Table
gcp_compute_interconnect_attachments 0 1 3 0 Table
aws_ec2_nat_gateways 2 0 16 0 Table
aws_ecs_service_registries 0 1 6 0 Table
gcp_crm_project_labels 0 1 4 0 Table
gcp_sql_db_instance_acl_entries 0 1 6 0 Table
azure_compute_disks 3 0 38 0 Table
gcp_compute_backend_service_backends 0 1 14 0 Table
gcp_compute_image_storage_locations 0 1 3 0 Table
aws_ec2_image_tags 0 1 4 0 Table
aws_s3_buckets 3 0 10 0 Table
gcp_storage_bucket_lifecycle_rules 0 1 13 0 Table
aws_ec2_internet_gateway_attachments 0 1 4 0 Table
aws_ecs_cluster_settings 0 1 4 0 Table
aws_elasticbeanstalk_environments 2 0 26 0 Table
gcp_iam_roles 1 0 9 0 Table
aws_redshift_cluster_nodes 0 1 5 0 Table
azure_mysql_tags 0 1 5 0 Table
azure_sql_servers 1 0 13 0 Table
gcp_compute_subnetworks 2 0 24 0 Table
gcp_kms_key_cavium_certs 0 1 3 0 Table
gcp_compute_networks 2 0 12 0 Table
aws_efs_file_system_descriptions 1 0 20 0 Table
gcp_compute_firewall_target_service_accounts 0 1 3 0 Table
gcp_compute_instance_tags 0 1 4 0 Table
azure_resources_groups 1 0 8 0 Table
azure_network_virtual_network_tags 0 1 4 0 Table
aws_autoscaling_launch_configurations 1 0 24 0 Table
gcp_iam_role_permissions 0 1 3 0 Table
aws_ec2_instances 8 0 58 0 Table
aws_elbv2_load_balancers 1 0 16 0 Table
gcp_storage_bucket_cors_methods 0 1 3 0 Table
aws_ecr_image_tags 0 1 3 0 Table
azure_keyvault_vault_private_endpoint_connections 0 1 7 0 Table
gcp_storage_buckets 7 0 31 0 Table
aws_ec2_vpc_peering_connections 5 0 21 0 Table
aws_eks_logging_configurations 0 1 4 0 Table
aws_ec2_instance_ipv6_addresses 0 1 3 0 Table
azure_network_virtual_network_peerings 0 1 3 0 Table
aws_ec2_subnets 2 0 18 0 Table
aws_s3_bucket_cors_rules 0 1 7 0 Table
aws_rds_cluster_roles 0 1 5 0 Table
gcp_compute_firewall_denied_ports 0 1 3 0 Table
aws_rds_cluster_option_group_statuses 0 1 4 0 Table
aws_cloudwatchlogs_metric_filter_transformations 0 1 6 0 Table
aws_iam_virtual_mfa_devices 0 0 5 0 Table
gcp_compute_firewall_denied 1 1 3 0 Table
okta_user_groups 0 2 2 0 Table
okta_application_groups 0 0 6 0 Table
aws_ec2_instance_group_identifiers 0 1 4 0 Table
gcp_compute_backend_services 1 0 60 0 Table
aws_cloudwatch_metric_alarms 2 0 25 0 Table
aws_ecs_cluster_key_value_pairs 0 1 4 0 Table
gcp_compute_firewall_source_service_accounts 0 1 3 0 Table
azure_compute_disk_share_info 0 1 3 0 Table
aws_sns_subscriptions 0 0 8 0 Table
gcp_kms_crypto_keys 3 0 23 0 Table
aws_ec2_route_tables 4 0 6 0 Table
gcp_compute_firewall_allowed_ports 0 1 3 0 Table
aws_ecs_service_security_groups 0 1 3 0 Table
aws_s3_bucket_encryption_rules 0 1 4 0 Table
aws_iam_user_access_keys 0 1 8 0 Table
azure_network_virtual_network_address_prefixes 0 1 3 0 Table
aws_ec2_byoip_cidrs 0 0 7 0 Table
aws_kms_keys 2 0 19 0 Table
azure_network_virtual_network_ip_allocations 0 1 3 0 Table
gcp_compute_network_peerings 0 1 13 0 Table
aws_ecs_service_load_balancers 0 1 6 0 Table
aws_eks_clusters 5 0 18 0 Table
aws_kms_key_signing_algorithms 0 1 2 0 Table
aws_ec2_route_table_routes 0 1 17 0 Table
gcp_storage_bucket_cors_origins 0 1 3 0 Table
aws_redshift_cluster_subnet_group_subnets 1 1 5 0 Table
gcp_compute_disk_types 0 0 17 0 Table
azure_mysql_server_configurations 0 1 11 0 Table
aws_ec2_instance_product_codes 0 1 4 0 Table
gcp_compute_firewall_source_ranges 0 1 3 0 Table
aws_ec2_images 3 0 27 0 Table
azure_postgresql_configurations 0 1 10 0 Table
aws_ec2_flow_logs 1 0 16 0 Table
aws_ec2_route_table_propagation_vgws 0 1 3 0 Table
aws_ecs_service_placement_constraints 0 1 4 0 Table
azure_keyvault_vault_access_policy_key_permissions 0 1 3 0 Table
azure_keyvault_vault_access_policy_storage_permissions 0 1 3 0 Table
aws_ec2_instance_private_ip_addresses 0 1 9 0 Table
aws_elbv2_load_balancer_addresses 0 1 5 0 Table
gcp_compute_interconnect_outage_notification_affected_circuits 0 1 3 0 Table
aws_ec2_security_group_ip_permissions 4 1 5 0 Table
gcp_storage_bucket_zone_affinities 0 1 3 0 Table
azure_mysql_server_private_endpoint_connections 0 1 9 0 Table
gcp_compute_instance_service_accounts 0 1 4 0 Table
gcp_compute_ssl_certificate_managed_domains 0 1 3 0 Table
azure_postgresql_tags 0 1 4 0 Table
gcp_sql_database_instance_ip_mappings 0 1 5 0 Table
aws_ec2_vpc_peering_connection_acc_cidr_blocks 0 1 3 0 Table
aws_ecs_service_placement_strategies 0 1 4 0 Table
aws_ec2_route_table_tags 0 1 4 0 Table
aws_ecs_cluster_capacity_provider_strategy_items 0 1 5 0 Table
aws_ec2_instance_network_interfaces 2 1 22 0 Table
aws_efs_file_system_description_tags 0 1 4 0 Table
gcp_compute_instance_guest_os_features 0 1 3 0 Table
aws_ecs_service_cap_provider_strategies 0 1 5 0 Table
aws_cloudwatch_metric_alarm_metrics 0 1 12 0 Table
gcp_compute_network_subnetworks 0 1 3 0 Table
aws_ecr_image_severity_counts 0 1 4 0 Table
gcp_compute_instance_attached_disk_licenses 0 1 3 0 Table
aws_ec2_vpc_peering_connection_req_cidr_blocks 0 1 3 0 Table
aws_redshift_clusters 7 0 69 0 Table
aws_ec2_internet_gateways 2 0 5 0 Table
azure_mysql_servers 3 0 31 0 Table
gcp_compute_images 4 0 29 0 Table
aws_organizations_accounts 0 0 9 0 Table
azure_sql_database_transparent_data_encryptions 0 1 7 0 Table
aws_rds_cluster_vpc_security_group_memberships 0 1 4 0 Table
aws_eks_public_access_cidr 0 1 3 0 Table
aws_iam_password_policies 0 0 12 0 Table
aws_ec2_security_group_ipv6_ranges 0 1 4 0 Table
gcp_kms_key_card_certs 0 1 3 0 Table
aws_eks_security_groups 0 1 3 0 Table
aws_redshift_cluster_subnet_group_tags 0 1 4 0 Table
aws_iam_role_policies 0 1 4 0 Table
aws_iam_users 4 0 14 0 Table
aws_ec2_instance_tags 0 1 4 0 Table
aws_ec2_nat_gateway_addresses 0 1 6 0 Table
azure_sql_database_tags 0 1 4 0 Table
aws_redshift_cluster_security_group_memberships 0 1 4 0 Table
gcp_compute_vpn_gateways 2 0 11 0 Table
azure_compute_disk_tags 0 1 4 0 Table
azure_keyvault_vault_virtual_network_rules 0 1 3 0 Table
gcp_compute_forwarding_rules 2 0 24 0 Table
aws_ec2_security_group_prefix_list_ids 0 1 4 0 Table
gcp_compute_interconnect_outages 1 1 9 0 Table
gcp_compute_instance_accelerator_configs 0 1 4 0 Table
aws_iam_policies 1 0 13 0 Table
gcp_compute_subnetwork_secondary_ranges 0 1 4 0 Table
aws_iam_policy_versions 0 1 6 0 Table
gcp_compute_autoscaler_status_details 0 1 4 0 Table
aws_ec2_security_group_ip_ranges 0 1 4 0 Table
aws_ec2_vpc_peering_connection_req_ipv6_cidr_blocks 0 1 3 0 Table
aws_sns_topics 0 0 14 0 Table
gcp_compute_autoscalers 2 0 23 0 Table
gcp_compute_image_license_codes 0 1 3 0 Table
aws_fsx_backup_tags 0 1 4 0 Table
aws_redshift_cluster_vpc_security_group_memberships 0 1 4 0 Table
gcp_compute_instance_alias_ip_ranges 0 1 4 0 Table
aws_eks_subnets 0 1 3 0 Table
aws_rds_cluster_domain_membership 0 1 6 0 Table
azure_resources_group_tags 0 1 4 0 Table
aws_cloudtrail_trail_event_selectors 0 1 4 0 Table
azure_keyvault_vault_access_policies 4 1 5 0 Table
aws_ecr_images 2 1 13 0 Table
aws_ecs_cluster_tags 0 1 4 0 Table
aws_ec2_network_acl_associations 0 1 4 0 Table
gcp_sql_db_instance_database_flags 0 1 4 0 Table
aws_redshift_cluster_tags 0 1 4 0 Table
gcp_storage_bucket_object_acls 0 1 16 0 Table
aws_elbv2_target_groups 1 0 18 0 Table
gcp_compute_instances 7 0 36 0 Table
gcp_compute_instance_scheduling_node_affinities 0 1 5 0 Table
aws_ecs_service_tags 0 1 4 0 Table
aws_ecs_services 8 0 24 0 Table
azure_keyvault_keys_tags 0 1 4 0 Table
gcp_storage_bucket_acls 0 1 14 0 Table
aws_elasticbeanstalk_environment_links 0 1 4 0 Table
azure_keyvault_vaults 6 0 20 0 Table
aws_ec2_network_acl_tags 0 1 4 0 Table
aws_elbv2_target_group_load_balancer_arns 0 1 3 0 Table
aws_rds_clusters 5 0 56 0 Table
aws_ec2_flow_log_tags 0 1 4 0 Table
aws_rds_db_subnet_groups 1 0 8 0 Table