Two foreign keys from one table
<p>I am trying in following DB ERD that <code>User</code> creates a <code>Profile</code>. A user can see his followers as well as the profiles that users are following.</p>

<p><a href="https://i.stack.imgur.com/koF3I.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/koF3I.jpg" alt="Database ERD"></a></p>

<p>The problem is: </p>

<p>Both sections either "Followers" or "Following" are users not Profile</p>

<p><strong>Update:</strong>
Is the following approach okay or in above diagram?</p>

<pre><code> SQL&gt; Create table users(
  2  user_id number(5) primary key,
  3  reg_date date,
  4  name varchar2(50),
  5  password varchar2(50));

Table created.

SQL&gt; Create table Follow(
  2  follow_id number(5),
  3  following number(5) constraint User_fk references users(user_id),
  4  follower number(5) constraint User_fk1 references users(user_id));

Table created.
</code></pre>

<p>Please advise. Thanks in anticipation</p>