linkedIn.sql

CREATE TABLE Users (
    UserID INT AUTO_INCREMENT PRIMARY KEY,
    FirstName TEXT,
    LastName TEXT,
    Username TEXT,
    Password TEXT
);

CREATE TABLE Schools (
    SchoolID INT AUTO_INCREMENT PRIMARY KEY,
    Name TEXT,
    Type TEXT,
    Location TEXT,
    FoundedYear INT
);

CREATE TABLE Companies (
    CompanyID INT AUTO_INCREMENT PRIMARY KEY,
    Name TEXT,
    Industry TEXT,
    Location TEXT
);

CREATE TABLE UserConnections (
    ConnectionID INT AUTO_INCREMENT PRIMARY KEY,
    UserID1 INT,
    UserID2 INT,
    FOREIGN KEY (UserID1) REFERENCES Users(UserID),
    FOREIGN KEY (UserID2) REFERENCES Users(UserID),
    UNIQUE (UserID1, UserID2)
    );
    
   CREATE TABLE UserSchools (
    UserSchoolID INT AUTO_INCREMENT PRIMARY KEY,
    UserID INT,
    SchoolID INT,
    StartDate DATE,
    EndDate DATE,
    Degree TEXT,
    FOREIGN KEY (UserID) REFERENCES Users(UserID),
    FOREIGN KEY (SchoolID) REFERENCES Schools(SchoolID)
    );
    
   CREATE TABLE UserCompanies (
    UserCompanyID INT AUTO_INCREMENT PRIMARY KEY,
    UserID INT,
    CompanyID INT,
    StartDate DATE,
    EndDate DATE,
    Title TEXT,
    FOREIGN KEY (UserID) REFERENCES Users(UserID),
    FOREIGN KEY (CompanyID) REFERENCES Companies(CompanyID)
);