gistfile1.sql

create table account_role(
    id          serial  not null,
    account_id  integer not null,
    role_id     integer not null,
    pool_id     integer,

    constraint pk_account_role
        primary key(id),

    constraint fk_account
        foreign key(account_id) references account(id),

    constraint fk_role
        foreign key(role_id) references role(id),

    constraint fk_pool
        foreign key(pool_id) references pool(id)
);