organ_donation.sql

CREATE TABLE user (
    Name VARCHAR(100) NOT NULL,
    Email VARCHAR(100) NOT NULL,
    Password VARCHAR(255) NOT NULL,
    Age INT NOT NULL,
    Gender ENUM('Male', 'Female', 'Other') NOT NULL,
    PhoneNo VARCHAR(10) UNIQUE NOT NULL,
    PRIMARY KEY (Name, Email)
);
CREATE TABLE donors (
    Name VARCHAR(100) NOT NULL,
    Email VARCHAR(100) NOT NULL,
    OrganName VARCHAR(50) NOT NULL,
    AllOrgans TINYINT(1) NOT NULL DEFAULT 0,
    BloodGroup VARCHAR(10) NOT NULL,
    MedicalIssue TEXT  NOT NULL,
    Contact VARCHAR(10) NOT NULL,
    Address TEXT NOT NULL,
    PRIMARY KEY (Name, Email, OrganName),
    FOREIGN KEY (Name, Email) REFERENCES User(Name, Email)
);
CREATE TABLE recipients (
    Name VARCHAR(100) NOT NULL,
    Email VARCHAR(100) NOT NULL,
    OrganName VARCHAR(50) NOT NULL,
    BloodGroup VARCHAR(10) NOT NULL,
    ExpectedDate DATE NOT NULL,
    Address TEXT NOT NULL,
    PRIMARY KEY (Name, Email, OrganName),
    FOREIGN KEY (Name, Email) REFERENCES User(Name, Email)
);