public.announcements

Description

Columns

Name	Type	Default	Nullable	Children	Parents	Comment
id	bigint	nextval('announcements_id_seq'::regclass)	false
title	varchar(255)		false
body	text		false
category	varchar(32)	'info'::character varying	false
published_at	timestamp with time zone	now()	false
created_at	timestamp with time zone	now()	false
updated_at	timestamp with time zone	now()	false

Constraints

Name	Type	Definition
announcements_body_not_null	n	NOT NULL body
announcements_category_not_null	n	NOT NULL category
announcements_created_at_not_null	n	NOT NULL created_at
announcements_id_not_null	n	NOT NULL id
announcements_published_at_not_null	n	NOT NULL published_at
announcements_title_not_null	n	NOT NULL title
announcements_updated_at_not_null	n	NOT NULL updated_at
announcements_pkey	PRIMARY KEY	PRIMARY KEY (id)

Indexes

Name	Definition
announcements_pkey	CREATE UNIQUE INDEX announcements_pkey ON public.announcements USING btree (id)
idx_announcements_published_at	CREATE INDEX idx_announcements_published_at ON public.announcements USING btree (published_at DESC)

Relations

---

Generated by tbls