You will not be able to upload external assets with your PlayStation 4 mods, but you will be able to use any assets that come with the game, as most mods do.
“Mods on PlayStation 4 will allow you to modify and create your own content by using our Creation Kit available here.
“We and Sony have worked hard to make this possible,” explained Bethesda. However, there will be some restrictions not found on PC or Xbox One. Bethesda also confirmed that Mods will be supported for both Skyrim Special Edition and Fallout 4, despite announcing this hadn’t been possible only last month.