create table category (
   id           numeric(9,0)  -- autoincrement
,  parent_id    numeric(9,0) null
,  name         varchar(30)
,  level        int           -- might not be needed)
,  ... other columns 
)