How to make two tables?

Question

PostgreSQL

The task is next. There is a table of users with data and there is a table of accounts linked to the user (one user can have two accounts). How to merge two tables so that when a user is deleted, all his accounts are deleted? Is this done through sql or is a separate method written?

Answer 1

This is done through foreign key constraints .