1

Tables (44)

admin_apt_manage

  • id — bigint — NOT NULL — 순번
  • insert_date — timestamp — 등록일
  • insert_user_id — character — 등록자
  • update_date — timestamp — 수정일
  • update_user_id — character — 수정자
  • admin_id — character — 어드민
  • apt_code — character — 아파트

admin_permission

  • permission_type — character — NOT NULL — 권한
  • insert_date — timestamp — 등록일
  • insert_user_id — character — 등록자
  • update_date — timestamp — 수정일
  • update_user_id — character — 수정자
  • menu_permission — character — 메뉴
  • permission_name — character — 권한명

admin_user

  • admin_id — character — NOT NULL — 관리자
  • insert_date — timestamp — 등록일
  • insert_user_id — character — 등록자
  • update_date — timestamp — 수정일
  • update_user_id — character — 수정자
  • account_blocked — boolean — NOT NULL — 계정
  • company_name — character — 소속
  • company_phone — character — 회사
  • deleted — boolean — 삭제
  • dept_name — character — 소속
  • emp_no — character — 사원번호
  • index_apt_code — character — 대표아파트코드
  • last_access_date — timestamp — 마지막
  • password — character — NOT NULL — 비밀번호
  • password_mismatch_count — integer — NOT NULL — 패스워드
  • phone — character — 관리자
  • status — boolean — NOT NULL — 활성화
  • user_name — character — 관리자
  • permission_type — character — 관리자
  • need_update_password — boolean — NOT NULL — 패스워드

app_version

  • id — bigint — NOT NULL — 순번
  • insert_date — timestamp — 등록일
  • insert_user_id — character — 등록자
  • update_date — timestamp — 수정일
  • update_user_id — character — 수정자
  • os — character — 디바이스
  • status — boolean — 상태
  • version — character — 앱버전

apt_complex

  • apt_code — character — NOT NULL — 아파트
  • insert_date — timestamp — 등록일
  • insert_user_id — character — 등록자
  • update_date — timestamp — 수정일
  • update_user_id — character — 수정자
  • address — character — 주소
  • address_detail — character — 상세
  • apt_name — character — 아파트
  • contents — character — 메모
  • households_count — integer — 총
  • status — boolean — 단지상태
  • zip_code — character — 우편번호

apt_complex_exclude_date

  • id — bigint — NOT NULL — 아이디
  • insert_date — timestamp — 등록일
  • insert_user_id — character — 등록자
  • update_date — timestamp — 수정일
  • update_user_id — character — 수정자
  • exd_date — date — 제외할
  • status_code — boolean — NOT NULL — 활성화상태
  • ymd — character — 제외할
  • apt_code — character — 아파트
  • yy — integer — 년도
  • desc — character — 설명

apt_complex_timer

  • id — bigint — NOT NULL — 순번
  • insert_date — timestamp — 등록일
  • insert_user_id — character — 등록자
  • update_date — timestamp — 수정일
  • update_user_id — character — 수정자
  • disp — character — 시간형태
  • hour — integer — NOT NULL — 시간
  • min — integer — NOT NULL — 분
  • status — boolean — 가능여부
  • apt_code — character — 근무지

banner_info

  • id — bigint — NOT NULL — 배너
  • insert_date — timestamp — 등록일
  • insert_user_id — character — 등록자
  • update_date — timestamp — 수정일
  • update_user_id — character — 수정자
  • category — character — 배너
  • image_link — character — 이미지
  • status_code — boolean — 활성화
  • title — character — 배너
  • posting_end_date — timestamp — 게시
  • posting_sort — bigint — 노출순서
  • posting_start_date — timestamp — 게시
  • file_name — character — 파일명
  • file_url — character — 파일
  • thumbnail_file_url — character — 썸네일
  • contents — character — 내용
  • image_name — character — 이미지명
  • inner_link_url — character — 내부링크주소
  • outer_link_url — character — 외부링크주소
  • banner_id — character

batch_job_execution

  • job_execution_id — bigint — NOT NULL — Job
  • version — bigint — 변경
  • job_instance_id — bigint — NOT NULL — Job
  • create_time — timestamp — NOT NULL — 생성
  • start_time — timestamp — 시작
  • end_time — timestamp — 종료
  • status — character — 실행
  • exit_code — character — 종료
  • exit_message — character — Job
  • last_updated — timestamp — 최종
  • job_configuration_location — character — Job

batch_job_execution_context

  • job_execution_id — bigint — NOT NULL — Step
  • short_context — character — NOT NULL — String
  • serialized_context — text — serializied

batch_job_execution_params

  • job_execution_id — bigint — NOT NULL — Job
  • type_cd — character — NOT NULL — 저장된
  • key_name — character — NOT NULL — 키
  • string_val — character — string
  • date_val — timestamp — date
  • long_val — bigint — long
  • double_val — double — double
  • identifying — character(1) — NOT NULL — Job

batch_job_instance

  • job_instance_id — bigint — NOT NULL — Job
  • version — bigint — 변경
  • job_name — character — NOT NULL — Job
  • job_key — character — NOT NULL — Job

batch_step_execution

  • step_execution_id — bigint — NOT NULL — Step
  • version — bigint — NOT NULL — 변경
  • step_name — character — NOT NULL — Step
  • job_execution_id — bigint — NOT NULL — Job
  • start_time — timestamp — NOT NULL — 시작
  • end_time — timestamp — 종료
  • status — character — 실행
  • commit_count — bigint — 트랜잭션당
  • read_count — bigint — 조회한
  • filter_count — bigint — 필터링된
  • write_count — bigint — 저장된
  • read_skip_count — bigint — 조회
  • write_skip_count — bigint — 저장
  • process_skip_count — bigint — skip된
  • rollback_count — bigint — 롤백
  • exit_code — character — 종료
  • exit_message — character — Step
  • last_updated — timestamp — 최종

batch_step_execution_context

  • step_execution_id — bigint — NOT NULL — Job
  • short_context — character — NOT NULL — String
  • serialized_context — text — serializied

calendar

  • id — bigint — NOT NULL — 순번
  • day_of_week — character — 요일
  • dd — integer — Step
  • holiday — character — 휴일
  • holiday_desc — character — 휴일
  • mm — integer — 월
  • remark — character — 설명
  • week_of_year — character — 년간
  • ymd — character — 년월일
  • yy — integer — 년도

care_service_cancel

  • cancel_id — bigint — NOT NULL — 취소
  • cancel_date — timestamp — 취소
  • cancel_reason_code — character — 취소
  • cancel_reason_contents — character — 취소
  • cancel_user_id — character — 취소
  • cancel_user_type — character — 취소한
  • return_coupon_type — character — 이용권
  • reservation_id — bigint — 서비스

care_service_file

  • id — bigint — NOT NULL — 시퀀스
  • insert_date — timestamp — 등록일
  • insert_user_id — character — 등록자
  • update_date — timestamp — 수정일
  • update_user_id — character — 수정자
  • file_category — character — 파일
  • file_name — character — 파일명
  • file_url — character — 파일
  • thumbnail_file_url — character — 파일
  • reservation_id — bigint — 예약

care_service_reservation

  • reservation_id — bigint — NOT NULL — 예약
  • insert_date — timestamp — 등록일
  • insert_user_id — character — 등록자
  • update_date — timestamp — 수정일
  • update_user_id — character — 수정자
  • complete_date — timestamp — 작업자
  • confirm_date — timestamp — 운영자
  • confirm_user_id — character — 운영자
  • confirm_user_type — character — 운영자
  • job_date — timestamp — 사용자
  • part_status — boolean — 자재
  • request_date — timestamp — 사용자
  • request_time — character — 사용자
  • root_category — character — 대분류
  • service_id — character — 접수
  • status_code — character — 작업
  • sub_category — character — 하위분류
  • user_request_date — timestamp — 사용자
  • user_request_time — character — 사용자
  • work_contents — character — 사용자
  • work_date — timestamp — 작업자
  • worker_complete_contents — character — 작업자
  • apt_code — character — 작업
  • coupon_id — bigint — 적용된
  • pre_worker_seq — bigint — 작업예정자
  • user_id — character — 작업
  • worker_seq — bigint — 작업자

care_service_review

  • id — bigint — NOT NULL — 시퀀스
  • insert_date — timestamp — 등록일
  • insert_user_id — character — 등록자
  • update_date — timestamp — 수정일
  • update_user_id — character — 수정자
  • deleted — boolean — NOT NULL — 삭제
  • review_contents — character — 리뷰
  • star_rating — real — 별점
  • reservation_id — bigint — 예약

care_service_status

  • id — bigint — NOT NULL — 시퀀스
  • insert_date — timestamp — 등록일
  • insert_user_id — character — 등록자
  • update_date — timestamp — 수정일
  • update_user_id — character — 수정자
  • status_code — character — 상태
  • update_person_type — character — 변경한
  • reservation_id — bigint — 예약

category_file

  • id — bigint — NOT NULL — 시퀀스
  • insert_date — timestamp — 등록일
  • insert_user_id — character — 등록자
  • update_date — timestamp — 수정일
  • update_user_id — character — 수정자
  • file_name — character — 파일명
  • file_url — character — 파일
  • image_id — character — NOT NULL — 소분류
  • root_category — character — 대분류
  • sub_category — character — 소분류

common_code

  • id — bigint — NOT NULL — 순번
  • insert_date — timestamp — 등록일
  • insert_user_id — character — 둥록자
  • update_date — timestamp — 수정일
  • update_user_id — character — 수정자
  • code — character — 코드
  • code_description — character — 코드설명
  • code_name — character — 코드명
  • group_code — character — 그룹코드
  • use_yn — boolean — 사용여부

coupon

  • coupon_id — bigint — NOT NULL — 쿠폰
  • insert_date — timestamp — 등록일
  • insert_user_id — character — 등록자
  • update_date — timestamp — 수정일
  • update_user_id — character — 수정자
  • cancel_date — timestamp — 쿠폰
  • cancel_reason — character — 쿠폰
  • cancel_remark — character — 취소사유
  • complete_date — timestamp — 쿠폰
  • contents — character — 발급
  • expired_date — timestamp — 만료일시
  • issuance_date — timestamp — 쿠폰
  • status_code — character — 쿠폰
  • type_code — character — 발급
  • apt_code — character — 아파트
  • user_id — character — 쿠폰

coupon_distribution

  • distribution_index — bigint — NOT NULL — 순번
  • insert_date — timestamp — 등록일
  • insert_user_id — character — 등록자
  • update_date — timestamp — 수정일
  • update_user_id — character — 수정자
  • active — boolean — 활성화
  • date_of_expiration — timestamp — 배포
  • date_of_issue — timestamp — 배포
  • distribution_type — character — 이용권
  • apt_code — character — 적용
  • contents — character — 내용

coupon_history

  • id — bigint — NOT NULL — 시퀀스
  • contents — character — 발급
  • insert_date — timestamp — 등록일
  • insert_user_id — character — 등록자
  • status — character — 이용권
  • coupon_id — bigint — 쿠폰

dashboard_days_rating

  • review_date — character — NOT NULL — 평가
  • review_average — double — 평가

dashboard_join

  • join_name — character — NOT NULL
  • join_count — bigint

dashboard_progress_step

  • step_seq — bigint — NOT NULL — 단계
  • status_code — character — 상태
  • status_count — bigint — 상태

dashboard_rating_status

  • star_rating_date — character — Primary key — NOT NULL — 평가
  • star_rating — bigint — Primary key — NOT NULL — 평가
  • star_rating_count — bigint — 평가

dashboard_request_category

  • category_date — character — Primary key — NOT NULL — 항목별
  • category_code — character — Primary key — NOT NULL — 항목별
  • category_name — character — 항목별
  • category_count — bigint — 항목별

dashboard_request_status

  • request_date — character — NOT NULL — 접수
  • request_count — bigint — 접수

dashboard_request_time

  • request_date — character — NOT NULL — 희망
  • day_week — bigint — 희망
  • time00 — bigint — 희망
  • time01 — bigint — 희망
  • time02 — bigint — 희망
  • time03 — bigint — 희망
  • time04 — bigint — 희망
  • time05 — bigint — 희망
  • time06 — bigint — 희망
  • time07 — bigint — 희망
  • time08 — bigint — 희망
  • time09 — bigint — 희망
  • time10 — bigint — 희망
  • time11 — bigint — 희망
  • time12 — bigint — 희망
  • time13 — bigint — 희망
  • time14 — bigint — 희망
  • time15 — bigint — 희망
  • time16 — bigint — 희망
  • time17 — bigint — 희망
  • time18 — bigint — 희망
  • time19 — bigint — 희망
  • time20 — bigint — 희망
  • time21 — bigint — 희망
  • time22 — bigint — 희망
  • time23 — bigint — 희망

message

  • message_id — bigint — NOT NULL — 순번
  • insert_date — timestamp — 등록일
  • insert_user_id — character — 등록자
  • update_date — timestamp — 수정일
  • update_user_id — character — 수정자
  • date_of_reservation — timestamp — 예약발송일시
  • message_content — character — 메시지
  • message_purpose — character — NOT NULL — 메시지
  • message_target — character — 수신자
  • message_template_id — character — 메시지
  • message_title — character — 메시지
  • message_transmit — character — NOT NULL — 즉시발송
  • message_type — character — NOT NULL — 메시지
  • purpose_entity_id — bigint — 메시지
  • purpose_entity_status — character — 상태
  • read — boolean — 읽음
  • receiver_id — character — 수신자
  • transmit_code — integer — 이지스
  • transmitted — boolean — 발송
  • virtual_url — character — 링크

notice_info

  • id — bigint — NOT NULL — Id
  • insert_date — timestamp — 등록일
  • insert_user_id — character — 등록자
  • update_date — timestamp — 수정일
  • update_user_id — character — 수정자
  • category — character — 공지
  • contents — character — 배너
  • notice_id — character — 공지
  • status_code — boolean — 활성화
  • title — character — 배너

sub_category_image

  • image_id — character — NOT NULL — 소분류
  • insert_date — timestamp — 등록일
  • insert_user_id — character — 등록자
  • update_date — timestamp — 수정일
  • update_user_id — character — 수정자
  • contents — character — 서비스
  • root_category — character — 대분류
  • sub_category — character — 소분류

sub_category_image_files

  • id — bigint — NOT NULL — 시퀀스
  • insert_date — timestamp — 등록일
  • insert_user_id — character — 등록자
  • update_date — timestamp — 수정일
  • update_user_id — character — 수정자
  • file_name — character — 파일명
  • file_url — character — 파일
  • image_id — character — 소분류
  • thumbnail_file_url — character — 썸네일

terms

  • terms_id — bigint — NOT NULL — 시퀀스
  • insert_date — timestamp — 등록일
  • insert_user_id — character — 등록자
  • update_date — timestamp — 수정일
  • update_user_id — character — 수정자
  • content — text — NOT NULL — 내용
  • expose — boolean — NOT NULL — 노출여부
  • expose_order — integer — NOT NULL — 노출순서
  • major_version — integer — NOT NULL — 메이저
  • minor_version — integer — NOT NULL — 마이너
  • need_renewal — boolean — NOT NULL — 재동의
  • title — character — NOT NULL — 제목
  • terms_type_id — character

terms_agreement

  • agreement_id — bigint — NOT NULL — 순번
  • insert_date — timestamp — 등록일
  • insert_user_id — character — 등록자
  • update_date — timestamp — 수정일
  • update_user_id — character — 수정자
  • agreed_date — timestamp — NOT NULL — 약관
  • terms_id — bigint — 약관
  • user_id — character — 유저
  • worker_seq — bigint — 작업자

terms_type

  • terms_type_id — character — NOT NULL — 아이디
  • insert_date — timestamp — 등록일
  • insert_user_id — character — 등록자
  • update_date — timestamp — 수정일
  • update_user_id — character — 수정자
  • required — boolean — NOT NULL — 필수여부
  • terms_target — character — NOT NULL — 약관
  • type_index — integer — NOT NULL — 인덱스

user

  • user_id — character — NOT NULL — 유저
  • insert_date — timestamp — 등록일
  • insert_user_id — character — 등록자
  • update_date — timestamp — 수정일
  • update_user_id — character — 수정자
  • apt_dong — character — 동
  • apt_ho — character — 호
  • del_datetime — timestamp — 탈퇴일시
  • del_yn — boolean — 탈퇴
  • dormant_yn — boolean — 휴면
  • householder — boolean — 세대주
  • member_yn — boolean — 아파트
  • phone — character — 휴대폰번호
  • user_name — character — 유저
  • apt_code — character — 아파트단지
  • apt_detail_address — integer — 검색용

user_auth

  • user_id — character — Primary key — NOT NULL — 유저
  • user_type — character — Primary key — NOT NULL — 유저
  • auth_token — character — 인증
  • issued_date — date — 토큰

user_auth_history

  • id — bigint — NOT NULL — 순번
  • user_id — character — 유저
  • user_type — character — 유저
  • auth_token — character — NOT NULL — 인증
  • category — character — NOT NULL — 분류
  • insert_date — timestamp — NOT NULL — 등록일

verification

  • verification_id — bigint — NOT NULL — 순번
  • insert_date — timestamp — 등록일
  • insert_user_id — character — 등록자
  • update_date — timestamp — 수정일
  • update_user_id — character — 수정자
  • disposed — boolean — NOT NULL — 토큰
  • verification_token — character — NOT NULL — 본인인증
  • worker_seq — bigint — 작업자

worker

  • worker_seq — bigint — NOT NULL — 시퀀스
  • insert_date — timestamp — 등록일
  • insert_user_id — character — 등록자
  • update_date — timestamp — 수정일
  • update_user_id — character — 수정자
  • accept_care_progress_push — boolean — NOT NULL — 케어
  • accept_notice_push — boolean — NOT NULL — 공지사항
  • account_blocked — boolean — 계정
  • company_name — character — 소속
  • company_phone — character — 업체
  • deleted — boolean — 삭제
  • last_access_date — timestamp — 마지막
  • memo — character — 메모
  • need_update_password — boolean — NOT NULL — 패스워드
  • password — character — NOT NULL — 패스워드
  • password_mismatch_count — integer — NOT NULL — 패스워드
  • phone — character — 전화번호
  • status — boolean — 작업자
  • worker_id — character — NOT NULL — 작업자
  • worker_name — character — 작업자
  • apt_code — character — 근무지