Just a simple DDL for MySQL

DDL_For_DB_Project.txt

CREATE TABLE `User + User Registration Info` (
  `User_Id` NUMBER,
  `Joined Website` DATETIME,
  `Handler` VARCHAR(40),
  `first_name` VARCHAR(20),
  `middle_name` VARCHAR(20),
  `last_name` VARCHAR(20),
  `Email` VARCHAR(30),
  `Password` VARCHAR(30),
  PRIMARY KEY (`User Id`)
);

CREATE TABLE `Connections` (
  `Connection_ID` NUMBER,
  `Follower` NUMBER,
  `Following` NUMBER,
  PRIMARY KEY (`Connection_ID`),
  FOREIGN KEY (Follower) REFERENCES User(User_Id),
  FOREIGN KEY (Following) REFERENCES User(User_Id)
);

CREATE TABLE `Interests` (
  `User_Id` NUMBER,
  `Topic` VARCHAR(20),
  FOREIGN KEY(User_Id) REFERENCES User(User_Id)
);

CREATE TABLE `Academic ` (
  `from` VARCHAR(20),
  `in` VARCHAR(20),
  `type` VARCHAR(20),
  `User_Id` NUMBER,
  `Academic ID` NUMBER,
  PRIMARY KEY (`Academic ID`),
  FOREIGN KEY (User_Id) REFERENCES User(User_Id)
);

CREATE TABLE `Work / Organization` (
  `User_Id` NUMBER,
  `name` VARCHAR(40),
  `type` VARCHAR(40),
  FOREIGN KEY (User_Id) REFERENCES User(User_Id)
);

CREATE TABLE `User Panel Information ` (
  `User_Id` NUMBER,
  `Date_Of_Birth` DATETIME,
  `Activities` VARCHAR(80),
  `Biography` VARCHAR(200),
  `Location` VARCHAR(60),
  `Instagram` VARCHAR(100),
  `Facebook` VARCHAR(100),
  `LinkedIn` VARCHAR(100),
  `Twitter` VARCHAR(100),
  `Website` VARCHAR(100),
  PRIMARY KEY (`User Id`),
  FOREIGN KEY(User_Id) REFERENCES User(User_Id)
);

CREATE TABLE `Post` (
  `Pid` NUMBER,
  `User_Id` NUMBER,
  `Title` VARCHAR(40),
  `Date Published` DATETIME,
  `ContentRef Id` NUMBER,
  PRIMARY KEY (`Pid`)
  FOREIGN KEY (User_Id) REFERENCES User(User_Id)
);

CREATE TABLE `Notification` (
  `Nid` NUMBER,
  `User_Id` NUMBER,
  `Action` VARCHAR(10),
  PRIMARY KEY (`Nid`)
  FOREIGN KEY (User_Id) REFERENCES User(User_Id)
);