public categories (table)

wikibot

Tablepublic.categories

Columns

ColumnData TypeNullableDefaultDescription
categoryidintegernot null  
categorynamevarchar(64)not null  
categorydescriptionvarchar(256)null  

Primary Key

Primary KeyColumns
category_pkeycategoryid

Indexes

IndexTypeColumns
category_idx categoryname

Detail Tables

Detail TableColumnReferencing Column
public.category_nodecategoryidcategoryid