數(shù)據(jù)倉庫技術(shù)介紹(2)-文庫吧資料
2025-01-14 01:47本頁面
【正文】 rade: CHAR(16) Process proc_id: CHAR(4) pname: CHAR(10) process_sub_group: CHAR(10) name: CHAR(10) plant_id: CHAR(10) plant_group: CHAR(10) EGSn_Production proc_id: CHAR(4) material_id: CHAR(11) status_key: NUMBER(8) timekey: DATE order_id: CHAR(10) original_order_id: VARCHAR2() material_tracking_id: CHAR(10) production_t_start: DATE production_t_end: DATE fnpr_sheet_length: NUMBER(8) Temp_Pickling_1_1: NUMBER(4) Temp_Pickling_2_1: NUMBER(4) Temp_Pickling_3_1: NUMBER(4) annl_center_speed: NUMBER(4) coating_weight_top: NUMBER(4) crpp_length_head: NUMBER(4) crpp_length_tail: NUMBER(4) ctng_weight_bottom: NUMBER(4) entry_coil_num_1: CHAR(10) entry_coil_num_2: CHAR(10) entry_coil_thick: NUMBER(4) entry_coil_weight: NUMBER(8) entry_coil_width: NUMBER(4) exit_coil_num_1: CHAR(10) exit_coil_otr_dim: NUMBER(4) exit_coil_thick: NUMBER(4) exit_coil_weight: NUMBER(8) exit_coil_width: NUMBER(4) hf_strip_temp_avg: NUMBER(3) hf_strip_temp_max: NUMBER(3) hf_strip_temp_min: NUMBER(3) n_pack_sheet: NUMBER(4) next_plant: CHAR(10) rh_strip_temp_avg: NUMBER(3) rh_strip_temp_max: NUMBER(3) rh_strip_temp_min: NUMBER(3) scf_strip_temp_avg: NUMBER(3) scf_strip_temp_max: NUMBER(3) scf_strip_temp_min: NUMBER(3) sf_strip_temp_avg: NUMBER(3) sf_strip_temp_max: NUMBER(3) sf_strip_temp_min: NUMBER(3) strip_20A_temp: NUMBER(3) strip_10A_temp: NUMBER(3) strip_1C_temp: NUMBER(3) strip_2C_temp: NUMBER(3) Act_Sheet_N: NUMBER(4) Status status_key: NUMBER(8) status_code: CHAR(10) redun: CHAR(1) withheld: CHAR(1) wreason: CHAR(8) defect_code: CHAR(10) defect: CHAR(10) dname: CHAR(10) dreason: CHAR(10) dtype: CHAR(10) 電鍍錫生產(chǎn)實(shí)際物理模型 產(chǎn)品質(zhì)量分析變量 EGSn Sample Testing material id (FK) order id (FK) process id (FK) product key (FK) timekey (FK) mtrl tracking num test time avg tensile rm a avg tensile rm n hardness a a hardness a n hardness c a hardness c n hardness d a hardness w a hardness w n ppi ba ppi bc ppi bd ppi bw ppi ta ppi tc ppi td ppi tw ra ba ra bc ra bd ra bw ra ta ra tc ra td ra tw rmax ba rmax bc rmax bd rmax bw rmax ta rmax tc rmax td rmax tw tensile a a tensile a n tensile ae a tensile ae n tensile ag a tensile ag n tensile delta r a tensile delta r n tensile r0 a tensile r0 n tensile r45 a tensile r45 n tensile r90 a tensile r90 n tensile re a tensile re n tensile reh a tensile reh n tensile rel a tensile rel n tensile rm a tensile rm n tensile ya a tensile ya n test times alloy sn bc alloy sn bd alloy sn bw alloy sn ta alloy sn tc alloy sn td alloy sn tw alloysn flag atc ba atc bc atc bd atc bw atc ta atc tc atc td atc tw capillary ba capillary bc capillary bd capillary bw capillary ta capillary tc capillary td capillary tw isv ba isv bc isv bd isv bw isv ta isv tc isv td isv tw oil ba oil bc oil bd oil bw oil ta oil tc oil td oil tw oxide film ba oxide film bc oxide film bd oxide film bw oxide film ta oxide film tc oxide film td oxide film tw phg ba phg bc phg bd phg bw phg ta phg tc phg td phg tw plv a plv c plv d plv w sample positin sn coat ba sn coat bc sn coat bd sn coat bw sn coat flag sn coat ta sn coat tc sn coat td sn coat tw surface cr a surface cr c surface cr d surface cr w tcs ba tcs bc tcs bd tcs bw tcs ta tcs tc tcs td tcs tw 電鍍錫檢化驗(yàn)邏輯模型 試樣分析變量 Order order id backlog apn psr nu
公司管理相關(guān)推薦
鄂ICP備17016276號(hào)-1