As shown in the figure, we have a need that several tables must be referenced to in a single table.
Please be aware that the design only serves to illustrate our requirements and is NOT the true DB model. Could you provide advice on how to accomplish the aforementioned in a
Entity Framework 6
Example: Multiple files may be uploaded to a sales order (in the SalesOrder database), and the information of those uploaded files are maintained in the UploadedFile table. The same applies to OrderTable and Invoice.
Therefore, a good database schema with FK links between the FileUpload table and all other associated tables is required.
Note: All tables' PKs are auto-increment int values, and further entities (tables) may be required in the future.