.\\$Private
) or on a remote machine (with appropriate configuration). MSMQ is suitable when:true
in production environments10
)100
is a good number for up to 10 concurrent connections)readonlyConnectionString
and a readWriterConnectionString
. These two connection strings should point at pools of read/write primary addresses and a pool of read-only secondary addresses.ent_vrsn_tbl
act_vrsn_tbl
cls_cd_id
(note: in 2.1.x and 2.2.x the partition should be on ent_tbl
).ent_rel_tbl
act_rel_tbl
rel_typ_cd_id
act_ptcpt_tbl
rol_cd_id
ent_vrsn_tbl
and act_vrsn_tbl
is provided in the file ZZ-Partition-PSQL11.sql
(for PostgreSQL 11+) and ZZ-Partition-PSQL10.sql
(for PostgreSQL 10)Male
) and to prevent non-sensical relationships (i.e. adding an Uncle
to Good Health Hospital
). CREATE TABLESPACE encrypted LOCATION '/var/......';
)ALTER TABLE ent_id_tbl SET TABLESPACE encrypted;
)DataPrivacyFilterService
(in Docker DATA_POLICY
feature) to increase query and write performance. This service attaches to all disclosure pathways in the SanteDB server and applies appropriate masking and filtering based on user roles.