Hi all,
I want to store attachments to more entities, for example:
- SalesOrder - I want to store various PDF files (customer purchase order, contract...)
- Delivery - I want to store different kind of documents (customs clearance, shipping information...)
And so on...
I'm using SQL Server 2019 and I want to use nvarchar(100) data type with the path to the file ("Z:\Attachments\SalesOrders\CustomerPO000101010.p df"), which is a good practice in Access in my opinion.
But I'm thinking of the correct design here... It seems to me that I will need a table for each attachment type, for example:
- tblSalesOrderAttachments
- tblDeliveryAttachments
And so on, because if I only had one table, I wouldn't be able to correctly assign foreign key to the respective entity.
Am I correct or am I missing something?
Thanks a lot.
Tomas