ddd

Tables (15)

RESIN_LIST

  • NAME — varchar(200) — Primary key — NOT NULL
  • CONTENT — varchar(10000)

actual_value

  • id — int — Primary key — NOT NULL
  • machine — varchar(100) — NOT NULL — 사출기이름
  • location — varchar(100) — NOT NULL — 공장이름
  • shot_number — double — NOT NULL — 샷넘버
  • shot_time_act — varchar(100) — NOT NULL — 샷 시각 (µs, 1970년 1월 1일 0시 00분 이후로 부터 흐른 µs 단위..?)
  • cycle_time_act — varchar(100) — NOT NULL — 싸이클 타임 (µs)
  • cooling_time_act — varchar(100) — NOT NULL — 냉각시간 (µs)
  • injection_time_act — varchar(100) — NOT NULL — 사출시간 (µs)
  • hold_time_act — double — NOT NULL — 보압시간 (µs)
  • injection_min_position_act — double — NOT NULL — 사출 최소 위치 (cm3)
  • injection_max_pressure_act — double — NOT NULL — 사출압력 최대값(수지) (bar spec)
  • injection_max_velocity_act — double — NOT NULL — 사출 체적율 최대값 (cm3/s)
  • cut_off_position_act — double — NOT NULL — 보압 절환 위치 (cm3)
  • cut_off_pressure_act — double — NOT NULL — 보압 절환 압력 (bar spec)
  • last_screw_velocity_act — double — NOT NULL — 보압 절환시 사출 제적율 (cm3/s)
  • hold_end_position_act — double — NOT NULL — 보압 종료 위치 (cm3)
  • cushion_act — double — NOT NULL — 쿠션 값 (cm3)
  • decompression1_act — double — NOT NULL — 석백1 시간 (µs)
  • plast_time_act — double — NOT NULL — 계량시간 (µs)
  • decompression2_act — double — NOT NULL — 석백2 시간 (µs)
  • start_position_act — double — NOT NULL — 계량 시작 위치 (cm3)
  • end_position_act — double — NOT NULL — 계량 종료 위치 (cm3)
  • nozzle_forward_time_act — double — NOT NULL — 노즐 전진 시간 (µs)
  • nozzle_backward_time_act — double — NOT NULL — 노즐 후진 시간 (µs)
  • mold_close_time_act — double — NOT NULL — 형폐 시간 (µs)
  • mold_open_time_act — double — NOT NULL — 형개 시간 (µs)
  • mold_open_end_position_act — double — NOT NULL — 형개 완료 위치(PDP)
  • ejector1_forward_time_act — double — NOT NULL — 이젝터1 전진시간 (µs)
  • ejector1_backward_time_act — double — NOT NULL — 이젝터1 후진시간 (µs)
  • oil_temperature_act — double — NOT NULL — 유압 오일 온도 (℃)
  • temperature_input_zone1_act — double — NOT NULL — 온도 존 1 (℃)
  • temperature_input_zone2_act — double — NOT NULL — 온도 존 2 (℃)
  • temperature_input_zone3_act — double — NOT NULL — 온도 존 3 (℃)
  • temperature_input_zone4_act — double — NOT NULL — 온도 존 4 (℃)
  • temperature_input_zone5_act — double — NOT NULL — 온도 존 5 (℃)
  • temperature_input_zone6_act — double — NOT NULL — 온도 존 6 (℃)
  • temperature_input_zone7_act — double — NOT NULL — 온도 존 7 (℃)
  • temperature_input_zone8_act — double — NOT NULL — 온도 존 8 (℃)
  • temperature_input_zone9_act — double — NOT NULL — 온도 존 9 (℃)
  • temperature_input_zone10_act — double — NOT NULL — 온도 존 10 (℃)
  • temperature_input_zone11_act — double — NOT NULL — 온도 존 11 (℃)
  • temperature_input_zone12_act — double — NOT NULL — 온도 존 12 (℃)
  • hopper_temperature_act — double — NOT NULL — 호퍼온도 (℃)
  • updatedAt — datetime — 업데이트시간

auth_list

  • auth_name — varchar(100) — Primary key — NOT NULL
  • auth_level — int

entire_info

  • mold_name — varchar(200) — Foreign key → geometry_list.mold_name
  • NumberOfCavities — varchar(20)
  • NumberOfGates — varchar(20)
  • OverallVolume — varchar(20)
  • CavityVolume — varchar(20)
  • RunnerVolume — varchar(20)
  • OverallSurfaceArea — varchar(20)
  • CavitySurfaceArea — varchar(20)
  • RunnerSurfaceArea — varchar(20)
  • OverallProjectionAreaXY — varchar(20)
  • OverallProjectionAreaYZ — varchar(20)
  • OverallProjectionAreaZX — varchar(20)
  • MaxPartThickness — varchar(20)
  • AvgPartThickness — varchar(20)
  • StdPartThickness — varchar(20)
  • MaxFlowLength — varchar(20)
  • MinFlowLength — varchar(20)
  • AvgFlowLength — varchar(20)
  • StdFlowLength — varchar(20)
  • MaxFlowLengthToThickness — varchar(20)
  • MinFlowLengthToThickness — varchar(20)
  • AvgFlowLengthToThickness — varchar(20)
  • StdFlowLengthToThickness — varchar(20)
  • MaxGateHydraulicDiameter — varchar(20)
  • MinGateHydraulicDiameter — varchar(20)
  • AvgGateHydraulicDiameter — varchar(20)
  • StdGateHydraulicDiameter — varchar(20)

geometry_img

  • mold_name — varchar(30) — Foreign key → geometry_list.mold_name
  • img_name — varchar(50)
  • img_path — varchar(100)
  • img_type — varchar(10)
  • img_data — mediumblob
  • img_name2 — varchar(50)
  • img_path2 — varchar(100)
  • img_type2 — varchar(10)
  • img_data2 — mediumblob

geometry_list

  • mold_name — varchar(200) — Primary key — NOT NULL

history_column_list

  • name — varchar(200)
  • value — varchar(100)
  • parent — varchar(200)
  • file — varchar(100)
  • depth — int

history_selected_list

  • text — varchar(200)
  • value — varchar(100)

language_data_table

  • vue_name — varchar(200)
  • component_id — varchar(100)
  • component_value — varchar(100)
  • kor_YN — varchar(10)

python_log

  • id — int — Primary key — NOT NULL
  • machine — varchar(100)
  • location — varchar(100)
  • fill_time — double
  • pack_press — double
  • pack_time — double
  • melt_temp — int
  • mold_temp — int
  • abs_diff — double
  • weight — double
  • min_weight — double
  • max_weight — double
  • label — varchar(100)
  • realweight — double
  • new_target_weight — double
  • python_weight — double
  • updatedAt — datetime

resin

  • generic_name — varchar(50) — Primary key — NOT NULL
  • density — varchar(50)
  • material_type — varchar(50)
  • melt_temp_min — varchar(50)
  • melt_temp_max — varchar(50)
  • melt_temp_avg — varchar(50)
  • mold_temp_min — varchar(50)
  • mold_temp_max — varchar(50)
  • mold_temp_avg — varchar(50)

select_value_local

  • id — int — Primary key — NOT NULL
  • machine — varchar(100)
  • location — varchar(100)
  • fill_time — double
  • pack_press — double
  • pack_time — double
  • mold_name — varchar(100)
  • OverallVolume — double
  • OverallSurfaceArea — double
  • realweight — double
  • updatedAt — datetime

select_value_main

  • id — int — Primary key — NOT NULL
  • machine — varchar(100) — NOT NULL — 사출기이름
  • location — varchar(100) — NOT NULL — 공장이름
  • shot_number — double — NOT NULL — 샷넘버
  • mold_name — varchar(100) — NOT NULL — 금형이름
  • resin_type — varchar(100) — NOT NULL — 수지종류
  • resin_company — varchar(100) — NOT NULL — 수지회사
  • resin_name — varchar(100) — NOT NULL — 수지이름
  • target_weight — double — NOT NULL — 목표중량
  • updatedAt — datetime — 업데이트시간

select_value_maintain

  • id — int — Primary key — NOT NULL
  • machine — varchar(100) — NOT NULL — 사출기이름
  • location — varchar(100) — NOT NULL — 공장이름
  • shot_number — double — NOT NULL — 샷넘버
  • mold_name — varchar(100) — NOT NULL — 금형이름
  • resin_type — varchar(100) — NOT NULL — 수지종류
  • resin_company — varchar(100) — NOT NULL — 수지회사
  • resin_name — varchar(100) — NOT NULL — 수지이름
  • target_weight — double — NOT NULL — 목표중량
  • real_weight — double — NOT NULL — 실제중량
  • error_range — double — NOT NULL — 오차범위
  • mold_temp — double — NOT NULL — 금형온도
  • standard_deviation — double — NOT NULL — 표준편차
  • relative_error — double — NOT NULL — 상대오차
  • updatedAt — datetime — 업데이트시간

user_info

  • name — varchar(100) — Primary key — NOT NULL
  • id — int — NOT NULL
  • pwd — varchar(100) — NOT NULL
  • e_name — varchar(100) — NOT NULL
  • auth — varchar(100) — Foreign key → auth_list.auth_name — NOT NULL