@ZhenLin I see. I'm certainly not the right person to ask since you seem to have understood about as much as I do. Maybe this would make a good question: Intuitive understanding of projective and flat modules in algebraic geometry. Another option: Have you tried to read
FAC?