pmms表结构
2022-03-19 12:29:43 12 举报pmms表结构补充
作者其他创作
大纲/内容
counter 灯位相关表
supplier_data_supplier(供应商表)
item_data_item_category_relation(物料与类型关联表)
counter_data_light_position_slice_relation(柜台灯位与灯片关联表)
配单相关表
item_data_item_group_relation(物料与group关联表)
item_id == id
id == counter_id
pr_item_id == id
item_data_image_file(物料文件主表)
item_data_counter_item_summary(物料与柜台关联表)
item_id == id
procurement_data_pr_item_sn_relation(配单物料SN码表)
counter_data_counter_image_file_relation(柜台图片与文件主表关联表)
pr_id == id
counter_data_counter(柜台主表)
counter_data_image_file(柜台文件主表)
id == pr_item_id
procurement_data_pr_item(配单物料表)
counter_data_venue(地区表)
brand_data_brand(品牌信息主表)
procurement_data_pr_item_relation(配单与配单物料关联表)
supplier_data_supplier(供应商主表)
counter_data_counter_light_position_relation(柜台与灯位关联表)
venue_code == memo1
light_position_id ==id
dis_code == distributor_sold_to
item_data_item_brand_relation(物料与品牌关联表)
item_data_item_group(group主表)
item_data_eco(物料 ECO 信息表)
item_data_rate_card(物料费率主表)
item_data_image_file_item_relation(物料图片与文件主表关联表)
item_data_class_code(class code 主表)
procurement_data_supplier_counter_channel_quantity(配单物料和供应商与柜台的数量关系)
counter_data_store(商场表)
counter_data_counter_supplier_relation(柜台与供应商关联表)
procurement_data_procurement_item_channel(配单物料与供应商生产数量表)
id == light_position_id
pr_item_id == id
item_data_light(灯片主表)
procurement_data_procurement(配单表)
counter_data_channel(柜台渠道主表)
item_data_item_rate_card_relation(物料费率关联表)
item_data_counter_item_ration(家具表)
counter_data_counter_brand_relation(柜台与品牌关联表)
counter_data_counter_store_relation(柜台商场关联表)
procurement_data_pr_item_counter_relation(配单物料数量与柜台关联表)
item_data_item_class_code_relation(物料与CLASS COED关联表)
procurement_data_procurement_order_relation(配单与供应商关联表)
counter_id ==id
counter_data_light_position(柜台灯位主表)
counter_data_light_position_texture_relation(灯位与材质关联表)
Item 主数据
item_data_item(物料主表)
counter_data_terminal(柜台渠道表)
item_data_item_column_extra(物料附加信息表)
counter 相关表
counter数据相关表
procurement_request_id == id
light_texture_id == id
item_data_item_group_ration(物料与group关联表)
store_code
counter_data_counter(柜台表)
id == supplier
procurement_data_pr_counter_relation(配单与柜台关联表)
item_data_category(物料与类型主表)
item_data_light_texture(材质主表)
item_data_counter_item_child_relation（家具下的group)
id == pr_id
0 条评论
下一页
