I have several entities for example: Order, Item, OrderITem, Country.... Each item can have many file path associated to it. so which is better?? 1-> For each entity, a table containing the file path and the entity it. Ex: FileID, OrderID, FilePath 2- or 1 table for all the entities in this way: FileID, FilePAth, EntityType (int: ex 1=Order, 2=Item..), RecordID Later on I need to select the file paths for a certain entity. Which approach is better?