replace foreign key with on delete cascade with trigger

This locking architecture would cause performance problem on almost all databases.