replace foreign key with on delete cascade with trigger

[prakashs43]

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