You can not select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
463 lines
17 KiB
463 lines
17 KiB
-- -----------------------------------------------------
|
|
-- 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;
|
|
|
|
|
|
|
|
|
|
|