public.block_feedback

Description

Used to link feedback to the related blocks.

Columns

Name	Type	Default	Nullable	Children	Parents	Comment
block_id	uuid		false			The id of the block.
block_text	varchar(10000)		true			The textual contents of the block, if any.
created_at	timestamp with time zone	now()	false			Timestamp when the record was created.
deleted_at	timestamp with time zone		true			Timestamp when the record was deleted. If null, the record is not deleted.
feedback_id	uuid		false		public.feedback	The id of the feedback.
id	uuid	uuid_generate_v4()	false			A unique, stable identifier for the record.
order_number	integer	0	false
updated_at	timestamp with time zone	now()	false			Timestamp when the record was last updated. The field is updated automatically by the set_timestamp trigger.

Constraints

Name	Type	Definition
block_feedback_feedback_id_fkey	FOREIGN KEY	FOREIGN KEY (feedback_id) REFERENCES feedback(id)
block_feedback_pkey	PRIMARY KEY	PRIMARY KEY (id)

Indexes

Name	Definition
block_feedback_pkey	CREATE UNIQUE INDEX block_feedback_pkey ON public.block_feedback USING btree (id)

Triggers

Name	Definition
set_timestamp	CREATE TRIGGER set_timestamp BEFORE UPDATE ON public.block_feedback FOR EACH ROW EXECUTE FUNCTION trigger_set_timestamp()

Relations

er

Generated by tbls