재임포트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