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`