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