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 — 만료