Best type to use in a composite key when one of the values varies in type
I wouldn't even consider forcing data of different types into one field.

Another option:


synthetic post_id and
child tables for each 'type' of 'native_post_id'


There are various ways to go about enforcing the subset relationship between these child tables and the parent if necessary