Merge_combin_common_to_product_field (psth)
Table: Merge_combin_common_to_product_field ( primary key: id_ield and id_product) : created by dataflow , union the common data field with the product field
dynamicproduct_common_field * id_common_field id_field id_product position id_group id_step
dynamicproduct_common_field data is created: 1. the dynamicproduct_field, the id_field is marked as Common and available for used by other products 2. When the other product add the Common field (of other products) into the product field list the product_commen_ field record will be created.
There is not direct relatonship between these two tables: product_common field and product_field To create a total product_field list: one needs to merge the product_field with the common_product_field cr438_yeslogonewps_dynamic_common_field_merg this tabel inner nested ( Common_field with product field,
cr438_yeslogonewps_dynamic_common_field_merg
To create a total product_field list: one needs to merge the product_field with the common_product_field .
cr438_yeslogonewps_dynamic_common_field_merg this tabel inner nested ( Common_field with product field, the approach to manage the product and product field is: 1. any fields that will be used shall be first create in id_product 152 （ this will create a id_field, id_product relation in the common_product_field, the product that ” offer” the common field is Not on the list, the products on the list are those that use the common field) 2. create a short list of common product pricing list ( e.g. embroidery badges, pvc badges, soft enamel pins ect) under the Category: 154 3. Other products will use Link instead of copying to link the dynamic product field with the common product pricing,