A
A
Art0052020-10-19 20:49:38
Database design
Art005, 2020-10-19 20:49:38

Relationship of a column to its own primary key?

I want to make a table of positions for myself, where, in addition to everything, the position will have a direct boss who would be connected to the same table of positions. How to do it? Is it possible to bind a foreign key to your own table or would it be better somehow differently and how exactly?
Or is it even possible to somehow improve the hierarchy?

Answer the question

In order to leave comments, you need to log in

1 answer(s)
D
Dr. Bacon, 2020-10-19
@bacon

foreign key on self, it is directly mentioned in the docs

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question