KTREND

Tables (33)

JOIN (KH - KP)

  • KTREND_DT — Primary key
  • WORK_TYPE — Primary key
  • BUILD_TYPE — Primary key
  • KTREND_APT_SEQ — Primary key
  • KTREND_PYONG_SEQ — Primary key

JOIN (KMMR - KRT)

  • REG — Primary key

JOIN (KWP - KM)

  • KTREND_DT — Primary key
  • WORK_TYPE — Primary key
  • BUILD_TYPE — Primary key
  • KTREND_APT_SEQ — Primary key

JOIN (KWP - KA)

  • KTREND_DT — Primary key
  • WORK_TYPE — Primary key

JOIN (KM - KTH)

  • KTREND_APT_SEQ (KTOWN_APT_SEQ) — Primary key

JOIN (KM - KTD)

  • KTREND_DONG_SEQ (SEQ) — Primary key

JOIN (KM - KB)

  • OFFICE_INFO_SEQ — Primary key

JOIN (KH - KTH)

  • KTREND_HO_SEQ (SEQ) — Primary key
  • KTREND_DONG_SEQ (KTOWN_DONG_SEQ) — Primary key — NOT NULL

JOIN (KH - KTD)

  • KTREND_DONG_SEQ (SEQ) — Primary key

JOIN (KMP - KH)

  • KTREND_DT — Primary key
  • WORK_TYPE — Primary key
  • BUILD_TYPE — Primary key
  • KTREND_APT_SEQ — Primary key
  • KTREND_HO_SEQ — Primary key

JOIN (KM - KKA)

  • KTREND_APT_SEQ (SEQ) — Primary key

JOIN (KS - MI)

  • MEMBER_INFO_SEQ (SEQ) — Primary key

JOIN (KM - KS)

  • KTREND_SEARCHER_SEQ (SEQ) — Primary key

JOIN (KM - KH)

  • KTREND_DT — Primary key
  • WORK_TYPE — Primary key
  • BUILD_TYPE — Primary key
  • KTREND_APT_SEQ — Primary key

JOIN (KM - KP)

  • KTREND_DT — Primary key
  • WORK_TYPE — Primary key
  • BUILD_TYPE — Primary key
  • KTREND_APT_SEQ — Primary key
  • KTREND_PYONG_SEQ — Primary key

JOIN (KB - KM)

  • REG (SREG) — Primary key
  • EUB (SEUB) — Primary key

JOIN (KA - KM)

  • KTREND_DT — Primary key
  • WORK_TYPE — Primary key

JOIN (KWP - KH)

  • KTREND_DT — Primary key
  • WORK_TYPE — Primary key
  • BUILD_TYPE — Primary key
  • KTREND_APT_SEQ — Primary key
  • KTREND_HO_SEQ — Primary key

KTOWNCM.KTOWN_APT (공동주택(정기공시) 단지)

  • SEQ ([공개] 단지코드) — Primary key — NOT NULL
  • RESEARCH_TYPE (조사구분 1: 공시(정기) , 2:공시(추가), 3:공시(신규) , 4:미공시(기존))
  • NUM (조사서출력번호)
  • CALC_PRICE_TYPE (가격산정구분 1:공급면적별가격, 2:전유면적당단가, 3:공급면적당단가)
  • SUB_RES_STD_TYPE (1일 경우 초고층가격산정방식 이용)
  • MOD_GBN (호풀이 대상 단지)
  • GRADE_CNT_YN (단지단위등급설정)
  • LAND_COST (토지가격)
  • BUILD_COST (건물재조달원가)
  • STATE_CODE (조사진행상태)
  • ADD_STATE_CODE (수시조사진행상태)
  • BUILD_CALC_YN (건물만의 가격산정여부)
  • NTS_YN (.)
  • GONGSI_YN (공시대상여부)
  • FL_PRICE_TYPE (층별효용지수)
  • FL_PRICE_YN (층별효용지수수정여부)
  • REPORT_SEQ (보고서 출력번호)
  • RESEARCH_DATE (조사일자)
  • DUP_YN (중복여부)
  • DUP_KTOWN_APT_SEQ (중복단지 코드)
  • GWASE_DT (지자체 과세 전송 날짜)
  • CALC_DIRECT_INPUT (가격일괄직접입력)
  • APT_CODE ([공개]단지 코드)
  • REG ([공개] 시군구)
  • EUB ([공개] 읍면동리)
  • SAN ([공개] 지번구분)
  • BUN1 ([공개] 본번지)
  • BUN2 ([공개] 부번지)
  • SREG ([공게] 최신 시군구)
  • SEUB ([공개] 최신 읍면동리)
  • SSAN ([공개] 최신 지번구분)
  • SBUN1 ([공개] 최신 본번지)
  • SBUN2 ([공개] 최신 부번지)
  • SPECIAL_NAME (특수지_명)
  • ROAD_REG (도로명 시군구)
  • ROAD_CODE (도로명 코드) — NOT NULL
  • ROAD_EUB_NO (도로명 읍면동 일련번호)
  • ROAD_BUILDBUN1 (도로명 건불본번)
  • ROAD_BUILDBUN2 (도로명 건물부번)
  • INSERT_DT (입력날짜)
  • APT_NAME ([공개] 단지명(공부명))
  • COMMON_APT_NAME ([공개] 단지명(통칭명))
  • APT_TYPE ([공개] 단지종류 1: 아파트, 3: 연립, 5: 다세대)
  • CREATE_TYPE (..)
  • SUB_APT_TYPE (단지종류 0: 일반, 1: 타워, 2: 주상복합 , 3: 타운하우스)
  • SUB_APT_TYPE_NAME (SUB_APT_TYPE에 기타 선택 시 입력)
  • USEAPR_DT ([공개]사용승인일)
  • LOSE_TYPE ([공개]멸실사유)
  • LOSE_DT (멸실일자)
  • DEL_FLAG (제외사유)
  • APT_YNG_RAT (용적률)
  • HEAT_TYPE (난방방식)
  • BIZ_TYPE ([공개] 사업유형)
  • STREET_TYPE (가로조건)
  • TRANS_TYPE ([공개]교통조건)
  • CONVEN_TYPE ([공개]편의시설)
  • EDU_TYPE ([공개]교육)
  • ENV_TYPE (환경)
  • PARK_TYPE (주차여건)
  • BULD_TYPE (건물상태)
  • … +33

KTOWNCM.KTOWN_DONG (공동주택(정기공시) 동)

  • SEQ ([공개] 단지코드) — Primary key — NOT NULL
  • KTOWN_APT_SEQ (아파트 SEQ)
  • APT_CODE (구 단지코드)
  • DONG_CODE (구 동코드)
  • REG ([공개] 시군구)
  • EUB ([공개] 읍면동리)
  • SAN ([공개] 지번구분)
  • BUN1 ([공개] 본번지)
  • BUN2 ([공개] 부번지)
  • SREG ([공게] 최신 시군구)
  • SEUB ([공개] 최신 읍면동리)
  • SSAN ([공개] 최신 지번구분)
  • SBUN1 ([공개] 최신 본번지)
  • SBUN2 ([공개] 최신 부번지)
  • SPECIAL_NAME (특수지_명)
  • ROAD_REG (도로명 시군구)
  • ROAD_CODE (도로명 코드) — NOT NULL
  • ROAD_EUB_NO (도로명 읍면동 일련번호)
  • ROAD_BUILDBUN1 (도로명 건불본번)
  • ROAD_BUILDBUN2 (도로명 건물부번)
  • DONG_NAME ([공개] 동명)
  • USEAPR_DT ([공개] 사용승인일)
  • NTS_DONG_NAME (국세청동명)
  • SUB_APT_TYPE (단지종류 0: 일반, 1: 타워, 2: 주상복합 , 3: 타운하우스)
  • SUB_APT_TYPE_NAME (SUB_APT_TYPE에 기타 선택 시 입력)
  • USEAPR_DT ([공개]사용승인일)
  • LOSE_TYPE ([공개]멸실사유)
  • LOSE_DT (멸실일자)
  • RENT_YN (임대 여부)
  • LAND_AREA (대지면적)
  • BULD_MA_USE_TYPE (건물주용도)
  • APT_TYPE ([공개] 동의용도 1:아파트 3:연립)
  • MGM_BLDRGST_PK (건축물대장 매칭)
  • APT_STR_TYPE (동구조)
  • ELEV_YN ([공개]엘레베이터 유무)
  • FL_PRICE_TYPE (층별효용지수)
  • TOP_FL_RATE (최고층효용지수)
  • STD_FL_RATE (기준층효용지수)
  • FIRST_FL_RATE (1층효용지수)
  • B_FL_RATE (지하층효용지수)
  • FL_CHANGE_YN (층호바뀜여부)
  • INSERT_DT (추가일자)
  • ROAD_NAME (도로명)
  • MODIFY_STATE (변경 여부)
  • BULD_STR_TYPE ([공개]건물구조)
  • DJY_EXISTS_YN (건축물대장존재여부)
  • SEARCH_NO (조사단지순번)
  • SROAD_REG (신도로명 시군구)
  • SROAD_CODE (신도로명 코드)
  • SROAD_EUB_NO (신도로명 읍면동 일련번호)
  • SROAD_UNDER (신도로명 지하구분)
  • SROAD_BUILDBUN1 (신도로명 건물본번)
  • SROAD_BUILDBUN2 (신도로명 건물부번)
  • SECOND_FL_RATE (2층 효용지수)
  • MODIFY_DT (수정된 날짜)
  • HO_CNT (호수)
  • MAX_FLOOR (최고층)
  • MAX_LINE (라인수)
  • KTREND_PYONG_SEQ — Foreign key → JOIN.KTREND_DONG_SEQ
  • KTREND_DONG_SEQ (SEQ2) — Foreign key → JOIN.KTREND_DONG_SEQ

KTOWNCM.KTOWN_HO (공동주택(정기공시) 호)

  • SEQ ([공개] 단지코드) — Primary key — NOT NULL
  • KTOWN_APT_SEQ (아파트 SEQ)
  • APT_CODE (구 단지코드)
  • DONG_CODE (구 동코드)
  • REG ([공개] 시군구)
  • EUB ([공개] 읍면동리)
  • SAN ([공개] 지번구분)
  • BUN1 ([공개] 본번지)
  • BUN2 ([공개] 부번지)
  • SREG ([공게] 최신 시군구)
  • SEUB ([공개] 최신 읍면동리)
  • SSAN ([공개] 최신 지번구분)
  • SBUN1 ([공개] 최신 본번지)
  • SBUN2 ([공개] 최신 부번지)
  • SPECIAL_NAME (특수지_명)
  • ROAD_REG (도로명 시군구)
  • ROAD_CODE (도로명 코드) — NOT NULL
  • ROAD_EUB_NO (도로명 읍면동 일련번호)
  • ROAD_BUILDBUN1 (도로명 건불본번)
  • ROAD_BUILDBUN2 (도로명 건물부번)
  • DONG_NAME ([공개] 동명)
  • USEAPR_DT ([공개] 사용승인일)
  • NTS_DONG_NAME (국세청동명)
  • SUB_APT_TYPE (단지종류 0: 일반, 1: 타워, 2: 주상복합 , 3: 타운하우스)
  • SUB_APT_TYPE_NAME (SUB_APT_TYPE에 기타 선택 시 입력)
  • USEAPR_DT ([공개]사용승인일)
  • LOSE_TYPE ([공개]멸실사유)
  • LOSE_DT (멸실일자)
  • RENT_YN (임대 여부)
  • LAND_AREA (대지면적)
  • BULD_MA_USE_TYPE (건물주용도)
  • APT_TYPE ([공개] 동의용도 1:아파트 3:연립)
  • MGM_BLDRGST_PK (건축물대장 매칭)
  • APT_STR_TYPE (동구조)
  • ELEV_YN ([공개]엘레베이터 유무)
  • FL_PRICE_TYPE (층별효용지수)
  • TOP_FL_RATE (최고층효용지수)
  • STD_FL_RATE (기준층효용지수)
  • FIRST_FL_RATE (1층효용지수)
  • B_FL_RATE (지하층효용지수)
  • FL_CHANGE_YN (층호바뀜여부)
  • INSERT_DT (추가일자)
  • ROAD_NAME (도로명)
  • MODIFY_STATE (변경 여부)
  • BULD_STR_TYPE ([공개]건물구조)
  • DJY_EXISTS_YN (건축물대장존재여부)
  • SEARCH_NO (조사단지순번)
  • SROAD_REG (신도로명 시군구)
  • SROAD_CODE (신도로명 코드)
  • SROAD_EUB_NO (신도로명 읍면동 일련번호)
  • SROAD_UNDER (신도로명 지하구분)
  • SROAD_BUILDBUN1 (신도로명 건물본번)
  • SROAD_BUILDBUN2 (신도로명 건물부번)
  • SECOND_FL_RATE (2층 효용지수)
  • MODIFY_DT (수정된 날짜)
  • HO_CNT (호수)
  • MAX_FLOOR (최고층)
  • MAX_LINE (라인수)
  • KTREND_DONG_SEQ (SEQ2) — Foreign key → JOIN.KTREND_HO_SEQ
  • KTREND_DONG_SEQ (SEQ3) — Foreign key → JOIN.KTREND_APT_SEQ
  • … +1

KTREND_AUTHORITY (주택동향 조사일정 회차 정보)

  • KTREND_DT (조사시점) — Primary key — NOT NULL
  • WORK_TYPE (작업구분(1 : 주간 , 2: 월간)) — Primary key — NOT NULL
  • OPEN_DATE (회차시작일자)
  • CLOSE_DATE (회차종료일자)
  • FINISH_DATE (마감일자)
  • FINISH_YN (마감여부)
  • BASE_DT (지수기준회차)
  • TRIP_YN (출장여부(0:미출장, 1:마감))
  • MOBILE_YN (모바일 조사여부)
  • MATCH_DT (주간,월간 매칭회차)
  • PRE_DT (전기 회차)
  • PRE_YEAR_MATCH_DT (전년말 매칭 주차)
  • PRE_YEAR_END_DT (전년말 최종회차)
  • ACC_STD_DT (누적년월 기준 회차)
  • FIX_OPEN_DATE (자동산정가격 생성기준일)
  • PIC_CHK_DATE (현장출장사진 조회기준일자)
  • PIC_VERI_YN (현장출장사진 검증 필수 회차여부)
  • KTREND_DT (Field) — Foreign key → JOIN.KTREND_DT
  • WORK_TYPE (Field2) — Foreign key → JOIN.WORK_TYPE
  • KTREND_DT — Foreign key → JOIN.KTREND_DT
  • WORK_TYPE — Foreign key → JOIN.WORK_TYPE

KTREND_BJDHIST (주택동향 법정동 관리정보)

  • REG (시군구 코드) — Primary key — NOT NULL
  • EUB (읍면동코드) — Primary key — NOT NULL
  • CHANGEDATE (변경일자)
  • REG2 (변경전 시군구 코드)
  • EUB2 (변경전 읍면동 코드)
  • FUSE (1:사용 2:미사용)
  • AS1 (시도)
  • AS2 (시군구)
  • AS3 (읍면)
  • AS4 (동리)
  • ZIP (우편번호)
  • LAST_NAME (최종하위레벨 명칭)
  • OLD_LAST_NAME (변경전 최종하위레벨 명칭)
  • OFFICE_INFO_SEQ (지사 SEQ)
  • PROVINCE_NAME (X)
  • CITY_NAME (시군구1)
  • DISTRICT_NAME (시군구2)
  • BLOCK_NAME (읍면동)
  • STREET_NAME (리)
  • BJD_ADDR_NAME (법정동명)
  • BRANCH_CD (관할지사코드)
  • BRANCH_SUB_CODE (관할지사 SUB 코드)
  • AREA_GBN (수도권 체크 플래그)
  • USE_FLAG (X.)
  • BRANCH_AREA (X..)
  • PYONG_AREA (X...)
  • PROV_GBN (시도구분)
  • ZONE_AREA (X....)
  • NEW_TOWN (신도시 여부)
  • NEW_TOWN_NAME (1기 신도시명)
  • NEW_TOWN_SUB_NAME (2기 신도시명)
  • NEW_CITY (행복,혁신,기업 도시 구분)
  • NEW_TOWN_1 (시범뉴타운) — NOT NULL
  • NEW_TOWN_2 (2차뉴타운) — NOT NULL
  • NEW_TOWN_3 (3차뉴타운)
  • ACC_TOWN (촉진지구 구분)
  • CITY_FLAG (시군구 구분)
  • RES_AREA_GBN (조사지역구분)
  • RES_PRICE (조사비)
  • MYEON_GUBUN (면구분)
  • REG (SREG) — Foreign key → JOIN.REG
  • EUB (SEUB) — Foreign key → JOIN.EUB

KTREND_BRANCH (주택동향지사정보)

  • OFFICE_INFO_SEQ (SEQ) — Primary key — NOT NULL
  • BRANCH_TYPE (지사유형)
  • BRANCH_NAME (지사명)
  • BRANCH_S_NAME (짧은 지사명)
  • BRANCH_USE_YN (사용여부)
  • HEAD_OFFICE_SEQ (권역지사코드)
  • HEAD_BRANCH_NAME (지점별 지역명)
  • TEL_NO (전화번호)
  • FAX_NO (팩스번호)
  • ZIP_NO (우편번호)
  • ADDR (소재지)
  • SREG (소재지 법정코드)
  • SORT_NUM (정렬번호)
  • IS_LEADER (선임지사여부)
  • KTREND_APT_SEQ (SEQ2) — Foreign key → JOIN.OFFICE_INFO_SEQ

KTREND_HO (주택동향조사 호)

  • KTREND_DT (조사시점) — Primary key — NOT NULL
  • WORK_TYPE (작업구분(1 : 주간 , 2: 월간)) — Primary key — NOT NULL
  • BUILD_TYPE (건물구분) — Primary key
  • KTREND_APT_SEQ (단지 SEQ) — Primary key
  • KTREND_DONG_SEQ (동SEQ) — Primary key
  • KTREND_HO_SEQ (호SEQ) — Primary key
  • KTRNED_PYONG_SEQ (평 SEQ)
  • LAND_AREA (대지구분)
  • KTREND_APT_CODE (단지코드)
  • KTREND_DONG_CODE (동코드)
  • KTREND_HO_CODE (호코드)
  • STD_CODE (표본코드)
  • STD_CODE_ORG (전년말 최종회차)
  • WEEK_YN (주간표본여부)
  • IS_NEW (신규표본여부)
  • INS_ID (입력ID)
  • INS_DATE (입력일자)
  • KTREND_HO_SEQ — Foreign key → JOIN.KTREND_HO_SEQ
  • KTREND_DT (KTREND_DT2) — Foreign key → JOIN.KTREND_DT
  • WORK_TYPE (WORK_TYPE2) — Foreign key → JOIN.WORK_TYPE
  • BUILD_TYPE (BUILD_TYPE2) — Foreign key → JOIN.BUILD_TYPE
  • KTREND_APT_SEQ (KTREND_APT_SEQ2) — Foreign key → JOIN.KTREND_APT_SEQ
  • KTREND_PYONG_SEQ — Foreign key → JOIN.KTREND_PYONG_SEQ
  • KTREND_DT (KTREND_DT3) — Foreign key → JOIN.KTREND_DT
  • WORK_TYPE (WORK_TYPE3) — Foreign key → JOIN.WORK_TYPE
  • BUILD_TYPE (BUILD_TYPE3) — Foreign key → JOIN.BUILD_TYPE
  • KTREND_APT_SEQ (KTREND_APT_SEQ3) — Foreign key → JOIN.KTREND_APT_SEQ
  • KTREND_DT (KTREND_DT4) — Foreign key → JOIN.KTREND_DT
  • WORK_TYPE (WORK_TYPE4) — Foreign key → JOIN.WORK_TYPE
  • BUILD_TYPE (BUILD_TYPE4) — Foreign key → JOIN.BUILD_TYPE
  • KTREND_APT_SEQ (KTREND_APT_SEQ4) — Foreign key → JOIN.KTREND_APT_SEQ
  • KTREND_HO_SEQ (KTREND_HO_SEQ2) — Foreign key → JOIN.KTREND_HO_SEQ
  • KTREND_DT (KTREND_DT5) — Foreign key
  • WORK_TYPE (WORK_TYPE5) — Foreign key
  • BUILD_TYPE (BUILD_TYPE5) — Foreign key
  • KTREND_APT_SEQ (KTREND_APT_SEQ5) — Foreign key
  • KTREND_PYONG_SEQ (KTREND_PYONG_SEQ2) — Foreign key → JOIN.KTREND_DONG_SEQ
  • KTREND_DONG_SEQ (SEQ2) — Foreign key → JOIN.KTREND_HO_SEQ
  • Key — Foreign key → JOIN.KTREND_DONG_SEQ — NOT NULL

KTREND_MASTER (주택동향 조사 단지)

  • KTREND_DT (조사시점) — Primary key — NOT NULL
  • WORK_TYPE (작업구분(1 : 주간 , 2: 월간)) — Primary key — NOT NULL
  • BUILD_TYPE (단지종류(1:공동, 2:단독)) — Primary key — NOT NULL
  • KTREND_APT_SEQ (단지코드) — Primary key — NOT NULL
  • APT_TYPE (단지종류)
  • USEAPR_DT (사용승인일)
  • DONG_CNT (단지별 동수)
  • HO_CNT (단지별 세대수)
  • AGENCY_INFO_SEQ (중개업소코드)
  • REG (시군구 코드)
  • EUB (웁면동 코드)
  • SAN (산지번)
  • BUN1 (본번)
  • BUN2 (부번)
  • KTREND_SEARCHER_SEQ (주택동향조사자)
  • OFFICE_INFO_SEQ (소속지사)
  • KTREND_TEAM_SEQ (표본지역 담당 팀)
  • STATE_CODE (조사상태)
  • FINISH_DATE (조사완료일자)
  • INS_LIMIT_YN (입력제한여부(0: 미마감, 1:마감))
  • BIZ_TYPE (사업유형)
  • REBUILD_TYPE (재건축유형)
  • RMS_YN (Field4)
  • SREG (시군구코드)
  • SEUB (읍면동코드)
  • SSAN (산구분)
  • SBUN1 (본번.)
  • SBUN2 (부번.)
  • INDEX_REG (지수 시군구 코드)
  • INDEX_EUB (지수 읍면동 코드)
  • INS_ID (입력 ID)
  • INS_DATE (입력일자)
  • CHG_ID (수정 ID)
  • CHG_DATE (수정일자)
  • OLD_WEEK_CNT ((구)주간표본수)
  • OLD_BRANCH_CD ((구)지사정보)
  • OLD_AGENCY_ID (Field2)
  • KTREND_DT (Field) — Foreign key → JOIN.KTREND_DT
  • WORK_TYPE (Field22) — Foreign key → JOIN.WORK_TYPE
  • REG (SREG) — Foreign key → JOIN.REG
  • EUB (SEUB) — Foreign key → JOIN.EUB
  • KTREND_DT — Foreign key → JOIN.KTREND_DT
  • WORK_TYPE — Foreign key → JOIN.WORK_TYPE
  • BUILD_TYPE — Foreign key → JOIN.BUILD_TYPE
  • KTREND_APT_SEQ — Foreign key → JOIN.KTREND_APT_SEQ
  • KTREND_PYONG_SEQ — Foreign key → JOIN.KTREND_PYONG_SEQ
  • KTREND_DT (KTREND_DT2) — Foreign key → JOIN.KTREND_DT
  • WORK_TYPE (WORK_TYPE2) — Foreign key → JOIN.WORK_TYPE
  • BUILD_TYPE (BUILD_TYPE2) — Foreign key → JOIN.BUILD_TYPE
  • KTREND_APT_SEQ (KTREND_APT_SEQ2) — Foreign key → JOIN.KTREND_APT_SEQ
  • KTREND_SEARCHER_SEQ (SEQ2) — Foreign key → JOIN.KTREND_SEARCHER_SEQ
  • KTREND_APT_SEQ (SEQ3) — Foreign key → JOIN.KTREND_APT_SEQ
  • KTREND_APT_SEQ (SEQ4) — Foreign key → JOIN.OFFICE_INFO_SEQ
  • KTREND_DONG_SEQ (SEQ5) — Foreign key → JOIN.KTREND_DONG_SEQ
  • KTREND_DONG_SEQ (SEQ6) — Foreign key → JOIN.KTREND_APT_SEQ
  • KTREND_DT (KTREND_DT3) — Foreign key → JOIN.KTREND_DT
  • WORK_TYPE (WORK_TYPE3) — Foreign key → JOIN.WORK_TYPE
  • BUILD_TYPE (BUILD_TYPE3) — Foreign key → JOIN.BUILD_TYPE
  • KTREND_APT_SEQ (KTREND_APT_SEQ3) — Foreign key → JOIN.KTREND_APT_SEQ

KTREND_MONTHLY_MARKERT_REPORT (주택동향 월간 시황입력정보)

  • KTREND_DT (조사시점) — Primary key — NOT NULL
  • WORK_TYPE (작업구분(1 : 주간 , 2: 월간)) — Primary key — NOT NULL
  • REG (시군구코드) — Primary key
  • CHG_DATE (수정일시)
  • CHG_ID ((기준)전세가격)
  • DEPOSIT_CONTENT (전세요약)
  • DEPOSIT_SUMMARY (전세 요약)
  • INS_DATE (입력일시)
  • INS_ID (입력ID)
  • INS_LIMIT_YN (입력여부(0:가능, 1:마감))
  • KTREND_TEAM_SEQ (담당 팀)
  • OFFICE_INFO_SEQ (지사코드)
  • OLD_BRANCH_CODE (지점코드)
  • RENT_CONTENT (월세요약)
  • RENT_SUMMARY (월세 요약)
  • SALE_CONTENT (매매요약)
  • SLAE_SUMMARY (매매 요약)
  • KTREND_HO_SEQ (SEQ) — Foreign key → JOIN.REG

KTREND_MONTHLY_PRICE (주택동향 월간 표본 가격정보)

  • KTREND_DT (조사시점) — Primary key — NOT NULL
  • WORK_TYPE (작업구분(1 : 주간 , 2: 월간)) — Primary key — NOT NULL
  • BUILD_TYPE (건물구분) — Primary key
  • KTREND_APT_SEQ (단지 SEQ) — Primary key
  • KTREND_DONG_SEQ (동SEQ) — Primary key
  • KTREND_HO_SEQ (호SEQ) — Primary key
  • RENT_PRICE (월세)
  • KEY_PRICE (보증금)
  • SALE_PRICE (매매가격)
  • DEPOSIT_PRICE (전세가격)
  • BASE_SALE_PRICE ((기준)매매가격)
  • BASE_DEPOSIT_PRICE ((기준)전세가격)
  • S_CASE_TYPE (선택 거래사례 타입)
  • S_CASE_SUB_TYPE (선택 거래사례 세부타입(매매))
  • S_CASE_SEQ (선택된 거래사례 SEQ)
  • S_PRICE_TEXT (거래사유 텍스트)
  • S_CHG_MCODE (매매가격 변동사유 메인코드)
  • S_CHG_SCODE (매매가격 변동사유 서브 코드)
  • S_CHG_TEXT (매매가격 변동사유 TEXT)
  • D_CASE_TYPE (선택 거래사례 타입(전세)
  • D_CASE_SUB_TYPE (선택 거래사례 타입(전세))
  • D_CASE_SEQ (선택된 거래사례 SEQ)
  • D_PRICE_TEXT (거래사유텍스트)
  • D_CHG_CODE (전세가격 변동사유 코드)
  • D_CHG_TEXT (매매가격 변동사유 TEXT)
  • S_BASIS_TYPE (가격판단근거)
  • S_PURCHASER_TYPE (수요구분)
  • S_PROSPECT_TYPE (전망구분)
  • EXCP_YN (제외여부(0 : 미제외, 1: 제외))
  • KTREND_APT_CODE (단지코드)
  • KTREND_DONG_CODE (동코드)
  • KTREND_HO_CODE (호코드)
  • INS_ID (입력ID)
  • INS_DATE (입력일자)
  • CHG_ID (수정ID)
  • CHG_DATE (수정일자)
  • S_RENT_PRICE (표준월세)
  • G_RENT_PRICE (보증부월세)
  • H_RENT_PRICE (반전세)
  • I_RENT_PRICE (통합월세(개선월세))
  • KTREND_DT — Foreign key → JOIN.KTREND_DT
  • WORK_TYPE — Foreign key → JOIN.WORK_TYPE
  • BUILD_TYPE — Foreign key → JOIN.BUILD_TYPE
  • KTREND_APT_SEQ — Foreign key → JOIN.KTREND_APT_SEQ
  • KTREND_HO_SEQ — Foreign key → JOIN.KTREND_HO_SEQ

KTREND_PYONG (주택동향조사 평)

  • KTREND_DT (조사시점) — Primary key — NOT NULL
  • WORK_TYPE (작업구분(1 : 주간 , 2: 월간)) — Primary key — NOT NULL
  • BUILD_TYPE (건물구분) — Primary key
  • KTREND_APT_SEQ (단지 SEQ) — Primary key
  • KTRNED_PYONG_SEQ (평 SEQ) — Primary key
  • PYONG (평)
  • PYONG_TYPE (평타입)
  • SUM_AREA (공급면적)
  • PRIV_AREA (공동주택 전용면적)
  • ETC_AREA (기타면적)
  • HO_CNT (평형별 세대수)
  • INS_ID (입력ID)
  • INS_DATE (입력일자)
  • KTREND_DT — Foreign key → JOIN.KTREND_DT
  • WORK_TYPE — Foreign key → JOIN.WORK_TYPE
  • BUILD_TYPE — Foreign key → JOIN.BUILD_TYPE
  • KTREND_APT_SEQ — Foreign key → JOIN.KTREND_APT_SEQ
  • KTREND_PYONG_SEQ — Foreign key → JOIN.KTREND_PYONG_SEQ
  • KTREND_DT (KTREND_DT2) — Foreign key → JOIN.KTREND_DT
  • WORK_TYPE (WORK_TYPE2) — Foreign key → JOIN.WORK_TYPE
  • BUILD_TYPE (BUILD_TYPE2) — Foreign key → JOIN.BUILD_TYPE
  • KTREND_APT_SEQ (KTREND_APT_SEQ2) — Foreign key → JOIN.KTREND_APT_SEQ
  • KTREND_PYONG_SEQ (KTREND_PYONG_SEQ2) — Foreign key → JOIN.KTREND_PYONG_SEQ

KTREND_REG_TEAM (주택동향 시군구별 관할지사- 팀)

  • REG (시군구코드) — Primary key
  • CHG_DATE (수정일시)
  • CHG_ID ((기준)전세가격)
  • INS_YN (등록여부)
  • KTREND_TEAM_SEQ (담당 팀)
  • OLD_BRANCH_CODE (지점코드)
  • OLD_TEAM_CODE (팀코드)
  • KTREND_HO_SEQ (SEQ) — Foreign key → JOIN.REG

KTREND_SEARCHER (주택동향조사자정보)

  • SEQ — Primary key — NOT NULL
  • MEMBER_INFO_SEQ (유저코드)
  • OFFICE_INFO_SEQ (지사코드)
  • KTRNED_TEAM_SEQ (팀코드)
  • USE_YN (사용여부)
  • PROXY_FLAG (결재상신대결자 권한)
  • MESSAGE_BLOCK (메세지 수신 차단)
  • KTREND_SEARCHER_SEQ (SEQ2) — Foreign key → JOIN.KTREND_SEARCHER_SEQ
  • MEMBER_INFO_SEQ (SEQ3) — Foreign key → JOIN.MEMBER_INFO_SEQ

KTREND_WEEKLY_PRICE (주택동향 주간 조사정보)

  • KTREND_DT (조사시점) — Primary key — NOT NULL
  • WORK_TYPE (작업구분(1 : 주간 , 2: 월간)) — Primary key — NOT NULL
  • BUILD_TYPE (건물구분) — Primary key
  • KTREND_APT_SEQ (단지 SEQ) — Primary key
  • KTREND_DONG_SEQ (동SEQ) — Primary key
  • KTREND_HO_SEQ (호SEQ) — Primary key
  • SALE_PRICE (매매가격)
  • DEPOSIT_PRICE (전세가격)
  • BASE_SALE_PRICE ((기준)매매가격)
  • BASE_DEPOSIT_PRICE ((기준)전세가격)
  • S_CASE_TYPE (선택 거래사례 타입)
  • S_CASE_SUB_TYPE (선택 거래사례 세부타입(매매))
  • S_CASE_SEQ (선택된 거래사례 SEQ)
  • S_PRICE_TEXT (거래사유 텍스트)
  • S_CHG_MCODE (매매가격 변동사유 메인코드)
  • S_CHG_SCODE (매매가격 변동사유 서브 코드)
  • S_CHG_TEXT (매매가격 변동사유 TEXT)
  • D_CASE_TYPE (선택 거래사례 타입(전세)
  • D_CASE_SUB_TYPE (선택 거래사례 타입(전세))
  • D_CASE_SEQ (선택된 거래사례 SEQ)
  • D_PRICE_TEXT (거래사유텍스트)
  • D_CHG_CODE (전세가격 변동사유 코드)
  • D_CHG_TEXT (매매가격 변동사유 TEXT)
  • S_BASIS_TYPE (가격판단근거)
  • S_PURCHASER_TYPE (수요구분)
  • S_PROSPECT_TYPE (전망구분)
  • EXCP_YN (제외여부(0 : 미제외, 1: 제외))
  • KTREND_APT_CODE (단지코드)
  • KTREND_DONG_CODE (동코드)
  • KTREND_HO_CODE (호코드)
  • INS_ID (입력ID)
  • INS_DATE (입력일자)
  • CHG_ID (수정ID)
  • CHG_DATE (수정일자)
  • KTREND_DT — Foreign key → JOIN.KTREND_DT
  • WORK_TYPE — Foreign key → JOIN.WORK_TYPE
  • BUILD_TYPE — Foreign key → JOIN.BUILD_TYPE
  • KTREND_APT_SEQ — Foreign key → JOIN.KTREND_APT_SEQ
  • KTREND_HO_SEQ — Foreign key → JOIN.KTREND_HO_SEQ
  • KTREND_DT (KTREND_DT2) — Foreign key → JOIN.KTREND_DT
  • WORK_TYPE (WORK_TYPE2) — Foreign key → JOIN.WORK_TYPE
  • KTREND_DT (KTREND_DT3) — Foreign key → JOIN.KTREND_DT
  • WORK_TYPE (WORK_TYPE3) — Foreign key → JOIN.WORK_TYPE
  • BUILD_TYPE (BUILD_TYPE2) — Foreign key → JOIN.BUILD_TYPE
  • KTREND_APT_SEQ (KTREND_APT_SEQ2) — Foreign key → JOIN.KTREND_APT_SEQ

MEMBER_INFO (회원정보)

  • SEQ
  • NAME (한글이름)
  • H_NAME (한자이름)
  • QUANO (자격번호)
  • OOFICE_INFO_SEQ (사무소코드)
  • MEMBER_INFO_SEQ (SEQ2) — Foreign key → JOIN.MEMBER_INFO_SEQ