testdb

Description

Sample PostgreSQL database document.

Viewpoints

Name	Description
post	for post
administrator	administrator schema only

Tables

Name	Columns	Comment	Type
public.users	6	Users table	BASE TABLE
public.user_options	4	User options table	BASE TABLE
public.posts	8	Posts table	BASE TABLE
public.comments	7	Comments Multi-line table comment	BASE TABLE
public.comment_stars	6		BASE TABLE
public.logs	7	audit log table	BASE TABLE
public.post_comments	7	post and comments View table	VIEW
public.post_comment_stars	5		MATERIALIZED VIEW
public.CamelizeTable	2		BASE TABLE
public.hyphen-table	4		BASE TABLE
administrator.blogs	6	admin blogs	BASE TABLE
backup.blogs	5		BASE TABLE
backup.blog_options	4		BASE TABLE
time.bar	1		BASE TABLE
time.hyphenated-table	1		BASE TABLE
time.referencing	3		BASE TABLE

Stored procedures and functions

Name	ReturnType	Arguments	Type
public.uuid_nil	uuid		FUNCTION
public.uuid_ns_dns	uuid		FUNCTION
public.uuid_ns_url	uuid		FUNCTION
public.uuid_ns_oid	uuid		FUNCTION
public.uuid_ns_x500	uuid		FUNCTION
public.uuid_generate_v1	uuid		FUNCTION
public.uuid_generate_v1mc	uuid		FUNCTION
public.uuid_generate_v3	uuid	namespace uuid, name text	FUNCTION
public.uuid_generate_v4	uuid		FUNCTION
public.uuid_generate_v5	uuid	namespace uuid, name text	FUNCTION
public.update_updated	trigger		FUNCTION
public.reset_comment	void	IN comment_id integer	PROCEDURE

Enums

Name	Values
public.post_types	draft, private, public

Relations

---

Generated by tbls