I'm adding a table and subclass table to my DB. (Subclass table = table where the primary key joins to the primary key of another table, to give extra row information to some subset of the rows.

Should I set up a foreign key constraint? How would I go about doing this within a table (to tie the parentid field to the folderid field)? Would it cascade through multiple levels? I.e. For the ...