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)