Foreign Key generator

ON DELETE CASCADE

It will make it easier to delete all child records when record on parent table is deleted

DEFERRABLE INITIALLY DEFERRED

Tells Postgres to only check constraints when committing the transaction, it will make the Insert, Update, Delete (DML) much faster, integrity will be ensured anyway.