alm_license / alm_entitlement_user / alm_entitlement_asset

[Alex3272]

Hello everyone!

I am asking the community for the 1st time and I hope you can help me.

It's about building structures and scripts. (I am doing this mini-project purely for myself and for learning purposes)

The requirements are as follows:


1) The user creates a peripheral from "alm_entitlement_asset" table after which the verified "location" goes, and also the peripheral must not be in the same "location".

2) When the user requests a peripheral add him to the correct "alm_licence" 

3) If is to "replace" remove the user from the old list and add him to the new (peripheral item)

My question is what can I link these tables through.

I already created catalog and share it with you.

Any help or advice would be appreciated.

Kind Regards, Alex