You use a regular bigint/bigserial for internal table relations and a UUID as an application-level identifier and natural key.