repeated schema

[Angham116]

You have made 2 SQL files for your schema (db_build.sql & test_db.sql)

Suggestion :

you can make 1 SQL file to your schema

    BEGIN;
    DROP TABLE IF EXISTS users, places CASCADE;
   CREATE TABLE users (
     user_id SERIAL PRIMARY KEY,
     user_name VARCHAR(20) NOT NULL,
     email  VARCHAR UNIQUE,
     phone  INT UNIQUE
   ); & so on

then you don't need to repeat the same commands to create tables and add constraints on db_test.js file

you can add the fake_data just.
As :

 INSERT INTO users(user_name,email,phone) VALUES ('Sajeda','[email protected]',0599789523);
 INSERT INTO users(user_name,email,phone) VALUES ('Fares','[email protected]',0599289523);
 INSERT INTO places(place_name,location,service,delivery,image,user_id) VALUES ('take-break','gaza','food',true,'https://images.unsplash.com/photo-1541745537411-b8046dc6d66c?ixlib=rb-1.2.1&ixid=eyJhcHBfaWQiOjEyMDd9&auto=format&fit=crop&w=334&q=80',1);
 INSERT INTO places(place_name,location,service,delivery,image,user_id) VALUES ('abdallah','gaza','food',true,'https://images.unsplash.com/photo-1541745537411-b8046dc6d66c?ixlib=rb-1.2.1&ixid=eyJhcHBfaWQiOjEyMDd9&auto=format&fit=crop&w=334&q=80',2);


JUST