I want to add a field to my user model that would be a referral ID, and would be a foreign key to a separate user, default value of null, and set to null on delete. Is this possible, having a foreign key to other records in the same class? If so, how would the foreign key be configured? I am having a hard time wrapping my head around how this would work, or even how to word a search to research myself.
Thanks in advance,