Product flat tables are essentially one big table of products or categories in a given store including all attributes and fields associated with that product or category, respectively. 

IMAGE