suse-hackweek-support-matrix

db.md

erDiagram

	rancher_releases {
		INTEGER RancherReleaseId
		NVARCHAR Version
	}

	hosted_runtime_versions {
		INTEGER HostedRuntimeVersionId
		ENUM Provider
		NVARCHAR Version
	}

	rancher_release_hosted_runtimes {
		INTEGER Id
		INTEGER RancherReleaseId
		INTEGER HostedRuntimeVersionId
	}

	rancher_releases ||--o{ rancher_release_hosted_runtimes : "foreign key"
	hosted_runtime_versions ||--o{ rancher_release_hosted_runtimes : "foreign key"

	rke_cli_versions {
		INTEGER RkeCliVersionId
		NVARCHAR Version
	}

	k8s_runtime_versions {
		INTEGER K8sRuntimeVersionId
		NVARCHAR Version
	}

	rancher_release_rke_runtimes {
		INTEGER Id
		INTEGER RancherReleaseId
		INTEGER RkeCliVersionId
		INTEGER K8sRuntimeVersionId
	}

	rancher_releases ||--o{ rancher_release_rke_runtimes : "foreign key"
	rke_cli_versions ||--o{ rancher_release_rke_runtimes : "foreign key"
	k8s_runtime_versions ||--o{ rancher_release_rke_runtimes : "foreign key"

	os_distros {
		INTEGER OsDistroId
		NVARCHAR Name
	}

	os_distro_versions {
		INTEGER OsDistroVersionId
		INTEGER OsDistroId
		NVARCHAR Version
	}

	os_distros ||--o{ os_distro_versions : "foreign key"

	rke_docker_versions {
		INTEGER DockerVersionId
		NVARCHAR Name
		NVARCHAR Version
	}

	rke_os_distro_docker_version_combos {
		INTEGER OsDistroDockerComboId
		INTEGER OsDistroVersionId
		INTEGER DockerVersionId
	}
	os_distro_versions ||--o{ rke_os_distro_docker_version_combos : "foreign key"
	rke_docker_versions ||--o{ rke_os_distro_docker_version_combos : "foreign key"

	rancher_release_rke_version_combos {
		INTEGER RancherReleaseOsDistroDockerComboId
		INTEGER RancherReleaseId
		INTEGER OsDistroDockerComboId
	}
	rancher_releases ||--o{ rancher_release_rke_version_combos : "foreign key"
	rke_os_distro_docker_version_combos ||--o{ rancher_release_rke_version_combos : "foreign key"

	k3s_runtime_variants {
		INTEGER K3sRuntimeVariantId
		INTEGER K8sRuntimeVersionId
		NVARCHAR Version
		NVARCHAR Notes
	}

	k8s_runtime_versions ||--o{ k3s_runtime_variants : "foreign key"

	rancher_release_k3s_version_combos {
		INTEGER RancherReleaseK3sVersionComboId
		INTEGER RancherReleaseId
		INTEGER K3sRuntimeVariantId
		NVARCHAR ComponentNotes
	}

	rancher_releases ||--o{ rancher_release_k3s_version_combos : "foreign key"
	k3s_runtime_variants ||--o{ rancher_release_k3s_version_combos : "foreign key"

	rancher_release_k3s_os_distro_versions {
		INTEGER RancherReleaseK3sOsDistroId
		INTEGER RancherReleaseId
		INTEGER OsDistroVersionId
	}
	rancher_releases ||--o{ rancher_release_k3s_os_distro_versions : "foreign key"
	os_distro_versions ||--o{ rancher_release_k3s_os_distro_versions : "foreign key"

	rke2_runtime_variants {
		INTEGER Rke2RuntimeVariantId
		INTEGER K8sRuntimeVersionId
		NVARCHAR Version
		NVARCHAR Notes
	}

	k8s_runtime_versions ||--o{ rke2_runtime_variants : "foreign key"

	rancher_release_rke2_version_combos {
		INTEGER RancherReleaseRke2VersionComboId
		INTEGER RancherReleaseId
		INTEGER Rke2RuntimeVariantId
		NVARCHAR ComponentNotes
	}

	rancher_releases ||--o{ rancher_release_rke2_version_combos : "foreign key"
	rke2_runtime_variants ||--o{ rancher_release_rke2_version_combos : "foreign key"

	rancher_release_rke2_os_distro_versions {
		INTEGER RancherReleaseK3sOsDistroId
		INTEGER RancherReleaseId
		INTEGER OsDistroVersionId
	}
	rancher_releases ||--o{ rancher_release_rke2_os_distro_versions : "foreign key"
	os_distro_versions ||--o{ rancher_release_rke2_os_distro_versions : "foreign key"