Announcing the SAVIYNT KNOWLEDGE EXCHANGE unifying the Saviynt forums, documentation, training, and more in a single search tool across platforms. Click HERE to read the Announcement.

Database columns' naming convention

Olesia
Regular Contributor
Regular Contributor

Hello,

Saviynt database columns' naming convention is not consistent. Some columns are in camel case, some are in lowercase, and some have underscores. Plus, some tables have description in the column name like "endpoint.endpointname" while others have simply name like "accounts.name".

Do you have plans to standardize the DB columns' names? It would make life a lot easier for everyone.

There are several examples:

  • entitlement_valuekey,
  • REQUEST_ACCESSKEY,
  • entitlementtypekey,
  • displayName,
  • endpointkey,
  • endpoint.endpointname
  • accounts.name

Thanks in advance!

4 REPLIES 4

Darshanjain
Saviynt Employee
Saviynt Employee

HI @Olesia 

There are no columns with accounts.name or endpoint.endpointname. ( these may be binding variables you are using it)

Also right now there is no plan to normalise for now, but this can be taken a look into it, I would suggest this to raise in ideas portal on this and take it forward.

 

Thanks

Darshan

Olesia
Regular Contributor
Regular Contributor

@Darshanjain I didn't state that the column name is accounts.name or endpoint.endpointname. There was just an example that in a table endpoints there is a column "endpointname" but  in a table accounts there is a column "name", not "accountname" as might be expected.

@RakeshMGThanks for the information!

Tim
Community Manager
Community Manager

Hi @Olesia ,

 

Please add your vote to this Enhancement Request here: https://ideas.saviynt.com/ideas/EIC-I-3417

This helps us gauge customer interest in certain new functions to implement. 

Thanks!

Tim

RakeshMG
Saviynt Employee
Saviynt Employee

Thank you for your inputs, we have already have an enhancement for same: https://ideas.saviynt.com/ideas/EIC-I-3417


​Regards

Rakesh M Goudar