Database Schema

This document lists and details the database schema used by KubeArchive.

Table kubearchive.resource

Name Type Description

uuid

uuid primary key

The UUID of the Kubernetes resource used as primary key.

api_version

varchar not null

API Version + API Group (apiVersion). "batch/v1" for Jobs, "apps/v1" for Deployments, "build.openshift.io/v1" for OpenShift Builds, "v1" for Services or Pods, …​

kind

varchar not null

Kind of the resource (kind). For example "Job", "Deployment", "Service"…​

name

varchar not null

Name of the resource (metadata.name).

namespace

varchar not null

Namespace of the resource (metadata.namespace).

resource_version

varchar not null

Version of the resource (metadata.resourceVersion).

created_at

timestamp not null

Timestamp when the record is inserted in this table.

updated_at

timestamp not null

Last time this record was updated.

cluster_deleted_ts

timestamp not null

Timestamp when KubeArchive deleted the resource from the cluster.

data

jsonb not null

Resource definition in JSON format.