【技術制度】數(shù)據(jù)倉庫技術介紹(文件)
【正文】 熱軋 1,2煉鋼 板坯 1煉鋼鋼錠 冷軋 1,2煉鋼 PONO 質量數(shù)據(jù)倉庫檢化驗主題 初軋 線材 電鍍錫 電鍍和 熱鍍鋅 普板 彩涂 電爐 熱軋 1,2煉鋼 數(shù)據(jù)抽取 Stee l Hot R o l l co l o r co ate d C o l d R o l l EGSn hot dip EGZ n B l o o m El ec tr i c Stee l W i r e Sta g i n g D W Q M D M E n v i r o n m e n t Su b j e c t A r e a s D a ta Ma r ts S o u r c e S y s t e m s EGSn Production 事實表 維表 邏輯表 Original Order original order id Order order id backlog apn psr number metallurgy index code production line code internal grade steel grade Time timekey Material material id Process process id process name process sub group process group plant id plant group process id (FK) material id (FK) status key (FK) timekey (FK) order id (FK) original order id (FK) material tracking number process begin time process end time fnpr length Temp Pickling 11 Temp Pickling 21 Temp Pickling P31 annl center speed coating weight top crpp length head crpp length tail ctng weight bottom entry coil num 1 entry coil num 2 entry coil thick entry coil weight entry coil width exit coil num 1 exit coil oth dim exit coil thick exit coil weight exit coil width hf strip temp avg hf strip temp max hf strip temp min n pack sheet next plant rh strip temp avg rh strip temp max rh strip temp min scf strip temp avg scf strip temp max scf strip temp min sf strip temp avg sf strip temp max sf strip temp min strip 20A temp strip 10A temp strip 1C temp strip 2C temp Act Sheet N Status status key status code redundant withheld withheld reason defect code defect id defect name defect reason defect type 電鍍錫生產實際邏輯模型 產品質量分析變量 . . . Order order_id: CHAR(10) backlog: CHAR(17) apn: CHAR(4) psr_num: CHAR(11) mic_num: CHAR(6) line_num: CHAR(4) internal_grade: CHAR(8) steel_grade: 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:
法律信息相關推薦
鄂ICP備17016276號-1