擅长:python、mysql、java
<p>考虑使用多对多联接表。使用应用程序逻辑防止每个患者有两个以上的医生。在</p>
<pre><code>Physician
Physician_ID
...
Patient
Patient_ID
...
Physician_Patient
Physician_ID int not null
Patient_ID int not null
Type ENUM ('Primary', 'Attending')
PRIMARY KEY (Physician_ID, Patient_ID)
KEY (Patient_ID)
</code></pre>