CREATE TABLE person ( name CHAR(50) PRIMARY KEY, spouse char(50) references person.name, father char(50) references person.name, mother char(50) references person.name, best_friend char(50) references person.name, boss char(50) references person.name ); #### cat "persons/Larry Wall/spouse:row/best_friend:row/mother:row/boss:row/father:row/name" #### > ls -l company:row cmopany:row -> ../../companies/Blogtronic > ls company:row name business #### > ls -l company:row cmopany:row # not a symlink > ls company:row name business