If J is a (small) discrete category, then a diagram of type J is essentially just an indexed family of objects in C (indexed by J).
If J represents a small category, a diagram of that type can be thought of as a collection of objects indexed by J.