System keyspaces and tables

local

key, bootstrapped, broadcast_address, cluster_name, cql_version, data_center, dse_version, gossip_generation, graph, host_id, jmx_port, listen_address, native_protocol_version, native_transport_address, native_transport_port, native_transport_port_ssl, partitioner, rack, release_version, rpc_address, schema_version, server_id, storage_port, storage_port_ssl, tokens, truncated_at, workload, workloads

Information that a node has about itself and a superset of gossip. Gossip is a peer-to-peer communication protocol for exchanging location and state information between nodes.

peers

peer, data_center, dse_version, graph, host_id, jmx_port, native_transport_address, native_transport_port, native_transport_port_ssl, preferred_ip, rack, release_version, rpc_address, schema_version, server_id, storage_port, storage_port_ssl, tokens, workload, workloads

Each node records what other nodes tell it about themselves over the gossip.

size_estimates

keyspace_name, table_name, range_start, range_end, mean_partition_size, partitions_count

Information on partitions.

aggregates

keyspace_name, aggregate_name, argument_types, final_func, initcond, return_type, state_func, state_type

Information about user-defined aggregates.

columns

keyspace_name, table_name, column_name, clustering_order, column_name_bytes, kind, position, type

Information about table columns.

dropped_columns

keyspace_name, table_name, column_name, dropped_time, type

Information about dropped columns.

functions

keyspace_name, function_name, argument_types, argument_names, body, called_on_null_input, language, return_type

Information on user-defined functions.

indexes

keyspace_name, table_name, index_name, kind, options

Information about indexes.

keyspaces

keyspace_name, durable_writes, replication

Information on keyspace durable writes and replication.

tables

keyspace_name, table_name, bloom_filter_fp_chance, caching, comment, compaction, compression, crc_check_chance, default_time_to_live, extensions, flags, gc_grace_seconds, id, max_index_interval, memtable_flush_period_in_ms, min_index_interval, speculative_retry

Information on columns and column indexes. Used internally for compound primary keys.

types

keyspace_name, type_name, field_names, field_types

Information about user-defined types.

views

keyspace_name, view_name, base_table_id, base_table_name, bloom_filter_fp_chance, caching, comment, compaction, compression, crc_check_chance, default_time_to_live, extensions, flags, gc_grace_seconds, include_all_columns, max_index_interval, memtable_flush_period_in_ms, min_index_interval, speculative_retry, where_clause

Information about materialized views.

role_permissions

role (PK), resource, permissions

Stores the role, resource (for example keyspace_name/table_name), and the permission that the role has to access the resource.

role_members

role (PK), member

Stores the roles and role members.

roles

role (PK), can_login, is_superuser, member_of, salted_hash

Stores the role name, whether the role can be used for login, whether the role is a superuser, what other roles the role may be a member of, and a bcrypt salted hash password for the role.