Tables


SchemaSpy Analysis of postgres

Generated on Mon May 17 00:09 UTC 2021

XML Representation
Insertion Order Deletion Order
TABLES 217
VIEWS 0
COLUMNS 2785
Constraints 139
Anomalies 0
Routines 0

Database Properties

Database Type: PostgreSQL - 11.12

Schema public

standard public schema

Tables

Table / View Children Parents Columns Rows Type Comments
aws_ec2_customer_gateways 0 0 11 0 Table
aws_directconnect_virtual_interfaces 1 0 25 0 Table
aws_ec2_instance_network_interface_groups 0 1 4 0 Table
aws_ec2_security_group_ip_permission_user_id_group_pairs 0 1 9 0 Table
gcp_compute_ssl_certificates 0 0 19 0 Table
aws_elbv2_load_balancer_availability_zone_addresses 0 1 6 0 Table
azure_keyvault_tags 0 1 4 0 Table
gcp_compute_instance_network_interface_alias_ip_ranges 0 1 4 0 Table
aws_emr_clusters 0 0 14 0 Table
aws_eks_cluster_encryption_configs 0 1 4 0 Table
gcp_compute_addresses 0 0 19 0 Table
gcp_sql_instance_ip_addresses 0 1 5 0 Table
aws_ec2_security_group_ip_permission_prefix_list_ids 0 1 4 0 Table
aws_directconnect_virtual_interface_bgp_peers 0 1 11 0 Table
aws_ec2_security_groups 2 0 9 0 Table
azure_network_subnet_address_prefixes 0 1 3 0 Table
aws_elasticbeanstalk_env_resources_load_balancer_listeners 0 1 4 0 Table
aws_directconnect_gateways 0 0 9 0 Table
azure_postgresql_server_private_endpoint_connections 0 1 8 0 Table
azure_network_virtual_networks 6 0 16 0 Table
aws_ec2_instance_block_device_mappings 0 1 7 0 Table
gcp_iam_service_accounts 0 0 10 0 Table
aws_ec2_security_group_ip_permissions_egress_ipv6_ranges 0 1 4 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_cluster_attachments 0 1 6 0 Table
aws_ecs_clusters 2 0 22 0 Table
aws_ec2_route_table_associations 0 1 8 0 Table
aws_elbv2_load_balancer_availability_zones 1 1 5 0 Table
gcp_compute_autoscaler_custom_metric_utilizations 0 1 7 0 Table
aws_efs_filesystems 0 0 23 0 Table
gcp_compute_firewalls 2 0 20 0 Table
gcp_sql_instance_settings_ip_configuration_authorized_networks 0 1 6 0 Table
aws_ec2_network_acls 2 0 8 0 Table
aws_rds_instance_db_subnet_group_subnets 0 1 6 0 Table
aws_redshift_cluster_deferred_maintenance_windows 0 1 5 0 Table
aws_iam_groups 0 0 9 0 Table
azure_postgresql_servers 3 0 31 0 Table
aws_fsx_backups 0 0 14 0 Table
aws_ec2_transit_gateway_vpc_attachments 0 1 11 0 Table
aws_ec2_vpc_ipv6_cidr_block_association_sets 0 1 8 0 Table
aws_cloudwatch_alarm_metrics 0 1 13 0 Table
gcp_compute_interconnects 2 0 21 0 Table
gcp_domains_registration_glue_records 0 1 5 0 Table
aws_ec2_vpcs 2 0 11 0 Table
aws_rds_instance_db_parameter_groups 0 1 4 0 Table
aws_ec2_transit_gateways 5 0 20 0 Table
gcp_crm_projects 0 0 11 0 Table
azure_keyvault_keys 1 1 18 0 Table
gcp_compute_firewall_allowed 0 1 4 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 32 0 Table
aws_s3_bucket_grants 0 1 8 0 Table
gcp_storage_bucket_cors 0 1 6 0 Table
azure_keyvault_vault_access_policy_certificate_permissions 0 1 3 0 Table
azure_network_virtual_network_dns_servers 0 1 3 0 Table
aws_cloudwatchlogs_filters 1 0 7 0 Table
azure_network_subnets 1 1 12 0 Table
gcp_compute_disks 0 0 46 0 Table
azure_keyvault_vault_ip_rules 0 1 3 0 Table
aws_ec2_route_table_propagating_vgws 0 1 3 0 Table
gcp_compute_instance_network_interfaces 2 1 10 0 Table
aws_iam_roles 0 0 16 0 Table
aws_iam_user_groups 0 1 7 0 Table
azure_sql_databases 2 0 30 0 Table
aws_ec2_image_block_device_mappings 0 1 14 0 Table
aws_ec2_instance_elastic_gpu_associations 0 1 6 0 Table
aws_ec2_instance_elastic_inference_accelerator_associations 0 1 6 0 Table
aws_ec2_ebs_volume_attachments 0 1 8 0 Table
aws_ecr_repositories 1 0 12 0 Table
aws_iam_user_attached_policies 0 1 4 0 Table
gcp_sql_instance_settings_deny_maintenance_periods 0 1 5 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_rds_instance_status_infos 0 1 6 0 Table
aws_ec2_security_group_ip_permissions_egresses 4 1 5 0 Table
aws_ec2_nat_gateways 1 0 17 0 Table
azure_compute_disks 3 0 38 0 Table
gcp_compute_backend_service_backends 0 1 14 0 Table
aws_s3_buckets 3 0 10 0 Table
gcp_storage_bucket_lifecycle_rules 0 1 14 0 Table
aws_ec2_internet_gateway_attachments 0 1 4 0 Table
aws_rds_instance_db_security_groups 0 1 4 0 Table
gcp_compute_interconnect_expected_outages 0 1 10 0 Table
aws_elasticbeanstalk_environments 2 0 26 0 Table
gcp_iam_roles 0 0 9 0 Table
aws_redshift_cluster_nodes 0 1 5 0 Table
azure_mysql_tags 0 1 5 0 Table
aws_ecr_repository_images 0 1 17 0 Table
azure_sql_servers 1 0 13 0 Table
gcp_compute_subnetworks 1 0 26 0 Table
aws_ec2_security_group_ip_permissions_egress_prefix_list_ids 0 1 4 0 Table
gcp_compute_networks 1 0 14 0 Table
aws_ec2_transit_gateway_peering_attachments 0 1 14 0 Table
aws_ec2_security_group_ip_permission_ipv6_ranges 0 1 4 0 Table
azure_resources_groups 1 0 8 0 Table
azure_network_virtual_network_tags 0 1 4 0 Table
aws_rds_instance_domain_memberships 0 1 6 0 Table
gcp_compute_instance_disks 0 1 38 0 Table
aws_redshift_cluster_endpoint_vpc_endpoints 1 1 4 0 Table
aws_rds_instance_vpc_security_groups 0 1 4 0 Table
aws_autoscaling_launch_configurations 1 0 24 0 Table
aws_redshift_cluster_endpoint_vpc_endpoint_network_interfaces 0 1 6 0 Table
aws_ec2_instances 7 0 60 0 Table
aws_elbv2_load_balancers 1 0 16 0 Table
aws_redshift_subnet_group_subnets 0 1 6 0 Table
azure_keyvault_vault_private_endpoint_connections 0 1 7 0 Table
gcp_storage_buckets 4 0 35 0 Table
aws_ec2_vpc_peering_connections 0 0 26 0 Table
aws_ec2_security_group_ip_permission_ip_ranges 0 1 4 0 Table
azure_network_virtual_network_peerings 0 1 3 0 Table
aws_ec2_subnets 1 0 19 0 Table
aws_s3_bucket_cors_rules 0 1 8 0 Table
aws_ecs_cluster_default_capacity_provider_strategies 0 1 5 0 Table
aws_iam_virtual_mfa_devices 0 0 17 0 Table
gcp_compute_firewall_denied 0 1 4 0 Table
aws_ec2_subnet_ipv6_cidr_block_association_sets 0 1 6 0 Table
aws_redshift_cluster_parameter_groups 1 1 4 0 Table
gcp_compute_backend_services 2 0 77 0 Table
azure_compute_disk_share_info 0 1 3 0 Table
aws_sns_subscriptions 0 0 8 0 Table
aws_cloudwatch_alarms 1 0 29 0 Table
gcp_kms_keyring_crypto_keys 0 1 29 0 Table
aws_ec2_route_tables 3 0 7 0 Table
aws_s3_bucket_encryption_rules 0 1 4 0 Table
aws_rds_cluster_vpc_security_groups 0 1 4 0 Table
aws_iam_user_access_keys 0 1 7 0 Table
azure_network_virtual_network_address_prefixes 0 1 3 0 Table
aws_ec2_byoip_cidrs 0 0 7 0 Table
aws_redshift_cluster_security_groups 0 1 4 0 Table
aws_kms_keys 0 0 21 0 Table
azure_network_virtual_network_ip_allocations 0 1 3 0 Table
gcp_compute_backend_service_cdn_negative_caching_policies 0 1 4 0 Table
gcp_compute_network_peerings 0 1 13 0 Table
gcp_storage_bucket_default_object_acls 0 1 14 0 Table
gcp_compute_instance_network_interface_access_configs 0 1 9 0 Table
aws_eks_clusters 2 0 23 0 Table
aws_ec2_instance_licenses 0 1 3 0 Table
aws_ec2_route_table_routes 0 1 17 0 Table
aws_directconnect_virtual_gateways 0 0 5 0 Table
gcp_compute_disk_types 0 0 17 0 Table
aws_ec2_security_group_ip_permissions_egress_user_group_pairs 0 1 9 0 Table
aws_ec2_instance_security_groups 0 1 4 0 Table
azure_mysql_server_configurations 0 1 11 0 Table
aws_ec2_instance_product_codes 0 1 4 0 Table
aws_eks_cluster_logging_cluster_loggings 0 1 4 0 Table
aws_ec2_images 1 0 29 0 Table
azure_postgresql_configurations 0 1 10 0 Table
aws_ec2_flow_logs 0 0 17 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_ebs_volumes 1 0 18 0 Table
aws_rds_instance_associated_roles 0 1 5 0 Table
aws_ec2_security_group_ip_permissions 4 1 5 0 Table
azure_mysql_server_private_endpoint_connections 0 1 9 0 Table
gcp_compute_instance_service_accounts 0 1 4 0 Table
azure_postgresql_tags 0 1 4 0 Table
aws_ec2_instance_network_interface_ipv6_addresses 0 1 3 0 Table
aws_ec2_instance_network_interfaces 3 1 23 0 Table
aws_redshift_clusters 7 0 74 0 Table
aws_ec2_internet_gateways 1 0 6 0 Table
azure_mysql_servers 3 0 31 0 Table
gcp_compute_images 0 0 51 0 Table
aws_rds_cluster_domain_memberships 0 1 6 0 Table
aws_organizations_accounts 0 0 10 0 Table
azure_sql_database_transparent_data_encryptions 0 1 7 0 Table
gcp_compute_interconnect_circuit_infos 0 1 5 0 Table
aws_rds_subnet_groups 1 0 8 0 Table
aws_ec2_security_group_ip_permissions_egress_ip_ranges 0 1 4 0 Table
aws_iam_password_policies 0 0 13 0 Table
aws_cloudwatchlogs_filter_metric_transformations 0 1 6 0 Table
aws_rds_cluster_associated_roles 0 1 5 0 Table
aws_autoscaling_launch_configuration_block_device_mappings 0 1 11 0 Table
aws_rds_instances 9 0 83 0 Table
aws_iam_users 3 0 10 0 Table
gcp_kms_keyrings 1 0 5 0 Table
aws_ec2_nat_gateway_addresses 0 1 6 0 Table
azure_sql_database_tags 0 1 4 0 Table
gcp_compute_subnetwork_secondary_ip_ranges 0 1 4 0 Table
gcp_compute_vpn_gateways 1 0 12 0 Table
aws_ec2_vpc_cidr_block_association_sets 0 1 6 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 0 0 29 0 Table
aws_iam_policies 1 0 14 0 Table
aws_iam_policy_versions 0 1 6 0 Table
gcp_domains_registrations 1 0 60 0 Table
aws_ec2_transit_gateway_attachments 0 1 11 0 Table
aws_sns_topics 0 0 14 0 Table
gcp_compute_autoscalers 1 0 27 0 Table
aws_redshift_cluster_vpc_security_groups 0 1 4 0 Table
aws_redshift_subnet_groups 1 0 8 0 Table
azure_resources_group_tags 0 1 4 0 Table
gcp_compute_vpn_gateway_vpn_interfaces 0 1 5 0 Table
aws_cloudtrail_trail_event_selectors 0 1 5 0 Table
azure_keyvault_vault_access_policies 4 1 5 0 Table
aws_rds_cluster_db_cluster_option_group_memberships 0 1 4 0 Table
aws_ec2_transit_gateway_route_tables 0 1 8 0 Table
aws_ec2_transit_gateway_multicast_domains 0 1 11 0 Table
aws_ec2_network_acl_associations 0 1 4 0 Table
aws_rds_instance_db_instance_automated_backups_replications 0 1 3 0 Table
gcp_sql_instances 3 0 107 0 Table
aws_redshift_cluster_parameter_group_status_lists 0 1 5 0 Table
aws_elbv2_target_groups 0 0 21 0 Table
gcp_compute_instances 4 0 49 0 Table
gcp_compute_instance_scheduling_node_affinities 0 1 5 0 Table
aws_rds_instance_option_group_memberships 0 1 4 0 Table
azure_keyvault_keys_tags 0 1 4 0 Table
gcp_storage_bucket_acls 0 1 14 0 Table
aws_rds_subnet_group_subnets 0 1 6 0 Table
aws_ec2_instance_network_interface_private_ip_addresses 0 1 9 0 Table
aws_elasticbeanstalk_environment_links 0 1 4 0 Table
aws_rds_cluster_db_cluster_members 0 1 6 0 Table
azure_keyvault_vaults 6 0 20 0 Table
aws_rds_clusters 5 0 63 0 Table