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