select distinct t.name , p.required , property , param_kind, param_type
from properties p , types t
where (t.name like '%PodSpec' or p.param_kind like '%PodSpec')
-- and p.param_kind like 'io%'
-- and p.required
and p.type_id = t.id
and param_kind not like '%alpha%'
and param_kind not like '%beta%'
-- and p.param_type != 'array'
and t.name not like '%alpha%'
and t.name not like '%beta%'
order by -- param_type,
t.name,
param_type,
param_kind;
name | required | property | param_kind | param_type
------------------------------------+----------+-------------------------------+-----------------------------------------+------------
io.k8s.api.core.v1.Pod | f | spec | io.k8s.api.core.v1.PodSpec | subtype
io.k8s.api.core.v1.PodSpec | f | initContainers | io.k8s.api.core.v1.Container | array
io.k8s.api.core.v1.PodSpec | t | containers | io.k8s.api.core.v1.Container | array
io.k8s.api.core.v1.PodSpec | f | hostAliases | io.k8s.api.core.v1.HostAlias | array
io.k8s.api.core.v1.PodSpec | f | imagePullSecrets | io.k8s.api.core.v1.LocalObjectReference | array
io.k8s.api.core.v1.PodSpec | f | readinessGates | io.k8s.api.core.v1.PodReadinessGate | array
io.k8s.api.core.v1.PodSpec | f | tolerations | io.k8s.api.core.v1.Toleration | array
io.k8s.api.core.v1.PodSpec | f | volumes | io.k8s.api.core.v1.Volume | array
io.k8s.api.core.v1.PodSpec | f | automountServiceAccountToken | integer | boolean
io.k8s.api.core.v1.PodSpec | f | enableServiceLinks | integer | boolean
io.k8s.api.core.v1.PodSpec | f | hostIPC | integer | boolean
io.k8s.api.core.v1.PodSpec | f | hostNetwork | integer | boolean
io.k8s.api.core.v1.PodSpec | f | hostPID | integer | boolean
io.k8s.api.core.v1.PodSpec | f | shareProcessNamespace | integer | boolean
io.k8s.api.core.v1.PodSpec | f | activeDeadlineSeconds | integer | integer
io.k8s.api.core.v1.PodSpec | f | priority | integer | integer
io.k8s.api.core.v1.PodSpec | f | terminationGracePeriodSeconds | integer | integer
io.k8s.api.core.v1.PodSpec | f | nodeSelector | integer | object
io.k8s.api.core.v1.PodSpec | f | overhead | integer | object
io.k8s.api.core.v1.PodSpec | f | dnsPolicy | string | string
io.k8s.api.core.v1.PodSpec | f | hostname | string | string
io.k8s.api.core.v1.PodSpec | f | nodeName | string | string
io.k8s.api.core.v1.PodSpec | f | preemptionPolicy | string | string
io.k8s.api.core.v1.PodSpec | f | priorityClassName | string | string
io.k8s.api.core.v1.PodSpec | f | restartPolicy | string | string
io.k8s.api.core.v1.PodSpec | f | runtimeClassName | string | string
io.k8s.api.core.v1.PodSpec | f | schedulerName | string | string
io.k8s.api.core.v1.PodSpec | f | serviceAccount | string | string
io.k8s.api.core.v1.PodSpec | f | serviceAccountName | string | string
io.k8s.api.core.v1.PodSpec | f | subdomain | string | string
io.k8s.api.core.v1.PodSpec | f | affinity | io.k8s.api.core.v1.Affinity | subtype
io.k8s.api.core.v1.PodSpec | f | dnsConfig | io.k8s.api.core.v1.PodDNSConfig | subtype
io.k8s.api.core.v1.PodSpec | f | securityContext | io.k8s.api.core.v1.PodSecurityContext | subtype
io.k8s.api.core.v1.PodTemplateSpec | f | spec | io.k8s.api.core.v1.PodSpec | subtype
(34 rows)