How to assign each post to an unique id in Wordpress? -

i trying structure website in format there 2 tables. table 1 used store ids, names , logo each university. table 2 used store degrees each university (1 university have 30 degrees).

the goal here create multiple unique posts can reference data table 1 , table 2. ideas?

assuming schools post type , degrees post type connecting factor school id. either using custom meta data , add field (school id etc) each post type. or create taxonomy shared both post types refers school id.

you able use custom queries degrees school id equals value need.

for custom meta: https://codex.wordpress.org/function_reference/add_meta_box

for taxonomies: https://codex.wordpress.org/function_reference/register_taxonomy