SMS versenden: The nature of the faint radio source population from observations of the Subaru/XMM-Newton Deep Field