Skip to content

public.trusted_source

Columns

Name Type Default Nullable Children Parents Comment
config text false
configVersion integer false
createdAt timestamp(3) with time zone CURRENT_TIMESTAMP(3) false
discoveryClaimToken varchar(36) true
discoveryClaimedAt timestamp(3) with time zone true
id varchar(36) false public.trusted_source_identity
issuer varchar false
lastCheckedAt timestamp(3) with time zone true
lastError text true
managedBy varchar(16) false
metadata text true
name varchar(128) false
status varchar(16) false
type varchar(32) false
updatedAt timestamp(3) with time zone CURRENT_TIMESTAMP(3) false

Constraints

Name Type Definition
PK_2eea0a99b54a2022620817b1ffb PRIMARY KEY PRIMARY KEY (id)
trusted_source_configVersion_not_null n NOT NULL "configVersion"
trusted_source_config_not_null n NOT NULL config
trusted_source_createdAt_not_null n NOT NULL "createdAt"
trusted_source_id_not_null n NOT NULL id
trusted_source_issuer_not_null n NOT NULL issuer
trusted_source_managedBy_not_null n NOT NULL "managedBy"
trusted_source_name_not_null n NOT NULL name
trusted_source_status_not_null n NOT NULL status
trusted_source_type_not_null n NOT NULL type
trusted_source_updatedAt_not_null n NOT NULL "updatedAt"

Indexes

Name Definition
IDX_519e3445a1740f2ddbab2749b5 CREATE UNIQUE INDEX "IDX_519e3445a1740f2ddbab2749b5" ON public.trusted_source USING btree (issuer)
IDX_d3055524099cd341a2af4b8eb9 CREATE UNIQUE INDEX "IDX_d3055524099cd341a2af4b8eb9" ON public.trusted_source USING btree (name)
PK_2eea0a99b54a2022620817b1ffb CREATE UNIQUE INDEX "PK_2eea0a99b54a2022620817b1ffb" ON public.trusted_source USING btree (id)

Relations

erDiagram

"public.trusted_source_identity" }o--|| "public.trusted_source" : "FOREIGN KEY (#quot;sourceId#quot;) REFERENCES trusted_source(id) ON DELETE CASCADE"

"public.trusted_source" {
  text config
  integer configVersion
  timestamp_3__with_time_zone createdAt
  varchar_36_ discoveryClaimToken
  timestamp_3__with_time_zone discoveryClaimedAt
  varchar_36_ id
  varchar issuer
  timestamp_3__with_time_zone lastCheckedAt
  text lastError
  varchar_16_ managedBy
  text metadata
  varchar_128_ name
  varchar_16_ status
  varchar_32_ type
  timestamp_3__with_time_zone updatedAt
}
"public.trusted_source_identity" {
  timestamp_3__with_time_zone createdAt
  timestamp_3__with_time_zone lastSeenAt
  varchar_32_ provenance
  varchar_36_ sourceId FK
  varchar_16_ status
  varchar subject
  timestamp_3__with_time_zone updatedAt
  uuid userId FK
}

Generated by tbls