P_GS_RIS_APT ERD
Tables (51)
MS_APTHALFINDEX
- GB — char(1) — Foreign key → MS_APTQINDEX.GB — NOT NULL
- JK_GB — char(1) — Foreign key → MS_APTQINDEX.JK_GB — NOT NULL
- JK_CODE — varchar(12) — Foreign key → MS_APTQINDEX.JK_CODE — NOT NULL
- GRP_CODE — char(3) — Foreign key → MS_APTQINDEX.GRP_CODE — NOT NULL
- TD — char(8) — Foreign key → MS_APTQINDEX.TD — NOT NULL
- MM_QCAP — numeric(18, 0)
- JS_QCAP — numeric(18, 0)
- WS_QCAP — numeric(18, 0)
- MM_HPRICE — numeric(12, 4)
- MM_LPRICE — numeric(12, 4)
- MM_APRICE — numeric(12, 4)
- JS_HPRICE — numeric(12, 4)
- JS_LPRICE — numeric(12, 4)
- JS_APRICE — numeric(12, 4)
- WS_HPRICE — numeric(12, 4)
- WS_LPRICE — numeric(12, 4)
- WS_APRICE — numeric(12, 4)
- MM_HCHG — numeric(9, 4)
- MM_LCHG — numeric(9, 4)
- MM_ACHG — numeric(9, 4)
- JS_HCHG — numeric(9, 4)
- JS_LCHG — numeric(9, 4)
- JS_ACHG — numeric(9, 4)
- WS_HCHG — numeric(9, 4)
- WS_LCHG — numeric(9, 4)
- WS_ACHG — numeric(9, 4)
- MM_HMCAP — numeric(18, 0)
- MM_LMCAP — numeric(18, 0)
- MM_AMCAP — numeric(18, 0)
- JS_HMCAP — numeric(18, 0)
- JS_LMCAP — numeric(18, 0)
- JS_AMCAP — numeric(18, 0)
- WS_HMCAP — numeric(18, 0)
- WS_LMCAP — numeric(18, 0)
- WS_AMCAP — numeric(18, 0)
- MM_HYOY — numeric(9, 4)
- MM_LYOY — numeric(9, 4)
- MM_AYOY — numeric(9, 4)
- JS_HYOY — numeric(9, 4)
- JS_LYOY — numeric(9, 4)
- JS_AYOY — numeric(9, 4)
- WS_HYOY — numeric(9, 4)
- WS_LYOY — numeric(9, 4)
- WS_AYOY — numeric(9, 4)
- MM_QTY — numeric(18, 0)
- JS_QTY — numeric(18, 0)
- WS_QTY — numeric(18, 0)
- MM_TCNT — numeric(18, 0)
- JS_TCNT — numeric(18, 0)
- WS_TCNT — numeric(18, 0)
- MM_TAMT — numeric(24, 6)
- JS_TAMT — numeric(24, 6)
- WS_TAMT — numeric(24, 6)
MS_APTHINDEX
- GB — char(1) — Primary key — NOT NULL
- JK_GB — char(1) — Foreign key → M_JK.JK_GB — NOT NULL
- JK_CODE — varchar(12) — Foreign key → M_JK.JK_CODE — NOT NULL
- GRP_CODE — char(3) — Foreign key → M_GRPLIST.GRP_CODE — NOT NULL
- TD — char(8) — Foreign key → M_DATE.TD — NOT NULL
- MM_QCAP — numeric(18, 0)
- JS_QCAP — numeric(18, 0)
- WS_QCAP — numeric(18, 0)
- MM_HPRICE — numeric(12, 4)
- MM_LPRICE — numeric(12, 4)
- MM_APRICE — numeric(12, 4)
- JS_HPRICE — numeric(12, 4)
- JS_LPRICE — numeric(12, 4)
- JS_APRICE — numeric(12, 4)
- WS_HPRICE — numeric(12, 4)
- WS_LPRICE — numeric(12, 4)
- WS_APRICE — numeric(12, 4)
- MM_HCHG — numeric(9, 4)
- MM_LCHG — numeric(9, 4)
- MM_ACHG — numeric(9, 4)
- JS_HCHG — numeric(9, 4)
- JS_LCHG — numeric(9, 4)
- JS_ACHG — numeric(9, 4)
- WS_HCHG — numeric(9, 4)
- WS_LCHG — numeric(9, 4)
- WS_ACHG — numeric(9, 4)
- MM_HMCAP — numeric(18, 0)
- MM_LMCAP — numeric(18, 0)
- MM_AMCAP — numeric(18, 0)
- JS_HMCAP — numeric(18, 0)
- JS_LMCAP — numeric(18, 0)
- JS_AMCAP — numeric(18, 0)
- WS_HMCAP — numeric(18, 0)
- WS_LMCAP — numeric(18, 0)
- WS_AMCAP — numeric(18, 0)
- MM_HMCAP_BASE — numeric(18, 0)
- MM_LMCAP_BASE — numeric(18, 0)
- MM_AMCAP_BASE — numeric(18, 0)
- JS_HMCAP_BASE — numeric(18, 0)
- JS_LMCAP_BASE — numeric(18, 0)
- JS_AMCAP_BASE — numeric(18, 0)
- WS_HMCAP_BASE — numeric(18, 0)
- WS_LMCAP_BASE — numeric(18, 0)
- WS_AMCAP_BASE — numeric(18, 0)
- MM_HMCAP_ADJ — numeric(18, 0)
- MM_LMCAP_ADJ — numeric(18, 0)
- MM_AMCAP_ADJ — numeric(18, 0)
- JS_HMCAP_ADJ — numeric(18, 0)
- JS_LMCAP_ADJ — numeric(18, 0)
- JS_AMCAP_ADJ — numeric(18, 0)
- WS_HMCAP_ADJ — numeric(18, 0)
- WS_LMCAP_ADJ — numeric(18, 0)
- WS_AMCAP_ADJ — numeric(18, 0)
- MM_QTY — numeric(18, 0)
- JS_QTY — numeric(18, 0)
- WS_QTY — numeric(18, 0)
- PTD — varchar(8)
- MM_TCNT — numeric(18, 0)
- JS_TCNT — numeric(18, 0)
- WS_TCNT — numeric(18, 0)
- … +6
MS_APTHPRICE
- AP_KIND — INT — Foreign key → M_APTSUB.AP_KIND — NOT NULL
- AP_TYPE — VARCHAR(15) — Foreign key → M_APTSUB.AP_TYPE — NOT NULL
- AP_CODE — VARCHAR(15) — Foreign key → M_APTSUB.AP_CODE — NOT NULL
- TD — char(8) — Foreign key → M_DATE.TD — NOT NULL
- BAREA — numeric(9, 2)
- QTY — int
- MM_HPRICE — numeric(18, 0)
- MM_LPRICE — numeric(18, 0)
- MM_APRICE — numeric(18, 0)
- JS_HPRICE — numeric(18, 0)
- JS_LPRICE — numeric(18, 0)
- JS_APRICE — numeric(18, 0)
- WS1_HPRICE — numeric(18, 0)
- WS1_LPRICE — numeric(18, 0)
- WS1_APRICE — numeric(18, 0)
- WS2_HPRICE — numeric(18, 0)
- WS2_LPRICE — numeric(18, 0)
- WS2_APRICE — numeric(18, 0)
- MM_HCHG — numeric(12, 6)
- MM_LCHG — numeric(12, 6)
- MM_ACHG — numeric(12, 6)
- JS_HCHG — numeric(12, 6)
- JS_LCHG — numeric(12, 6)
- JS_ACHG — numeric(12, 6)
- WS_HCHG — numeric(12, 6)
- WS_LCHG — numeric(12, 6)
- WS_ACHG — numeric(12, 6)
- MM_HMCAP — numeric(18, 0)
- MM_LMCAP — numeric(18, 0)
- MM_AMCAP — numeric(18, 0)
- JS_HMCAP — numeric(18, 0)
- JS_LMCAP — numeric(18, 0)
- JS_AMCAP — numeric(18, 0)
- WS_HMCAP — numeric(18, 0)
- WS_LMCAP — numeric(18, 0)
- WS_AMCAP — numeric(18, 0)
- MM_QCAP — numeric(18, 0)
- JS_QCAP — numeric(18, 0)
- WS_QCAP — numeric(18, 0)
- MM_CNT — int
- JS_CNT — int
- WS_CNT — int
- MM_AMT — numeric(18, 0)
- JS_AMT — numeric(18, 0)
- WS_AMT — numeric(18, 0)
- FLOOR_GB — numeric(18, 2)
MS_APTHPRICE_RIS
- AP_KIND — INT — Foreign key → MS_GIS_APT_PY_01.AP_KIND — NOT NULL
- AP_TYPE — VARCHAR(15) — Foreign key → MS_GIS_APT_PY_01.AP_TYPE — NOT NULL
- AP_CODE — VARCHAR(15) — Foreign key → MS_GIS_APT_PY_01.AP_CODE — NOT NULL
- TD — char(8) — Foreign key → MS_GIS_APT_PY_01.TD — NOT NULL
- BAREA — numeric(9, 2)
- QTY — numeric(18, 0)
- MM_LFPRICE — numeric(18, 0)
- MM_HFPRICE — numeric(18, 0)
- MM_HHFPRICE — numeric(18, 0)
- JS_LFPRICE — numeric(18, 0)
- JS_HFPRICE — numeric(18, 0)
- JS_HHFPRICE — numeric(18, 0)
- WS_LFPRICE — numeric(18, 0)
- WS_HFPRICE — numeric(18, 0)
- WS_HHFPRICE — numeric(18, 0)
- MM_LFMCAP — numeric(18, 0)
- MM_HFMCAP — numeric(18, 0)
- MM_HHFMCAP — numeric(18, 0)
- JS_LFMCAP — numeric(18, 0)
- JS_HFMCAP — numeric(18, 0)
- JS_HHFMCAP — numeric(18, 0)
- WS_LFMCAP — numeric(18, 0)
- WS_HFMCAP — numeric(18, 0)
- WS_HHFMCAP — numeric(18, 0)
- MM_QCAP — numeric(18, 0)
- JS_QCAP — numeric(18, 0)
- WS_QCAP — numeric(18, 0)
- MM_LCNT — numeric(18, 0)
- MM_HCNT — numeric(18, 0)
- MM_HHCNT — numeric(18, 0)
- JS_LCNT — numeric(18, 0)
- JS_HCNT — numeric(18, 0)
- JS_HHCNT — numeric(18, 0)
- WS_LCNT — numeric(18, 0)
- WS_HCNT — numeric(18, 0)
- WS_HHCNT — numeric(18, 0)
- MM_LAMT — numeric(18, 0)
- MM_HAMT — numeric(18, 0)
- MM_HHAMT — numeric(18, 0)
- JS_LAMT — numeric(18, 0)
- JS_HAMT — numeric(18, 0)
- JS_HHAMT — numeric(18, 0)
- WS_LAMT — numeric(18, 0)
- WS_HAMT — numeric(18, 0)
- WS_HHAMT — numeric(18, 0)
MS_APTHPRICE_RIS_PER
- AP_KIND — INT — Foreign key → MS_GIS_APT_PY_01.AP_KIND — NOT NULL
- AP_TYPE — VARCHAR(15) — Foreign key → MS_GIS_APT_PY_01.AP_TYPE — NOT NULL
- AP_CODE — VARCHAR(15) — Foreign key → MS_GIS_APT_PY_01.AP_CODE — NOT NULL
- TD — char(8) — Foreign key → MS_GIS_APT_PY_01.TD — NOT NULL
- BAREA — numeric(9, 2)
- AREA — numeric(9, 2)
- QTY — numeric(18, 0)
- MM_APRICE — numeric(18, 0)
- JS_APRICE — numeric(18, 0)
- MM_AMCAP — numeric(18, 0)
- JS_AMCAP — numeric(18, 0)
- MM_QCAP — numeric(18, 0)
- JS_QCAP — numeric(18, 0)
- MM_CNT — numeric(18, 0)
- JS_CNT — numeric(18, 0)
MS_APTMDISTR
- DEAL_GB — varchar(1) — Primary key — NOT NULL
- TD — char(8) — Foreign key → M_DATE.TD — NOT NULL
- GRP_CODE — char(3) — Foreign key → M_GRPLIST.GRP_CODE — NOT NULL
- GRP_LIST — varchar(12) — Foreign key → M_GRPLIST.GRP_LIST — NOT NULL
- JK_GB — char(1) — Foreign key → M_JK.JK_GB — NOT NULL
- JK_CODE — varchar(12) — Foreign key → M_JK.JK_CODE — NOT NULL
- H_00 — numeric(18, 0)
- H_10 — numeric(18, 0)
- H_11 — numeric(18, 0)
- H_12 — numeric(18, 0)
- H_13 — numeric(18, 0)
- H_14 — numeric(18, 0)
- H_15 — numeric(18, 0)
- H_16 — numeric(18, 0)
- H_17 — numeric(18, 0)
- H_18 — numeric(18, 0)
- H_19 — numeric(18, 0)
- H_20 — numeric(18, 0)
- H_21 — numeric(18, 0)
- H_22 — numeric(18, 0)
- H_23 — numeric(18, 0)
- H_24 — numeric(18, 0)
- H_25 — numeric(18, 0)
- H_26 — numeric(18, 0)
- H_27 — numeric(18, 0)
- H_28 — numeric(18, 0)
- H_29 — numeric(18, 0)
- H_30 — numeric(18, 0)
- H_31 — numeric(18, 0)
- H_32 — numeric(18, 0)
- H_33 — numeric(18, 0)
- H_34 — numeric(18, 0)
- H_35 — numeric(18, 0)
- H_36 — numeric(18, 0)
- H_37 — numeric(18, 0)
- H_38 — numeric(18, 0)
- H_39 — numeric(18, 0)
- H_40 — numeric(18, 0)
- H_41 — numeric(18, 0)
- H_42 — numeric(18, 0)
- H_43 — numeric(18, 0)
MS_APTQINDEX
- GB — char(1) — Foreign key → MS_APTHINDEX.GB — NOT NULL
- JK_GB — char(1) — Foreign key → MS_APTHINDEX.JK_GB — NOT NULL
- JK_CODE — varchar(12) — Foreign key → MS_APTHINDEX.JK_CODE — NOT NULL
- GRP_CODE — char(3) — Foreign key → MS_APTHINDEX.GRP_CODE — NOT NULL
- TD — char(8) — Foreign key → MS_APTHINDEX.TD — NOT NULL
- MM_QCAP — numeric(18, 0)
- JS_QCAP — numeric(18, 0)
- WS_QCAP — numeric(18, 0)
- MM_HPRICE — numeric(12, 4)
- MM_LPRICE — numeric(12, 4)
- MM_APRICE — numeric(12, 4)
- JS_HPRICE — numeric(12, 4)
- JS_LPRICE — numeric(12, 4)
- JS_APRICE — numeric(12, 4)
- WS_HPRICE — numeric(12, 4)
- WS_LPRICE — numeric(12, 4)
- WS_APRICE — numeric(12, 4)
- MM_HCHG — numeric(9, 4)
- MM_LCHG — numeric(9, 4)
- MM_ACHG — numeric(9, 4)
- JS_HCHG — numeric(9, 4)
- JS_LCHG — numeric(9, 4)
- JS_ACHG — numeric(9, 4)
- WS_HCHG — numeric(9, 4)
- WS_LCHG — numeric(9, 4)
- WS_ACHG — numeric(9, 4)
- MM_HMCAP — numeric(18, 0)
- MM_LMCAP — numeric(18, 0)
- MM_AMCAP — numeric(18, 0)
- JS_HMCAP — numeric(18, 0)
- JS_LMCAP — numeric(18, 0)
- JS_AMCAP — numeric(18, 0)
- WS_HMCAP — numeric(18, 0)
- WS_LMCAP — numeric(18, 0)
- WS_AMCAP — numeric(18, 0)
- MM_HYOY — numeric(9, 4)
- MM_LYOY — numeric(9, 4)
- MM_AYOY — numeric(9, 4)
- JS_HYOY — numeric(9, 4)
- JS_LYOY — numeric(9, 4)
- JS_AYOY — numeric(9, 4)
- WS_HYOY — numeric(9, 4)
- WS_LYOY — numeric(9, 4)
- WS_AYOY — numeric(9, 4)
- MM_QTY — numeric(18, 0)
- JS_QTY — numeric(18, 0)
- WS_QTY — numeric(18, 0)
- MM_TCNT — numeric(18, 0)
- JS_TCNT — numeric(18, 0)
- WS_TCNT — numeric(18, 0)
- MM_TAMT — numeric(24, 6)
- JS_TAMT — numeric(24, 6)
- WS_TAMT — numeric(24, 6)
MS_APTYINDEX
- GB — char(1) — Foreign key → MS_APTHALFINDEX.GB — NOT NULL
- JK_GB — char(1) — Foreign key → MS_APTHALFINDEX.JK_GB — NOT NULL
- JK_CODE — varchar(12) — Foreign key → MS_APTHALFINDEX.JK_CODE — NOT NULL
- GRP_CODE — char(3) — Foreign key → MS_APTHALFINDEX.GRP_CODE — NOT NULL
- TD — char(8) — Foreign key → MS_APTHALFINDEX.TD — NOT NULL
- MM_QCAP — numeric(18, 0)
- JS_QCAP — numeric(18, 0)
- WS_QCAP — numeric(18, 0)
- MM_HPRICE — numeric(12, 4)
- MM_LPRICE — numeric(12, 4)
- MM_APRICE — numeric(12, 4)
- JS_HPRICE — numeric(12, 4)
- JS_LPRICE — numeric(12, 4)
- JS_APRICE — numeric(12, 4)
- WS_HPRICE — numeric(12, 4)
- WS_LPRICE — numeric(12, 4)
- WS_APRICE — numeric(12, 4)
- MM_HCHG — numeric(9, 4)
- MM_LCHG — numeric(9, 4)
- MM_ACHG — numeric(9, 4)
- JS_HCHG — numeric(9, 4)
- JS_LCHG — numeric(9, 4)
- JS_ACHG — numeric(9, 4)
- WS_HCHG — numeric(9, 4)
- WS_LCHG — numeric(9, 4)
- WS_ACHG — numeric(9, 4)
- MM_HMCAP — numeric(18, 0)
- MM_LMCAP — numeric(18, 0)
- MM_AMCAP — numeric(18, 0)
- JS_HMCAP — numeric(18, 0)
- JS_LMCAP — numeric(18, 0)
- JS_AMCAP — numeric(18, 0)
- WS_HMCAP — numeric(18, 0)
- WS_LMCAP — numeric(18, 0)
- WS_AMCAP — numeric(18, 0)
- MM_HYOY — numeric(9, 4)
- MM_LYOY — numeric(9, 4)
- MM_AYOY — numeric(9, 4)
- JS_HYOY — numeric(9, 4)
- JS_LYOY — numeric(9, 4)
- JS_AYOY — numeric(9, 4)
- WS_HYOY — numeric(9, 4)
- WS_LYOY — numeric(9, 4)
- WS_AYOY — numeric(9, 4)
- MM_QTY — numeric(18, 0)
- JS_QTY — numeric(18, 0)
- WS_QTY — numeric(18, 0)
- MM_TCNT — numeric(18, 0)
- JS_TCNT — numeric(18, 0)
- WS_TCNT — numeric(18, 0)
- MM_TAMT — numeric(24, 6)
- JS_TAMT — numeric(24, 6)
- WS_TAMT — numeric(24, 6)
MS_GIS_APT_PY
- 아파트구분 (AP_GB) — CHAR(1) — Foreign key → M_APT_MAST.아파트구분 — NOT NULL
- AP_CODE — VARCHAR(15) — Foreign key → M_APT_MAST.AP_CODE — NOT NULL
- JK_CODE — varchar(12) — Foreign key → M_JK.JK_CODE — NOT NULL
- TD — char(8) — Foreign key → M_DATE.TD — NOT NULL
- GB — varchar(50) — NOT NULL
- QTY — numeric(18, 0)
- IBJU_DT — varchar(100)
- PX — varchar(500)
- PY — varchar(500)
- MM_AMCAP — numeric(18, 0)
- MM_QCAP — numeric(18, 0)
- JS_AMCAP — numeric(18, 0)
- JS_QCAP — numeric(18, 0)
- WS_AMCAP — numeric(18, 0)
- WS_QCAP — numeric(18, 0)
- AP_QTY — numeric(18, 0)
- WS_R — numeric(18, 4)
- JS_CV — numeric(18, 4)
- JS_CV_R — numeric(18, 4)
- CON_NM — varchar(2000)
- LINE — varchar(2000)
- SWAY_NM — varchar(1000)
- IBJUDT — varchar(100)
- JUNGONDDT — varchar(100)
- TOTFLOOR — varchar(600)
- DONGCNT — varchar(500)
- NANBANG — varchar(1000)
- NANBANGTYPE — varchar(1000)
- RATIO — numeric(18, 2)
- TOTCAR — numeric(18, 0)
- LIFE — numeric(18, 0)
- MINKIND — varchar(500)
- MAXKIND — varchar(500)
- GONGGOIMG — varchar(2000)
MS_GIS_APT_PY_01
- AP_KIND — INT — Foreign key → MS_APTHPRICE.AP_KIND — NOT NULL
- AP_TYPE — VARCHAR(15) — Foreign key → MS_APTHPRICE.AP_TYPE — NOT NULL
- AP_CODE — VARCHAR(15) — Foreign key → MS_APTHPRICE.AP_CODE — NOT NULL
- TD — char(8) — Foreign key → MS_APTHPRICE.TD — NOT NULL
- GB — varchar(50) — NOT NULL
- AP_NM — varchar(50) — NOT NULL
- JK_CODE — varchar(12) — NOT NULL
- BAREA — numeric(18, 0)
- QTY — numeric(18, 0)
- IBJU_DT — varchar(100)
- PX — varchar(500)
- PY — varchar(500)
- MM_LFMCAP — numeric(18, 0)
- MM_HFMCAP — numeric(18, 0)
- MM_HHFMCAP — numeric(18, 0)
- JS_LFMCAP — numeric(18, 0)
- JS_HFMCAP — numeric(18, 0)
- JS_HHFMCAP — numeric(18, 0)
- WS_LFMCAP — numeric(18, 0)
- WS_HFMCAP — numeric(18, 0)
- WS_HHFMCAP — numeric(18, 0)
- MM_QCAP — numeric(18, 0)
- JS_QCAP — numeric(18, 0)
- WS_QCAP — numeric(18, 0)
- MM_LCNT — numeric(18, 0)
- MM_HCNT — numeric(18, 0)
- MM_HHCNT — numeric(18, 0)
- JS_LCNT — numeric(18, 0)
- JS_HCNT — numeric(18, 0)
- JS_HHCNT — numeric(18, 0)
- WS_LCNT — numeric(18, 0)
- WS_HCNT — numeric(18, 0)
- WS_HHCNT — numeric(18, 0)
- MM_LAMT — numeric(18, 0)
- MM_HAMT — numeric(18, 0)
- MM_HHAMT — numeric(18, 0)
- JS_LAMT — numeric(18, 0)
- JS_HAMT — numeric(18, 0)
- JS_HHAMT — numeric(18, 0)
- WS_LAMT — numeric(18, 0)
- WS_HAMT — numeric(18, 0)
- WS_HHAMT — numeric(18, 0)
- AP_QTY — numeric(18, 0)
- CON_NM — varchar(2000)
- LINE — varchar(2000)
- SWAY_NM — varchar(1000)
- JUNGONGDT — varchar(100)
- TOTFLOOR — varchar(600)
- DONGCNT — varchar(500)
- NANBANG — varchar(1000)
- NANBANGTYPE — varchar(1000)
- RATIO — numeric(18, 2)
- TOTCAR — numeric(18, 0)
- LIFE — numeric(18, 0)
- GONGGOIMG — varchar(2000)
M_APT
- AP_CODE — VARCHAR(15) — Primary key — NOT NULL
- AP_NM — VARCHAR(100)
- AP_UH — CHAR(1)
- JK_CODE — VARCHAR(12)
- JU_CODE — VARCHAR(20)
- SINDOSI — VARCHAR(12)
- NTOWN — VARCHAR(12)
- JIGU — VARCHAR(12)
- SA_UH — CHAR(1)
- YEOKSE — CHAR(1)
- JUSANG — CHAR(1)
- JAPT — CHAR(1)
- IMDAE — CHAR(1)
- QTY — NUMERIC(18,0)
- GQTY — NUMERIC(18,0)
- JQTY — NUMERIC(18,0)
- IBJU_DT — VARCHAR(8)
- BUN_DT — VARCHAR(8)
- LIFE — NUMERIC(9,2)
- CONS_GB — CHAR(1)
- BK_CODE — VARCHAR(15)
- DELIST — CHAR(1)
M_APTBPRICE
- JK_GB — char(1) — Primary key — NOT NULL
- JK_CODE — varchar(12) — Primary key — NOT NULL
- AP_UH — char(2) — Primary key — NOT NULL
- GRP_CODE — varchar(12) — Primary key — NOT NULL
- GRP_LIST — varchar(12) — Primary key — NOT NULL
- BUN_DT — varchar(12) — Primary key — NOT NULL
- PRICE — numeric(18, 0)
M_APTBSUPPLY
- JK_GB — char(1) — Foreign key → M_APTBPRICE.JK_GB — NOT NULL
- JK_CODE — varchar(12) — Foreign key → M_APTBPRICE.JK_CODE — NOT NULL
- AP_UH — char(2) — Foreign key → M_APTBPRICE.AP_UH — NOT NULL
- BUN_DT — varchar(12) — Foreign key → M_APTBPRICE.BUN_DT — NOT NULL
- GRP_CODE — char(3) — Foreign key → M_GRPLIST.GRP_CODE — NOT NULL
- GRP_LIST — varchar(12) — Foreign key → M_GRPLIST.GRP_LIST — NOT NULL
- QTY — numeric(18, 0)
- GQTY — numeric(18, 0)
- JQTY — numeric(18, 0)
M_APTCYAK_R
- AP_KIND — INT — Foreign key → M_APTSUB.AP_KIND — NOT NULL
- AP_TYPE — VARCHAR(15) — Foreign key → M_APTSUB.AP_TYPE — NOT NULL
- AP_CODE — VARCHAR(15) — Foreign key → M_APTSUB.AP_CODE — NOT NULL
- BAREA — numeric(9, 2)
- AREA — numeric(9, 2)
- JK_CODE — varchar(12)
- GUBN — char(1)
- BUN_GB — char(1)
- TD — char(6)
- BUN_DT — varchar(12)
- IBJU_DT — char(8)
- PR_S1 — numeric(9, 0)
- PR_D1 — numeric(9, 0)
- PR_M1 — numeric(9, 0)
- PR_R1 — numeric(9, 4)
- PR_S2 — numeric(9, 0)
- PR_A2 — numeric(9, 0)
- PR_D2 — numeric(9, 0)
- PR_C2 — numeric(9, 0)
- PR_M2 — numeric(9, 0)
- PR_R2 — numeric(9, 4)
- MU_S1 — numeric(9, 0)
- MU_A1 — numeric(9, 0)
- MU_D1 — numeric(9, 0)
- MU_C1 — numeric(9, 0)
- MU_M1 — numeric(9, 0)
- MU_R1 — numeric(9, 4)
- MU_S2 — numeric(9, 0)
- MU_A2 — numeric(9, 0)
- MU_D2 — numeric(9, 0)
- MU_C2 — numeric(9, 0)
- MU_M2 — numeric(9, 0)
- MU_R2 — numeric(9, 4)
- R1_S1 — numeric(9, 0)
- R1_A1 — numeric(9, 0)
- R1_D1 — numeric(9, 0)
- R1_C1 — numeric(9, 0)
- R1_M1 — numeric(9, 0)
- R1_R1 — numeric(9, 4)
- R1_S2 — numeric(9, 0)
- R1_A2 — numeric(9, 0)
- R1_D2 — numeric(9, 0)
- R1_C2 — numeric(9, 0)
- R1_M2 — numeric(9, 0)
- R1_R2 — numeric(9, 4)
- R2_S1 — numeric(9, 0)
- R2_A1 — numeric(9, 0)
- R2_D1 — numeric(9, 0)
- R2_C1 — numeric(9, 0)
- R2_M1 — numeric(9, 0)
- R2_R1 — numeric(9, 4)
- R2_S2 — numeric(9, 0)
- R2_A2 — numeric(9, 0)
- R2_D2 — numeric(9, 0)
- R2_C2 — numeric(9, 0)
- R2_M2 — numeric(9, 0)
- R2_R2 — numeric(9, 4)
- R3_S1 — numeric(9, 0)
- R3_A1 — numeric(9, 0)
- R3_D1 — numeric(9, 0)
- … +35
M_APTHALFINDEX
- JK_GB — char(1) — Foreign key → M_APTQINDEX.JK_GB — NOT NULL
- JK_CODE — varchar(12) — Foreign key → M_APTQINDEX.JK_CODE — NOT NULL
- GB (GB2) — char(1) — Foreign key → M_APTQINDEX.GB — NOT NULL
- GRP_CODE — varchar(12) — Foreign key → M_APTQINDEX.GRP_CODE — NOT NULL
- TD — char(8) — Foreign key → M_APTQINDEX.TD — NOT NULL
- MM_QCAP — numeric(18, 0)
- JS_QCAP — numeric(18, 0)
- MM_HPRICE — numeric(12, 4)
- MM_LPRICE — numeric(12, 4)
- MM_APRICE — numeric(12, 4)
- JS_HPRICE — numeric(12, 4)
- JS_LPRICE — numeric(12, 4)
- JS_APRICE — numeric(12, 4)
- MM_HCHG — numeric(9, 4)
- MM_LCHG — numeric(9, 4)
- MM_ACHG — numeric(9, 4)
- JS_HCHG — numeric(9, 4)
- JS_LCHG — numeric(9, 4)
- JS_ACHG — numeric(9, 4)
- MM_HMCAP — numeric(18, 0)
- MM_LMCAP — numeric(18, 0)
- MM_AMCAP — numeric(18, 0)
- JS_HMCAP — numeric(18, 0)
- JS_LMCAP — numeric(18, 0)
- JS_AMCAP — numeric(18, 0)
- MM_HYOY — numeric(9, 4)
- MM_LYOY — numeric(9, 4)
- MM_AYOY — numeric(9, 4)
- JS_HYOY — numeric(9, 4)
- JS_LYOY — numeric(9, 4)
- JS_AYOY — numeric(9, 4)
- MM_QTY — numeric(18, 0)
- JS_QTY — numeric(18, 0)
M_APTHINDEX
- GB (GB2) — char(1) — Foreign key → M_APTMINDEX.GB — NOT NULL
- GRP_CODE (GRP_CODE2) — varchar(12) — Foreign key → M_APTMINDEX.GRP_CODE — NOT NULL
- TD — char(8) — Foreign key → M_APTMINDEX.TD — NOT NULL
- GRP_CODE — char(3) — Foreign key → M_GRPLIST.GRP_CODE — NOT NULL
- GRP_LIST — varchar(12) — Foreign key → M_GRPLIST.GRP_LIST — NOT NULL
- JK_GB (JK_GB2) — char(1) — Foreign key → M_JK.JK_GB — NOT NULL
- JK_CODE (JK_CODE2) — varchar(12) — Foreign key → M_JK.JK_CODE — NOT NULL
- JK_GB — char(1) — NOT NULL
- JK_CODE — varchar(12) — NOT NULL
- GB — char(1) — NOT NULL
- MM_QCAP — numeric(18, 0)
- JS_QCAP — numeric(18, 0)
- MM_HPRICE — numeric(12, 4)
- MM_LPRICE — numeric(12, 4)
- MM_APRICE — numeric(12, 4)
- JS_HPRICE — numeric(12, 4)
- JS_LPRICE — numeric(12, 4)
- JS_APRICE — numeric(12, 4)
- MM_HCHG — numeric(9, 4)
- MM_LCHG — numeric(9, 4)
- MM_ACHG — numeric(9, 4)
- JS_HCHG — numeric(9, 4)
- JS_LCHG — numeric(9, 4)
- JS_ACHG — numeric(9, 4)
- MM_HMCAP — numeric(18, 0)
- MM_LMCAP — numeric(18, 0)
- MM_AMCAP — numeric(18, 0)
- JS_HMCAP — numeric(18, 0)
- JS_LMCAP — numeric(18, 0)
- JS_AMCAP — numeric(18, 0)
- MM_HMCAP_BASE — numeric(18, 0)
- MM_LMCAP_BASE — numeric(18, 0)
- MM_AMCAP_BASE — numeric(18, 0)
- JS_HMCAP_BASE — numeric(18, 0)
- JS_LMCAP_BASE — numeric(18, 0)
- JS_AMCAP_BASE — numeric(18, 0)
- MM_HMCAP_ADJ — numeric(18, 0)
- MM_LMCAP_ADJ — numeric(18, 0)
- MM_AMCAP_ADJ — numeric(18, 0)
- JS_HMCAP_ADJ — numeric(18, 0)
- JS_LMCAP_ADJ — numeric(18, 0)
- JS_AMCAP_ADJ — numeric(18, 0)
- MM_QTY — numeric(18, 0)
- JS_QTY — numeric(18, 0)
- PTD — varchar(8)
M_APTHPRICE
- AP_KIND — int — Primary key — NOT NULL
- AP_TYPE — varchar(15) — Primary key — NOT NULL
- AP_CODE — VARCHAR(15) — Foreign key → M_APT.AP_CODE — NOT NULL
- FD (TD) — char(8) — Foreign key → M_DATE.TD — NOT NULL
- BAREA — numeric(9, 2)
- QTY — int
- MM_HPRICE — numeric(18, 0)
- MM_LPRICE — numeric(18, 0)
- MM_APRICE — numeric(18, 0)
- JS_HPRICE — numeric(18, 0)
- JS_LPRICE — numeric(18, 0)
- JS_APRICE — numeric(18, 0)
- MM_HCHG — numeric(12, 6)
- MM_LCHG — numeric(12, 6)
- MM_ACHG — numeric(12, 6)
- JS_HCHG — numeric(12, 6)
- JS_LCHG — numeric(12, 6)
- JS_ACHG — numeric(12, 6)
- MM_HMCAP — numeric(18, 0)
- MM_LMCAP — numeric(18, 0)
- MM_AMCAP — numeric(18, 0)
- JS_HMCAP — numeric(18, 0)
- JS_LMCAP — numeric(18, 0)
- JS_AMCAP — numeric(18, 0)
- MM_QCAP — numeric(18, 0)
- JS_QCAP — numeric(18, 0)
M_APTMINDEX
- JK_GB — char(1) — Primary key — NOT NULL
- JK_CODE — varchar(12) — Primary key — NOT NULL
- GB — char(1) — Primary key — NOT NULL
- GRP_CODE — varchar(12) — Primary key — NOT NULL
- TD — char(8) — Primary key — NOT NULL
- MM_QCAP — numeric(18, 0)
- JS_QCAP — numeric(18, 0)
- MM_HPRICE — numeric(12, 4)
- MM_LPRICE — numeric(12, 4)
- MM_APRICE — numeric(12, 4)
- JS_HPRICE — numeric(12, 4)
- JS_LPRICE — numeric(12, 4)
- JS_APRICE — numeric(12, 4)
- MM_HCHG — numeric(9, 4)
- MM_LCHG — numeric(9, 4)
- MM_ACHG — numeric(9, 4)
- JS_HCHG — numeric(9, 4)
- JS_LCHG — numeric(9, 4)
- JS_ACHG — numeric(9, 4)
- MM_HMCAP — numeric(18, 0)
- MM_LMCAP — numeric(18, 0)
- MM_AMCAP — numeric(18, 0)
- JS_HMCAP — numeric(18, 0)
- JS_LMCAP — numeric(18, 0)
- JS_AMCAP — numeric(18, 0)
- MM_HYOY — numeric(9, 4)
- MM_LYOY — numeric(9, 4)
- MM_AYOY — numeric(9, 4)
- JS_HYOY — numeric(9, 4)
- JS_LYOY — numeric(9, 4)
- JS_AYOY — numeric(9, 4)
- MM_QTY — numeric(18, 0)
- JS_QTY — numeric(18, 0)
M_APTMPRICE
- AP_KIND — int — Foreign key → M_APTHPRICE.AP_KIND — NOT NULL
- AP_TYPE — varchar(15) — Foreign key → M_APTHPRICE.AP_TYPE — NOT NULL
- AP_CODE — VARCHAR(15) — Foreign key → M_APTHPRICE.AP_CODE — NOT NULL
- FD (TD) — char(8) — Foreign key → M_APTHPRICE.FD — NOT NULL
- BAREA — numeric(9, 2)
- QTY — int
- MM_HPRICE — numeric(18, 0)
- MM_LPRICE — numeric(18, 0)
- MM_APRICE — numeric(18, 0)
- JS_HPRICE — numeric(18, 0)
- JS_LPRICE — numeric(18, 0)
- JS_APRICE — numeric(18, 0)
- MM_HCHG — numeric(9, 4)
- MM_LCHG — numeric(9, 4)
- MM_ACHG — numeric(9, 4)
- JS_HCHG — numeric(9, 4)
- JS_LCHG — numeric(9, 4)
- JS_ACHG — numeric(9, 4)
- MM_HMCAP — numeric(18, 0)
- MM_LMCAP — numeric(18, 0)
- MM_AMCAP — numeric(18, 0)
- JS_HMCAP — numeric(18, 0)
- JS_LMCAP — numeric(18, 0)
- JS_AMCAP — numeric(18, 0)
- MM_HYOY — numeric(9, 4)
- MM_LYOY — numeric(9, 4)
- MM_AYOY — numeric(9, 4)
- JS_HYOY — numeric(9, 4)
- JS_LYOY — numeric(9, 4)
- JS_AYOY — numeric(9, 4)
M_APTQINDEX
- JK_GB — char(1) — Foreign key → M_APTMINDEX.JK_GB — NOT NULL
- JK_CODE — varchar(12) — Foreign key → M_APTMINDEX.JK_CODE — NOT NULL
- GB (GB2) — char(1) — Foreign key → M_APTMINDEX.GB — NOT NULL
- GRP_CODE — varchar(12) — Foreign key → M_APTMINDEX.GRP_CODE — NOT NULL
- TD — char(8) — Foreign key → M_APTMINDEX.TD — NOT NULL
- MM_QCAP — numeric(18, 0)
- JS_QCAP — numeric(18, 0)
- MM_HPRICE — numeric(12, 4)
- MM_LPRICE — numeric(12, 4)
- MM_APRICE — numeric(12, 4)
- JS_HPRICE — numeric(12, 4)
- JS_LPRICE — numeric(12, 4)
- JS_APRICE — numeric(12, 4)
- MM_HCHG — numeric(9, 4)
- MM_LCHG — numeric(9, 4)
- MM_ACHG — numeric(9, 4)
- JS_HCHG — numeric(9, 4)
- JS_LCHG — numeric(9, 4)
- JS_ACHG — numeric(9, 4)
- MM_HMCAP — numeric(18, 0)
- MM_LMCAP — numeric(18, 0)
- MM_AMCAP — numeric(18, 0)
- JS_HMCAP — numeric(18, 0)
- JS_LMCAP — numeric(18, 0)
- JS_AMCAP — numeric(18, 0)
- MM_HYOY — numeric(9, 4)
- MM_LYOY — numeric(9, 4)
- MM_AYOY — numeric(9, 4)
- JS_HYOY — numeric(9, 4)
- JS_LYOY — numeric(9, 4)
- JS_AYOY — numeric(9, 4)
- MM_QTY — numeric(18, 0)
- JS_QTY — numeric(18, 0)
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
M_APTQPRICE
- AP_KIND — int — Foreign key → M_APTMPRICE.AP_KIND — NOT NULL
- AP_TYPE — varchar(15) — Foreign key → M_APTMPRICE.AP_TYPE — NOT NULL
- AP_CODE — VARCHAR(15) — Foreign key → M_APTMPRICE.AP_CODE — NOT NULL
- FD (TD) — char(8) — Foreign key → M_APTMPRICE.FD — NOT NULL
- BAREA — numeric(9, 2)
- QTY — int
- MM_HPRICE — numeric(18, 0)
- MM_LPRICE — numeric(18, 0)
- MM_APRICE — numeric(18, 0)
- JS_HPRICE — numeric(18, 0)
- JS_LPRICE — numeric(18, 0)
- JS_APRICE — numeric(18, 0)
- MM_HCHG — numeric(9, 4)
- MM_LCHG — numeric(9, 4)
- MM_ACHG — numeric(9, 4)
- JS_HCHG — numeric(9, 4)
- JS_LCHG — numeric(9, 4)
- JS_ACHG — numeric(9, 4)
- MM_HMCAP — numeric(18, 0)
- MM_LMCAP — numeric(18, 0)
- MM_AMCAP — numeric(18, 0)
- JS_HMCAP — numeric(18, 0)
- JS_LMCAP — numeric(18, 0)
- JS_AMCAP — numeric(18, 0)
- MM_HYOY — numeric(9, 4)
- MM_LYOY — numeric(9, 4)
- MM_AYOY — numeric(9, 4)
- JS_HYOY — numeric(9, 4)
- JS_LYOY — numeric(9, 4)
- JS_AYOY — numeric(9, 4)
M_APTSUB
- AP_KIND — INT — Primary key — NOT NULL
- AP_TYPE — VARCHAR(15) — Primary key — NOT NULL
- AP_CODE — VARCHAR(15) — Foreign key → M_APT_MAST.AP_CODE — NOT NULL
- BAREA — NUMERIC(9,2)
- AREA — NUMERIC(9,2)
- QTY — INT
- BQTY — INT
- BPRICE — NUMERIC(18,0)
- MM_PY — NUMERIC(18,0)
- JS_PY — NUMERIC(18,0)
- MM_PRICE — NUMERIC(18,0)
- JS_PRICE — NUMERIC(18,0)
M_APTSUB_MAST
- AP_GB — CHAR(1) — Primary key — NOT NULL
- AP_KIND — INT — Foreign key → M_APTSUB.AP_KIND — NOT NULL
- AP_TYPE — VARCHAR(15) — Foreign key → M_APTSUB.AP_TYPE — NOT NULL
- AP_CODE — VARCHAR(20) — Foreign key → M_APTSUB.AP_CODE — NOT NULL
- BAREA — NUMERIC(9,2)
- AREA — NUMERIC(9,2)
- QTY — INT
- BQTY — INT
- BPRICE — NUMERIC(18,0)
- MM_PY — NUMERIC(18,0)
- JS_PY — NUMERIC(18,0)
- MM_PRICE — NUMERIC(18,0)
- JS_PRICE — NUMERIC(18,0)
M_APTSUPPLY
- PROC_GB — char(1) — Primary key — NOT NULL
- AP_UH — char(2) — Primary key — NOT NULL
- GRP_CODE — varchar(12) — Primary key — NOT NULL
- GRP_LIST — varchar(12) — Primary key — NOT NULL
- IBJU_CD — varchar(12) — Primary key — NOT NULL
- JK_GB — char(1) — Foreign key → M_JK.JK_GB — NOT NULL
- JK_CODE — varchar(12) — Foreign key → M_JK.JK_CODE — NOT NULL
- QTY — numeric(18, 0)
M_APTYINDEX
- JK_GB — char(1) — Foreign key → M_APTHALFINDEX.JK_GB — NOT NULL
- JK_CODE — varchar(12) — Foreign key → M_APTHALFINDEX.JK_CODE — NOT NULL
- GB (GB2) — char(1) — Foreign key → M_APTHALFINDEX.GB — NOT NULL
- GRP_CODE — varchar(12) — Foreign key → M_APTHALFINDEX.GRP_CODE — NOT NULL
- TD — char(8) — Foreign key → M_APTHALFINDEX.TD — NOT NULL
- MM_QCAP — numeric(18, 0)
- JS_QCAP — numeric(18, 0)
- MM_HPRICE — numeric(12, 4)
- MM_LPRICE — numeric(12, 4)
- MM_APRICE — numeric(12, 4)
- JS_HPRICE — numeric(12, 4)
- JS_LPRICE — numeric(12, 4)
- JS_APRICE — numeric(12, 4)
- MM_HCHG — numeric(9, 4)
- MM_LCHG — numeric(9, 4)
- MM_ACHG — numeric(9, 4)
- JS_HCHG — numeric(9, 4)
- JS_LCHG — numeric(9, 4)
- JS_ACHG — numeric(9, 4)
- MM_HMCAP — numeric(18, 0)
- MM_LMCAP — numeric(18, 0)
- MM_AMCAP — numeric(18, 0)
- JS_HMCAP — numeric(18, 0)
- JS_LMCAP — numeric(18, 0)
- JS_AMCAP — numeric(18, 0)
- MM_QTY — numeric(18, 0)
- JS_QTY — numeric(18, 0)
M_APTYPRICE
- AP_KIND — int — Foreign key → M_APTQPRICE.AP_KIND — NOT NULL
- AP_TYPE — varchar(15) — Foreign key → M_APTQPRICE.AP_TYPE — NOT NULL
- AP_CODE — VARCHAR(15) — Foreign key → M_APTQPRICE.AP_CODE — NOT NULL
- FD (TD) — char(8) — Foreign key → M_APTQPRICE.FD — NOT NULL
- BAREA — numeric(9, 2)
- QTY — int
- MM_HPRICE — numeric(18, 0)
- MM_LPRICE — numeric(18, 0)
- MM_APRICE — numeric(18, 0)
- JS_HPRICE — numeric(18, 0)
- JS_LPRICE — numeric(18, 0)
- JS_APRICE — numeric(18, 0)
- MM_HCHG — numeric(9, 4)
- MM_LCHG — numeric(9, 4)
- MM_ACHG — numeric(9, 4)
- JS_HCHG — numeric(9, 4)
- JS_LCHG — numeric(9, 4)
- JS_ACHG — numeric(9, 4)
- MM_HMCAP — numeric(18, 0)
- MM_LMCAP — numeric(18, 0)
- MM_AMCAP — numeric(18, 0)
- JS_HMCAP — numeric(18, 0)
- JS_LMCAP — numeric(18, 0)
- JS_AMCAP — numeric(18, 0)
M_APT_CONS
- AP_CODE — VARCHAR(15) — Foreign key → M_APT_PEER.AP_CODE — NOT NULL
- CON_NM — varchar(300)
M_APT_MAST
- 아파트구분 (AP_GB) — CHAR(1) — Primary key — NOT NULL
- AP_CODE — VARCHAR(15) — Foreign key → M_APT.AP_CODE — NOT NULL
- 아파트명 (AP_NM) — VARCHAR(50)
- 아파트유형 (AP_UH) — CHAR(1)
- 지역코드 (JK_CODE) — VARCHAR(12)
- 주소코드 (JU_CODE) — VARCHAR(20)
- 신도시 (SINDOSI) — VARCHAR(12)
- 뉴타운 (NTOWN) — VARCHAR(12)
- 지구 (JIGU) — VARCHAR(12)
- 사업유형 (SA_UH) — CHAR(1)
- 역세권 (YEOKSE) — CHAR(1)
- 주사복합 (JUSANG) — CHAR(1)
- 재건축 (JAPT) — CHAR(1)
- 임대 (IMDAE) — CHAR(1)
- 세대수 (QTY) — INT
- 일반세대수 (GQTY) — NUMERIC(18,0)
- 조합세대수 (JQTY) — NUMERIC(18,0)
- 입주일 (IBJU_DT) — VARCHAR(8)
- 분양일 (BUN_DT) — VARCHAR(8)
- 연식 (LIFE) — NUMERIC(9,2)
- 공고 (GONGGO) — CAHR(1)
- 컨소시엄 (CONS_GB) — CHAR(1)
- 후분양 (HOOBUN) — CHAR(1)
M_APT_PEER
- AP_CODE — VARCHAR(15) — Foreign key → M_APT.AP_CODE — NOT NULL
- CON_NM — varchar(1000)
- LINE — int
- SWAY_NM — varchar(1000)
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
M_APT_PY
- AP_CODE — VARCHAR(15) — Foreign key → M_APT.AP_CODE — NOT NULL
- TD — char(8) — Foreign key → M_DATE.TD — NOT NULL
- JK_CD1 — varchar(2)
- JK_CD2 — varchar(2)
- JK_NM1 — varchar(20)
- JK_NM2 — varchar(20)
- JK_NM3 — varchar(20)
- PY_GU — numeric(18, 0)
- PY_DG — numeric(18, 0)
- PY_AP — numeric(18, 0)
- JS_GU — numeric(18, 0)
- JS_DG — numeric(18, 0)
- JS_AP — numeric(18, 0)
M_APT_RECENT
- TD — char(8) — Primary key — NOT NULL
- 아파트구분 (AP_GB) — CHAR(1) — Foreign key → M_APT_MAST.아파트구분 — NOT NULL
- AP_CODE — VARCHAR(15) — Foreign key → M_APT_MAST.AP_CODE — NOT NULL
- AP_KIND — INT — Foreign key → M_APTSUB.AP_KIND — NOT NULL
- AP_TYPE — VARCHAR(15) — Foreign key → M_APTSUB.AP_TYPE — NOT NULL
- BAREA — numeric(9, 2)
- MM_HP — numeric(18, 0)
- MM_LP — numeric(18, 0)
- MM_AP — numeric(18, 0)
- JS_HP — numeric(18, 0)
- JS_LP — numeric(18, 0)
- JS_AP — numeric(18, 0)
- MM_HP_1W — numeric(18, 0)
- MM_LP_1W — numeric(18, 0)
- MM_AP_1W — numeric(18, 0)
- JS_HP_1W — numeric(18, 0)
- JS_LP_1W — numeric(18, 0)
- JS_AP_1W — numeric(18, 0)
- MM_HP_1M — numeric(18, 0)
- MM_LP_1M — numeric(18, 0)
- MM_AP_1M — numeric(18, 0)
- JS_HP_1M — numeric(18, 0)
- JS_LP_1M — numeric(18, 0)
- JS_AP_1M — numeric(18, 0)
- MM_HP_3M — numeric(18, 0)
- MM_LP_3M — numeric(18, 0)
- MM_AP_3M — numeric(18, 0)
- JS_HP_3M — numeric(18, 0)
- JS_LP_3M — numeric(18, 0)
- JS_AP_3M — numeric(18, 0)
- MM_HP_6M — numeric(18, 0)
- MM_LP_6M — numeric(18, 0)
- MM_AP_6M — numeric(18, 0)
- JS_HP_6M — numeric(18, 0)
- JS_LP_6M — numeric(18, 0)
- JS_AP_6M — numeric(18, 0)
- MM_HP_1Y — numeric(18, 0)
- MM_LP_1Y — numeric(18, 0)
- MM_AP_1Y — numeric(18, 0)
- JS_HP_1Y — numeric(18, 0)
- JS_LP_1Y — numeric(18, 0)
- JS_AP_1Y — numeric(18, 0)
- MM_HP_2Y — numeric(18, 0)
- MM_LP_2Y — numeric(18, 0)
- MM_AP_2Y — numeric(18, 0)
- JS_HP_2Y — numeric(18, 0)
- JS_LP_2Y — numeric(18, 0)
- JS_AP_2Y — numeric(18, 0)
- MM_HP_3Y — numeric(18, 0)
- MM_LP_3Y — numeric(18, 0)
- MM_AP_3Y — numeric(18, 0)
- JS_HP_3Y — numeric(18, 0)
- JS_LP_3Y — numeric(18, 0)
- JS_AP_3Y — numeric(18, 0)
M_APT_SWAY
- AP_CODE — VARCHAR(15) — Foreign key → M_APT.AP_CODE — NOT NULL
- SWAY_NM — varchar(300)
M_BUN
- AP_CODE (AP_CODE2) — VARCHAR(15) — Foreign key → M_APT.AP_CODE — NOT NULL
- AP_NM — varchar(50)
- AP_UH — char(1)
- JK_CODE — varchar(12)
- JU_CODE — varchar(27)
- SINDOSI — varchar(10)
- NTOWN — varchar(10)
- JIGU — varchar(10)
- SA_UH — char(1)
- YEOKSE — char(1)
- JUSANG — char(1)
- IMDAE — char(1)
- QTY — numeric(18, 0)
- GQTY — numeric(18, 0)
- JQTY — numeric(18, 0)
- IBJU_DT — varchar(8)
- BUN_DT — varchar(8)
- GONGGO — char(1)
- CONS_GB — char(1)
- HOOBUN — char(1)
M_BUNSUB
- AP_KIND — int — Primary key — NOT NULL
- AP_TYPE — varchar(15) — Primary key — NOT NULL
- AP_CODE — VARCHAR(15) — Foreign key → M_BUN.AP_CODE — NOT NULL
- BAREA — numeric(9, 2)
- AREA — numeric(9, 2)
- QTY — numeric(18, 0)
- BQTY — int
- BPRICE — numeric(18, 0)
- PY — numeric(18, 0)
M_DATE
- TD (FD) — char(8) — Primary key — NOT NULL
- TR — char(1)
- SEQ — int
- DDAY — char(1)
- W_E — char(1)
- M_E — char(1)
- Q_E — char(1)
- H_E — char(1)
- Y_E — char(1)
- BF_TD — char(8)
- AF_TD — char(8)
- TR_MP — char(1)
- TR_GUBUN — char(1)
M_GIS_APT_HUGBUN
- JK_CODE — varchar(12) — Foreign key → M_JK.JK_CODE — NOT NULL
- AP_CODE — VARCHAR(15) — Foreign key → M_APT.AP_CODE — NOT NULL
- JK_CODE2 — varchar(10)
- AP_PYN — numeric(18, 8)
- AP_PYNTYPE — varchar(5)
- BAREA — numeric(18, 8)
- JK_NM1 — varchar(20)
- JK_NM2 — varchar(20)
- JK_NM3 — varchar(20)
- AP_NM — varchar(100)
- IBJU_DT — varchar(20)
- LIFE — varchar(20)
- RATE — decimal(18, 4)
- TQTY — int
- QTY — int
- KB_PRICE — numeric(18, 8)
- REB_PRICE — numeric(18, 8)
- REG — decimal(18, 4)
- TD — varchar(8)
M_GIS_APT_PY
- GB — varchar(50) — Primary key — NOT NULL
- AP_NM — varchar(700) — Primary key — NOT NULL
- TD — char(8) — Foreign key → M_DATE.TD — NOT NULL
- JK_CODE — varchar(12) — Foreign key → M_JK.JK_CODE — NOT NULL
- AP_CODE — VARCHAR(15) — Foreign key → M_APT.AP_CODE — NOT NULL
- QTY — numeric(18, 0)
- IBJU_DT — varchar(100)
- PX — varchar(500)
- PY — varchar(500)
- MM_AMCAP — numeric(18, 0)
- MM_QCAP — numeric(18, 0)
- JS_AMCAP — numeric(18, 0)
- JS_QCAP — numeric(18, 0)
- WS_AMCAP — numeric(18, 0)
- WS_QCAP — numeric(18, 0)
- AP_QTY — numeric(18, 0)
- WS_R — numeric(18, 4)
- JS_CV — numeric(18, 4)
- JS_CV_R — numeric(18, 4)
- CON_NM — varchar(2000)
- LINE — varchar(2000)
- SWAY_NM — varchar(1000)
- IBJUDT — varchar(100)
- JUNGONDDT — varchar(100)
- TOTFLOOR — varchar(600)
- DONGCNT — varchar(500)
- NANBANG — varchar(1000)
- NANBANGTYPE — varchar(1000)
- RATIO — numeric(18, 2)
- TOTCAR — numeric(18, 0)
- LIFE — numeric(18, 0)
- MINKIND — varchar(500)
- MAXKIND — varchar(500)
- GONGGOIMG — varchar(2000)
M_GRPLIST
- GRP_CODE — char(3) — Primary key — NOT NULL
- GRP_LIST — varchar(12) — Primary key — NOT NULL
- GRP_NM — varchar(30)
- FR_BASE — varchar(20)
- TO_BASE — varchar(20)
M_JDAPT
- JK_CODE — varchar(12) — Foreign key → M_JK.JK_CODE — NOT NULL
- JD_CODE — varchar(15) — NOT NULL
- JD_NM — varchar(50)
- SA_STEP — varchar(2)
- SA_NM — varchar(20)
- SA_UH — varchar(2)
- NT_CODE — varchar(15)
- NT_NM — varchar(50)
- CO_NM — varchar(100)
- GK_CODE — varchar(15)
- GK_NM — varchar(100)
M_JGB_APT
- GB — char(1) — Primary key — NOT NULL
- AP_CODE — VARCHAR(15) — Foreign key → M_APT_MAST.AP_CODE — NOT NULL
M_JGB_APTMAST
- 아파트구분 (AP_GB) — CHAR(1) — Foreign key → M_APT_MAST.아파트구분 — NOT NULL
- AP_CODE — VARCHAR(15) — Foreign key → M_APT_MAST.AP_CODE — NOT NULL
- GB — char(1) — NOT NULL
M_JK
- JK_GB — char(1) — Foreign key → M_APTBPRICE.JK_GB — NOT NULL
- JK_CODE — varchar(12) — Foreign key → M_APTBPRICE.JK_CODE — NOT NULL
- JK_NM — varchar(30)
- PARENT — varchar(12)
- PARENT_2 — varchar(12)
- DEPTH — char(1)
- GUBN — char(1)
- JK_NM1 — varchar(30)
- JK_NM2 — varchar(30)
- JK_NM3 — varchar(30)
- VISIBLE — char(1)
M_JK_APT
- AP_CODE — varchar(15) — Primary key — NOT NULL
- JK_GB — char(1) — Foreign key → M_JK.JK_GB — NOT NULL
- JK_CODE — varchar(12) — Foreign key → M_JK.JK_CODE — NOT NULL
- DELIST — char(1)
M_JK_APTMAST
- JK_GB — char(1) — Foreign key → M_JK.JK_GB — NOT NULL
- JK_CODE — varchar(12) — Foreign key → M_JK.JK_CODE — NOT NULL
- 아파트구분 (AP_GB) — CHAR(1) — Foreign key → M_APT_MAST.아파트구분 — NOT NULL
- AP_CODE — VARCHAR(15) — Foreign key → M_APT_MAST.AP_CODE — NOT NULL
M_JK_INFO
- 아파트구분 (AP_GB) — CHAR(1) — Foreign key → M_APT_MAST.아파트구분 — NOT NULL
- AP_CODE — VARCHAR(15) — Foreign key → M_APT_MAST.AP_CODE — NOT NULL
- EDU — varchar(2000)
- CONV — varchar(2000)
M_JK_JDAPT
- JK_GB — char(1) — Foreign key → M_JK.JK_GB — NOT NULL
- JK_CODE — varchar(12) — Foreign key → M_JK.JK_CODE — NOT NULL
- JD_CODE — varchar(15) — NOT NULL
M_JK_RJAPT
- JK_GB — char(1) — Foreign key → M_JK.JK_GB — NOT NULL
- JK_CODE — varchar(12) — Foreign key → M_JK.JK_CODE — NOT NULL
- RJ_CODE — varchar(15) — NOT NULL
M_MOCT_RPRICE
- TD — char(8) — Foreign key → M_DATE.TD — NOT NULL
- ADDR_CODE — varchar(10)
- APT_CODE — varchar(15)
- APT_NAME — varchar(100)
- JUN_AREA — numeric(9, 2)
- PRICE — numeric(18, 0)
- FLR — varchar(40)
- JS_PRICE — numeric(18, 0)
- WS_PRICE — numeric(18, 0)
- DEALING_GEN_CODE — varchar(20)
- DEALING_GEN — varchar(20)
- BLDG_GBN_CODE — varchar(80)
- BLDG_GBN — varchar(80)
M_RJAPT
- JK_CODE — varchar(12) — Foreign key → M_JK.JK_CODE — NOT NULL
- AP_CODE — VARCHAR(15) — Foreign key → M_APT.AP_CODE — NOT NULL
- RJ_CODE — varchar(15) — NOT NULL
- RJ_NM — varchar(50)
- SA_STEP — varchar(2)
- SA_NM — varchar(20)
- DENSITY — char(1)
- SA_GB — char(1)
- H_TYPE — char(1)
- CO_NM — varchar(100)
- QTY — numeric(18, 0)
- DJ_AREA — float
- YJ_R — float
- YJ_R_P — float
- EVAL_1 — numeric(8, 2)
- EVAL_2 — numeric(8, 2)
- EVAL_3 — numeric(8, 2)
- EVAL_4 — numeric(8, 2)
- EVAL_5 — numeric(8, 2)
- EVAL_6 — numeric(8, 2)
- EVAL_1_STAN — varchar(1000)
- EVAL_2_STAN — varchar(1000)
- EVAL_3_STAN — varchar(1000)
- EVAL_4_STAN — varchar(1000)
- EVAL_5_STAN — varchar(1000)
- EVAL_6_STAN — varchar(1000)
- FIGURE — varchar(1000)
- AREA — float
- YJ_P — float
- DS_GB — char(1)
M_SALE
- AP_CODE — VARCHAR(15) — Foreign key → M_APT.AP_CODE — NOT NULL
- JK_CODE — varchar(12) — Foreign key → M_JK.JK_CODE — NOT NULL
- AP_NM — varchar(50)
- AP_UH — char(1)
- JU_CODE — varchar(27)
- SINDOSI — varchar(10)
- NTOWN — varchar(10)
- JIGU — varchar(10)
- SA_UH — char(1)
- YEOKSE — char(1)
- JUSANG — char(1)
- JAPT — char(1)
- IMDAE — char(1)
- QTY — numeric(18, 0)
- GQTY — numeric(18, 0)
- JQTY — numeric(18, 0)
- IBJU_DT — varchar(8)
- BUN_DT — varchar(8)
- LIFE — numeric(9, 2)
- CONS_GB — char(1)
- BK_CODE — varchar(15)
M_SALESUB
- AP_KIND — INT — Foreign key → M_APTSUB.AP_KIND — NOT NULL
- AP_TYPE — VARCHAR(15) — Foreign key → M_APTSUB.AP_TYPE — NOT NULL
- AP_CODE — VARCHAR(15) — Foreign key → M_APTSUB.AP_CODE — NOT NULL
- BAREA — numeric(9, 2)
- AREA — numeric(9, 2)
- QTY — int
- BQTY — int
- BPRICE — numeric(18, 0)
- PY — numeric(18, 0)