test_tebengan.sql

gistfile1.txt

create table "user" (
  id serial primary key,
  first_name varchar(50) not null,
  last_name varchar(50)
);

create table "ride" (
  id serial primary key,
  from_city_name varchar(100) not null,
  to_city_name varchar(100) not null,
  user_id int not null
)

insert into public."user" (first_name, last_name)
values
	('jaka', 'tingkir'),
	('tengku', 'umar');

	
insert into public."ride" (from_city_name, to_city_name, user_id)
values
	('Bandung', 'Jakarta', 2);