banjjak

Tables (24)

tb_diary_beauty_bath

  • idx — INT(10) — Primary key — NOT NULL
  • mgr_idx — INT(10) — NOT NULL
  • bath_1 — INT(10) — NOT NULL — 잘해요
  • bath_2 — INT(10) — NOT NULL — 조금 싫어해요
  • bath_3 — INT(10) — NOT NULL — 거부감이 있어요
  • bath_etc — INT(10) — NOT NULL — 기타
  • bath_etc_memo — VARCHAR(4000) — 기타 메모' COLLATE 'utf8_general_ci
  • reg_datetime — TIMESTAMP — NOT NULL
  • INDEX — `FK__tb_diary_mgr_tb_diary_beauty_bath`

tb_diary_beauty_condition

  • idx — INT(10) — Primary key — NOT NULL
  • mgr_idx — INT(10) — NOT NULL
  • condition_1 — INT(10) — NOT NULL — 좋아요
  • condition_2 — INT(10) — NOT NULL — 긴장했어요
  • condition_3 — INT(10) — NOT NULL — 피곤해 해요
  • condition_etc — INT(10) — NOT NULL — 기타
  • condition_etc_memo — VARCHAR(4000) — 기타 메모' COLLATE 'utf8_general_ci
  • reg_datetime — TIMESTAMP — NOT NULL
  • INDEX — `FK__tb_diary_mgr`

tb_diary_beauty_etiquette

  • idx — INT(10) — Primary key — NOT NULL
  • mgr_idx — INT(10) — NOT NULL
  • etiquette_1 — INT(10) — NOT NULL — 아주 잘했어요
  • etiquette_2 — INT(10) — NOT NULL — 좋아요
  • etiquette_3 — INT(10) — NOT NULL — 힘들어해요
  • etiquette_etc — INT(10) — NOT NULL — 기타
  • etiquette_etc_memo — VARCHAR(4000) — 기타 메모' COLLATE 'utf8_general_ci
  • reg_datetime — TIMESTAMP — NOT NULL
  • INDEX — `FK_tb_diary_beauty_etiquette_tb_diary_mgr`

tb_diary_beauty_notice

  • idx — INT(10) — Primary key — NOT NULL
  • mgr_idx — INT(10) — NOT NULL
  • notice_1 — INT(10) — NOT NULL — 피부 자극으로 긁거나 핥을 수 있으니 주의해주세요.
  • notice_2 — INT(10) — NOT NULL — 스트레스로 인하여 식욕 부진, 구토 및 설사 증상을 보일 수 있습니다.
  • notice_3 — INT(10) — NOT NULL — 항문을 끌고 다니거나 꼬리를 감추는 증상을 보일 수 있습니다
  • notice_4 — INT(10) — NOT NULL — 이중모(포메, 스피츠 등)의 경우 미용 후 알로페시아(클리퍼 증후군) 현상이 나타날 수 있습니다.
  • notice_etc — INT(10) — NOT NULL — 기타
  • notice_etc_memo — VARCHAR(4000) — 기타 메모' COLLATE 'utf8_general_ci
  • reg_datetime — TIMESTAMP — NOT NULL
  • INDEX — `FK__tb_diary_mgr_tb_diary_beauty_notice`

tb_diary_beauty_part

  • idx — INT(10) — Primary key — NOT NULL
  • mgr_idx — INT(10) — NOT NULL
  • part_1 — INT(10) — NOT NULL — 얼굴
  • part_2 — INT(10) — NOT NULL — 귀
  • part_3 — INT(10) — NOT NULL — 앞발
  • part_4 — INT(10) — NOT NULL — 뒷발
  • part_5 — INT(10) — NOT NULL — 발톱
  • part_6 — INT(10) — NOT NULL — 꼬리
  • part_etc — INT(10) — NOT NULL — 기타
  • part_etc_memo — VARCHAR(4000) — 기타메모' COLLATE 'utf8_general_ci
  • reg_datetime — TIMESTAMP — NOT NULL
  • INDEX — `FK__tb_diary_mgr_tb_diary_beauty_part`

tb_diary_beauty_photo

  • idx — INT(10) — Primary key — NOT NULL
  • mgr_idx — INT(10) — NOT NULL
  • file_path — VARCHAR(4000) — 사진경로|사진경로' COLLATE 'utf8_general_ci
  • reg_datetime — TIMESTAMP — NOT NULL
  • INDEX — `FK__tb_diary_mgr_tb_diary_beauty_photo`

tb_diary_beauty_skin

  • idx — INT(10) — Primary key — NOT NULL
  • mgr_idx — INT(10) — NOT NULL
  • skin_1 — INT(10) — NOT NULL — 깨끗해요
  • skin_2 — INT(10) — NOT NULL — 피부염
  • skin_3 — INT(10) — NOT NULL — 각질
  • skin_4 — INT(10) — NOT NULL — 붉은기
  • skin_5 — INT(10) — NOT NULL — 습진
  • skin_6 — INT(10) — NOT NULL — 농피증
  • skin_7 — INT(10) — NOT NULL — 알로페시아
  • skin_etc — INT(10) — NOT NULL — 기타
  • skin_etc_memo — VARCHAR(4000) — 기타 메모' COLLATE 'utf8_general_ci
  • reg_datetime — TIMESTAMP — NOT NULL
  • INDEX — `FK__tb_diary_mgr_tb_diary_beauty_skin`

tb_diary_beauty_tangles

  • idx — INT(10) — Primary key — NOT NULL
  • mgr_idx — INT(10) — NOT NULL
  • tangles_1 — INT(10) — NOT NULL — 없어요
  • tangles_2 — INT(10) — NOT NULL — 얼굴
  • tangles_3 — INT(10) — NOT NULL — 귀
  • tangles_4 — INT(10) — NOT NULL — 겨드랑이
  • tangles_5 — INT(10) — NOT NULL — 다리
  • tangles_6 — INT(10) — NOT NULL — 꼬리
  • tangles_7 — INT(10) — NOT NULL — 전체적으로 엉킴
  • tangles_etc — INT(10) — NOT NULL — 기타
  • tangles_etc_memo — VARCHAR(4000) — 기타메모' COLLATE 'utf8_general_ci
  • reg_datetime — TIMESTAMP — NOT NULL
  • INDEX — `FK_tb_diary_beauty_tangles_tb_diary_mgr`

tb_diary_hotel_breakfast

  • idx — INT(10) — Primary key — NOT NULL
  • mgr_idx — INT(10) — NOT NULL
  • breakfast_1 — INT(10) — NOT NULL — 다 먹었어요
  • breakfast_2 — INT(10) — NOT NULL — 남겼어요
  • breakfast_3 — INT(10) — NOT NULL — 안 먹었어요
  • breakfast_etc — INT(10) — NOT NULL — 기타
  • breakfast_etc_memo — VARCHAR(4000) — 기타 메모' COLLATE 'utf8_general_ci
  • reg_datetime — TIMESTAMP — NOT NULL
  • INDEX — `FK__tb_diary_mgr_tb_diary_hotel_breakfast`

tb_diary_hotel_condition

  • idx — INT(10) — Primary key — NOT NULL
  • mgr_idx — INT(10) — NOT NULL
  • condition_1 — INT(10) — NOT NULL — 잘 놀고 있어요
  • condition_2 — INT(10) — NOT NULL — 친구들과 잘 어울려요
  • condition_3 — INT(10) — NOT NULL — 아직 적응 중이에요
  • condition_4 — INT(10) — 낯설어해요
  • condition_5 — INT(10) — 혼자 쉬는 걸 좋아해요
  • condition_etc — INT(10) — NOT NULL — 기타
  • condition_etc_memo — VARCHAR(4000) — 기타 메모' COLLATE 'utf8_general_ci
  • reg_datetime — TIMESTAMP — NOT NULL
  • INDEX — `FK__tb_diary_hotel_mgr`

tb_diary_hotel_defecation

  • idx — INT(10) — Primary key — NOT NULL
  • mgr_idx — INT(10) — NOT NULL
  • defecation_1 — INT(10) — NOT NULL — 좋음
  • defecation_2 — INT(10) — NOT NULL — 보통
  • defecation_3 — INT(10) — NOT NULL — 나쁨
  • defecation_4 — INT(10) — NOT NULL — 마킹
  • defecation_etc — INT(10) — NOT NULL — 기타
  • defecation_etc_memo — VARCHAR(4000) — 기타 메모' COLLATE 'utf8_general_ci
  • reg_datetime — TIMESTAMP — NOT NULL
  • INDEX — `FK__tb_diary_mgr_tb_diary_hotel_defecation`

tb_diary_hotel_dinner

  • idx — INT(10) — Primary key — NOT NULL
  • mgr_idx — INT(10) — NOT NULL
  • dinner_1 — INT(10) — NOT NULL — 다 먹었어요
  • dinner_2 — INT(10) — NOT NULL — 남겼어요
  • dinner_3 — INT(10) — NOT NULL — 안 먹었어요
  • dinner_etc — INT(10) — NOT NULL — 기타
  • dinner_etc_memo — VARCHAR(4000) — 기타 메모' COLLATE 'utf8_general_ci
  • reg_datetime — TIMESTAMP — NOT NULL
  • INDEX — `FK__tb_diary_mgr_tb_diary_hotel_dinner`

tb_diary_hotel_lunch

  • idx — INT(10) — Primary key — NOT NULL
  • mgr_idx — INT(10) — NOT NULL
  • lunch_1 — INT(10) — NOT NULL — 다 먹었어요
  • lunch_2 — INT(10) — NOT NULL — 남겼어요
  • lunch_3 — INT(10) — NOT NULL — 안 먹었어요
  • lunch_etc — INT(10) — NOT NULL — 기타
  • lunch_etc_memo — VARCHAR(4000) — 기타 메모' COLLATE 'utf8_general_ci
  • reg_datetime — TIMESTAMP — NOT NULL
  • INDEX — `FK__tb_diary_mgr_tb_diary_hotel_lunch`

tb_diary_hotel_notice

  • idx — INT(10) — Primary key — NOT NULL
  • mgr_idx — INT(10) — NOT NULL
  • notice_1 — INT(10) — NOT NULL — 친구들과도 잘 놀고 잘 지냈어요!
  • notice_2 — INT(10) — NOT NULL — 보호자와 떨어져 지내며 스트레스 받았을 수 있으니 푹 쉴 수 있도록 해주세요!
  • notice_etc — INT(10) — NOT NULL — 기타
  • notice_etc_memo — VARCHAR(4000) — 기타 메모' COLLATE 'utf8_general_ci
  • reg_datetime — TIMESTAMP — NOT NULL
  • INDEX — `FK__tb_diary_mgr_tb_diary_hotel_notice`

tb_diary_hotel_sleep

  • idx — INT(10) — Primary key — NOT NULL
  • mgr_idx — INT(10) — NOT NULL
  • sleep_1 — INT(10) — NOT NULL — 편안하게 잘 자요
  • sleep_2 — INT(10) — NOT NULL — 잘 자요
  • sleep_3 — INT(10) — NOT NULL — 낯선지 조금 뒤척여요
  • sleep_etc — INT(10) — NOT NULL — 기타
  • sleep_etc_memo — VARCHAR(4000) — 기타 메모' COLLATE 'utf8_general_ci
  • reg_datetime — TIMESTAMP — NOT NULL
  • INDEX — `FK__tb_diary_mgr_tb_diary_hotel_sleep`

tb_diary_hotel_snack

  • idx — INT(10) — Primary key — NOT NULL
  • mgr_idx — INT(10) — NOT NULL
  • snack_1 — INT(10) — NOT NULL — 챙겨주신 간식
  • snack_2 — INT(10) — NOT NULL — 호텔 간식
  • snack_3 — INT(10) — NOT NULL — 안 먹었어요
  • snack_etc — INT(10) — NOT NULL — 기타
  • snack_etc_memo — VARCHAR(4000) — 기타 메모' COLLATE 'utf8_general_ci
  • reg_datetime — TIMESTAMP — NOT NULL
  • INDEX — `FK__tb_diary_mgr_tb_diary_hotel_snack`

tb_diary_mgr

  • idx — INT(10) — Primary key — NOT NULL
  • payment_log_seq — VARCHAR(100) — NOT NULL
  • shop_id — VARCHAR(256) — NOT NULL
  • pet_seq — INT(10) — NOT NULL
  • cellphone — VARCHAR(16) — NOT NULL
  • type — INT(10) — NOT NULL — 0: 미용, 1: 호텔, 2:유치원
  • update_time — TIMESTAMP — NOT NULL
  • INDEX — `idx_main_display`
  • INDEX — `idxPaymentlogseq`

tb_diary_playroom_activity

  • idx — INT(10) — Primary key — NOT NULL
  • mgr_idx — INT(10) — NOT NULL
  • activity_1 — INT(10) — NOT NULL — 친구들이랑 잘 놀아요
  • activity_2 — INT(10) — NOT NULL — 선생님을 좋아해요
  • activity_3 — INT(10) — NOT NULL — 아직 적응 중이에요
  • activity_4 — INT(10) — NOT NULL — 조금 낯설어해요
  • activity_5 — INT(10) — NOT NULL — 주로 잠을 많이 자요
  • activity_etc — INT(10) — NOT NULL — 기타
  • activity_etc_memo — VARCHAR(4000) — 기타 메모' COLLATE 'utf8_general_ci
  • reg_datetime — TIMESTAMP — NOT NULL
  • INDEX — `FK__tb_diary_mgr_tb_diary_kinder_activity`

tb_diary_playroom_defecation

  • idx — INT(10) — Primary key — NOT NULL
  • mgr_idx — INT(10) — NOT NULL
  • defecation_1 — INT(10) — NOT NULL — 좋음
  • defecation_2 — INT(10) — NOT NULL — 보통
  • defecation_3 — INT(10) — NOT NULL — 나쁨
  • defecation_4 — INT(10) — NOT NULL — 마킹
  • defecation_etc — INT(10) — NOT NULL — 기타
  • defecation_etc_memo — VARCHAR(4000) — 기타 메모' COLLATE 'utf8_general_ci
  • reg_datetime — TIMESTAMP — NOT NULL
  • INDEX — `FK__tb_diary_mgr_tb_diary_kinder_defecation`

tb_diary_playroom_meal

  • idx — INT(10) — Primary key — NOT NULL
  • mgr_idx — INT(10) — NOT NULL
  • meal_1 — INT(10) — NOT NULL — 아침
  • meal_2 — INT(10) — NOT NULL — 점심
  • meal_3 — INT(10) — NOT NULL — 저녁
  • meal_etc — INT(10) — NOT NULL — 기타
  • meal_etc_memo — VARCHAR(4000) — 기타메모' COLLATE 'utf8_general_ci
  • reg_datetime — TIMESTAMP — NOT NULL
  • INDEX — `FK__tb_diary_mgr_tb_diary_kinder_meal`

tb_diary_playroom_notice

  • idx — INT(10) — Primary key — NOT NULL
  • mgr_idx — INT(10) — NOT NULL
  • notice_1 — INT(10) — NOT NULL — 오늘 활동에 잘 참여해주었어요. 마구 칭찬해주세요!
  • notice_2 — INT(10) — NOT NULL — 마음 맞는 친구들이 많아 신나게 놀았어요!
  • notice_3 — INT(10) — NOT NULL — 다음 등원 시 매너벨트 넉넉하게 챙겨주세요!
  • notice_etc — INT(10) — NOT NULL — 기타
  • notice_etc_memo — VARCHAR(4000) — 기타 메모' COLLATE 'utf8_general_ci
  • reg_datetime — TIMESTAMP — NOT NULL
  • INDEX — `FK__tb_diary_mgr_tb_diary_kinder_notice`

tb_diary_playroom_participation

  • idx — INT(10) — Primary key — NOT NULL
  • mgr_idx — INT(10) — NOT NULL
  • participation_1 — INT(10) — NOT NULL — 적극적으로 참여해요
  • participation_2 — INT(10) — NOT NULL — 낯설어 하지만 관심을 보여요
  • participation_3 — INT(10) — NOT NULL — 아직은 어려워해요
  • participation_4 — INT(10) — NOT NULL — 친구들이랑 노는 걸 더 좋아해요
  • participation_5 — INT(10) — NOT NULL — 휴식을 더 좋아해요
  • participation_etc — INT(10) — NOT NULL — 기타
  • participation_etc_memo — VARCHAR(4000) — 기타 메모' COLLATE 'utf8_general_ci
  • reg_datetime — TIMESTAMP — NOT NULL
  • INDEX — `FK__tb_diary_mgr_tb_diary_kinder_participation`

tb_diary_playroom_snack

  • idx — INT(10) — Primary key — NOT NULL
  • mgr_idx — INT(10) — NOT NULL
  • snack_1 — INT(10) — NOT NULL — 챙겨주신 간식
  • snack_2 — INT(10) — NOT NULL — 유치원 간식
  • snack_3 — INT(10) — NOT NULL — 안 먹었어요
  • snack_etc — INT(10) — NOT NULL — 기타
  • snack_etc_memo — VARCHAR(4000) — 기타 메모' COLLATE 'utf8_general_ci
  • reg_datetime — TIMESTAMP — NOT NULL
  • INDEX — `FK__tb_diary_mgr_tb_diary_kinder_snack`

tb_diary_playroom_tracking

  • idx — INT(10) — Primary key — NOT NULL
  • mgr_idx — INT(10) — NOT NULL
  • tracking_1 — INT(10) — NOT NULL — O
  • tracking_2 — INT(10) — NOT NULL — X
  • INDEX — `FK__tb_diary_mgr_tb_diary_kinder_tracking`