Haekwang
Tables (4)
02 (tbMachine)
- 1 (n_MC_ID) — numeric — Primary key — NOT NULL
- 2 (n_MC_Type) — numeric
- 3 (s_MC_Code) — string
- 4 (s_MC_No) — string
- 5 (s_MC_Name) — string
- 6 (n_MC_Dept_ID) — numeric
- 7 (s_MC_Model) — string
- 8 (s_MC_Maker) — string
- 9 (s_MC_Serial) — string
- 10 (s_MC_Standard) — string
- 11 (d_MC_Make) — date
- 12 (d_MC_Purchase) — date
- 13 (d_MC_Setting) — date
- 14 (n_MC_Price) — numeric
- 15 (s_MC_Location) — string
- 16 (s_MC_Memo) — string
- 17 (n_MC_Signal_ID) — numeric
- 18 (s_MC_IP) — string
- 19 (n_MC_Monitoring) — numeric
- 20 (n_MC_Ratio) — numeric
- 21 (n_MC_CastGroup) — numeric
- 22 (n_MC_Outsourcing) — numeric
- 23 (n_MC_ShowLine) — numeric
- 24 (n_MC_State) — numeric
- 25 (n_MC_Order) — numeric
- 26 (s_MC_Img) — string
- 27 (dt_MC_Mdf) — numeric
- 28 (s_MC_MdfUser) — numeric
- 29 (n_MC_Signal_ID_1) — numeric
- 30 (s_MC_Machine_IP_1) — string
- 31 (s_MC_Machine_IP_2) — string
- 32 (n_MC_HoldNumber) — numeric
- 33 (n_MC_PC_ID) — numeric
- 34 (n_MC_Ton) — numeric
- 35 (n_MC_System) — numeric
- 36 (n_MC_CallAndon) — numeric
- 37 (n_MC_FCT_ID) — numeric
- 38 (n_MC_Trimming) — numeric
- 39 (n_MC_UseIngot) — numeric
- 40 (n_MC_Consumable) — numeric
- 41 (n_MC_NopIntvSec) — numeric
- 42 (n_MC_Test) — numeric
03 (tbMold)
- 1 (n_MD_ID) — numeric — Primary key — NOT NULL
- 4 (n_MD_PD_ID) — numeric — Primary key — NOT NULL
- 3 (s_MD_No) — numeric
- 5 (n_MD_COM_ID) — date
- 6 (d_MD_Make) — date
- 7 (d_MD_Product) — numeric
- 8 (n_MD_Number) — numeric
- 9 (s_MD_Number) — string
- 10 (s_MD_Size) — numeric
- 11 (n_MD_Cavity) — numeric
- 12 (f_MD_Weight) — numeric
- 13 (n_MD_Base) — numeric
- 14 (n_MD_Life) — numeric
- 15 (n_MD_CTSec) — numeric
- 16 (s_MD_Image1) — string
- 17 (s_MD_Image2) — string
- 18 (s_MD_Image3) — string
- 19 (s_MD_Image4) — numeric
- 20 (n_MD_StateDetail) — string
- 21 (n_MD_WeightInject) — numeric
- 22 (n_MD_SizeSleeve) — string
- 23 (n_MD_PanelType) — datetime
- 24 (s_MD_Memo) — string
- 25 (n_MD_State) — numeric
- 26 (s_MD_MdfUser) — string
- 27 (df_MD_Mdf) — numeric
- 28 (s_MD_Standard01) — numeric
- 29 (s_MD_Standard02) — numeric
- 30 (s_MD_Standard03) — string
- 31 (s_MD_Standard04) — string
- 32 (s_MD_Standard01_MC) — numeric
- 33 (s_MD_Standard02_MC) — numeric
- 34 (s_MD_Standard03_MC) — numeric
- 35 (s_MD_Standard04_MC) — numeric
08 (tbFaultyProduct)
- 1 (n_FP_ID) — numeric
- 2 (d_FP_WorkDate) — date
- 3 (n_FP_WorkShift) — numeric
- 5 (n_FP_MD_ID) — numeric
- 7 (s_FP_UI_ID) — string
- 8 (n_FP_PCW_ID) — numeric
- 9 (n_FP_Count) — numeric
- 10 (s_FP_Memo) — string
- 11 (dt_FP_In) — datetime
- 12 (n_FTP_InputType) — numeric
- 4 (n_FP_MC_ID) — numeric — Foreign key → 02.1 — NOT NULL
- 1 (n_MD_ID) — numeric — Foreign key → 03.1 — NOT NULL
- 6 (n_FP_FT_ID) — numeric — Foreign key → 09.1 — NOT NULL
09 (vwFaultyType)
- 1 (n_FT_ID) — numeric — Primary key — NOT NULL
- 2 (s_FT_Code) — string
- 3 (s_FT_Name) — string
- 4 (s_FT_Memo) — string
- 5 (n_FT_Order) — numeric
- 6 (n_FT_State) — numeric
- 7 (dt_FT_Mdf) — datetime
- 8 (s_FT_MdfUser) — string
- 9 (n_FCS_FC_ID) — numeric
- 10 (n_FCS_PC_ID) — numeric
- 11 (n_FCS_Dev) — numeric
- 12 (n_FI_ID) — numeric
- 13 (s_FI_Name) — string
- 14 (s_FI_Memo) — string
- 15 (n_FI_Order) — numeric
- 16 (n_FI_PC_ID) — numeric
- 17 (n_FC_Kind) — numeric