seocho
Tables (30)
admin
- id — varchar(21) — NOT NULL
- username — varchar(32) — NOT NULL — 접속시
- password — bytea — NOT NULL
- name — varchar(32) — NOT NULL
- email — varchar(64) — NOT NULL
- phone — varchar(11) — NOT NULL
- updated_at — timestamp — 수정일
- created_at — timestamp — NOT NULL — 생성일
- deleted_at — timestamp — 삭제일
- available — boolean — NOT NULL — 사용
alembic_version
- version_num — varchar(32) — NOT NULL
auth_log
- id — serial
- admin_id — varchar(21) — NOT NULL — 어드민
- reason — varchar(64) — NOT NULL — 활성화/비활성화
- updated_at — timestamp — 수정일
- created_at — timestamp — NOT NULL — 생성일
- change — boolean — NOT NULL — 변경
care_119_apply
- id — varchar(21) — NOT NULL
- user_id — varchar(21) — 돌봄
- guard_name — varchar(16) — NOT NULL — 보호자
- guard_security_num — varchar(6) — NOT NULL — 보호자
- guard_phone — varchar(11) — NOT NULL — 보호자
- guard_etc_comment — varchar(256) — 보호자와의
- child_info — json — NOT NULL — (자녀
- reason — json — NOT NULL — 긴급신청
- wanted_daytime — json — NOT NULL — 희망요일,
- cctv_count — integer — NOT NULL — cctv
- animals — json — NOT NULL — 동물
- relate_info — json — NOT NULL — (응급처치
- apply_route — json — NOT NULL — 신청
- applier_name — varchar(16) — NOT NULL — 신청자
- service_status — varchar(7) — NOT NULL — (공통코드)
- updated_at — timestamp — 수정일
- created_at — timestamp — NOT NULL — 생성일
- applied_at — date — NOT NULL
- guard_relationship — varchar(1) — NOT NULL — 보호자와의
- required_files — json — NOT NULL — 필수
- optional_files — json — NOT NULL — 선택
- detail — text — NOT NULL — 비고
- apply_type — varchar(17) — NOT NULL — 해당
- address_region — varchar(8) — NOT NULL — 주소(동)
- address_main — varchar(128) — NOT NULL — 주소
- address_detail — varchar(128) — NOT NULL — 상세
- target_child_count — integer — NOT NULL — 대상자
- service_start_at — date
care_119_monthly_info
- idx — varchar(21) — NOT NULL
- apply_id — varchar(21) — NOT NULL
- left_count — integer — NOT NULL — 잔여
- cancel_count — integer — NOT NULL — 취소
- day_cancel_count — integer — NOT NULL — 당일
- estimated_price — integer — NOT NULL — 자부담금(예상액)
- price_traffic — integer — NOT NULL — (예상액)산출내역
- price_extra_usage — integer — NOT NULL — (예상액)산출내역
- price_weekend_night — integer — NOT NULL — (예상액)산출내역
- price_bro_care — integer — NOT NULL — (예상액)산출내역
- updated_at — timestamp — 수정일
- created_at — timestamp — NOT NULL — 생성일
- month — integer — NOT NULL — 월
- year — integer — NOT NULL — 년
care_119_schedule
- idx — serial
- apply_id — varchar(21) — NOT NULL
- before_check — boolean — NOT NULL — 일정
- final_check — boolean — NOT NULL — 시행
- view_check — boolean — NOT NULL — 변동
- updated_at — timestamp — 수정일
- created_at — timestamp — NOT NULL — 생성일
- helper_id — varchar(21) — 헬퍼
- date — date — NOT NULL — 날짜
- time_range — json — NOT NULL — 일정
- helper_check — boolean — NOT NULL — 돌보미
- cancel_check — boolean — NOT NULL — 취소
- visible — boolean — NOT NULL — 노출
- deleted_at — timestamp — 삭제일
- day_cancel_check — boolean — NOT NULL — 당일
- center_work_hour — double — NOT NULL — 센터
- user_work_hour — double — NOT NULL — 가정
- target_child_count — integer — NOT NULL — 돌봄
- day — varchar(16) — 요일
complaint
- idx — serial
- content — text — NOT NULL — 민원
- updated_at — timestamp — 수정일
- created_at — timestamp — NOT NULL — 생성일
- route — varchar(7) — NOT NULL — 방법,
- care_type — varchar(6) — NOT NULL — 돌봄
- complaint_target_type — varchar(6) — NOT NULL — 민원
- deleted_at — timestamp — 삭제일
- complaint_target_etc — varchar(64) — NOT NULL — 민원
- route_etc — varchar(64) — NOT NULL — 경로
- date — timestamp — NOT NULL — 민원
- name — varchar(8) — NOT NULL — 민원인
- phone — varchar(11) — NOT NULL — 민원인
- manager — varchar(32) — NOT NULL — 민원인
- comment — text — NOT NULL — ext default '::text not nul
- writer_id — varchar(21) — NOT NULL — 담당자
contract_intro
- idx — serial
- type — varchar(5) — NOT NULL
- title — varchar(64) — NOT NULL
- pdf — json — NOT NULL
- writer_id — varchar(21) — NOT NULL
- updated_at — timestamp — 수정일
- created_at — timestamp — NOT NULL — 생성일
- deleted_at — timestamp — 삭제일
db_log
- id — serial
- admin_id — varchar(21) — NOT NULL — 어드민
- content — varchar(64) — NOT NULL — 조회
- updated_at — timestamp — 수정일
- created_at — timestamp — NOT NULL — 생성일
download_log
- id — serial
- admin_id — varchar(21) — NOT NULL — 어드민
- content — varchar(64) — NOT NULL — 다운로드
- updated_at — timestamp — 수정일
- created_at — timestamp — NOT NULL — 생성일
education_apply
- user_id — varchar(21) — NOT NULL — 신청자
- id — varchar(21) — NOT NULL
- guard_name — varchar(16) — NOT NULL — 조부모
- guard_security_num — varchar(6) — NOT NULL — 조부모
- guard_phone — varchar(11) — NOT NULL — 조부모
- account_bank — varchar(16) — NOT NULL — 은행
- account_num — varchar(32) — NOT NULL — 계좌
- account_self — boolean — NOT NULL
- service_at — date — NOT NULL — 서비스
- name — varchar(16) — NOT NULL — 이용자
- phone — varchar(11) — NOT NULL — 이용자
- child_name — varchar(16) — NOT NULL — 아동
- child_birth — date — NOT NULL
- child_count — integer — NOT NULL
- live_seocho_year — boolean — NOT NULL — 부모가정
- live_seocho — boolean — NOT NULL — 본인(조부모)
- service_used_history — json — NOT NULL
- apply_route — json — NOT NULL
- applied_at — date — NOT NULL
- applier_name — varchar(16) — NOT NULL
- updated_at — timestamp — 수정일
- created_at — timestamp — NOT NULL — 생성일
- guard_relationship — varchar(1) — NOT NULL — 조부모와의
- required_files — json — NOT NULL — 필수
- optional_files — json — 선택
- confirmed_at — date — 교육
- status — varchar(7) — NOT NULL — 교육
- generation — varchar(8) — NOT NULL — 교육
- subjects — json — NOT NULL — 선택
- address_region — varchar(8) — NOT NULL — 주소(동)
- address_main — varchar(128) — NOT NULL — 주소
- address_detail — varchar(128) — NOT NULL — 상세
- memo — text — NOT NULL — 비고
global_config
- idx — serial
- care_119_check — boolean — NOT NULL
- monitor_salary — integer — NOT NULL
- seocho_check — boolean — NOT NULL
- grand_salary — integer — NOT NULL
- updated_at — timestamp — 수정일
- created_at — timestamp — NOT NULL — 생성일
- subjects — json — NOT NULL
- grand_check — boolean — NOT NULL
grand_care_apply
- id — varchar(21) — NOT NULL
- applier_name — varchar(16) — NOT NULL — 신청자
- guard_name — varchar(16) — NOT NULL — 이용자
- guard_security_num — varchar(6) — NOT NULL — 이용자
- guard_phone — varchar(11) — NOT NULL — 이용자
- child_info — json — NOT NULL — (자녀
- service_start_at — date — NOT NULL — 서비스
- service_end_at — date — NOT NULL — 서비스
- service_extend_end_at — date — (서비스
- updated_at — timestamp — 수정일
- created_at — timestamp — NOT NULL — 생성일
- user_id — varchar(21) — 돌봄
- apply_type — varchar(17) — NOT NULL — 해당
- grand_name — varchar(16) — NOT NULL — 조부모
- grand_birth — date — NOT NULL — 조부모
- grand_phone — varchar(11) — NOT NULL — 조부모
- applied_at — date — NOT NULL
- guard_relationship — varchar(1) — NOT NULL — 관계
- required_files — json — NOT NULL — 필수
- optional_files — json — NOT NULL — 선택
- service_status — varchar(7) — NOT NULL — (공통코드)
- extend_show — boolean — 연장
- detail — text — NOT NULL — 비고
- generation — varchar(8) — NOT NULL — 돌보미
- address_region — varchar(8) — NOT NULL — 주소(동)
- address_main — varchar(128) — NOT NULL — 주소
- address_detail — varchar(128) — NOT NULL — 상세
- target_child_count — integer — NOT NULL — 대상자
- grand_relationship — varchar(1) — NOT NULL — 조부모
- monthly_max_schedule_hours — integer — NOT NULL — 월
- set_service_extend_end_at — date
grand_care_extend_apply
- id — varchar(21) — NOT NULL
- guard_name — varchar(8) — NOT NULL — 보호자
- guard_security_num — varchar(6) — NOT NULL — 보호자
- guard_phone — varchar(11) — NOT NULL — 보호자
- guard_relationship — varchar(1) — NOT NULL — 관계
- parent_info — json — NOT NULL
- grand_name — varchar(8) — NOT NULL — 조부모
- grand_phone — varchar(11) — NOT NULL — 조부모
- child_info — json — NOT NULL
- comment — text — NOT NULL — ext default '::text not nul
- required_files — json — NOT NULL — 필수
- optional_files — json — 선택
- applier_name — varchar(8) — NOT NULL — 연장
- applied_at — date — NOT NULL
- updated_at — timestamp — 수정일
- created_at — timestamp — NOT NULL — 생성일
- apply_id — varchar(21) — NOT NULL
- address_region — varchar(8) — NOT NULL — 주소(동)
- address_main — varchar(128) — NOT NULL — 주소
- address_detail — varchar(128) — NOT NULL — 상세
- target_child_count — integer — NOT NULL — 대상자
grand_care_schedule
- idx — serial
- apply_id — varchar(21) — NOT NULL
- before_check — boolean — NOT NULL — 일정
- final_check — boolean — NOT NULL — 시행
- paid_check — boolean — NOT NULL — 납부
- view_check — boolean — NOT NULL — 변동
- updated_at — timestamp — 수정일
- created_at — timestamp — NOT NULL — 생성일
- date — date — NOT NULL — 날짜
- time_range — json — NOT NULL — 일정
- work_hour — double — NOT NULL — 근무
- salary — integer — NOT NULL — 급여
- deleted_at — timestamp — 삭제일
- day_cancel_check — boolean — NOT NULL — 당일
- target_child_count — integer — NOT NULL — 돌봄
helper
- id — varchar(21) — NOT NULL
- username — varchar(32) — NOT NULL
- password — bytea — NOT NULL
- name — varchar(32) — NOT NULL
- email — varchar(64) — NOT NULL
- phone — varchar(11) — NOT NULL
- verified — boolean — NOT NULL — 관리자가
- updated_at — timestamp — 수정일
- created_at — timestamp — NOT NULL — 생성일
- deleted_at — timestamp — 삭제일
- security_num — varchar(13) — NOT NULL — 주민등록번호
- generation — varchar(8) — NOT NULL — 돌보미
- address — varchar(128) — NOT NULL — 주소(동까지만)
- start_at — date — 입사일
- end_at — date — 퇴사
- end_reason — varchar(256) — NOT NULL — 퇴사
- admin_id — varchar(21) — 담당자
- career — text — NOT NULL — 경력
- qualification — text — NOT NULL — 자격
- account_bank — varchar(16) — NOT NULL — 급여
- account_num — varchar(32) — NOT NULL — 급여
- detail — text — NOT NULL — 비고
- helper_type — varchar(13) — NOT NULL
- want_house_count — integer — NOT NULL — 희망
- brother_check — boolean — NOT NULL — 형제
- status — varchar(8) — NOT NULL — 활동
- inactive_reason — text — NOT NULL — 휴직
- emergency_contact_info — json — 비상
- address_region — varchar(8) — NOT NULL — 주소(동)
- full_security_num — bytea — NOT NULL — 주민등록번호
- signin_at — timestamp
- expired_type — varchar(1) — NOT NULL — 만료
helper_check_notice
- idx — serial
- visible — boolean — NOT NULL — 공지사항
- title — varchar(32) — NOT NULL — 제목
- content — text — NOT NULL
- writer_id — varchar(21) — NOT NULL — 작성자
- updated_at — timestamp — 수정일
- created_at — timestamp — NOT NULL — 생성일
- deleted_at — timestamp — 삭제일
helper_check_notice_log
- idx — serial
- files — json — NOT NULL — 제출한
- confirmed — boolean — NOT NULL — 관리자가
- helper_check_notice_idx — integer — NOT NULL — 돌보미
- helper_id — varchar(21) — NOT NULL — 작성자
- updated_at — timestamp — 수정일
- created_at — timestamp — NOT NULL — 생성일
- deleted_at — timestamp — 삭제일
helper_salary_monthly_info
- idx — varchar(21) — NOT NULL
- helper_id — varchar(21) — NOT NULL
- month — integer — NOT NULL — 월
- year — integer — NOT NULL — 년
- weekly_allowance — integer — NOT NULL — 주휴
- day_off_not_used — integer — NOT NULL — 연차
- center_retroactive — integer — NOT NULL — 센터
- user_retroactive — integer — NOT NULL — 가정
- deduction_pension — integer — NOT NULL — (공제)
- deduction_health_insurance — integer — NOT NULL — (공제)
- deduction_employment_insurance — integer — NOT NULL — (공제)
- deduction_long_care_insurance — integer — NOT NULL — (공제)
- deduction_income_tax — integer — NOT NULL — (공제)
- deduction_local_income_tax — integer — NOT NULL — (공제)
- updated_at — timestamp — 수정일
- created_at — timestamp — NOT NULL — 생성일
- pay_holiday — integer — NOT NULL — 유급
- retirement_saving — integer — NOT NULL — 퇴직
monitor
- id — varchar(21) — NOT NULL
- username — varchar(32) — NOT NULL — 접속시
- password — bytea — NOT NULL
- name — varchar(32) — NOT NULL
- email — varchar(64) — NOT NULL
- phone — varchar(11) — NOT NULL
- verified — boolean — NOT NULL — 관리자가
- updated_at — timestamp — 수정일
- created_at — timestamp — NOT NULL — 생성일
- deleted_at — timestamp — 삭제일
- signin_at — timestamp
- expired_type — varchar(1) — NOT NULL — 만료
monitor_target
- idx — serial
- monitor_type — varchar(6) — NOT NULL
- seocho_care_id — varchar(21)
- care_119_id — varchar(21)
- grand_care_id — varchar(21)
- monitor_check — boolean — 대상자
- updated_at — timestamp — 수정일
- created_at — timestamp — NOT NULL — 생성일
- deleted_at — timestamp — 삭제일
- admin_id — varchar(21) — NOT NULL — 담당자
- detail — text — NOT NULL — 비고/특이사항
- monitor_id — varchar(21) — 모니터링요원
- monitor_check_status — varchar(7) — NOT NULL — 모니터링
- monitor_check_datetime — timestamp — 모니터링
- monitor_check_detail — text — NOT NULL — 모니터링
- monitor_final_uncheck — boolean — NOT NULL — 최종
- salary — integer — NOT NULL — 급여
- monitor_delete_check — boolean — NOT NULL — 미확인
notice
- idx — serial
- type — varchar(11) — NOT NULL
- title — varchar(32) — NOT NULL
- content — text — NOT NULL
- writer_id — varchar(21) — NOT NULL
- updated_at — timestamp — 수정일
- created_at — timestamp — NOT NULL — 생성일
- deleted_at — timestamp — 삭제일
popup
- idx — serial
- type — varchar(5) — NOT NULL — 유형
- title — varchar(32) — NOT NULL — 제목
- link — varchar(128) — 클릭시
- left — varchar(8) — NOT NULL — 하단,
- top — varchar(8) — NOT NULL — 상단,
- width — integer — NOT NULL — 폭
- center — boolean — NOT NULL — 중심
- img — varchar — NOT NULL — 팝업
- writer_id — varchar(21) — NOT NULL — 작성자
- updated_at — timestamp — 수정일
- created_at — timestamp — NOT NULL — 생성일
- deleted_at — timestamp — 삭제일
salary_holiday
- idx — serial
- name — varchar(16) — NOT NULL — 휴일
- year — integer — NOT NULL — 년
- month — integer — NOT NULL — 월
- day — integer — NOT NULL — 일
- updated_at — timestamp — 수정일
- created_at — timestamp — NOT NULL — 생성일
seocho_care_apply
- id — varchar(21) — NOT NULL
- guard_name — varchar(16) — NOT NULL — 보호자
- guard_etc_comment — varchar(256) — 보호자와의
- guard_security_num — varchar(6) — NOT NULL — 보호자
- guard_phone — varchar(11) — NOT NULL — 보호자
- child_info — json — NOT NULL — 아동
- apply_type — varchar(17) — NOT NULL — 해당
- wanted_datetime — json — NOT NULL
- wanted_datetime_else — boolean — NOT NULL — (시간대)
- wanted_datetime_comment — varchar(256) — NOT NULL — (시간대)
- cctv_count — integer — NOT NULL
- animals — json — NOT NULL
- apply_route — json — NOT NULL — 신청
- applier_name — varchar(16) — NOT NULL — 신청자
- relate_info — json — NOT NULL — (응급처치
- service_status — varchar(14) — NOT NULL
- service_extend_end_at — date
- user_id — varchar(21) — 돌봄
- helper_id — varchar(21) — 헬퍼
- updated_at — timestamp — 수정일
- created_at — timestamp — NOT NULL — 생성일
- guard_relationship — varchar(1) — NOT NULL — 보호자와의
- applied_at — date — NOT NULL
- required_files — json — NOT NULL — 필수
- optional_files — json — NOT NULL — 선택
- family_type — varchar(21) — NOT NULL — 가족
- detail — text — 비고
- want_change — boolean — NOT NULL — 교체
- extend_show — boolean — 연장
- monitor_target — boolean — 모니터링
- complaint — text — 민원
- schedule_datetime — json — 확정
- address_region — varchar(8) — NOT NULL — 주소(동)
- address_main — varchar(128) — NOT NULL — 주소
- address_detail — varchar(128) — NOT NULL — 상세
- target_child_count — integer — NOT NULL — 대상자
- service_start_at — date
- service_end_at — date
- set_service_extend_end_at — date
- leftover_time_sum — double — NOT NULL — 잔여시간
seocho_care_extend_apply
- id — varchar(21) — NOT NULL
- apply_id — varchar(21) — NOT NULL
- guard_name — varchar(16) — NOT NULL
- guard_security_num — varchar(6) — NOT NULL
- parent_info — json — NOT NULL
- child_info — json — NOT NULL
- wanted_day_info — json — NOT NULL
- service_place — json — NOT NULL
- cctv_count — integer — NOT NULL
- animals — json — NOT NULL
- relate_info — json — NOT NULL
- applier_name — varchar(16) — NOT NULL — 신청자
- updated_at — timestamp — 수정일
- created_at — timestamp — NOT NULL — 생성일
- applied_at — date — NOT NULL
- guard_relationship — varchar(1) — NOT NULL — 보호자와의
- required_files — json — NOT NULL — 필수
- optional_files — json — NOT NULL — 선택
- address_region — varchar(8) — NOT NULL — 주소(동)
- address_main — varchar(128) — NOT NULL — 주소
- address_detail — varchar(128) — NOT NULL — 상세
- target_child_count — integer — NOT NULL — 대상자
- guard_phone — varchar(11) — NOT NULL
seocho_care_monthly_info
- idx — varchar(21) — NOT NULL
- apply_id — varchar(21) — NOT NULL
- leftover_time — double — NOT NULL — 잔여
- leftover_time_reason — varchar(256) — NOT NULL — 잔여
- estimated_price — integer — NOT NULL — 자부담금(예상액)
- price_traffic — integer — NOT NULL — (예상액)산출내역
- price_extra_usage — integer — NOT NULL — (예상액)산출내역
- price_weekend_night — integer — NOT NULL — (예상액)산출내역
- price_bro_care — integer — NOT NULL — (예상액)산출내역
- updated_at — timestamp — 수정일
- created_at — timestamp — NOT NULL — 생성일
- month — integer — NOT NULL — 월
- year — integer — NOT NULL — 년
- center_work_hour — double — NOT NULL — 센터
- user_work_hour — double — NOT NULL — 가정
- service_left_time — double — NOT NULL — 신청
- user_work_hour_pay_flag — boolean — NOT NULL — 자부담금
- leftover_set_at — date — 잔여시간
seocho_care_schedule
- idx — serial
- apply_id — varchar(21) — NOT NULL
- final_check — boolean — NOT NULL — 시행
- view_check — boolean — NOT NULL — 변동
- updated_at — timestamp — 수정일
- created_at — timestamp — NOT NULL — 생성일
- helper_id — varchar(21) — 헬퍼
- date — date — NOT NULL — 날짜
- time_range — json — NOT NULL — 일정
- helper_check — boolean — NOT NULL — 돌보미
- deleted_at — timestamp — 삭제일
- day_cancel_check — boolean — NOT NULL — 당일
- target_child_count — integer — NOT NULL — 돌봄
sms_auth
- idx — serial
- phone — varchar(11) — NOT NULL
- auth_code — varchar(6) — NOT NULL
- updated_at — timestamp — 수정일
- created_at — timestamp — NOT NULL — 생성일
user
- id — varchar(21) — NOT NULL
- username — varchar(32) — NOT NULL
- password — bytea — NOT NULL
- name — varchar(32) — NOT NULL
- email — varchar(32) — NOT NULL
- address — varchar(128) — NOT NULL
- updated_at — timestamp — 수정일
- created_at — timestamp — NOT NULL — 생성일
- deleted_at — timestamp — 삭제일
- phone — varchar(11) — NOT NULL
- address_region — varchar(8) — NOT NULL — 주소(동)
- signin_at — timestamp
- expired_type — varchar(1) — NOT NULL — 만료