create table USERS (
    userId INT primary key GENERATED BY DEFAULT AS IDENTITY NOT NULL,
    firstName varchar(15),
    lastName varchar(15),
    pesel varchar(11),
    email varchar(30),
    phoneNumber varchar(10),
    password varchar(40),
    specialisation varchar (30),
    roleId INT
);

create table VISITS (
    visitId INT primary key GENERATED BY DEFAULT AS IDENTITY NOT NULL,
    doctorId INT,
    patientId INT,
    visitDate date,
    room INT
);

create table ROLES (
    roleId INT primary key GENERATED BY DEFAULT AS IDENTITY NOT NULL,
    roleName varchar(20)
);