Odtnhj

I want to build an application with Spring Boot, Spring Data JPA and PostgreSQL.
I my data model I have some partial unique indexes that works with some rules like those below:

drop table if exists persons.person;
create table if not exists persons.person (
 id bigserial,
 name varchar(99) not null, 
 sobrename varchar(99) not null, 
 birthdate date,
 official_registry varchar(32) not null, 
 realPerson_sn bool not null default true, -- in case of real person, true, juridical person, false
 isMatrix bool null, -- in case of eral person, female = false, male = true
 isConfirmed bool default false, -- if data is confirmed officially
 constraint person_id primary key(id),
); create unique index person_juridical_cnpj_ix on persons.person (official_registry) where (realPerson_sn = false);
 create unique index person_realPerson_ix on persons.person (name, sobrename, birthdate_dt) where (realPerson_sn = true);
 create unique index person_realPerson_cpf_ix on persons.person (official_registry) where ((realPerson_sn = true) and ((official_registry <> null) and (official_registry <> ''))); 

In this example, I want to use a single table to store both real persons and juridical persons, using similarities in their data, like names, registry etc. And after that I created unique indexes that reflex the differences between them, to make it easier to find records in both cases.

Note about critcism: This is only one example, I have several tables using those types of indexes with where clause, so it doesn't matter with if the example is replaceable with 2 tables, I will still need the where clauses in other indexes.

I managed to compile my entire model in PostgreSQL 9 and it's working well when I used it in a Delphi and PHP application.

But now I want to implement it in Java Spring Boot and Angular. But I want to rewrite the model so it is compiled from JPA from zero.

Is this possible to recreate those index rules in JPA or is it an PostgreSQL thing that is not covered by JPA, Hibernate, Spring Data and others?