Can anyone see any problem with the following, practice?
CREATE TABLE parent (
foo SERIAL PRIMARY KEY
);
CREATE TABLE child (
foo INTEGER PRIMARY KEY REFERENCES parent ON DELETE CASCADE,
bar TEXT
);
CREATE TABLE subchild (
foo INTEGER PRIMARY KEY REFERENCES child ON DELETE CASCADE,
bar2 TEXT
);