database - PostgreSQL - Foreign Key referencing multiple tables -

database - PostgreSQL - Foreign Key referencing multiple tables -

i've got problem @ postgres database. have 4 tables of location info (hospitals, schools, markets , police force precints), different between themselves, , event study table has location column, referencing location.

how can create reference, id can in of location tables? i've tried reference parent table of them all, inserts homecoming error of "key not nowadays @ table"

thanks

per kouber saparev's suggestion, i've removed inheritance , used foreign keys reference parent children. it's working now.

database postgresql