PDF documents for customer profile

[Former Member]

Hi, My business requirement is each B2B unit have some signed agreement copies in pdf formats. I have to provide a provision for B2B Customer to save those pdf documents at B2b unit level and whenever the customer wants to see, he/she can view it once he login and by going to that screen.
So, I have created a custom table and provided a relationship to B2B unit model. Now, my question is what data type I can use it? BLOB or CLOB types are available in Hybris? Can I use type as "media" ? or Media container? But, these are catalog aware objects which depend on the catalog versioning and synchronization.

Any other approach to achieve my requirement? please suggest me an approach.

Thanks, .

[Former Member]

You can create media type for pdf and can provide a relation with b2bunit. It should work fine.

[Former Member]

thank you for the reply. If I use media type, then, pdf's will be stored in a database or first file will be stored in the physical file system and a reference will be stored in the database? As the number of documents are huge my requirement is to store them in database at table level than in physical file system.