Skip to content
DBML templates

DBML — content CMS

Articles, authors, tags, revisions.

Template previewDBML
articles.author_id > authors.idrevisions.article_id > articles.idarticle_tags.article_id > articles.idarticle_tags.tag_id > tags.idauthorsiduuidnamevarcharemailvarchararticlesiduuidauthor_iduuidslugvarcharpublished_attimestamprevisionsidbigintarticle_iduuidbodytextcreated_attimestamptagsidintnamevarchararticle_tagsarticle_iduuidtag_idint

Make it your own.

Table authors { id uuid [pk]; name varchar; email varchar }
Table articles { id uuid [pk]; author_id uuid [ref: > authors.id]; slug varchar; published_at timestamp }
Table revisions { id bigint [pk, increment]; article_id uuid [ref: > articles.id]; body text; created_at timestamp }
Table tags { id int [pk]; name varchar }
Table article_tags { article_id uuid [ref: > articles.id]; tag_id int [ref: > tags.id] }