create table invites(
    id uuid primary key not null,

    email text not null,
    "role" organization_role not null,
    organization_id bigint not null references organizations(id),

    invited_by bigint not null references customers(id),

    created_at timestamp not null
);

create index ON invites(organization_id);
create index ON invites(invited_by);
create index ON invites(email);

create unique index ON invites(email, organization_id);