UAA DB is nothing special. We like to keep it simple.
We don't use foreign keys to simplify migration scripts.
We support four different database types, HSQLDB, MySQL(MariaDB),
PostgreSQL and SQL Server.

We made a choice to store some data in JSON format in text or clob
columns. We do this for data we don't want to query and index.


The UAADB is really a very small database, there isn't much to it. The one
thing we are considering reworking is data that is frequently deleted based
on time expiration. MySQL performance is really bad for large transactional
deletes and it can cause hiccups and consume both locks and CPU.

We use Flyway for database migrations between versions.

Filip


On Thu, Jul 20, 2017 at 8:49 AM, Gowrisankar M <gowrisankarbeece(a)gmail.com

wrote:

Hi Colleages,

I am trying to understand CCDB/UAADB design . Can somebody share some
link for the db design of uaa/cc

BRs, Gowrisankar