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 — 근무지