k9B1z83Z

1I thing is text not varchar
2
3DROP DATABASE IF NOT EXISTS udemy;
4CREATE DATABASE udemy;
5
6\c udemy;
7
8
9CREATE TABLE IF NOT EXISTS courses (
10 course_id SERIAL PRIMARY KEY,
11 name VARCHAR (200),
12 created_at TIMESTAMP not null DEFAULT CURRENT_TIMESTAMP,
13 updated_at TIMESTAMP not null DEFAULT CURRENT_TIMESTAMP
14);
15
16CREATE TABLE IF NOT EXISTS users (
17user_id SERIAL PRIMARY KEY,
18username CHAR(50),
19user_pic VARCHAR (50),
20course_count INTEGER,
21review_count INTEGER,
22created_at TIMESTAMP not null DEFAULT CURRENT_TIMESTAMP,
23updated_at TIMESTAMP not null DEFAULT CURRENT_TIMESTAMP
24);
25
26
27CREATE TABLE IF NOT EXISTS reviews (
28 review_id SERIAL PRIMARY KEY,
29 user_id INTEGER REFERENCES users(user_id),
30 course_id INTEGER REFERENCES courses(course_id),
31 rating NUMERIC(2,1),
32 review VARCHAR (300),
33 date VARCHAR (25),
34 upvotes INTEGER,
35 downvotes INTEGER,
36 reported INTEGER,
37 created_at TIMESTAMP not null DEFAULT CURRENT_TIMESTAMP,
38 updated_at TIMESTAMP not null DEFAULT CURRENT_TIMESTAMP
39);
40
41\COPY courses (course_id, name) FROM ‘/Users/simonliu/Desktop/student-feedback/database/courseData.csv’ WITH (FORMAT CSV)
42\COPY users (username, user_pic, course_count, review_count) FROM ‘/Users/simonliu/Desktop/student-feedback/database/users.csv’ WITH (FORMAT CSV)
43\COPY reviews (user_id, course_id, rating, review, date, upvotes, downvotes, reported) FROM ‘/Users/simonliu/Desktop/student-feedback/database/reviews.csv’ WITH (FORMAT CSV)
44this is what i have for my tables
45I might have to use map for it