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