create table public.USERS (
    user_id int primary key,
    nickname varchar not null,
    password varchar not null,
    gold int,
    silver int,
    bronze int,
    totalPoints int,
    numOfRunEventsCreated int,
    numOfCycEventsCreated int,
 profilePic bytea
);
create table public.ACTIVITIES (
    activity_id int primary key,
    adate date,
    aname varchar,
    user_id int references USERS
);
create table public.ROC (
    roc_id int references ACTIVITIES,
    averageSpeed float,
    calories int,
    distance float,
    elapsedTime time,
    maxSpeed float,
    primary key (roc_id)
);
create table public.ROUNDS (
    round_id int references ACTIVITIES,
    numOfRounds int,
    roundTime int,
    roundPause int,
    primary key (round_id)
);
create table public.EVENTS (
    event_id int primary key,
    numOfIn int,
    numOfPictures int,
    startDate date,
    endDate date,
    challangedDistance float,
    challangedTime int,
    user_id int references USERS,
    roc_id int references ROC
);
create table public.PICTURES (
    description varchar,
    picture bytea,
    event_id int references EVENTS,
    user_id int references USERS,
 primary key(event_id, user_id)
);
create table public.INVITATIONS (
    invitation_id int,
    event_id int references EVENTS,
 user_id int references USERS,
 for_user int references USERS,
    primary key(invitation_id)
);
create table public.IS_FRIEND (
    user_id int references USERS,
    with_user int references USERS,
    --check (user <> with_user),
    primary key (user_id, with_user)
);