재임포트9
테이블 (50)
ADM
- USER_NO — VARCHAR2(15) — 외래 키 → MEMBER.USER_NO — NOT NULL
- DEPT_NM — VARCHAR2(50)
- PSTN_NM — VARCHAR2(50)
AI_RQST
- AI_RQST_NO — VARCHAR2(15) — 기본 키 — NOT NULL
- REG_DT — DATE
- CHAT_ROOM_NO — VARCHAR2(15) — 외래 키 → CHAT_ROOM.CHAT_ROOM_NO — NOT NULL
- RQST_CN — CLOB — NOT NULL
- RQST_SUMRY_CN — CLOB — NOT NULL
- CHAT_MSG_NO — NUMBER — 외래 키 → CHAT_MESSAGE.CHAT_MSG_NO
AI_RSLT
- AI_RSLT_NO — VARCHAR2(15) — 기본 키 — NOT NULL
- APT_CMPLEX_NO — VARCHAR2(15) — 외래 키 → APT_COMPLEX.APT_CMPLEX_NO — NOT NULL
- RCM_SCR — NUMBER(2) — NOT NULL
- REG_DT — DATE
- AI_RSLT_CN — CLOB — NOT NULL
- AI_RQST_NO — VARCHAR2(15) — 외래 키 → AI_RQST.AI_RQST_NO — NOT NULL
APLCT
- APLCT_NO — VARCHAR2(50) — 기본 키 — NOT NULL
- ANN_NO — VARCHAR2(15) — 외래 키 → CENTER_ANN_BOARD_POST.ANN_NO — NOT NULL
- USER_NO — VARCHAR2(15) — 외래 키 → MEMBER.USER_NO — NOT NULL
- HO_TY_NO — VARCHAR2(30) — 외래 키 → APT_HO_TY.HO_TY_NO — NOT NULL
- REG_DT — DATE
- MDF_DT — DATE
- APLCT_STTS_CD — VARCHAR2(20) — NOT NULL
- RJCT_RSN_CN — VARCHAR2(1000)
APT_ANN_BOARD_POST
- ANN_NO — VARCHAR2(15) — 기본 키 — NOT NULL
- TTL — VARCHAR2(200) — NOT NULL
- CN — CLOB — NOT NULL
- WRTR_ID — VARCHAR2(50) — NOT NULL
- TOP_FIX_YN — VARCHAR2(1) — NOT NULL
- PBLANC_BGNG_DT — DATE
- PBLANC_END_DT — DATE
- REG_DTTM — DATE
- MDF_DTTM — DATE
- INQ_CNT — NUMBER
- DEL_YN — VARCHAR2(1) — NOT NULL
- ATCH_FILE_ID — VARCHAR2(10)
- BOARD_NO — VARCHAR2(30) — 외래 키 → APT_BOARD_INSTANCE.BOARD_NO — NOT NULL
APT_BOARD_COMMENT
- CMT_NO — VARCHAR2(15) — 기본 키 — NOT NULL
- POST_NO — VARCHAR2(15) — 외래 키 → APT_BOARD_POST.POST_NO — NOT NULL
- CMT_GROUP — NUMBER(8)
- CMT_CN — VARCHAR2(500) — NOT NULL
- CMT_SORT_ORD — NUMBER(8)
- REG_DTTM — DATE
- DEL_YN — VARCHAR2(1) — NOT NULL
- MDF_DTTM — DATE
- USER_NO — VARCHAR2(15) — 외래 키 → MEMBER.USER_NO
APT_BOARD_INSTANCE
- BOARD_NO — VARCHAR2(30) — 기본 키 — NOT NULL
- APT_CMPLEX_NO — VARCHAR2(15) — 외래 키 → APT_COMPLEX.APT_CMPLEX_NO — NOT NULL
- BOARD_TY_CD — VARCHAR2(20) — NOT NULL
- BOARD_NM — VARCHAR2(200) — NOT NULL
- USE_YN — VARCHAR2(1) — NOT NULL
APT_BOARD_POST
- POST_NO — VARCHAR2(15) — 기본 키 — NOT NULL
- BOARD_NO — VARCHAR2(15) — 외래 키 → APT_BOARD_INSTANCE.BOARD_NO — NOT NULL
- TTL — VARCHAR2(200) — NOT NULL
- CN — CLOB — NOT NULL
- WRTR_ID — VARCHAR2(50) — NOT NULL
- REG_DTTM — DATE
- MDF_DTTM — DATE
- INQ_CNT — NUMBER
- DEL_YN — VARCHAR2(1) — NOT NULL
- ATCH_FILE_ID — VARCHAR2(10)
- OPN_YN — VARCHAR2(1) — NOT NULL
- PRRT_CD — VARCHAR2(30)
APT_COMPLEX
- APT_CMPLEX_NO — VARCHAR2(15) — 기본 키 — NOT NULL
- APT_CMPLEX_NM — VARCHAR2(100) — NOT NULL
- BJD_CD — VARCHAR2(10) — NOT NULL
- SIDO_NM — VARCHAR2(25) — NOT NULL
- SIGUNGU_NM — VARCHAR2(20) — NOT NULL
- EMD_NM — VARCHAR2(20) — NOT NULL
- LAT_VAL — NUMBER(18,10)
- LON_VAL — NUMBER(18,10)
- UNIT_CNT — NUMBER
- BLD_YR — VARCHAR2(8)
- CNSCO_NM — VARCHAR2(100)
- IMG_FILE_NO — VARCHAR2(10)
- RPRSNT_IMG_FILE_NO — VARCHAR2(10)
- HEAT_TY — VARCHAR2(50) — 난방방식코드
- PKG_CNT — NUMBER(5)
- MAX_FLOOR — NUMBER(3)
- FREE_PKG_CNT — NUMBER(1)
- DONG_CNT — NUMBER(5)
- DOROJUSO — VARCHAR2(100)
- CC_CNT — VARCHAR2(5)
APT_DETAIL
- HO_NO — VARCHAR2(30) — 기본 키 — NOT NULL
- FLOOR — NUMBER(2) — NOT NULL
- HO_TY_NO — VARCHAR2(30) — 외래 키 → APT_HO_TY.HO_TY_NO
- HO_STTS_CD — VARCHAR2(30) — NOT NULL
- IMAGE_NO — VARCHAR2(10)
- PANO_IMAGE_NO — VARCHAR2(10)
- DONG_NO — VARCHAR2(15) — 외래 키 → APT_UNIT.DONG_NO — NOT NULL
- HO — VARCHAR2(10) — NOT NULL
APT_HO_TY
- HO_TY_NO — VARCHAR2(30) — 기본 키 — NOT NULL
- APT_CMPLEX_NO — VARCHAR2(15) — 외래 키 → APT_COMPLEX.APT_CMPLEX_NO — NOT NULL — 아파트
- TY_NM — VARCHAR2(20) — 타입명
- EXCLUSIVE_SIZE — VARCHAR2(30) — 전용
- ROOM_CNT — NUMBER(2) — 방
- BATHROOM_CNT — NUMBER(2) — 욕실
- IMAGE_FILE_NO — VARCHAR2(10) — 이미지
APT_INFRA
- INFRA_NO — VARCHAR2(15) — 기본 키 — NOT NULL
- INFRA_NM — VARCHAR2(1000) — NOT NULL
- CATEGORY_CD — VARCHAR2(20) — NOT NULL
- REG_DT — DATE
- APT_CMPLEX_NO — VARCHAR2(15) — 외래 키 → APT_COMPLEX.APT_CMPLEX_NO — NOT NULL
APT_UNIT
- DONG_NO — VARCHAR2(15) — 기본 키 — NOT NULL
- DONG_NM — VARCHAR2(20) — NOT NULL
- FLOOR — NUMBER(2) — NOT NULL
- UNIT_CNT — NUMBER
- APT_CMPLEX_NO — VARCHAR2(15) — 외래 키 → APT_COMPLEX.APT_CMPLEX_NO — NOT NULL
ATTACH_FILE
- FILE_GROUP_NO — NUMBER — 기본 키 — NOT NULL
- FILE_SAVE_UUID — VARCHAR2(255) — 기본 키 — NOT NULL
- FILE_OG_NAME — VARCHAR2(255) — NOT NULL
- FILE_PATH — VARCHAR2(500) — NOT NULL
- FILE_EXT — VARCHAR2(20) — NOT NULL
- FILE_SIZE — NUMBER — NOT NULL
- MIME_TYPE — VARCHAR2(100) — NOT NULL
- REG_DT — DATE
- MDF_DT — DATE
- FILE_SORT_ORDER — NUMBER
- DOWN_CNT — NUMBER
- GOOGLE_ID — VARCHAR2(255) — NOT NULL
- CAT — VARCHAR2(30)
AUTH
- USER_NO — VARCHAR2(15) — 외래 키 → MEMBER.USER_NO — NOT NULL
- USER_ROLE_CD — VARCHAR2(20) — NOT NULL
AUTO_PAYMENT
- AUTO_PAY_NO — VARCHAR2(15) — 기본 키 — NOT NULL
- BILL_NO — VARCHAR2(15) — 외래 키 → BILL.BILL_NO — NOT NULL
- PAY_MTHD_CD — VARCHAR2(20) — NOT NULL
- BILLING_KEY — VARCHAR2(200) — NOT NULL
- PAY_STTS_CD — VARCHAR2(20) — NOT NULL
- START_DT — DATE — NOT NULL
- END_DT — DATE
- PAY_DAY — DATE — NOT NULL
- USER_NO — VARCHAR2(15) — 외래 키 → MEMBER.USER_NO — NOT NULL
BILL
- BILL_NO — VARCHAR2(15) — 기본 키 — NOT NULL
- HO_NO — VARCHAR2(30) — 외래 키 → APT_DETAIL.HO_NO — NOT NULL
- BILL_YM — VARCHAR2(6)
- YYYYMM) — NOT — NOT NULL
- BILL_PBLANC_DT — DATE — NOT NULL
- BILL_TOT_AMT — NUMBER(15) — NOT NULL
- DUE_DT — DATE — NOT NULL
- PYMT_STTS_CD — VARCHAR2(20) — NOT NULL
- PYMT_DT — DATE
- PYMT_AMT — NUMBER(15)
- LATE_FEE_RT — NUMBER(5,4) — NOT NULL
- LATE_FEE_AMT — NUMBER(15)
BILL_DETAIL
- BILL_DETAIL_NO — VARCHAR2(15) — 기본 키 — NOT NULL
- BILL_NO — VARCHAR2(15) — 외래 키 → BILL.BILL_NO — NOT NULL
- BILL_ITEM_CD — VARCHAR2(50) — NOT NULL
- BILL_ITEM_AMT — NUMBER(15) — NOT NULL
- ATCH_FILE_ID — VARCHAR2(10)
BUDGET
- BUDGET_NO — VARCHAR2(15) — 기본 키 — NOT NULL
- APT_CMPLEX_NO — VARCHAR2(15) — 외래 키 → APT_COMPLEX.APT_CMPLEX_NO — NOT NULL
- BUDGET_CD — VARCHAR2(15) — NOT NULL
- BUDGET_YR — NUMBER(4) — NOT NULL
- BUDGET_MM — NUMBER(2)
- BUDGET_AMT — NUMBER(15) — NOT NULL
- BUDGET_CN — VARCHAR2(200)
- REG_DT — DATE
- MDF_DT — DATE
- RMRK_CN — VARCHAR2(255)
CENTER_ANN_BOARD_POST
- ANN_NO — VARCHAR2(15) — 기본 키 — NOT NULL
- BOARD_NO — VARCHAR2(15) — 외래 키 → CENTER_BOARD_INSTANCE.BOARD_NO — NOT NULL
- TTL — VARCHAR2(200) — NOT NULL
- CN — CLOB — NOT NULL
- WRTR_ID — VARCHAR2(50) — NOT NULL
- TOP_FIX_YN — VARCHAR2(1) — NOT NULL
- PBLANC_BGNG_DT — DATE
- PBLANC_END_DT — DATE
- RCRT_BGNG_DT — DATE
- RCRT_END_DT — DATE
- REG_DTTM — DATE
- MDF_DTTM — DATE
- INQ_CNT — NUMBER
- DEL_YN — VARCHAR2(1)
- ATCH_FILE_ID — VARCHAR2(20)
- OPN_YN — VARCHAR2(1) — NOT NULL
- SBMSN_DOC — VARCHAR2(1000) — 제출서류
- MVIN_PRD_DT — DATE
- APT_CMPLEX_NO — VARCHAR2(15)
CENTER_BOARD_COMMENT
- CMT_NO — VARCHAR2(15) — 기본 키 — NOT NULL
- POST_NO — VARCHAR2(15) — 외래 키 → CENTER_BOARD_POST.POST_NO — NOT NULL
- CMT_GROUP — NUMBER(8)
- CMT_CN — VARCHAR2(500) — NOT NULL
- CMT_SORT_ORD — NUMBER(8)
- REG_DTTM — DATE
- DEL_YN — VARCHAR2(1) — NOT NULL
- MDF_DTTM — DATE
CENTER_BOARD_INSTANCE
- BOARD_NO — VARCHAR2(15) — 기본 키 — NOT NULL
- BOARD_NM — VARCHAR2(200) — NOT NULL
- BOARD_TY_CD — VARCHAR2(20) — NOT NULL
- USE_YN — VARCHAR2(1) — NOT NULL
- APT_CMPLEX_NO — VARCHAR2(15) — 외래 키 → APT_COMPLEX.APT_CMPLEX_NO
CENTER_BOARD_POST
- POST_NO — VARCHAR2(15) — 기본 키 — NOT NULL
- BOARD_NO — VARCHAR2(15) — 외래 키 → CENTER_BOARD_INSTANCE.BOARD_NO — NOT NULL
- TTL — VARCHAR2(200) — NOT NULL
- CN — CLOB — NOT NULL
- WRTR_ID — VARCHAR2(50) — NOT NULL
- TOP_FIX_YN — VARCHAR2(1) — NOT NULL
- REG_DTTM — DATE
- MDF_DTTM — DATE
- INQ_CNT — NUMBER
- DEL_YN — VARCHAR2(1) — NOT NULL
- ATCH_FILE_ID — VARCHAR2(10)
CHAT_MESSAGE
- CHAT_MSG_NO — NUMBER — 기본 키 — NOT NULL
- CHAT_ROOM_NO — VARCHAR2(15) — 외래 키 → CHAT_ROOM.CHAT_ROOM_NO — NOT NULL
- MSG_TY_CD — VARCHAR2(10) — NOT NULL
- MSG_CN — VARCHAR2(1000)
- ATCH_FILE_ID — VARCHAR2(10)
- REG_DTTM — DATE
- SENDER_TY — VARCHAR2(20)
- CHAT_MEMBER_ID — VARCHAR2(15) — 외래 키 → CHAT_ROOM_MEMBER.CHAT_MEMBER_ID
CHAT_ROOM
- CHAT_ROOM_NO — VARCHAR2(15) — 기본 키 — NOT NULL
- CHAT_ROOM_NM — VARCHAR2(150)
- CHAT_ROOM_TY_CD — VARCHAR2(10) — NOT NULL
- REG_DT — DATE
- USE_YN — VARCHAR2(1) — NOT NULL
- RGTR_ID — VARCHAR2(15)
- CHAT_JOIN_KEY — VARCHAR2(100)
- APT_CMPLEX_NO — VARCHAR2(15)
- CHAT_ROOM_DESC — VARCHAR2(600)
CHAT_ROOM_MEMBER
- CHAT_MEMBER_ID — VARCHAR2(15) — 기본 키 — NOT NULL
- USER_NO — VARCHAR2(15) — 외래 키 → MEMBER.USER_NO — NOT NULL
- CHATROLE_CD — VARCHAR2(10)
- JOIN_DTTM — DATE
- LEFT_DTTM — DATE
- CHAT_ROOM_NO — VARCHAR2(15) — 외래 키 → CHAT_ROOM.CHAT_ROOM_NO — NOT NULL
- NOTI_YN — VARCHAR2(1) — NOT NULL
CHAT_ROOM_READ
- CHAT_MEMBER_ID — VARCHAR2(15) — 외래 키 → CHAT_ROOM_MEMBER.CHAT_MEMBER_ID — NOT NULL
- CHAT_ROOM_NO — VARCHAR2(15) — 외래 키 → CHAT_ROOM.CHAT_ROOM_NO — NOT NULL
- LAST_READ_MSG_NO — NUMBER — 외래 키 → CHAT_MESSAGE.CHAT_MSG_NO
CNTRCT_FRM
- FRM_NO — VARCHAR2(15) — 기본 키 — NOT NULL
- FRM_NM — VARCHAR2(100) — NOT NULL
- RENT_TYPE_CD — VARCHAR2(15)
- REG_DT — DATE
- MDF_DT — DATE
- FILE_NO — VARCHAR2(10)
COMMENT_LIKE
- CMT_LIKE_NO — VARCHAR2(15) — 기본 키 — NOT NULL
- USER_NO — VARCHAR2(15) — NOT NULL
- BOARD_TYPE_CD — VARCHAR2(20) — NOT NULL
- CMT_NO — VARCHAR2(15) — NOT NULL
- REG_DTTM — DATE
COMMON_CODE
- GROUP_CODE_NO — VARCHAR2(20) — 기본 키 — NOT NULL
- CODE_NO_CD — VARCHAR2(20) — 기본 키 — NOT NULL
- CODE_NAME — VARCHAR2(100) — NOT NULL
- CODE_CONTENT — VARCHAR2(500)
- SORT_ORDER — NUMBER — NOT NULL
- USE_YN — VARCHAR2(1) — NOT NULL
COMPLEX_3D
- MODEL_NO — VARCHAR2(20) — 기본 키 — NOT NULL
- MODEL_NM — VARCHAR2(200) — NOT NULL
- FILE_PATH — VARCHAR2(255) — NOT NULL
- ORGNL_FILE_NM — VARCHAR2(255) — NOT NULL
- STRG_FILE_UUID — VARCHAR2(100) — NOT NULL
- MIME_TYPE_CD — VARCHAR2(20) — NOT NULL
- FILE_SZ — NUMBER — NOT NULL
- FILE_EXTN — VARCHAR2(10)
- REG_DT — DATE — NOT NULL
- MDF_DT — DATE
- APT_CMPLEX_NO — VARCHAR2(15) — 외래 키 → APT_COMPLEX.APT_CMPLEX_NO — NOT NULL
COMPLEX_SCHEDULE
- SCHEDULE_NO — VARCHAR2(15) — 기본 키 — NOT NULL
- APT_CMPLEX_NO — VARCHAR2(15) — 외래 키 → APT_COMPLEX.APT_CMPLEX_NO — NOT NULL
- SCHDL_TTL — VARCHAR2(50) — NOT NULL
- LOC_CN — VARCHAR2(50)
- SCHDL_STTS_CD — VARCHAR2(50)
- REG_DT — DATE
- MDF_DT — DATE
- RGTR_ID — VARCHAR2(50) — NOT NULL
- SCHDL_CN — VARCHAR2(200)
- UTILITY_PROVIDER_NO — VARCHAR2(20) — 외래 키 — NOT NULL
CTRT_MGR
- CTRT_MGR_NO — VARCHAR2(15) — 기본 키 — NOT NULL
- USER_NO — VARCHAR2(15) — 외래 키 → ADM.USER_NO — NOT NULL
- MGR_ASGN_DT — DATE — NOT NULL
- CHG_YN — VARCHAR2(1) — NOT NULL
- RENT_CTRT_NO — VARCHAR2(50) — 외래 키 — NOT NULL
CTRT_PAY_HSTRY
- CTRT_PAY_NO — VARCHAR2(15) — 기본 키 — NOT NULL
- PAY_TY_CD — VARCHAR2(20) — NOT NULL
- PAY_AMT — NUMBER(15)
- PAY_DT — DATE
- PAY_STTS_CD — VARCHAR2(20) — NOT NULL
- PAY_MTHD_CD — VARCHAR2(20)
- REG_DT — DATE
- MDF_DT — DATE
- RENT_CTRT_NO — VARCHAR2(20) — 외래 키 — NOT NULL
CVPL
- CVPL_NO — VARCHAR2(15) — 기본 키 — NOT NULL
- CVPL_TY_CD — VARCHAR2(20) — NOT NULL
- CVPL_LOC — VARCHAR2(50) — NOT NULL
- CVPL_CN — CLOB — NOT NULL
- CVPL_STTS_CD — VARCHAR2(10) — NOT NULL
- CVPL_REG_DT — DATE — NOT NULL
- CVPL_MDF_DT — DATE
- CVPL_RCPT_DT — DATE
- CVPL_END_DT — DATE
- CVPL_PRRT — VARCHAR2(30)
- CVPL_FILE_NO — VARCHAR2(10)
- CVPL_TTL — VARCHAR2(100) — NOT NULL
- USER_NO — VARCHAR2(15) — NOT NULL
- HO_NO — VARCHAR2(30) — NOT NULL
- APT_CMPLEX_NO — VARCHAR2(15) — 외래 키 → APT_COMPLEX.APT_CMPLEX_NO — NOT NULL
CVPL_AI_ANLS
- ANLS_NO — VARCHAR2(15) — 기본 키 — NOT NULL
- RISK_SCR — NUMBER(3) — NOT NULL
- RISK_GRAD — VARCHAR2(20) — NOT NULL
- PRED_CTGRY — VARCHAR2(50) — NOT NULL
- CHN_RISK_CN — CLOB
- ANLS_DT — DATE — NOT NULL
- CVPL_NO — VARCHAR2(15) — 외래 키 → CVPL.CVPL_NO — NOT NULL
CVPL_HSTRY
- CVPL_HSTRY_ID — VARCHAR2(15) — 기본 키 — NOT NULL
- CVPL_ANS — CLOB
- PIC_ID — VARCHAR2(50)
- CVPL_REG_DT — DATE — NOT NULL
- CVPL_STTS_CD — VARCHAR2(10) — NOT NULL
- CVPL_NO — VARCHAR2(15) — 외래 키 → CVPL.CVPL_NO — NOT NULL
EXPENSE
- EXPENSE_NO — VARCHAR2(15) — 기본 키 — NOT NULL
- EXPENSE_YR — NUMBER(4) — NOT NULL
- EXPENSE_MM — NUMBER(2) — NOT NULL
- EXPENSE_AMT — NUMBER — NOT NULL
- EXPENSE_CD — VARCHAR2(20) — NOT NULL
- EXPENSE_CN — VARCHAR2(200)
- REG_DT — DATE
- MDF_DT — DATE
- RMRK_CN — VARCHAR2(255)
- ATCH_FILE_ID — VARCHAR2(10)
- APT_CMPLEX_NO — VARCHAR2(15) — 외래 키 → APT_COMPLEX.APT_CMPLEX_NO — NOT NULL
FACILITY
- FACILITY_NO — VARCHAR2(15) — 기본 키 — NOT NULL
- FACILITY_TY_CD — VARCHAR2(20) — NOT NULL — 공통코드
- INSTL_DT — DATE
- FACILITY_NM — VARCHAR2(100) — NOT NULL
- APT_CMPLEX_NO — VARCHAR2(15) — 외래 키 → APT_COMPLEX.APT_CMPLEX_NO — NOT NULL
- DONG_NO — VARCHAR2(15) — 시설
- LOC_CN — VARCHAR2(300) — 시설
- USE_YN — CHAR(1) — NOT NULL
- FILE_GROUP_NO — NUMBER
FACILITY_CHECK_HSTRY
- FAC_CHK_HSTRY_NO — VARCHAR2(15) — 기본 키 — NOT NULL
- FACILITY_NO — VARCHAR2(15) — 외래 키 → FACILITY.FACILITY_NO — NOT NULL
- PARTNER_NO — VARCHAR2(15) — 외래 키
- CHK_DT — DATE
- CHK_STTS_CD — VARCHAR2(20)
- CHK_CN — VARCHAR2(1000)
- RMK — VARCHAR2(500)
- REG_DT — DATE
- MDF_DT — DATE
- CHK_TY_CD — VARCHAR2(20)
- CHK_FLOW_NO — VARCHAR2(20)
- CONT_NO — VARCHAR2(15)
- USE_RESTRICT_YN — VARCHAR2(1) — NOT NULL
- USE_RESTRICT_BGNG_DT — DATE
- USE_RESTRICT_END_DT — DATE
- CHK_CTGRY_CD — VARCHAR2(20)
FACILITY_CONTRACT
- CONT_NO — VARCHAR2(15) — 기본 키 — NOT NULL
- FACILITY_NO — VARCHAR2(15) — 외래 키 → FACILITY.FACILITY_NO
- PARTNER_NO — VARCHAR2(15) — 외래 키 — NOT NULL
- CONT_NM — VARCHAR2(200) — NOT NULL
- BID_TY_CD — VARCHAR2(20) — NOT NULL
- CONT_DT — DATE
- CONT_STTS_CD — VARCHAR2(50)
- CONT_AMT — NUMBER(15) — NOT NULL
- PYMT_DT — DATE
- CONT_BGNG_DT — DATE — NOT NULL
- CONT_END_DT — DATE
- CONT_TY_CD — VARCHAR2(20)
- CONT_TARGET_CD — VARCHAR2(20)
- CONT_CN — VARCHAR2(1000)
- RMRK_CN — VARCHAR2(1000)
- REG_DT — DATE
- MDF_DT — DATE
- FILE_GROUP_NO — NUMBER
FACILITY_CONTRACT_TARGET
- CONT_NO — VARCHAR2(20) — 외래 키 → FACILITY_CONTRACT.CONT_NO — NOT NULL
- FACILITY_NO — VARCHAR2(20) — 외래 키 → FACILITY.FACILITY_NO — NOT NULL
- REG_DT — DATE
FACILITY_HSTRY
- RSVT_NO — VARCHAR2(15) — 기본 키 — NOT NULL
- CMN_FACILITY_ITEM_NO — VARCHAR2(15) — 외래 키 — NOT NULL
- RSVT_DT — DATE — NOT NULL
- RSVT_BGNG_DTTM — DATE
- RSVT_END_DTTM — DATE
- RSVT_STTS_CD — VARCHAR2(20) — NOT NULL
- REG_DT — DATE
- MDF_DT — DATE
- USER_NO — VARCHAR2(15) — 외래 키 → MEMBER.USER_NO — NOT NULL
- USE_PRSN_CNT — NUMBER(5) — 공용시설
- USE_PRPS_CN — VARCHAR2(1000) — 공용시설
- RJCT_RSN_CN — VARCHAR2(1000) — 공용시설
HSHLD_HEAD
- HO_NO — VARCHAR2(30) — 외래 키 → APT_DETAIL.HO_NO — NOT NULL
- USER_NO — VARCHAR2(15) — 외래 키 → MEMBER.USER_NO — NOT NULL
- INOUT_CD — VARCHAR2(20) — NOT NULL
- MOVE_IN_DT — DATE
- MOVE_OUT_DT — DATE
- HEAD_YN — VARCHAR2(1)
HSHLD_MEMBER
- HO_NO — VARCHAR2(30) — 외래 키 → APT_DETAIL.HO_NO — NOT NULL
- HSHLD_MBR_NM — VARCHAR2(15) — NOT NULL
KAKAO_ALIM
- ALIM_NO — VARCHAR2(20) — 기본 키 — NOT NULL — 알림번호
- USER_NO — VARCHAR2(20) — NOT NULL — 수신회원번호
- ALIM_TY_CD — VARCHAR2(50) — 알림유형코드
- ALIM_TTL — VARCHAR2(100) — 알림제목
- ALIM_CN — VARCHAR2(1000) — 알림내용
- LINK_URL — VARCHAR2(300) — 클릭
- READ_YN — CHAR(1) — 읽음여부
- SND_DTTM — DATE — 발송일시
- RGTR_ID — VARCHAR2(50) — 등록자
LAW_DONG
- LAWD_CD — VARCHAR2(10) — 기본 키 — NOT NULL
- SIDO_NM — VARCHAR2(50)
- SIGUNGU_NM — VARCHAR2(50)
- DONG_NM — VARCHAR2(50)
- RI_NM — VARCHAR2(50)
- USE_YN — CHAR(1) — NOT NULL
- REG_DT — DATE — NOT NULL
MANAGER
- USER_NO — VARCHAR2(15) — 외래 키 → MEMBER.USER_NO — NOT NULL
- MGMT_OFC_NO — VARCHAR2(50) — 외래 키 — NOT NULL
- MNGR_DUTY_CD — VARCHAR2(50) — NOT NULL
MEMBER
- USER_NO — VARCHAR2(50) — 기본 키 — NOT NULL
- USER_ID — VARCHAR2(20) — NOT NULL
- USER_PW — VARCHAR2(255) — NOT NULL
- USER_NM — VARCHAR2(100) — NOT NULL
- USER_RRNO — VARCHAR2(200) — NOT NULL
- USER_TELNO — VARCHAR2(50)
- USER_EML — VARCHAR2(50)
- REG_DT — DATE — NOT NULL
- MDF_DT — DATE
- USER_YN — VARCHAR2(1) — NOT NULL
- SMS_RCV_YN — VARCHAR2(1) — NOT NULL
- SMS_NTC_RCV_YN — VARCHAR2(1) — NOT NULL
- SMS_CTRT_RCV_YN — VARCHAR2(1) — NOT NULL
- EML_RCV_YN — VARCHAR2(1) — NOT NULL
- EML_NTC_RCV_YN — VARCHAR2(1) — NOT NULL
- EML_CTRT_RCV_YN — VARCHAR2(1) — NOT NULL
- PROF_FILE_ID — VARCHAR2(100)
METER_HSTRY
- METER_HSTRY_NO — VARCHAR2(15) — 기본 키 — NOT NULL
- FACILITY_NO — VARCHAR2(15) — 외래 키 → FACILITY.FACILITY_NO — NOT NULL
- HO_NO — VARCHAR2(30) — 외래 키 → APT_DETAIL.HO_NO
- METER_DT — DATE — NOT NULL
- PRE_VAL — NUMBER(10,2)
- CURR_VAL — NUMBER(10,2)
- METER_CN — VARCHAR2(1000)
- METER_RSLT_CD — VARCHAR2(20) — NOT NULL
- REG_DT — DATE — NOT NULL
- MDF_DT — DATE
- UTILITY_PROVIDER_NO — VARCHAR2(20) — 외래 키
- METER_TY_CD — VARCHAR2(20)
- METER_SCOPE — VARCHAR2(20) — NOT NULL