Translational Research vs. Clinical Research vs. basic science research

What’s the difference between all of these and is there like a hierarchy of prestige that med schools assign to each of these?