SQLStatements Session 1 2 1

1.create table role(Id BIGINT(20), name varchar(255) NOT NULL,primary key(Id));
2.create table skill(Id BIGINT(20)primary key, description varchar(255) NULL, name varchar(255) NOT NULL);
3.create table post_type(Id BIGINT(20)primary key,name varchar(255) NOT NULL);
4.create table department(Id BIGINT(20)primary key, name varchar(255) NOT NULL);
5.create table degree
(
Id BIGINT(20)primary key, department_id BIGINT(20) NOT NULL, name varchar(255) NOT NULL, FOREIGN KEY(department_id) REFERENCES department(Id)
);

6. create table profile
(
Id BIGINT(20)primary key, address varchar(255) NOT NULL, batch varchar(255) NOT NULL, degree_id BIGINT(20) NOT NULL, designation varchar(255) NULL, gender varchar(255) NOT NULL, FOREIGN KEY(degree_id) REFERENCES degree(Id)
);

7. create table higher_degree
(
Id BIGINT(20)primary key, degree_name varchar(255) NULL, university_name varchar(255) NULL, profile_id BIGINT(20) NOT NULL, FOREIGN KEY(profile_id) REFERENCES profile(Id)
);

8. create table experience
(
Id BIGINT(20)primary key, company_name varchar(255) NOT NULL, current BIT(1) NOT NULL, end DATETIME NULL, start DATETIME NOT NULL, profile_id BIGINT(20) NOT NULL, FOREIGN KEY(profile_id) REFERENCES profile(Id)
);

9. create table project
(
Id BIGINT(20)primary key, name varchar(255) NOT NULL, number_of_members INT(11) NOT NULL, profile_id BIGINT(20) NOT NULL, short_description varchar(255) NULL, FOREIGN KEY(profile_id) REFERENCES profile(Id)
);

10.create table profile_skills
(
skill_id BIGINT(20), profile_id BIGINT(20), PRIMARY KEY(skill_id,profile_id)
);

11. create table user
(
Id BIGINT(20) primary key, emailid varchar(255) NOT NULL, name varchar(255) NOT NULL, password varchar(255) NOT NULL, phonenumber varchar(255) NOT NULL, profile_id BIGINT(20) NULL, role_id BIGINT(20) NOT NULL, username varchar(255) NOT NULL, FOREIGN KEY(profile_id) REFERENCES profile(Id), FOREIGN KEY(role_id)