public.proposed_block_edits

Description

A suggestion to change the contents of a single block, part of some set of proposed edits to a page.

Columns

Name	Type	Default	Nullable	Children	Parents	Comment
block_attribute	text		false			The block attribute that contains the text that is being changed.
block_id	uuid		false			The course material block that the proposal is for.
changed_text	text		false			The changed text of the block.
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.
id	uuid	uuid_generate_v4()	false			A unique, stable identifier for the record.
original_text	text		false			The original text of the block.
proposal_id	uuid		false		public.proposed_page_edits	A student can send in proposal this edit is a part of.
status	proposal_status	‘pending’::proposal_status	false			The status of the proposal.
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
proposed_block_edits_pkey	PRIMARY KEY	PRIMARY KEY (id)
proposed_block_edits_proposal_id_fkey	FOREIGN KEY	FOREIGN KEY (proposal_id) REFERENCES proposed_page_edits(id)

Indexes

Name	Definition
proposed_block_edits_pkey	CREATE UNIQUE INDEX proposed_block_edits_pkey ON public.proposed_block_edits USING btree (id)

Triggers

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

Relations

er

Generated by tbls