category


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id INTEGER 2000000000 √ √ null
account.category_id R
category.parent_id N
name TEXT 2000000000 null
parent_id INTEGER 2000000000 √ null
category.id N
revision_id INTEGER 2000000000 1

Indexes

Constraint Name Type Sort Column(s)
category_s_pk Primary key Asc id
idx_category_parent Performance Asc parent_id

Relationships

Close relationships within degrees of separation