Is this SQL queries Correct??

create table routes route_id int, route_name varchar(50) not null, primary key (route_id) create table stops stop_id int, stop_name varchar(50) not null, primary key(stop_id) create table vehicles( vehicle_id int, primary key(vehicle_id) create table passenger_data( Lindex) Int, date timestamp not nulL, route_id int not null, direction varchar(50) not null, stop_id int not null, on number int not null default 0 off number int not null default 0 vehicle_id int not null, primary key([index]), foreign key(route_id) references routes (route_id), foreign key(stop_id) references stops(stop_id), foreign key(vehicle_id) references vehicles(vehicle_id)