iRhea-m5 ERD
Tables (14)
Authority-Code
- auth_code — char(2) — Primary key — NOT NULL
- auth_name — varchar(40)
- update-date — timestamp — yyyy-mm-dd hh:mm:ss
Code_Info
- class_code — char(7) — Primary key — NOT NULL
- code_id — char(2) — Primary key — NOT NULL
- code_name — varchar(40)
- update_date — timestamp — NOT NULL — timestamp =>yyyy-mm-dd hh:mm:ss
Coffee_Usage_Result
- serial_no — char(12) — Primary key — NOT NULL
- recipe_name — varchar(40) — Primary key — NOT NULL
- drip_date — date — Primary key — NOT NULL — type: yyyy-mm-dd
- drip_count_daily (dripcnt_daily) — num(4) — NOT NULL
- bean_weight_daily (beanwgt_daily) — num(5) — NOT NULL
- update_date — timestamp — NOT NULL — timestamp => yyyy-mm-dd hh:mm:ss
Default-brewset
- pattern_code — char(2) — Primary key — NOT NULL — "SP" : sprial pattern "BN" : bean pattern
- serial_no — char(12) — Foreign key → Machine-info.serial_no — NOT NULL — unique device serial_no
- default_bloom_stage_temperature (dft_bloomstg_temp) — num(2) — NOT NULL — 73 < temp <93 'C
- default_bloom_stage_flowrate (dft_bloomstg_flowrate) — num(1) — NOT NULL
- default_bloom_stage_nozspeed (dft_bloomstg_nzspeed) — num(2) — NOT NULL
- default_bloom_stage_pourrate (dft_bloomstg_pourrate) — num(3) — NOT NULL
- default_brew_stage1_temperature (dft_brewstg1_temp) — int(2) — NOT NULL — 뜸들이기 온도 대비 상대온도
- default_brew_stage1_flowrate (dft_brewstg1_flowrate) — num(1) — NOT NULL
- default_brew_stage1_nozspeed (dft_brewstg1_nzspeed) — num(2) — NOT NULL
- default_brew_stage1_pourrate (dft_brewstg1_pourrate) — num(3) — NOT NULL
- default_brew_stage2_temperature (dft_brewstg2_temp) — int(2) — NOT NULL — -2 'C
- default_brew_stage2_flowrate (dft_brewstg2_flowrate) — num(1) — NOT NULL
- default_brew_stage2_nozspeed (dft_brewstg2_nzspeed) — num(2) — NOT NULL
- default_brew_stage2_pourrate (dft_brewstg2_pourrate) — num(3) — NOT NULL
- default_brew_stage3_temperature (dft_brewstg3_temp) — int(2) — NOT NULL — -2 'C
- default_brew_stage3_flowrate (dft_brewstg3_flowrate) — num(1) — NOT NULL
- default_brew_stage3_nozspeed (dft_brewstg3_nzspeed) — num(2) — NOT NULL
- default_brew_stage3_pourrate (dft_brewstg3_pourrate) — num(3) — NOT NULL
- default_brew_stage4_temperature (dft_brewstg4_temp) — int(2) — NOT NULL — -2 'C
- default_brew_stage4_flowrate (dft_brewstg4_flowrate) — num(1) — NOT NULL
- default_brew_stage4_nozspeed (dft_brewstg4_nzspeed) — num(2) — NOT NULL
- default_brew_stage4_pourrate (dft_brewstg4_pourrate) — num(3) — NOT NULL
- update_date — timestamp — NOT NULL — yyyy-mm-dd hh:mm:ss
Error_History
- error_time — timestamp — Primary key — NOT NULL
- serial_no — char(12) — Foreign key → Machine-info.serial_no — NOT NULL — unique device serial_no
- error_occured_source (error_source) — char(3) — NOT NULL
- language_code — char(2) — NOT NULL
- error_code — char(4) — NOT NULL — 에러 코드
Group-code
- group_code — char(5) — Primary key — NOT NULL — * upper case * text(5) : G + text(4) * exe) GADMN
- group_name — varchar(40)
- update_date — timestamp — yyyy-mm-dd hh:mm:ss
Machine-info
- serial_no — char(12) — Primary key — NOT NULL — unique device serial_no
- model_no — varchar(10) — NOT NULL
- device_name — varchar(40)
- owner_name — varchar(40)
- store_name — varchar(40)
- fw_version — decial(1,1) — NOT NULL — v0.0 ~ v9.9
- fw_size — num(9) — NOT NULL — 0 ~ 999,999,999
- davice_install_date (install_date) — date — NOT NULL — date => yyyy-mm-dd
- fw_update_date (fw_update) — timestamp — NOT NULL — yyyy-mm-dd hh:mm:ss
- alarm_flag — char(1) — NOT NULL — Y, N
- use_language_code (language_code) — char(2) — NOT NULL — EN: English
- use_network — char(1) — E : Ethernet, W : Wifi
- ip_setting_method (ipsetting_method) — char(1) — A : Auto M : Manual
- ip_address — varchar(15) — 192.168.0.101
- subnet_mask — varchar(15)
- gate_way — varchar(15) — 192.168.000.001
- default_dripper (dft_dripper) — char(2) — NOT NULL — HA: hario, KA: kalita
- default_pattern_bloom (dft_ptn_bloom) — char(2) — 기본패턴-뜸들이기 단계 SP : spiral, BN : bean, DO : dot drip
- default_pattern_brew (dft_ptn_brew) — char(2) — NOT NULL — 기본패턴-추출 단계 SP : spiral, BN : bean, DO : dot drip
- default_spiral_bloom_temp (dftsp_bloom_temp) — num(2) — NOT NULL — 기본-나선패턴-뜸들이기단계 -추출수 온도 (temp ): 73 ~ 93
- default_spiral_bloom_flowrate (dftsp_bloom_flowrate) — num(1) — 기본 -나선패턴-뜸들이기단계 -유속 : 4 ml/sec
- default_spiral_bloom_nzspeed (dftsp_bloom_nzspeed) — num(2) — NOT NULL — 기본-나선-뜸들이기단계-노즐이동속도: 15 ~ 35 mm/sec
- default_spiral_bloom_pourrate (dftsp_bloom_pourrate) — num(3) — NOT NULL — 기본나선-뜸들이기단계-물붓기비율 pour-rate : 100 %
- default_bean_bloom_temp (dftbn_bloom_temp) — num(2) — 본-나선패턴-뜸들이기단계 -추출수 온도 (temp ): 73 ~ 93
- default_bean_bloom_flowrate (dftbn_bloom_flowrate) — num(1) — NOT NULL — 기본-원두패턴-뜸들이기단계 -유속 : 4 ml/sec
- default_bean_bloom_nzspeed (dftbn_bloom_nzspeed) — num(2) — NOT NULL — 기본-원두-뜸들이기단계-노즐이동속도: 15 ~ 35 mm/sec
- default_bean_bloom_pourrate (dftbn_bloom_pourrate) — num(3) — bloom-pourrate : 100 % 고정값
- drain_temperature (drain_temp) — num(2) — 드레인 온수온도 : 82'C (73 ~ 93 'C)
- drain_flowrate — num(1) — NOT NULL
- drain_water_volume (drain_water) — num(3) — NOT NULL — drain_water_volume : 20 ~ 100 ml
- rinse_temperature — num(2) — 린스 온수온도 : 82'C (73 ~ 93 'C)
- rinse_water_volume (rinse_water) — num(3) — NOT NULL — 린스유량 : 40 ml
- rinse_flowrate — num(1) — 린스유속: 3 ~ 7 ml
- rinse_range_xaxis (rinse_range_x) — num(2) — NOT NULL — x축 이동범위(30 ~55mm)
- rinse_range_yaxis (rinse_range_y) — num(2) — NOT NULL — y축 이동범위(30 ~55mm)
- htb_set_temperature (htb_set_temp) — num(2) — NOT NULL — htp-set-temp : 95 'C 고온보일러 설정온도
- htb_total_count_insolvalve (htb_totcnt_insol) — num(7) — NOT NULL — 고온보일러-입수솔밸브-누적횟수
- htb_general_highlvl1 — num(4) — NOT NULL
- htb_general_highlvl2 — num(4) — NOT NULL
- htb_general_lowlvl1 — num(4) — NOT NULL
- htb_general_lowlvl2 — num(4) — NOT NULL
- htb_membrain_highlvl1 — num(4) — NOT NULL
- htb_membrain_highlvl2 — num(4) — NOT NULL
- htb_membrain_lowlvl1 — num(4) — NOT NULL
- htb_membrain_lowlvl2 — num(4) — NOT NULL
- ltb_set_temperature (ltb_set_temp) — num(2) — NOT NULL
- ltb_total_count_insolvalve (ltb_totcnt_insol) — num(7) — NOT NULL
- ltb_general_highlvl1 — num(4) — NOT NULL
- ltb_general_highlvl2 — num(4) — NOT NULL
- ltb_general_lowlvl1 — num(4) — NOT NULL
- ltb_general_lowlvl2 — num(4) — NOT NULL
- ltb_membrain_highlvl1 — num(4) — NOT NULL
- ltb_membrain_highlvl2 — num(4) — NOT NULL
- ltb_membrain_lowlvl1 — num(4) — NOT NULL
- ltb_membrain_lowlvl2 — num(4) — NOT NULL
- update_date — timestamp — NOT NULL
Menu _Authority
- menu_id — varchar(12) — Primary key — NOT NULL
- auth_code — char(2) — Foreign key → Authority-Code.auth_code — NOT NULL
- menu_name — varchar(40)
- use_flag — char(1) — Y, N 화면 사용권한=> 권한 변경시 대비
- update_date — timestamp — NOT NULL — yyyy-mm-dd hh:mm:ss
Message_Info
- language_code — char(2) — Primary key — NOT NULL
- message_code — char(4) — Primary key — NOT NULL
- message_contents — varchar(100)
- update_date — timestamp — NOT NULL — timestamp=> yyyy-mm-dd hh:mm:ss
Pour_Range
- pattern_code — char(2) — Primary key — NOT NULL — sp: spiral pattern bn: bean pattern do: dot drip
- pour_range_code (pourrng_code) — char(2) — Primary key — NOT NULL — 1 cup: 30 ~ 55 mm 2 cup: 30 ~ 55 mm 3 cup: 30 ~ 55 mm 4 cup: 30 ~ 55 mm
- pour_range_x (pourrng_x) — num(2) — NOT NULL — x-axis max range
- pour_range_y (pourrng_y) — num(2) — NOT NULL — y-axis max range
- update_date — timestamp — NOT NULL — timestamp=> yyyy-mm-dd hh:mm:ss
Recipe_Main
- recipe_name — varchar(40) — Primary key — NOT NULL
- spout_no — num(1) — Foreign key → Spout_Info.spout_no — NOT NULL — spout no = 1 ~ 5
- serial_no — char(12) — Foreign key → Spout_Info.serial_no — NOT NULL — unique device serial_no
- bean_name — varchar(40) — NOT NULL
- pattern_bloom (ptn_bloom) — char(2) — NOT NULL
- pattern_brew (ptn_brew) — char(2) — NOT NULL
- bean_weight — num(3) — NOT NULL
- extraction_ratio — decimal(2,1) — NOT NULL
- extract_coffee_weight (extract_coffeewgt) — num(3) — NOT NULL — extract_coffeewgt <= 450 g
- use_dripper — char(2) — NOT NULL
- pour_range_bloom (pourrng_bloom) — char(2) — NOT NULL — R1 : 1 cup R2: 2 cup R3: 3 cup R4: 4 cup
- pour_range_brew (pourrng_brew) — char(2) — NOT NULL — R1 : 1 cup R2: 2 cup R3: 3 cup R4: 4 cup
- bean_grind_degree (grind_degree) — char(60) — NOT NULL — degree of grinding coffee bean
- favorite_flag — char(1) — NOT NULL
- bloom_stage_water_volume (bloom_water) — num(3) — NOT NULL
- bloom_stage_waittime (bloom_waittime) — num(3) — NOT NULL — unit : sec
- bloom_stage_temperature (bloom_temp) — num(2) — NOT NULL — unit : 'C, 72 'C < temp < 94'C
- bloom_stage_flowrate (bloom_flowrate) — num(1) — NOT NULL
- update-date — timestamp — timestamp => yyyy-mm-dd hh:mm:ss
Recipe_Stage
- brew_stage_num (brewstg_num) — num(2) — Primary key — NOT NULL
- recipe-name — text(40) — Foreign key → Recipe_Main.recipe_name
- spout_no — num(1) — Foreign key → Recipe_Main.spout_no — NOT NULL — spout no = 1 ~ 5
- serial_no — char(12) — Foreign key → Recipe_Main.serial_no — NOT NULL — unique device serial_no
- brew_stage_ratio (brew_ratio) — num(2) — NOT NULL — unit => % max < 100 %
- brew_stage_waittime (brew_waittime) — num(3) — NOT NULL
- brew_stage_temperature (brew_temp) — num(2) — NOT NULL — unit : 'C, 72 'C < temp < 94'C
- flow_rate — num(1) — NOT NULL — unit: g/sec, 3 ~ 7 g/sec
- update_time — timestamp — NOT NULL — timestamp => yyyy-mm-dd hh:mm:ss
Spout_Info
- spout_no — num(1) — Primary key — NOT NULL — spout no = 1 ~ 5
- serial_no — char(12) — Foreign key → Machine-info.serial_no — NOT NULL — unique device serial_no
- scale_deviation_value (scale_deviation) — num(2) — NOT NULL
- nzcenter_deviation_xaxis (nzcenter_deviation_x) — num(2) — NOT NULL — 현재위치 - 축중심위치(50) = 이동값
- nzcenter_deviation_yaxis (nzcenter_deviation_y) — num(2) — NOT NULL — 현재위치 - 축중심위치(50) = 이동값
- std_flowrate_pump1 — decimal(1,1) — NOT NULL — 기준유량-펌프1 = 0.5
- std_flowrate_pump2 — decimal(1,1) — NOT NULL — 기준유량_펌프2 = 1.0
- std_flowrate_pump3 — decimal(1,1) — NOT NULL — 기준유량_펌프3 = 2.0
- std_flowrate_pump4 — decimal(1,1) — NOT NULL — 기준유량_펌프4 = 3.0
- std_flowrate_pump5 — decimal(1,1) — NOT NULL — 기준유량_펌프5 = 4.0
- cal_flowrate_pump1 — decimal(1,1) — NOT NULL — 교정유량_펌프1
- cal_flowrate_pump2 — decimal(1,1) — NOT NULL — 교정유량_펌프2
- cal_flowrate_pump3 — decimal(1,1) — NOT NULL — 교정유량_펌프3
- cal_flowrate_pump4 — decimal(1,1) — NOT NULL — 교정유량_펌프4
- cal_flowrate_pump5 — decimal(1,1) — NOT NULL — 교정유량_펌프5
- htb_pump_worktime — num(7) — NOT NULL
- ltb_pump_worktime — num(7) — NOT NULL
- total_count_drip (totcnt_drip) — num(7) — NOT NULL
- total_count_out_solenoid_valve (totcnt_out_solvalve) — num(7) — NOT NULL
- update_date — timestamp — NOT NULL
User-Info
- user_id — varchar(14) — Primary key — NOT NULL — * first : alphabet (must) * alpabet +number + 1 Special Characters 조합 * min : text(8) ~ max: text(14)
- group_code — char(5) — Foreign key → Group-code.group_code — NOT NULL — * upper case * text(5) : G + text(4) * exe) GADMN
- auth_code — char(2) — Foreign key → Authority-Code.auth_code — NOT NULL
- user_pwd — varchar(12) — NOT NULL
- user_name — varchar(40) — NOT NULL
- user_email — varchar(40) — NOT NULL
- serial_no — char(12)
- mobile_no — varchar(20) — NOT NULL
- store_name — varchar(40) — NOT NULL
- store_telno — varchar(20)
- company_name — varchar(40)
- country_code — char(2)
- accept_terms — char(1) — NOT NULL — * 약관동의 : Y, N
- accept_personal — char(1) — NOT NULL
- zip_code — vahchar(10)
- store_address — varchar(100)
- update_date — timestamp — NOT NULL