Week 6 (Scaling)/ Happy To Connect

[v4run3]

CREATE DATABASE linkedin;
USE linkedin;

CREATE TABLE Users(
id INT AUTO_INCREMENT,
first_lastname VARCHAR(30) NOT NULL,
username VARCHAR(25) NOT NULL,
password VARCHAR(128) NOT NULL,
PRIMARY KEY(id)
);

CREATE TABLE Schools (
id INT AUTO_INCREMENT,
school_name VARCHAR(50) NOT NULL,
school_type ENUM('Primary', 'Secondary', 'Higher Education') NOT NULL,
school_location VARCHAR(32) NOT NULL,
school_year DATE NOT NULL,
PRIMARY KEY(id)
);

CREATE TABLE Companies(
id INT AUTO_INCREMENT,
company_name VARCHAR(30) NOT NULL,
company_industry VARCHAR(20) NOT NULL,
company_locationVARCHAR(20) NOT NULL,
PRIMARY KEY(id)
);

CREATE TABLE people_connections(
id INT AUTO_INCREMENT,
user_id INT NOT NULL,
following_user_id INT NOT NULL,
connection_date DATE NOT NULL,
PRIMARY KEY(id),
FOREIGN KEY(user_id) REFERENCES Users(id),
FOREIGN KEY(following_user_id) REFERENCES Users(id)
);

CREATE TABLE school_connections(
id INT AUTO_INCREMENT,
user_id INT NOT NULL,
school_id INT NOT NULL,
start_date DATE NOT NULL,
end_date DATE NOT NULL,
degree_type VARCHAR(10) NOT NULL,
PRIMARY KEY(id),
FOREIGN KEY(user_id) REFERENCES Users(id),
FOREIGN KEY(school_id) REFERENCES Schools(id)
);

CREATE TABLE company_connections(
id INT AUTO_INCREMENT,
user_id INT NOT NULL,
company_id INT NOT NULL,
start_date DATE NOT NULL,
end_date DATE NOT NULL,
PRIMARY KEY(id),
FOREIGN KEY(user_id) REFERENCES Users(id),
FOREIGN KEY(company_id) REFERENCES Companies(id)
);

[muhammedahmetsekerci]

There is no problem in both spellings.

[v4run3]

In the school_type u have used:
school_type ENUM(Primary, Secondary, Higher Education) NOT NULL, (which will give you error since you are using `` inside the ENUM)
instead you should be using '' to pass the data inside the ENUM.

[muhammedahmetsekerci]

Hello again, I tried both codes and the tables were created without any problems, although there were 1-2 errors due to SQLite3. Not only does the school desk you mentioned not appear, but it also doesn't appear when I try your code. This is probably a bug caused by the enum code and sqlite3. Also, when I try the code you sent with .read, both the Companies table and the school table do not appear in the schema and tables sections.