BBWA_ERD
Tables (3)
BBWA
- Donor_Id (Donor_id) — CHAR(8 BYTE) — Primary key — NOT NULL
- D_Name (D_name) — NCHAR(6)
- D_Birth (D_birth) — NUMBER(6, 0)
- B_type — NCHAR(6)
- Hospital_loc (hosp_loc) — CHAR(1 BYTE)
- R_Date (r_date) — DATE
Donator
- Donor_Id (Donor_id) — CHAR(8 BYTE) — Foreign key → BBWA.Donor_Id — NOT NULL
- Name (name) — NCHAR(6)
- ID_Name (id) — NCHAR(8)
- Donation_Date (Donat_date) — DATE
- DRoom_Id (Droom_id) — CHAR(8 BYTE)
- Hospital_loc (hosp_loc) — LOCATION
Hospital (hospital)
- Donor_Id (Donor_id) — CHAR(8 BYTE) — Foreign key → BBWA.Donor_Id — NOT NULL
- Hosp_Date (hosp_date) — DATE
- HRoom_Id (hroom_id) — CHAR(8 BYTE)