Skip to content

Relationships

Schema relationships
graph LR
    RelationalDatabases -->|"account"| Accounts
    RelationalDatabases -->|"attached_rule_sets"| FirewallRuleSets
    RelationalDatabases -->|"encryption_key"| ManagedKeys
    RelationalDatabases -->|"audit_log_destinations"| LogDestinations
    RelationalDatabases -->|"replicas"| RelationalDatabases

Properties

idstring
required·

Truto's stable unified identifier for this object. Opaque; use provider_id to address the object in the provider's own console or API.

accountstring

The account, subscription or project this object belongs to.

References: Accounts → id
allow_all_ingressboolean

Whether any allowed network rule permits the whole internet.

allowed_networksobject[]

Ingress rules that reach this database.

from_portinteger

Lowest port allowed.

protocolstring

The protocol allowed.

source_idstring

The source range or security group allowed in.

to_portinteger

Highest port allowed.

attached_rule_setsobject[]

The firewall rule sets attached to this database.

idstring

The target's id.

audit_log_destinationsobject[]

Where audit and error logs are delivered. AWS creates the destination on first write, so a row here can name a log group that does not exist yet.

idstring

The target's id.

backup_retention_daysinteger

How many days of backups are retained.

collected_atstring · date-time

When Truto actually read this object from the provider, in UTC ISO 8601 with the offset present — not the request time, and not a provider timestamp.

created_atstring

When the object was created at the provider, in UTC ISO 8601. Null when the provider does not record one - see unreadable_fields.

db_idstring

The provider's own identifier for the database.

deletion_protectionboolean

Whether the database is protected against deletion.

encryption_at_restboolean

Whether storage is encrypted at rest.

encryption_keyobject

The key protecting the database at rest.

References: ManagedKeys → id
idstring

The target's id.

encryption_key_typestring

Who manages the storage encryption key. AWS merges provider-managed and customer-managed into one value (only provider-owned is distinguishable); resolving further may yield permission_denied.

Possible values:
provider_managedprovider_ownedcustomer_managednoneunknown
enginestring

The database engine, as the provider names it.

engine_lifecycle_supportstring

The provider's support status for this engine version, where exposed.

engine_versionstring

The database engine version currently running.

global_cluster_idstring

The global cluster this database belongs to, where it is part of one.

high_availability_modestring

The database's high-availability topology, distinguishing standby, multi-AZ, and multi-region configurations.

Possible values:
nonesingle_standbymulti_az_clustermulti_regionzone_redundantunknown
is_writerboolean

Whether this row is the writer of its cluster or global cluster.

latest_restorable_timestring · date-time

The most recent point the database could be restored to.

locationstring

Where the database sits.

min_tls_versionstring

Minimum TLS version accepted. Often not derivable on AWS: some engines have no true minimum, only an allow-list or independent toggles, and an absent parameter isn't the same as off.

native_typestring

The provider's own type string, unmodified — for example 'AWS::S3::Bucket', 'aws_iam_role', 'Microsoft.Sql/servers'. Used for display and drill-down.

point_in_time_recoveryboolean

Whether point-in-time restore is available. AWS has no such flag; this is derived from backup retention and cross-checked against latest_restorable_time.

providerstring

Which cloud this object was read from.

Possible values:
awsazuregcp
provider_idstring

The provider's own identifier, passed through verbatim — a full ARN, resource id, or self-link. Never truncated, prefixed, or normalized.

public_network_accessboolean

The provider's public-network-access flag, not proven reachability: true doesn't mean reachable, and false doesn't mean safe — actual exposure also depends on routing.

regionstring

Where the object is located. 'global' denotes genuinely global resources (e.g. IAM, GCP VPC networks) rather than a guessed region. A substituted region (when none is derivable) is flagged in unreadable_fields.

remote_dataRecord<string, any>

Raw data returned from the remote API call.

replica_locationsstring[]

Regions holding replicas of this database.

replicasobject[]

The replica databases themselves.

idstring

The target's id.

storage_encryption_typestring

The provider's own storage encryption type string, verbatim.

tagsobject

Key-value pairs exactly as the customer set them: no case folding, key/value normalization, or merging of separate provider concepts. An empty object means no tags; tags that could not be read appear in unreadable_fields instead.

tls_enforcedboolean

Whether TLS is required for connections, independent of any minimum version floor.

topologystring

Whether this row represents a cluster or a standalone instance.

Possible values:
clusterinstanceunknown
unreadable_fieldsobject[]

Fields on this object that could not be read, and why. An empty array means everything was read. Use this to tell a real value from a missing one.

detailstring

Explanation of the reason, where one adds anything.

fieldstring

The property on this resource that could not be read.

reasonstring

Why the field could not be read. available_on_get: Not read on list to keep the list fast; call GET for this resource's id to get it.

Possible values:
not_supported_by_providernot_configuredpermission_deniednot_collectedcollection_errorpartially_collectedavailable_on_get
updated_atstring

When the object was last modified at the provider, in UTC ISO 8601. Null when the provider does not record one - see unreadable_fields.