我想把doctorid作为我病人桌上的外键.
So I have all of my tables created - the main problem is that when I go to the table > structure > relation view only the primary key comes up that I can create a foreign key (and it is already the primary key of the certain table that I want to keep - i.e Patient table patient is enabled to be changed but the doctor Id -I have a doctor table also- is not enabled).
在关系视图中,我有另一个表,其中包含两个组合键(MedicineID和Patientid),它使我能够同时更改这两个键
我必须把患者表中的doctor ID索引放到其他地方吗?两者不能都是主键,因为Patient ID是Patient表的主键-Doctor是外来键.
我希望有人能帮忙
亲切的问候