Hi Xinhuan, A Product is a description of a service, facility use, asset use, or a digital or physical good for sale. An Asset commonly represents an instance of a Product, or in other words the physical item that the Product record describes.
Regarding hierarchy structure data, you may interest in BOM data structure, see https://cwiki.apache.org/confluence/display/OFBIZ/%5BWIP%5D+Getting+Started+with+Apache+OFBiz+Manufacturing+and+MRP+in+5+Easy+Steps 在 2020/9/8 下午3:35，“Xinhuan Zheng”<[email protected]> 写入: Good Afternoon, I'm a developer working for some digital company. My use case is not too general, and is simpler than OFBiz. It is for a small business. I have maintained a few Excel spreadsheet for a few years for some business asset. The spreadsheet are not formal modeled, and from time to time we maintain and query those sheets. The data present characteristics of hierarchy structure and different attribute sets for different kind types. Maintaining those data in database may require formal data modeling and I am not clear how it works. I came across an old publication about Universal E-Catalog, and I learned about OFBiz project. I want to learn Key-Value pair modeling pattern. I downloaded the OFBiz ERD diagrams. I studied the ERD diagrams for a couple days, and what I'm interested is Product, ProductType, Content, ContentType, Entities that use Universal E-Catalog pattern. You can correct me if that is not the case. This modeling pattern needs to have seed data to understand, and I found the best way to view the seed data is using Excel spreadsheet. I found the project on Github containing Seed data, however, all Seed data are XML format. Is there any possibilities to extract some XML seed data to convert to CSV format? From the ERD diagram, I think I need Product, ProductType, ProductTypeAttr, Content, ContentType, ContentAttr seed data. Thank you! Xinhuan Zheng
