You shouldn't need a composite key as you are linking a single table to a single field, if you rename VesselID and VesselTypeID then both tables (Vessel and VesselType) will be linked to max_stock.
VesselId as MainVesselId,
Name /// vessel name
VesselTypeId as MainVesselTypeId,
TypeName // vessel type name