米其林实验室er图
2024-04-29 17:39:35 35 举报
登录查看完整内容
米其林实验室er图
作者其他创作
大纲/内容
referential_schema.f_users( users 用户表 )
michelin_idlast_nameemail_addresssite_iddepartmentstatuslanguagelast_update_by
referential_schema.d_measurement_process(measurement 测试过程记录)
pm_idpm_categorypm_maturitypm_characterization_typepm_statuscomments
referential_schema.d_machine(machine机器)
machine_idmachine_aliasmachine_namedescriptionloc_idstatusmachine_typecommentsregistered_byregistered_satemachine_alias
referential_schema.f_domain(domain 角色)
domain_iddomain_description
referential_schema.d_region( )
region_idsuffixenglish_labelzone_id
1 to 1sample_code
many to 1loc_id
referential_schema.f_measurement_process_meas(measurement 测试过程记录)
pm_machine_idmachine_idpm_idmm_id
sample_definition_schema.f_sample_machine_link(sample and machine link样品与机器关系)
machine_idsample_code
1 to manysample_code
sample_definition_schema.f_sample_link(sample link 子父样品关联关系)
sample_link_idis_primaryparent_sample_codechild_sample_code
referential_schema.d_measurement_process_method(measurement 测试过程方法)
pm_idmm_idmm_description
many to 1machine_id
referential_schema.d_site(site 位置 )
site_idsite_namecountry_id
1 to 1domain_id
1 to 1lab_id
1 to 1machine_id
referential_schema.d_country_region_link( )
country_idregion_id
referential_schema.d_machine_loc(location 机器位置表)
loc_idloc_aliaslab_idloc_name
sample_definition_schema.f_ddt_info(ddt)
ddt_idsample_codeddt_batbatch_id
sample_definition_schema.f_template(template 样品标签模板)
template_idtemplate_namefile
referential_schema.d_material_type( material 材料表 )
mat_type_idmat_type_descriptionmat_type_categorydomain_id
sample_definition_schema.f_track_record(track record 轨迹记录表)
track_idmachine_idsample_codepm_idddt_idsite_idloc_idweightexpired_daysactiontimestamp
sample_definition_schema.f_sample(sample样品)
sample_codemat_type_idmaterial_idmanufacturing_datesite_idcustomerexpress_supplierexpress_numberreceived_datecommentsregistered_by
1 to Manysample_code-parent_sample_code/child_sample_code
1 to 1sample_code
referential_schema.d_laborarory(location 机器位置表)
lab_idlab_aliaslab_namelab_locationsite_id
sample_definition_schema.f_stock_management(stock 样品库存表)
idsample_codeweightunit_weightstock_locationexpired_days
1 to manymichelin_id
referential_schema.d_country(country 国家 )
country_idcountry_code_3cenglish_name
0 条评论
回复 删除
下一页