-- tbl_code_group 테이블 데이터 --------------------------------------------------------------------------
INSERT INTO tbl_code_group
    (cg_cd, title, reg_dt, mod_dt, sys_member_id)
VALUES
    ('BF_RECORD_CATEGORY', '기록카테고리', now(), null, 'so2');



-- tbl_code_item 테이블 데이터 --------------------------------------------------------------------------
DELETE FROM tbl_code_item WHERE cg_cd = 'BF_RECORD_CATEGORY';
INSERT INTO tbl_code_item
  (title, order_no, cg_cd, val_1, ci_explain, ci_link, reg_dt, mod_dt, sys_member_id)
VALUES
  ('모유', '1', 'BF_RECORD_CATEGORY', '1', '', '', '2022-02-05 00:00:00', null, 'so2');
INSERT INTO tbl_code_item
  (title, order_no, cg_cd, val_1, ci_explain, ci_link, reg_dt, mod_dt, sys_member_id)
VALUES
  ('간식', '2', 'BF_RECORD_CATEGORY', '3', '', '', '2022-02-05 00:00:00', null, 'so2');
INSERT INTO tbl_code_item
  (title, order_no, cg_cd, val_1, ci_explain, ci_link, reg_dt, mod_dt, sys_member_id)
VALUES
  ('대소변', '3', 'BF_RECORD_CATEGORY', '6', '', '', '2022-02-05 00:00:00', null, 'so2');
INSERT INTO tbl_code_item
  (title, order_no, cg_cd, val_1, ci_explain, ci_link, reg_dt, mod_dt, sys_member_id)
VALUES
  ('병원', '4', 'BF_RECORD_CATEGORY', '11', '', '', '2022-02-05 00:00:00', null, 'so2');
INSERT INTO tbl_code_item
  (title, order_no, cg_cd, val_1, ci_explain, ci_link, reg_dt, mod_dt, sys_member_id)
VALUES
  ('생활', '5', 'BF_RECORD_CATEGORY', '12', '', '', '2022-02-05 00:00:00', null, 'so2');
INSERT INTO tbl_code_item
  (title, order_no, cg_cd, val_1, ci_explain, ci_link, reg_dt, mod_dt, sys_member_id)
VALUES
  ('발달과정성취', '6', 'BF_RECORD_CATEGORY', '13', '', '', '2022-02-05 00:00:00', null, 'so2');
INSERT INTO tbl_code_item
  (title, order_no, cg_cd, val_1, ci_explain, ci_link, reg_dt, mod_dt, sys_member_id)
VALUES
  ('수면', '7', 'BF_RECORD_CATEGORY', '5', '', '', '2022-02-05 00:00:00', null, 'so2');
INSERT INTO tbl_code_item
  (title, order_no, cg_cd, val_1, ci_explain, ci_link, reg_dt, mod_dt, sys_member_id)
VALUES
  ('시판이유식', '8', 'BF_RECORD_CATEGORY', '10', '', '', '2022-02-05 00:00:00', null, 'so2');
INSERT INTO tbl_code_item
  (title, order_no, cg_cd, val_1, ci_explain, ci_link, reg_dt, mod_dt, sys_member_id)
VALUES
  ('예방접종', '9', 'BF_RECORD_CATEGORY', '7', '', '', '2022-02-05 00:00:00', null, 'so2');
INSERT INTO tbl_code_item
  (title, order_no, cg_cd, val_1, ci_explain, ci_link, reg_dt, mod_dt, sys_member_id)
VALUES
  ('유축', '10', 'BF_RECORD_CATEGORY', '14', '', '', '2022-02-05 00:00:00', null, 'so2');
INSERT INTO tbl_code_item
  (title, order_no, cg_cd, val_1, ci_explain, ci_link, reg_dt, mod_dt, sys_member_id)
VALUES
  ('젖병', '11', 'BF_RECORD_CATEGORY', '2', '', '', '2022-02-05 00:00:00', null, 'so2');
INSERT INTO tbl_code_item
  (title, order_no, cg_cd, val_1, ci_explain, ci_link, reg_dt, mod_dt, sys_member_id)
VALUES
  ('체온', '12', 'BF_RECORD_CATEGORY', '15', '', '', '2022-02-05 00:00:00', null, 'so2');
INSERT INTO tbl_code_item
  (title, order_no, cg_cd, val_1, ci_explain, ci_link, reg_dt, mod_dt, sys_member_id)
VALUES
  ('홈메이드 이유식', '13', 'BF_RECORD_CATEGORY', '9', '', '', '2022-02-05 00:00:00', null, 'so2');



-- tbl_code_item_str 테이블 --------------------------------------------------------------------------
delete from tbl_code_item_str where cg_cd = 'BF_NU_TP';
INSERT INTO tbl_code_item_str
  (cd_no, title, order_no, val_1, ci_explain, ci_link, reg_dt, mod_dt, sys_member_id, cg_cd)
VALUES
  ('BF_NU_TP_1', '모유', '1', '1', '', '', '2021-03-26 07:17:04', null, 'renamaestro', 'BF_NU_TP');

INSERT INTO tbl_code_item_str
  (cd_no, title, order_no, val_1, ci_explain, ci_link, reg_dt, mod_dt, sys_member_id, cg_cd)
VALUES
  ('BF_NU_TP_3', '간식', '2', '3', '', '', '2021-03-26 07:17:24', null, 'renamaestro', 'BF_NU_TP');

INSERT INTO tbl_code_item_str
  (cd_no, title, order_no, val_1, ci_explain, ci_link, reg_dt, mod_dt, sys_member_id, cg_cd)
VALUES
  ('BF_NU_TP_6', '대소변', '3', '6', '', '', '2021-04-08 18:27:59', null, 'renamaestro', 'BF_NU_TP');

INSERT INTO tbl_code_item_str
  (cd_no, title, order_no, val_1, ci_explain, ci_link, reg_dt, mod_dt, sys_member_id, cg_cd)
VALUES
  ('BF_NU_TP_11', '병원', '4', '11', '', '', '2021-01-28 00:00:00', null, 'so2', 'BF_NU_TP');

INSERT INTO tbl_code_item_str
  (cd_no, title, order_no, val_1, ci_explain, ci_link, reg_dt, mod_dt, sys_member_id, cg_cd)
VALUES
  ('BF_NU_TP_12', '생활', '5', '12', '', '', '2021-01-28 00:00:00', null, 'so2', 'BF_NU_TP');

INSERT INTO tbl_code_item_str
  (cd_no, title, order_no, val_1, ci_explain, ci_link, reg_dt, mod_dt, sys_member_id, cg_cd)
VALUES
  ('BF_NU_TP_13', '발달과정성취', '6', '13', '', '', '2021-01-28 00:00:00', null, 'so2', 'BF_NU_TP');

INSERT INTO tbl_code_item_str
  (cd_no, title, order_no, val_1, ci_explain, ci_link, reg_dt, mod_dt, sys_member_id, cg_cd)
VALUES
  ('BF_NU_TP_5', '수면', '7', '5', '', '', '2021-03-26 07:17:40', null, 'renamaestro', 'BF_NU_TP');

INSERT INTO tbl_code_item_str
  (cd_no, title, order_no, val_1, ci_explain, ci_link, reg_dt, mod_dt, sys_member_id, cg_cd)
VALUES
  ('BF_NU_TP_10', '시판이유식', '8', '10', '', '', '2021-04-08 18:29:15', null, 'renamaestro', 'BF_NU_TP');

INSERT INTO tbl_code_item_str
  (cd_no, title, order_no, val_1, ci_explain, ci_link, reg_dt, mod_dt, sys_member_id, cg_cd)
VALUES
  ('BF_NU_TP_7', '예방접종', '9', '7', '', '', '2021-04-08 18:28:17', null, 'renamaestro', 'BF_NU_TP');

INSERT INTO tbl_code_item_str
  (cd_no, title, order_no, val_1, ci_explain, ci_link, reg_dt, mod_dt, sys_member_id, cg_cd)
VALUES
  ('BF_NU_TP_14', '유축', '10', '14', '', '', '2021-01-28 00:00:00', null, 'so2', 'BF_NU_TP');

INSERT INTO tbl_code_item_str
  (cd_no, title, order_no, val_1, ci_explain, ci_link, reg_dt, mod_dt, sys_member_id, cg_cd)
VALUES
  ('BF_NU_TP_2', '젖병', '11', '2', '', '', '2021-03-26 07:17:12', null, 'renamaestro', 'BF_NU_TP');

INSERT INTO tbl_code_item_str
  (cd_no, title, order_no, val_1, ci_explain, ci_link, reg_dt, mod_dt, sys_member_id, cg_cd)
VALUES
  ('BF_NU_TP_15', '체온', '12', '15', '', '', '2021-01-28 00:00:00', null, 'so2', 'BF_NU_TP');

INSERT INTO tbl_code_item_str
  (cd_no, title, order_no, val_1, ci_explain, ci_link, reg_dt, mod_dt, sys_member_id, cg_cd)
VALUES
  ('BF_NU_TP_9', '홈메이드이유식', '13', '9', '', '', '2021-04-08 18:28:56', null, 'renamaestro', 'BF_NU_TP');




-- tbl_code_item_str 부모질병관련 코드 수정
delete from tbl_code_item_str where cg_cd = 'BF_BABY_DISEASE';

INSERT INTO tbl_code_item_str
  (cd_no, title, order_no, val_1, ci_explain, ci_link, reg_dt, mod_dt, sys_member_id, cg_cd)
VALUES
  ('BF_B_D_1', '아토피', '1', '', '', '', '2021-01-31 06:09:43', null, 'renamaestro', 'BF_BABY_DISEASE');

INSERT INTO tbl_code_item_str
  (cd_no, title, order_no, val_1, ci_explain, ci_link, reg_dt, mod_dt, sys_member_id, cg_cd)
VALUES
  ('BF_B_D_2', '음식알레르기', '2', '', '', '', '2021-01-31 06:09:43', null, 'renamaestro', 'BF_BABY_DISEASE');

INSERT INTO tbl_code_item_str
  (cd_no, title, order_no, val_1, ci_explain, ci_link, reg_dt, mod_dt, sys_member_id, cg_cd)
VALUES
  ('BF_B_D_3', '비염', '5', '', '', '', '2021-01-31 06:09:43', null, 'renamaestro', 'BF_BABY_DISEASE');

INSERT INTO tbl_code_item_str
  (cd_no, title, order_no, val_1, ci_explain, ci_link, reg_dt, mod_dt, sys_member_id, cg_cd)
VALUES
  ('BF_B_D_4', '천식', '6', '', '', '', '2021-01-31 06:09:43', null, 'renamaestro', 'BF_BABY_DISEASE');

INSERT INTO tbl_code_item_str
  (cd_no, title, order_no, val_1, ci_explain, ci_link, reg_dt, mod_dt, sys_member_id, cg_cd)
VALUES
  ('BF_B_D_5', '햇빛알레르기', '3', '', '', '', '2022-02-06 00:00:00', null, 'so2', 'BF_BABY_DISEASE');

INSERT INTO tbl_code_item_str
  (cd_no, title, order_no, val_1, ci_explain, ci_link, reg_dt, mod_dt, sys_member_id, cg_cd)
VALUES
  ('BF_B_D_6', '금속알레르기', '4', '', '', '', '2022-02-06 00:00:00', null, 'so2', 'BF_BABY_DISEASE');