Is there any tables to query contract information

Summary:

I need to write SQL to get valid personnel details of parties with 'supplier' role from contract data. would you like to share which tables I can use

Content (please ensure you mask any confidential information):

Version (include the version you are using, if applicable):

Code Snippet (add any code snippets that support your topic, if applicable):