mysql - 如何将流程添加为数据库中的关系，例如捐赠记录等

Question

I wanted to record processes of donating blood by a donor to a blood bank as well as processes of accepting blood by a patient from a blood bank by including table of the processes

record of Donation and record of Acceptance

I was confused on how to add the tables should i link them with the donors or the bank can i get help with plus any other additional info i will grateful.

Answer 1

我不确定我是否完全理解您发布的图片，但根据您的解释，这是适合您的用例的示例设计。

1) 从以下 3 个表开始:它们定义基础对象，并且彼此独立。

DONOR
    ID               -- primary key
    NAME
    BLOOD_GROUP
    MEDICAL_REPORT
    CONTACT_NUMBER
    ADDRESS

PATIENT
    ID               -- primary key
    NAME
    BLOOD_GROUP
    DISEASE

BLOOD_BANK
    ID               -- primary key
    ADDRESS
    CONTACT_NUMBER

现在您已准备好创建用于跟踪捐赠和接受的表格。

2) 捐赠表引用了捐赠者和血库:

DONATION
    ID               -- primary key
    DONOR_ID         -- foreign key to DONOR.ID
    BLOOD_BANK_ID    -- foreign key to BLOOD_BANK.ID
    PLACE
    TIME
    AMOUNT

3) 接受表引用捐赠和患者:

 ACCEPTANCE
    ID               -- primary key
    PATIENT_ID       -- foreign key to PATIENT.ID
    DONATION_ID      -- foreign key to DONATION.ID