create.sql

    create schema IF NOT EXISTS user_details;
    create table if not exists user_details."user-details" (
        age integer,
        birth_day date,
        consent_allowed boolean not null,
        id varchar(255) not null,
        email varchar(255),
        first_name varchar(255),
        last_name varchar(255),
        password varchar(255),
        role varchar(255) check (role in ('USER','ADMIN')),
        friends_list varchar(255),
        primary key (id)
    );

    create table user_details."user-details" (
        age integer,
        birth_day date,
        consent_allowed boolean not null,
        email varchar(255),
        first_name varchar(255),
        friends_list varchar(255),
        id varchar(255) not null,
        last_name varchar(255),
        password varchar(255),
        role varchar(255) check (role in ('USER','ADMIN')),
        primary key (id)
    );

    create table user_details."user-details" (
        age integer,
        birth_day date,
        consent_allowed boolean not null,
        email varchar(255),
        first_name varchar(255),
        friends_list varchar(255),
        id varchar(255) not null,
        last_name varchar(255),
        password varchar(255),
        role varchar(255) check (role in ('USER','ADMIN')),
        primary key (id)
    );

    create table user_details."user-details" (
        age integer,
        birth_day date,
        consent_allowed boolean not null,
        email varchar(255),
        first_name varchar(255),
        friends_list varchar(255),
        id varchar(255) not null,
        last_name varchar(255),
        password varchar(255),
        role varchar(255) check (role in ('USER','ADMIN')),
        primary key (id)
    );

    create table user_details."user-details" (
        age integer,
        birth_day date,
        consent_allowed boolean not null,
        email varchar(255),
        first_name varchar(255),
        friends_list varchar(255),
        id varchar(255) not null,
        last_name varchar(255),
        password varchar(255),
        role varchar(255) check (role in ('USER','ADMIN')),
        primary key (id)
    );

    create table user_details."user-details" (
        age integer,
        birth_day date,
        consent_allowed boolean not null,
        email varchar(255),
        first_name varchar(255),
        friends_list varchar(255),
        id varchar(255) not null,
        last_name varchar(255),
        password varchar(255),
        role varchar(255) check (role in ('USER','ADMIN')),
        primary key (id)
    );

    create table user_details."user-details" (
        age integer,
        birth_day date,
        consent_allowed boolean not null,
        email varchar(255),
        first_name varchar(255),
        friends_list varchar(255),
        id varchar(255) not null,
        last_name varchar(255),
        password varchar(255),
        role varchar(255) check (role in ('USER','ADMIN')),
        primary key (id)
    );

    create table user_details."user-details" (
        age integer,
        birth_day date,
        consent_allowed boolean not null,
        email varchar(255),
        first_name varchar(255),
        friends_list varchar(255),
        id varchar(255) not null,
        last_name varchar(255),
        password varchar(255),
        role varchar(255) check (role in ('USER','ADMIN')),
        primary key (id)
    );

    create table user_details."user-details" (
        age integer,
        birth_day date,
        consent_allowed boolean not null,
        email varchar(255),
        first_name varchar(255),
        friends_list varchar(255),
        id varchar(255) not null,
        last_name varchar(255),
        password varchar(255),
        role varchar(255) check (role in ('USER','ADMIN')),
        primary key (id)
    );

    create table user_details."user-details" (
        age integer,
        birth_day date,
        consent_allowed boolean not null,
        email varchar(255),
        first_name varchar(255),
        friends_list varchar(255),
        id varchar(255) not null,
        last_name varchar(255),
        password varchar(255),
        role varchar(255) check (role in ('USER','ADMIN')),
        primary key (id)
    );

    create table user_details."user-details" (
        age integer,
        birth_day date,
        consent_allowed boolean not null,
        email varchar(255),
        first_name varchar(255),
        friends_list varchar(255),
        id varchar(255) not null,
        last_name varchar(255),
        password varchar(255),
        role varchar(255) check (role in ('USER','ADMIN')),
        primary key (id)
    );

    create table user_details."user-details" (
        age integer,
        birth_day date,
        consent_allowed boolean not null,
        email varchar(255),
        first_name varchar(255),
        friends_list varchar(255),
        id varchar(255) not null,
        last_name varchar(255),
        password varchar(255),
        role varchar(255) check (role in ('USER','ADMIN')),
        primary key (id)
    );

    create table user_details."user-details" (
        age integer,
        birth_day date,
        consent_allowed boolean not null,
        email varchar(255),
        first_name varchar(255),
        friends_list varchar(255),
        id varchar(255) not null,
        last_name varchar(255),
        password varchar(255),
        role varchar(255) check (role in ('USER','ADMIN')),
        primary key (id)
    );

    create table user_details."user-details" (
        age integer,
        birth_day date,
        consent_allowed boolean not null,
        email varchar(255),
        first_name varchar(255),
        friends_list varchar(255),
        id varchar(255) not null,
        last_name varchar(255),
        password varchar(255),
        role varchar(255) check (role in ('USER','ADMIN')),
        primary key (id)
    );

    create table user_details."user-details" (
        age integer,
        birth_day date,
        consent_allowed boolean not null,
        email varchar(255),
        first_name varchar(255),
        friends_list varchar(255),
        id varchar(255) not null,
        last_name varchar(255),
        password varchar(255),
        role varchar(255) check (role in ('USER','ADMIN')),
        primary key (id)
    );

    create table user_details."user-details" (
        age integer,
        birth_day date,
        consent_allowed boolean not null,
        email varchar(255),
        first_name varchar(255),
        friends_list varchar(255),
        id varchar(255) not null,
        last_name varchar(255),
        password varchar(255),
        role varchar(255) check (role in ('USER','ADMIN')),
        primary key (id)
    );

    create table user_details."user-details" (
        age integer,
        birth_day date,
        consent_allowed boolean not null,
        email varchar(255),
        first_name varchar(255),
        friends_list varchar(255),
        id varchar(255) not null,
        last_name varchar(255),
        password varchar(255),
        role varchar(255) check (role in ('USER','ADMIN')),
        primary key (id)
    );

    create table user_details."user-details" (
        age integer,
        birth_day date,
        consent_allowed boolean not null,
        email varchar(255),
        first_name varchar(255),
        friends_list varchar(255),
        id varchar(255) not null,
        last_name varchar(255),
        password varchar(255),
        role varchar(255) check (role in ('USER','ADMIN')),
        primary key (id)
    );

    create table user_details."user-details" (
        age integer,
        birth_day date,
        consent_allowed boolean not null,
        email varchar(255),
        first_name varchar(255),
        friends_list varchar(255),
        id varchar(255) not null,
        last_name varchar(255),
        password varchar(255),
        role varchar(255) check (role in ('USER','ADMIN')),
        primary key (id)
    );

    create table user_details."user-details" (
        age integer,
        birth_day date,
        consent_allowed boolean not null,
        email varchar(255),
        first_name varchar(255),
        friends_list varchar(255),
        id varchar(255) not null,
        last_name varchar(255),
        password varchar(255),
        role varchar(255) check (role in ('USER','ADMIN')),
        primary key (id)
    );

    create table user_details."user-details" (
        age integer,
        birth_day date,
        consent_allowed boolean not null,
        email varchar(255),
        first_name varchar(255),
        friends_list varchar(255),
        id varchar(255) not null,
        last_name varchar(255),
        password varchar(255),
        role varchar(255) check (role in ('USER','ADMIN')),
        primary key (id)
    );

    create table user_details."user-details" (
        age integer,
        birth_day date,
        consent_allowed boolean not null,
        email varchar(255),
        first_name varchar(255),
        friends_list varchar(255),
        id varchar(255) not null,
        last_name varchar(255),
        password varchar(255),
        role varchar(255) check (role in ('USER','ADMIN')),
        primary key (id)
    );

    create table user_details."user-details" (
        age integer,
        birth_day date,
        consent_allowed boolean not null,
        email varchar(255),
        first_name varchar(255),
        friends_list varchar(255),
        id varchar(255) not null,
        last_name varchar(255),
        password varchar(255),
        role varchar(255) check (role in ('USER','ADMIN')),
        primary key (id)
    );

    create table user_details."user-details" (
        age integer,
        birth_day date,
        consent_allowed boolean not null,
        email varchar(255),
        first_name varchar(255),
        friends_list varchar(255),
        id varchar(255) not null,
        last_name varchar(255),
        password varchar(255),
        role varchar(255) check (role in ('USER','ADMIN')),
        primary key (id)
    );

    create table user_details."user-details" (
        age integer,
        birth_day date,
        consent_allowed boolean not null,
        email varchar(255),
        first_name varchar(255),
        friends_list varchar(255),
        id varchar(255) not null,
        last_name varchar(255),
        password varchar(255),
        role varchar(255) check (role in ('USER','ADMIN')),
        primary key (id)
    );

    create table user_details."user-details" (
        age integer,
        birth_day date,
        consent_allowed boolean not null,
        email varchar(255),
        first_name varchar(255),
        friends_list varchar(255),
        id varchar(255) not null,
        last_name varchar(255),
        password varchar(255),
        role varchar(255) check (role in ('USER','ADMIN')),
        primary key (id)
    );

    create table user_details."user-details" (
        age integer,
        birth_day date,
        consent_allowed boolean not null,
        email varchar(255),
        first_name varchar(255),
        friends_list varchar(255),
        id varchar(255) not null,
        last_name varchar(255),
        password varchar(255),
        role varchar(255) check (role in ('USER','ADMIN')),
        primary key (id)
    );

    create table user_details."user-details" (
        age integer,
        birth_day date,
        consent_allowed boolean not null,
        email varchar(255),
        first_name varchar(255),
        friends_list varchar(255),
        id varchar(255) not null,
        last_name varchar(255),
        password varchar(255),
        role varchar(255) check (role in ('USER','ADMIN')),
        primary key (id)
    );

    create table user_details."user-details" (
        age integer,
        birth_day date,
        consent_allowed boolean not null,
        email varchar(255),
        first_name varchar(255),
        friends_list varchar(255),
        id varchar(255) not null,
        last_name varchar(255),
        password varchar(255),
        role varchar(255) check (role in ('USER','ADMIN')),
        primary key (id)
    );

    create table user_details."user-details" (
        age integer,
        birth_day date,
        consent_allowed boolean not null,
        email varchar(255),
        first_name varchar(255),
        friends_list varchar(255),
        id varchar(255) not null,
        last_name varchar(255),
        password varchar(255),
        role varchar(255) check (role in ('USER','ADMIN')),
        primary key (id)
    );

    create table user_details."user-details" (
        age integer,
        birth_day date,
        consent_allowed boolean not null,
        email varchar(255),
        first_name varchar(255),
        friends_list varchar(255),
        id varchar(255) not null,
        last_name varchar(255),
        password varchar(255),
        role varchar(255) check (role in ('USER','ADMIN')),
        primary key (id)
    );

    create table user_details."user-details" (
        age integer,
        birth_day date,
        consent_allowed boolean not null,
        email varchar(255),
        first_name varchar(255),
        friends_list varchar(255),
        id varchar(255) not null,
        last_name varchar(255),
        password varchar(255),
        role varchar(255) check (role in ('USER','ADMIN')),
        primary key (id)
    );

    create table user_details."user-details" (
        age integer,
        birth_day date,
        consent_allowed boolean not null,
        email varchar(255),
        first_name varchar(255),
        friends_list varchar(255),
        id varchar(255) not null,
        last_name varchar(255),
        password varchar(255),
        role varchar(255) check (role in ('USER','ADMIN')),
        primary key (id)
    );

    create table user_details."user-details" (
        age integer,
        birth_day date,
        consent_allowed boolean not null,
        email varchar(255),
        first_name varchar(255),
        friends_list varchar(255),
        id varchar(255) not null,
        last_name varchar(255),
        password varchar(255),
        role varchar(255) check (role in ('USER','ADMIN')),
        primary key (id)
    );

    create table user_details."user-details" (
        age integer,
        birth_day date,
        consent_allowed boolean not null,
        email varchar(255),
        first_name varchar(255),
        friends_list varchar(255),
        id varchar(255) not null,
        last_name varchar(255),
        password varchar(255),
        role varchar(255) check (role in ('USER','ADMIN')),
        primary key (id)
    );

    create table user_details."user-details" (
        age integer,
        birth_day date,
        consent_allowed boolean not null,
        email varchar(255),
        first_name varchar(255),
        friends_list varchar(255),
        id varchar(255) not null,
        last_name varchar(255),
        password varchar(255),
        role varchar(255) check (role in ('USER','ADMIN')),
        primary key (id)
    );

    create table user_details."user-details" (
        age integer,
        birth_day date,
        consent_allowed boolean not null,
        email varchar(255),
        first_name varchar(255),
        friends_list varchar(255),
        id varchar(255) not null,
        last_name varchar(255),
        password varchar(255),
        role varchar(255) check (role in ('USER','ADMIN')),
        primary key (id)
    );

    create table user_details."user-details" (
        age integer,
        birth_day date,
        consent_allowed boolean not null,
        email varchar(255),
        first_name varchar(255),
        friends_list varchar(255),
        id varchar(255) not null,
        last_name varchar(255),
        password varchar(255),
        role varchar(255) check (role in ('USER','ADMIN')),
        primary key (id)
    );

    create table user_details."user-details" (
        age integer,
        birth_day date,
        consent_allowed boolean not null,
        email varchar(255),
        first_name varchar(255),
        friends_list varchar(255),
        id varchar(255) not null,
        last_name varchar(255),
        password varchar(255),
        role varchar(255) check (role in ('USER','ADMIN')),
        primary key (id)
    );

    create table user_details."user-details" (
        age integer,
        birth_day date,
        consent_allowed boolean not null,
        email varchar(255),
        first_name varchar(255),
        friends_list varchar(255),
        id varchar(255) not null,
        last_name varchar(255),
        password varchar(255),
        role varchar(255) check (role in ('USER','ADMIN')),
        primary key (id)
    );

    create table user_details."user-details" (
        age integer,
        birth_day date,
        consent_allowed boolean not null,
        email varchar(255),
        first_name varchar(255),
        friends_list varchar(255),
        id varchar(255) not null,
        last_name varchar(255),
        password varchar(255),
        role varchar(255) check (role in ('USER','ADMIN')),
        primary key (id)
    );

    create table user_details."user-details" (
        age integer,
        birth_day date,
        consent_allowed boolean not null,
        email varchar(255),
        first_name varchar(255),
        friends_list varchar(255),
        id varchar(255) not null,
        last_name varchar(255),
        password varchar(255),
        role varchar(255) check (role in ('USER','ADMIN')),
        primary key (id)
    );

    create table user_details."user-details" (
        age integer,
        birth_day date,
        consent_allowed boolean not null,
        email varchar(255),
        first_name varchar(255),
        friends_list varchar(255),
        id varchar(255) not null,
        last_name varchar(255),
        password varchar(255),
        role varchar(255) check (role in ('USER','ADMIN')),
        primary key (id)
    );

    create table user_details."user-details" (
        age integer,
        birth_day date,
        consent_allowed boolean not null,
        email varchar(255),
        first_name varchar(255),
        friends_list varchar(255),
        id varchar(255) not null,
        last_name varchar(255),
        password varchar(255),
        role varchar(255) check (role in ('USER','ADMIN')),
        primary key (id)
    );

    create table user_details."user-details" (
        age integer,
        birth_day date,
        consent_allowed boolean not null,
        email varchar(255),
        first_name varchar(255),
        friends_list varchar(255),
        id varchar(255) not null,
        last_name varchar(255),
        password varchar(255),
        role varchar(255) check (role in ('USER','ADMIN')),
        primary key (id)
    );

    create table user_details."user-details" (
        age integer,
        birth_day date,
        consent_allowed boolean not null,
        email varchar(255),
        first_name varchar(255),
        friends_list varchar(255),
        id varchar(255) not null,
        last_name varchar(255),
        password varchar(255),
        role varchar(255) check (role in ('USER','ADMIN')),
        primary key (id)
    );

    create table user_details."user-details" (
        age integer,
        birth_day date,
        consent_allowed boolean not null,
        email varchar(255),
        first_name varchar(255),
        friends_list varchar(255),
        id varchar(255) not null,
        last_name varchar(255),
        password varchar(255),
        role varchar(255) check (role in ('USER','ADMIN')),
        primary key (id)
    );

    create table user_details."user-details" (
        age integer,
        birth_day date,
        consent_allowed boolean not null,
        email varchar(255),
        first_name varchar(255),
        friends_list varchar(255),
        id varchar(255) not null,
        last_name varchar(255),
        password varchar(255),
        role varchar(255) check (role in ('USER','ADMIN')),
        primary key (id)
    );

    create table user_details."user-details" (
        age integer,
        birth_day date,
        consent_allowed boolean not null,
        email varchar(255),
        first_name varchar(255),
        friends_list varchar(255),
        id varchar(255) not null,
        last_name varchar(255),
        password varchar(255),
        role varchar(255) check (role in ('USER','ADMIN')),
        primary key (id)
    );

    create table user_details."user-details" (
        age integer,
        birth_day date,
        consent_allowed boolean not null,
        email varchar(255),
        first_name varchar(255),
        friends_list varchar(255),
        id varchar(255) not null,
        last_name varchar(255),
        password varchar(255),
        role varchar(255) check (role in ('USER','ADMIN')),
        primary key (id)
    );

    create table user_details."user-details" (
        age integer,
        birth_day date,
        consent_allowed boolean not null,
        email varchar(255),
        first_name varchar(255),
        friends_list varchar(255),
        id varchar(255) not null,
        last_name varchar(255),
        password varchar(255),
        role varchar(255) check (role in ('USER','ADMIN')),
        primary key (id)
    );

    create table user_details."user-details" (
        age integer,
        birth_day date,
        consent_allowed boolean not null,
        email varchar(255),
        first_name varchar(255),
        friends_list varchar(255),
        id varchar(255) not null,
        last_name varchar(255),
        password varchar(255),
        role varchar(255) check (role in ('USER','ADMIN')),
        primary key (id)
    );

    create table user_details."user-details" (
        age integer,
        birth_day date,
        consent_allowed boolean not null,
        email varchar(255),
        first_name varchar(255),
        friends_list varchar(255),
        id varchar(255) not null,
        last_name varchar(255),
        password varchar(255),
        role varchar(255) check (role in ('USER','ADMIN')),
        primary key (id)
    );

    create table user_details."user-details" (
        age integer,
        birth_day date,
        consent_allowed boolean not null,
        email varchar(255),
        first_name varchar(255),
        friends_list varchar(255),
        id varchar(255) not null,
        last_name varchar(255),
        password varchar(255),
        role varchar(255) check (role in ('USER','ADMIN')),
        primary key (id)
    );

    create table user_details."user-details" (
        age integer,
        birth_day date,
        consent_allowed boolean not null,
        email varchar(255),
        first_name varchar(255),
        friends_list varchar(255),
        id varchar(255) not null,
        last_name varchar(255),
        password varchar(255),
        role varchar(255) check (role in ('USER','ADMIN')),
        primary key (id)
    );

    create table user_details."user-details" (
        age integer,
        birth_day date,
        consent_allowed boolean not null,
        email varchar(255),
        first_name varchar(255),
        friends_list varchar(255),
        id varchar(255) not null,
        last_name varchar(255),
        password varchar(255),
        role varchar(255) check (role in ('USER','ADMIN')),
        primary key (id)
    );

    create table user_details."user-details" (
        age integer,
        birth_day date,
        consent_allowed boolean not null,
        email varchar(255),
        first_name varchar(255),
        friends_list varchar(255),
        id varchar(255) not null,
        last_name varchar(255),
        password varchar(255),
        role varchar(255) check (role in ('USER','ADMIN')),
        primary key (id)
    );

    create table user_details."user-details" (
        age integer,
        birth_day date,
        consent_allowed boolean not null,
        email varchar(255),
        first_name varchar(255),
        friends_list varchar(255),
        id varchar(255) not null,
        last_name varchar(255),
        password varchar(255),
        role varchar(255) check (role in ('USER','ADMIN')),
        primary key (id)
    );

    create table user_details."user-details" (
        age integer,
        birth_day date,
        consent_allowed boolean not null,
        email varchar(255),
        first_name varchar(255),
        friends_list varchar(255),
        id varchar(255) not null,
        last_name varchar(255),
        password varchar(255),
        role varchar(255) check (role in ('USER','ADMIN')),
        primary key (id)
    );

    create table user_details."user-details" (
        age integer,
        birth_day date,
        consent_allowed boolean not null,
        email varchar(255),
        first_name varchar(255),
        friends_list varchar(255),
        id varchar(255) not null,
        last_name varchar(255),
        password varchar(255),
        role varchar(255) check (role in ('USER','ADMIN')),
        primary key (id)
    );

    create table user_details."user-details" (
        age integer,
        birth_day date,
        consent_allowed boolean not null,
        email varchar(255),
        first_name varchar(255),
        friends_list varchar(255),
        id varchar(255) not null,
        last_name varchar(255),
        password varchar(255),
        role varchar(255) check (role in ('USER','ADMIN')),
        primary key (id)
    );