public.type_availability_policy¶

Columns¶

Name	Type	Default	Nullable	Children
createdAt	timestamp(3) with time zone	CURRENT_TIMESTAMP(3)	false
id	varchar(36)		false	public.type_availability_policy_attachment
kind	varchar(64)		false
rules	json		false
updatedAt	timestamp(3) with time zone	CURRENT_TIMESTAMP(3)	false
updatedBy	varchar(36)		false
version	integer	1	false

Constraints¶

Name	Type	Definition
PK_7dc9809c6d53a6b8b8a62cd7798	PRIMARY KEY	PRIMARY KEY (id)
type_availability_policy_createdAt_not_null	n	NOT NULL "createdAt"
type_availability_policy_id_not_null	n	NOT NULL id
type_availability_policy_kind_not_null	n	NOT NULL kind
type_availability_policy_rules_not_null	n	NOT NULL rules
type_availability_policy_updatedAt_not_null	n	NOT NULL "updatedAt"
type_availability_policy_updatedBy_not_null	n	NOT NULL "updatedBy"
type_availability_policy_version_not_null	n	NOT NULL version

Indexes¶

Name	Definition
IDX_type_availability_policy_kind_createdAt_id	CREATE INDEX "IDX_type_availability_policy_kind_createdAt_id" ON public.type_availability_policy USING btree (kind, "createdAt", id)
PK_7dc9809c6d53a6b8b8a62cd7798	CREATE UNIQUE INDEX "PK_7dc9809c6d53a6b8b8a62cd7798" ON public.type_availability_policy USING btree (id)

Relations¶

erDiagram

"public.type_availability_policy_attachment" }o--|| "public.type_availability_policy" : "FOREIGN KEY (#quot;policyId#quot;) REFERENCES type_availability_policy(id) ON DELETE RESTRICT"

"public.type_availability_policy" {
  timestamp_3__with_time_zone createdAt
  varchar_36_ id
  varchar_64_ kind
  json rules
  timestamp_3__with_time_zone updatedAt
  varchar_36_ updatedBy
  integer version
}
"public.type_availability_policy_attachment" {
  timestamp_3__with_time_zone createdAt
  boolean isFloor
  varchar_36_ policyId FK
  integer priority
  varchar_36_ scopeId FK
  timestamp_3__with_time_zone updatedAt
}

Generated by tbls