-- -----------------------------------------------------
-- Table `babyfeed`.`tbl_bf_daily_nutrition`
-- -----------------------------------------------------
DROP TABLE IF EXISTS `babyfeed`.`tbl_bf_daily_nutrition` ;

CREATE TABLE IF NOT EXISTS `babyfeed`.`tbl_bf_daily_nutrition` (
  `dn_no` INT(11) NOT NULL AUTO_INCREMENT,
  `smc_no` INT(11) NOT NULL,
  `baseday` DATETIME NOT NULL,
  `append_src_img_file` BIGINT(20) NULL,
  `append_300_img_file` BIGINT(20) NULL,
  `nutirition_cd_no` VARCHAR(30) NOT NULL,
  `reg_dt` DATETIME NOT NULL,
  `mod_dt` DATETIME NULL DEFAULT NULL,
  PRIMARY KEY (`dn_no`),
  UNIQUE INDEX `n_no_UNIQUE` (`dn_no` ASC))
ENGINE = InnoDB
AUTO_INCREMENT = 2
DEFAULT CHARACTER SET = utf8;


-- -----------------------------------------------------
-- Table `babyfeed`.`tbl_bf_daily_nutrition`
-- -----------------------------------------------------
DROP TABLE IF EXISTS `babyfeed`.`tbl_bf_daily_nutrition` ;

CREATE TABLE IF NOT EXISTS `babyfeed`.`tbl_bf_daily_nutrition` (
  `dn_no` INT(11) NOT NULL AUTO_INCREMENT,
  `smc_no` INT(11) NOT NULL,
  `baseday` DATETIME NOT NULL,
  `append_src_img_file` BIGINT(20) NULL,
  `append_300_img_file` BIGINT(20) NULL,
  `nutirition_cd_no` VARCHAR(30) NOT NULL,
  `reg_dt` DATETIME NOT NULL,
  `mod_dt` DATETIME NULL DEFAULT NULL,
  PRIMARY KEY (`dn_no`),
  UNIQUE INDEX `n_no_UNIQUE` (`dn_no` ASC))
ENGINE = InnoDB
AUTO_INCREMENT = 2
DEFAULT CHARACTER SET = utf8;


-- -----------------------------------------------------
-- Table `babyfeed`.`tbl_bf_daily_nutrition_1`
-- -----------------------------------------------------
DROP TABLE IF EXISTS `babyfeed`.`tbl_bf_daily_nutrition_1` ;

CREATE TABLE IF NOT EXISTS `babyfeed`.`tbl_bf_daily_nutrition_1` (
  `dn_no` INT(11) NOT NULL,
  `smc_no` INT(11) NOT NULL,
  `baseday` DATETIME NOT NULL,
  `birthday` DATETIME NOT NULL,
  `afterbirthday` INT(11) NOT NULL,
  `fed_rs` INT(11) NULL COMMENT '섭취이유',
  `emo_pre` INT(11) NULL COMMENT '섭취전',
  `emo_post` INT(11) NULL COMMENT '섭취후',
  `lacto` CHAR(1) NULL DEFAULT 'N' COMMENT '유산균섭취여부',
  `fdv` CHAR(1) NULL DEFAULT 'N' COMMENT '유축기사용여부',
  `eat_qty` INT(11) NULL COMMENT '수유량',
  `blm` INT(11) NULL COMMENT '왼쪽수유 (분)',
  `bls` INT(11) NULL COMMENT '왼쪽수유 (초)',
  `brm` INT(11) NULL COMMENT '오른쪽수유 (분)',
  `brs` INT(11) NULL COMMENT '오른쪽수유 (초)',
  `srv` INT(11) NULL COMMENT '유축제공량',
  `rem` INT(11) NULL COMMENT '유축 잔량',
  `wgt` decimal(5,2) null COMMENT '가중치,
  `reg_dt` DATETIME NOT NULL,
  `mod_dt` DATETIME NULL,
  PRIMARY KEY (`dn_no`))
ENGINE = InnoDB
AUTO_INCREMENT = 2
DEFAULT CHARACTER SET = utf8;


-- -----------------------------------------------------
-- Table `babyfeed`.`tbl_bf_daily_nutrition_2`
-- -----------------------------------------------------
DROP TABLE IF EXISTS `babyfeed`.`tbl_bf_daily_nutrition_2` ;

CREATE TABLE IF NOT EXISTS `babyfeed`.`tbl_bf_daily_nutrition_2` (
  `dn_no` INT(11) NOT NULL,
  `smc_no` INT(11) NOT NULL,
  `baseday` DATETIME NOT NULL,
  `birthday` DATETIME NOT NULL,
  `afterbirthday` INT(11) NOT NULL,
  `fed_rs` INT(11) NULL COMMENT '섭취이유',
  `emo_pre` INT(11) NULL COMMENT '섭취전',
  `emo_post` INT(11) NULL COMMENT '섭취후',
  `db_dn_no` INT(11) NULL,
  `lacto` CHAR(1) NULL DEFAULT 'N' COMMENT '유산균 섭취여부',
  `eat_qty` INT(11) NULL COMMENT '섭취량',
  `bm` INT(11) NULL COMMENT '섭취분',
  `bs` INT(11) NULL COMMENT '섭취초',
  `rem` INT(11) NULL COMMENT '잔량',
  `reg_dt` DATETIME NOT NULL,
  `mod_dt` DATETIME NULL,
  PRIMARY KEY (`dn_no`))
ENGINE = InnoDB
AUTO_INCREMENT = 2
DEFAULT CHARACTER SET = utf8;

-- -----------------------------------------------------
-- Table `babyfeed`.`tbl_bf_daily_nutrition_3`
-- -----------------------------------------------------
DROP TABLE IF EXISTS `babyfeed`.`tbl_bf_daily_nutrition_3` ;

CREATE TABLE IF NOT EXISTS `babyfeed`.`tbl_bf_daily_nutrition_3` (
  `dn_no` INT(11) NOT NULL,
  `smc_no` INT(11) NOT NULL,
  `baseday` DATETIME NOT NULL,
  `birthday` DATETIME NOT NULL,
  `afterbirthday` INT(11) NOT NULL,
  `fed_rs` INT(11) NULL COMMENT '섭취이유',
  `emo_pre` INT(11) NULL COMMENT '섭취전',
  `emo_post` INT(11) NULL COMMENT '섭취후',
  `bm` INT(11) NULL COMMENT '섭취분',
  `bs` INT(11) NULL COMMENT '섭취초',
  `allergy` CHAR(1) NOT NULL DEFAULT 'N' COMMENT '알러지 유무',
  `allergy_cd_no` VARCHAR(30) NULL,
  `db_dn_no` INT(11) NULL,
  `reg_dt` DATETIME NOT NULL,
  `mod_dt` DATETIME NULL,
  PRIMARY KEY (`dn_no`))
ENGINE = InnoDB
AUTO_INCREMENT = 2
DEFAULT CHARACTER SET = utf8;


-- -----------------------------------------------------
-- Table `babyfeed`.`tbl_bf_daily_nutrition_4`
-- -----------------------------------------------------
DROP TABLE IF EXISTS `babyfeed`.`tbl_bf_daily_nutrition_4` ;

CREATE TABLE IF NOT EXISTS `babyfeed`.`tbl_bf_daily_nutrition_4` (
  `dn_no` INT(11) NOT NULL,
  `smc_no` INT(11) NOT NULL,
  `baseday` DATETIME NOT NULL,
  `birthday` DATETIME NOT NULL,
  `afterbirthday` INT(11) NOT NULL,
  `fed_rs` INT(11) NULL COMMENT '섭취이유',
  `emo_pre` INT(11) NULL COMMENT '섭취전',
  `emo_post` INT(11) NULL COMMENT '섭취후',
  `cup_cd_no` VARCHAR(30) NULL COMMENT '섭취도구',
  `eat_qty` VARCHAR(20) NULL,
  `db_dn_no` INT(11) NULL,
  `reg_dt` DATETIME NOT NULL,
  `mod_dt` DATETIME NULL,
  PRIMARY KEY (`dn_no`))
ENGINE = InnoDB
AUTO_INCREMENT = 2
DEFAULT CHARACTER SET = utf8;


-- -----------------------------------------------------
-- Table `babyfeed`.`tbl_db_vac`
-- -----------------------------------------------------
DROP TABLE IF EXISTS `babyfeed`.`tbl_db_vac` ;

CREATE TABLE IF NOT EXISTS `babyfeed`.`tbl_db_vac` (
  `dv_no` INT NOT NULL,
  PRIMARY KEY (`dv_no`))
ENGINE = InnoDB;



-- -----------------------------------------------------
-- Table `babyfeed`.`tbl_bf_daily_nutrition_5`
-- -----------------------------------------------------
DROP TABLE IF EXISTS `babyfeed`.`tbl_bf_daily_nutrition_5` ;

CREATE TABLE IF NOT EXISTS `babyfeed`.`tbl_bf_daily_nutrition_5` (
  `dn_no` INT(11) NOT NULL,
  `smc_no` INT(11) NOT NULL,
  `baseday` DATETIME NOT NULL,
  `birthday` DATETIME NOT NULL,
  `afterbirthday` INT(11) NOT NULL,
  `sleep_rs` INT(11) NULL COMMENT '수면이유',
  `emo_pre` INT(11) NULL COMMENT '섭취전',
  `sleep_tp` INT(11) NULL COMMENT '낮잠밤잠',
  `sleep_s_h` INT NULL,
  `sleep_s_m`INT NULL,
  `sleep_h` INT NULL,
  `sleep_m` INT NULL,
  `emo_post` INT(11) NULL COMMENT '섭취후',
  `reg_dt` DATETIME NOT NULL,
  `mod_dt` DATETIME NULL,
  PRIMARY KEY (`dn_no`))
ENGINE = InnoDB
AUTO_INCREMENT = 2
DEFAULT CHARACTER SET = utf8;



-- -----------------------------------------------------
-- Table `babyfeed`.`tbl_bf_daily_nutrition_6`
-- -----------------------------------------------------
DROP TABLE IF EXISTS `babyfeed`.`tbl_bf_daily_nutrition_6` ;

CREATE TABLE IF NOT EXISTS `babyfeed`.`tbl_bf_daily_nutrition_6` (
  `dn_no` INT(11) NOT NULL,
  `smc_no` INT(11) NOT NULL,
  `baseday` DATETIME NOT NULL,
  `birthday` DATETIME NOT NULL,
  `afterbirthday` INT(11) NOT NULL,
  `rest_rs` INT(11) NULL COMMENT '대소변 이유',
  `emo_pre` INT(11) NULL COMMENT '접종전',
  `emo_post` INT(11) NULL COMMENT '접종 후',
  `rest_tp` INT(11) NULL COMMENT '대소변',
  `rest_qty` INT NOT NULL DEFAULT 0 COMMENT '배변량',
  `rest_color` INT NOT NULL DEFAULT 0 COMMENT '배변색',
  `reg_dt` DATETIME NOT NULL,
  `mod_dt` DATETIME NULL,
  PRIMARY KEY (`dn_no`))
ENGINE = InnoDB
AUTO_INCREMENT = 2
DEFAULT CHARACTER SET = utf8;

-- -----------------------------------------------------
-- Table `babyfeed`.`tbl_bf_daily_nutrition_7`
-- -----------------------------------------------------
DROP TABLE IF EXISTS `babyfeed`.`tbl_bf_daily_nutrition_7` ;

CREATE TABLE IF NOT EXISTS `babyfeed`.`tbl_bf_daily_nutrition_7` (
  `dn_no` INT(11) NOT NULL,
  `smc_no` INT(11) NOT NULL,
  `baseday` DATETIME NOT NULL,
  `birthday` DATETIME NOT NULL,
  `afterbirthday` INT(11) NOT NULL,
  `vac_rs` VARCHAR(20) NULL COMMENT '예방접종이유',
  `emo_pre` INT(11) NULL COMMENT '접종전',
  `emo_post` INT(11) NULL COMMENT '접종 후',
  `vac_alg_tp` VARCHAR(20) NULL COMMENT '예방접종 알러지 여부',
  `y` INT NULL COMMENT '접종년',
  `m` INT NULL COMMENT '접종월',
  `d` INT NULL COMMENT '접종일',
  `db_dv_no` INT NULL COMMENT '예방접종명',
  `memo` VARCHAR(500) NULL COMMENT '특이사항',
  `reg_dt` DATETIME NOT NULL,
  `mod_dt` DATETIME NULL,
  PRIMARY KEY (`dn_no`))
ENGINE = InnoDB
AUTO_INCREMENT = 2
DEFAULT CHARACTER SET = utf8;








DROP TABLE IF EXISTS `babyfeed`.`tbl_db_home_bf` ;

CREATE TABLE IF NOT EXISTS `babyfeed`.`tbl_db_home_bf` (
  `dhb_no` INT NOT NULL AUTO_INCREMENT,
  `dhb_cd` VARCHAR(10) NOT NULL,
  `name` VARCHAR(20) NULL,
  `for_m` VARCHAR(10) NULL,
  `water_qty` VARCHAR(20) NULL,
  `recipe1` VARCHAR(500) NULL,
  `recipe2` VARCHAR(500) NULL,
  `recipe3` VARCHAR(500) NULL,
  `recipe4` VARCHAR(500) NULL,
  `recipe5` VARCHAR(500) NULL,
  `recipe6` VARCHAR(500) NULL,
  `recipe7` VARCHAR(500) NULL,
  `recipe8` VARCHAR(500) NULL,
  `make_hint` VARCHAR(500) NULL,
  `nutrition_info` VARCHAR(500) NULL,
  `source` VARCHAR(20) NULL,
  `keyword1` VARCHAR(100) NULL,
  `keyword2` VARCHAR(100) NULL,
  `reg_dt` DATETIME NULL,
  `mod_dt` DATETIME NULL,
  `sys_member_id` VARCHAR(30) NULL,
  PRIMARY KEY (`dhb_cd`),
  UNIQUE INDEX `dhb_no_UNIQUE` (`dhb_no` ASC))
ENGINE = InnoDB;


-- -----------------------------------------------------
-- Table `babyfeed`.`tbl_db_home_bf_ingre`
-- -----------------------------------------------------
DROP TABLE IF EXISTS `babyfeed`.`tbl_db_home_bf_ingre` ;

CREATE TABLE IF NOT EXISTS `babyfeed`.`tbl_db_home_bf_ingre` (
  `dhbi_no` INT(11) NOT NULL AUTO_INCREMENT,
  `dhb_cd` VARCHAR(10) NOT NULL,
  `di_name` VARCHAR(20) NOT NULL COMMENT '식재료',
  `rate_100` DECIMAL(6,2) NOT NULL COMMENT '비율',
  `for_m` INT NOT NULL COMMENT '실중량',
  `reg_dt` DATETIME NOT NULL,
  `mod_dt` DATETIME NULL,
  `sys_member_id` VARCHAR(30) NOT NULL,
  PRIMARY KEY (`dhbi_no`),
  UNIQUE INDEX `n_no_UNIQUE` (`dhbi_no` ASC))
ENGINE = InnoDB
AUTO_INCREMENT = 1
DEFAULT CHARACTER SET = utf8mb4
COLLATE = utf8mb4_unicode_ci;

-- -----------------------------------------------------
-- Table `babyfeed`.`tbl_db_ingre`
-- -----------------------------------------------------
DROP TABLE IF EXISTS `babyfeed`.`tbl_db_ingre` ;

CREATE TABLE IF NOT EXISTS `babyfeed`.`tbl_db_ingre` (
  `di_no` INT(11) NOT NULL AUTO_INCREMENT,
  `dhb_cd` VARCHAR(10) NOT NULL,
  `di_name` VARCHAR(20) NOT NULL COMMENT '식재료',
  `food_nm` VARCHAR(100) NOT NULL COMMENT '식품명',
  `food_cd` VARCHAR(9) NOT NULL COMMENT '식품코드',
  `name_real` VARCHAR(20) NOT NULL COMMENT '실제 식재료명',
  `g` VARCHAR(9) NOT NULL COMMENT '중량',
  `di_rate` DECIMAL(6,2) NOT NULL COMMENT '비율',
  `g_real` INT NOT NULL COMMENT '실중량',
  `enerc` DECIMAL(6,2) NULL COMMENT '에너지',
  `procnp` DECIMAL(6,2) NULL COMMENT '단백질',
  `fat` DECIMAL(6,2) NULL COMMENT '지방',
  `chotdf` DECIMAL(6,2) NULL COMMENT '탄수화물',
  `sugar` DECIMAL(6,2) NULL COMMENT '총당류',
  `fibtg` DECIMAL(6,2) NULL COMMENT '총식이섬유',
  `ca` DECIMAL(6,2) NULL COMMENT '칼슘',
  `fe` DECIMAL(6,2) NULL COMMENT '철',
  `mg` DECIMAL(6,2) NULL COMMENT '마그네슘',
  `p` DECIMAL(6,2) NULL COMMENT '인',
  `k` DECIMAL(6,2) NULL COMMENT '칼륨',
  `na` DECIMAL(6,2) NULL COMMENT '나트륨',
  `zn` DECIMAL(6,2) NULL COMMENT '아연',
  `cu` DECIMAL(6,2) NULL COMMENT '구리',
  `mn` DECIMAL(6,2) NULL COMMENT '망간',
  `se` DECIMAL(6,2) NULL COMMENT '셀레늄',
  `iodine` DECIMAL(6,2) NULL COMMENT '요오드',
  `vitamina` DECIMAL(6,2) NULL COMMENT '비타민a',
  `vitamind` DECIMAL(6,2) NULL COMMENT '비타민d',
  `vitamine` DECIMAL(6,2) NULL COMMENT '비타민e',
  `vitamink` DECIMAL(6,2) NULL COMMENT '비타민k',
  `vitaminb1` DECIMAL(6,2) NULL COMMENT '비타민b1',
  `vitaminb2` DECIMAL(6,2) NULL COMMENT '비타민b1',
  `niacin` DECIMAL(6,2) NULL COMMENT '이아신',
  `pantac` DECIMAL(6,2) NULL COMMENT '판토텐산',
  `vitaminb6` DECIMAL(6,2) NULL COMMENT '비타민b6',
  `biot` DECIMAL(6,2) NULL COMMENT '비오틴',
  `fol` DECIMAL(6,2) NULL COMMENT '엽산',
  `vitaminb12` DECIMAL(6,2) NULL COMMENT '비타민12',
  `vitaminc` DECIMAL(6,2) NULL COMMENT '민타민c',
  `cholesterol` DECIMAL(6,2) NULL COMMENT '콜레스테롤',
  `fasate` DECIMAL(6,2) NULL COMMENT '포화지방',
  `linol` DECIMAL(6,2) NULL COMMENT '리놀레산',
  `alinol` DECIMAL(6,2) NULL COMMENT '아리놀레산',
  `epadha` DECIMAL(6,2) NULL COMMENT 'epa와 dha의 합',
  `nutrient_source` VARCHAR(60) NULL COMMENT '성분표출',
  `publish_org` VARCHAR(50) NULL COMMENT '발행기관',
  `dqi_food_1` CHAR(1) NULL,
  `dqi_food_2` CHAR(1) NULL,
  `dqi_food_3` CHAR(1) NULL,
  `dqi_food_4` CHAR(1) NULL,
  `dqi_food_5` CHAR(1) NULL,
  `dqi_food_6` CHAR(1) NULL,
  `dqi_food_7` CHAR(1) NULL,
  `dqi_food_8` CHAR(1) NULL,
  `dqi_food_9` CHAR(1) NULL,
  `dqi_food_10` CHAR(1) NULL,
  `dqi_food_11` CHAR(1) NULL,
  `dqi_food_12` CHAR(1) NULL,
  `reg_dt` DATETIME NOT NULL,
  `mod_dt` DATETIME NULL,
  `sys_member_id` VARCHAR(30) NOT NULL,
  PRIMARY KEY (`di_no`),
  UNIQUE INDEX `n_no_UNIQUE` (`di_no` ASC))
ENGINE = InnoDB
AUTO_INCREMENT = 1
DEFAULT CHARACTER SET = utf8mb4
COLLATE = utf8mb4_unicode_ci;


DROP TABLE IF EXISTS `babyfeed`.`tbl_db_bf_ingre` ;

CREATE TABLE IF NOT EXISTS `babyfeed`.`tbl_db_bf_ingre` (
  `dbi_no` INT(11) NOT NULL AUTO_INCREMENT,
  `food_nm` VARCHAR(100) NOT NULL COMMENT '식품명',
  `food_cd` VARCHAR(9) NOT NULL COMMENT '식품코드',
  `name_real` VARCHAR(20) NOT NULL COMMENT '실제 식재료명',
  `food_grp` VARCHAR(20) NULL COMMENT '식품군',
  `for_m` VARCHAR(10) NULL COMMENT '추천개월수',
  `recom_bf` VARCHAR(20) NULL COMMENT '추천이유식',
  `meaning` VARCHAR(500) NULL COMMENT '영양학적 의미',
  `source` VARCHAR(50) NULL COMMENT '출처',
  `keyword1` VARCHAR(50) NULL COMMENT '영양키워드1',
  `keyword2` VARCHAR(50) NULL COMMENT '영양키워드2',
  `keyword3` VARCHAR(50) NULL COMMENT '영양키워드3',
  `relation_bf_ingre` VARCHAR(20) NULL COMMENT '어울리는 식재료',
  `allergy` VARCHAR(1) NULL COMMENT '알레르기 여부',
  `recipe1` VARCHAR(500) NULL COMMENT '식재료 다루는 법',
  `source2` VARCHAR(50) NULL COMMENT '소스2',
  `season1` VARCHAR(1) NULL COMMENT '봄',
  `season2` VARCHAR(1) NULL COMMENT '여름',
  `season3` VARCHAR(1) NULL COMMENT '가을',
  `season4` VARCHAR(1) NULL COMMENT '겨울',
  `enerc` DECIMAL(6,2) NULL COMMENT '에너지',
  `procnp` DECIMAL(6,2) NULL COMMENT '단백질',
  `fat` DECIMAL(6,2) NULL COMMENT '지방',
  `chotdf` DECIMAL(6,2) NULL COMMENT '탄수화물',
  `sugar` DECIMAL(6,2) NULL COMMENT '총당류',
  `fibtg` DECIMAL(6,2) NULL COMMENT '총식이섬유',
  `ca` DECIMAL(6,2) NULL COMMENT '칼슘',
  `fe` DECIMAL(6,2) NULL COMMENT '철',
  `mg` DECIMAL(6,2) NULL COMMENT '마그네슘',
  `p` DECIMAL(6,2) NULL COMMENT '인',
  `k` DECIMAL(6,2) NULL COMMENT '칼륨',
  `na` DECIMAL(10,2) NULL COMMENT '나트륨',
  `zn` DECIMAL(6,2) NULL COMMENT '아연',
  `cu` DECIMAL(6,2) NULL COMMENT '구리',
  `mn` DECIMAL(6,2) NULL COMMENT '망간',
  `se` DECIMAL(6,2) NULL COMMENT '셀레늄',
  `iodine` DECIMAL(6,2) NULL COMMENT '요오드',
  `vitamina` DECIMAL(6,2) NULL COMMENT '비타민a',
  `vitamind` DECIMAL(6,2) NULL COMMENT '비타민d',
  `vitamine` DECIMAL(6,2) NULL COMMENT '비타민e',
  `vitamink` DECIMAL(6,2) NULL COMMENT '비타민k',
  `vitaminb1` DECIMAL(6,2) NULL COMMENT '비타민b1',
  `vitaminb2` DECIMAL(6,2) NULL COMMENT '비타민b1',
  `niacin` DECIMAL(6,2) NULL COMMENT '이아신',
  `pantac` DECIMAL(6,2) NULL COMMENT '판토텐산',
  `vitaminb6` DECIMAL(6,2) NULL COMMENT '비타민b6',
  `biot` DECIMAL(6,2) NULL COMMENT '비오틴',
  `fol` DECIMAL(6,2) NULL COMMENT '엽산',
  `vitaminb12` DECIMAL(6,2) NULL COMMENT '비타민12',
  `vitaminc` DECIMAL(6,2) NULL COMMENT '민타민c',
  `cholesterol` DECIMAL(6,2) NULL COMMENT '콜레스테롤',
  `fasate` DECIMAL(6,2) NULL COMMENT '포화지방',
  `linol` DECIMAL(6,2) NULL COMMENT '리놀레산',
  `alinol` DECIMAL(6,2) NULL COMMENT '아리놀레산',
  `epadha` DECIMAL(6,2) NULL COMMENT 'epa와 dha의 합',
  `nutrient_source` VARCHAR(60) NULL COMMENT '성분표출',
  `publish_org` VARCHAR(50) NULL COMMENT '발행기관',
  `dqi_food_1` CHAR(1) NULL COMMENT '모유',
  `dqi_food_2` CHAR(1) NULL COMMENT '분유',
  `dqi_food_3` CHAR(1) NULL COMMENT '유제품',
  `dqi_food_4` CHAR(1) NULL COMMENT '통곡물',
  `dqi_food_5` CHAR(1) NULL COMMENT '정제된곡물',
  `dqi_food_6` CHAR(1) NULL COMMENT '단백질식품',
  `dqi_food_7` CHAR(1) NULL COMMENT '채소류',
  `dqi_food_8` CHAR(1) NULL COMMENT '과일류',
  `dqi_food_9` CHAR(1) NULL COMMENT '100%과일주스',
  `dqi_food_10` CHAR(1) NULL COMMENT '음료',
  `dqi_food_11` CHAR(1) NULL COMMENT '함유제품',
  `dqi_food_12` CHAR(1) NULL COMMENT '짠과자',
  `reg_dt` DATETIME NOT NULL,
  `mod_dt` DATETIME NULL,
  `sys_member_id` VARCHAR(30) NOT NULL,
  PRIMARY KEY (`dbi_no`),
  UNIQUE INDEX `n_no_UNIQUE` (`dbi_no` ASC))
ENGINE = InnoDB
AUTO_INCREMENT = 1
DEFAULT CHARACTER SET = utf8mb4
COLLATE = utf8mb4_unicode_ci;