P_DW_RIS_Etc ERD
Tables (25)
M_AGE
- JK_GB — char(1) — Foreign key → M_JK.JK_GB — NOT NULL
- JK_CODE — varchar(12) — Foreign key → M_JK.JK_CODE — NOT NULL
- TD — char(8) — Foreign key → M_DATE.FD — NOT NULL
- TOT — numeric(18, 0)
- MALE — numeric(18, 0)
- FEMALE — numeric(18, 0)
M_AGE_YR
- JK_GB — char(1) — Foreign key → M_AGE.JK_GB — NOT NULL
- JK_CODE — varchar(12) — Foreign key → M_AGE.JK_CODE — NOT NULL
- TD — char(8) — Foreign key → M_AGE.TD — NOT NULL
- TOT — numeric(18, 0)
- MALE — numeric(18, 0)
- FEMALE — numeric(18, 0)
M_BPLACE
- BP_CODE — varchar(12) — Primary key — NOT NULL
- JK_CODE — varchar(12) — Foreign key → M_JK.JK_CODE — NOT NULL
- BP_NM — varchar(1000)
- PX — varchar(500) — NOT NULL
- PY — varchar(500) — NOT NULL
- DEL_YN — varchar(1) — NOT NULL
- REG_ID — varchar(50)
- REG_MENU_ID — varchar(30)
- REG_DTM — datetime
- MOD_ID — varchar(50)
- MOD_MENU_ID — varchar(30)
- MOD_DTM — datetime
M_BPLACE_DETAIL
- LINK_CODE — varchar(12) — Primary key — NOT NULL
- BP_CODE — varchar(12) — Foreign key → M_BPLACE.BP_CODE — NOT NULL
- LINK_NM — varchar(1000)
- URL — varchar(1000)
- MEMO — varchar(1000)
- DEL_YN — varchar(1) — NOT NULL
- REG_ID — varchar(50)
- REG_MENU_ID — varchar(30)
- REG_DTM — datetime
- MOD_ID — varchar(50)
- MOD_MENU_ID — varchar(30)
- MOD_DTM — datetime
M_CENSUS_AGE
- AGE — varchar(50) — 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
- TD — char(8) — Foreign key → M_DATE.FD — NOT NULL
- GRP_LIST — varchar(12) — Foreign key → M_GRPLIST.GRP_LIST — NOT NULL
- TOT — decimal(18, 0)
- MALE — decimal(18, 0)
- FEMALE — decimal(18, 0)
- RATIO — numeric(18, 2)
- LOCAL_TOT — decimal(18, 0)
- LOCAL_MALE — decimal(18, 0)
- LOCAL_FEMALE — decimal(18, 0)
- LOCAL_RATIO — numeric(18, 2)
M_CENSUS_STAT_DWELL
- JK_GB — char(1) — Foreign key → M_JK.JK_GB — NOT NULL
- JK_CODE — varchar(12) — Foreign key → M_JK.JK_CODE — NOT NULL
- TD — char(8) — Foreign key → M_DATE.FD — NOT NULL
- JUTAEG_TOT — decimal(18, 0)
- DANDOK — decimal(18, 0)
- APT — decimal(18, 0)
- YOLIP — decimal(18, 0)
- DASEDAE — decimal(18, 0)
- NON_RESI — decimal(18, 0)
- OTHER — decimal(18, 0)
M_CENSUS_STAT_GAGU
- JK_GB — char(1) — Foreign key → M_JK.JK_GB — NOT NULL
- JK_CODE — varchar(12) — Foreign key → M_JK.JK_CODE — NOT NULL
- TD — char(8) — Foreign key → M_DATE.FD — NOT NULL
- GAGU_TOT — decimal(18, 0)
- GAGU_ILBAN — decimal(18, 0)
- GAGU_JIBDAN — decimal(18, 0)
- GAGU_FOR — decimal(18, 0)
M_CENSUS_STAT_INGU
- JK_GB — char(1) — Foreign key → M_JK.JK_GB — NOT NULL
- JK_CODE — varchar(12) — Foreign key → M_JK.JK_CODE — NOT NULL
- TD — char(8) — Foreign key → M_DATE.FD — NOT NULL
- TOT — decimal(18, 0)
- MALE — decimal(18, 0)
- FEMALE — decimal(18, 0)
M_CENSUS_STAT_NAT
- JK_GB — char(1) — Foreign key → M_JK.JK_GB — NOT NULL
- JK_CODE — varchar(12) — Foreign key → M_JK.JK_CODE — NOT NULL
- TD — char(8) — Foreign key → M_DATE.FD — NOT NULL
- LOCAL_TOT — decimal(18, 0)
- LOCAL_MALE — decimal(18, 0)
- LOCAL_FEMALE — decimal(18, 0)
- FOR_TOT — decimal(18, 0)
- FOR_MALE — decimal(18, 0)
- FOR_FEMALE — decimal(18, 0)
M_DATE
- 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_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_INGU2
- JK_GB — char(1) — Foreign key → M_JK.JK_GB — NOT NULL
- JK_CODE — varchar(12) — Foreign key → M_JK.JK_CODE — NOT NULL
- TD — char(8) — Foreign key → M_DATE.FD — NOT NULL
- TOT — numeric(18, 0)
- SEDAE — numeric(18, 0)
- SEDAE_INGU — numeric(18, 2)
- MALE — numeric(18, 0)
- FEMALE — numeric(18, 0)
- RATIO — numeric(18, 2)
M_INGU2_YR
- JK_GB — char(1) — Foreign key → M_INGU2.JK_GB — NOT NULL
- JK_CODE — varchar(12) — Foreign key → M_INGU2.JK_CODE — NOT NULL
- TD — char(8) — Foreign key → M_INGU2.TD — NOT NULL
- TOT — numeric(18, 0)
- SEDAE — numeric(18, 0)
- SEDAE_INGU — numeric(18, 2)
- MALE — numeric(18, 0)
- FEMALE — numeric(18, 0)
- RATIO — numeric(18, 2)
M_INGU_AGE
- GB_AGE — varchar(20) — 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
- TD — char(8) — Foreign key → M_DATE.FD — NOT NULL
- TOT — numeric(18, 0)
- MALE — numeric(18, 0)
- FEMALE — numeric(18, 0)
- RATIO — numeric(18, 2)
M_INGU_AGE_YR
- GB_AGE — varchar(20) — Foreign key → M_INGU_AGE.GB_AGE — NOT NULL
- JK_GB — char(1) — Foreign key → M_INGU_AGE.JK_GB — NOT NULL
- JK_CODE — varchar(12) — Foreign key → M_INGU_AGE.JK_CODE — NOT NULL
- TD — char(8) — Foreign key → M_INGU_AGE.TD — NOT NULL
- TOT — numeric(18, 0)
- MALE — numeric(18, 0)
- FEMALE — numeric(18, 0)
- RATIO — numeric(18, 2)
M_INGU_VAR
- JK_GB — char(1) — Foreign key → M_JK.JK_GB — NOT NULL
- JK_CODE — varchar(12) — Foreign key → M_JK.JK_CODE — NOT NULL
- TD — char(8) — Foreign key → M_DATE.FD — NOT NULL
- PRE — numeric(18, 0)
- CUR — numeric(18, 0)
- CHG — numeric(18, 0)
M_INGU_VAR_YR
- JK_GB — char(1) — Foreign key → M_INGU_VAR.JK_GB — NOT NULL
- JK_CODE — varchar(12) — Foreign key → M_INGU_VAR.JK_CODE — NOT NULL
- TD — char(8) — Foreign key → M_INGU_VAR.TD — NOT NULL
- PRE — numeric(18, 0)
- CUR — numeric(18, 0)
- CHG — numeric(18, 0)
M_JK
- JK_GB — char(1) — Primary key — NOT NULL
- JK_CODE — varchar(12) — Primary key — 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_SUMMARY
- JK_GB — char(1) — Foreign key → M_JK.JK_GB — NOT NULL
- JK_CODE — varchar(12) — Foreign key → M_JK.JK_CODE — NOT NULL
- INGU_TD — char(4)
- TOT — numeric(18, 0)
- CHG_TOT — numeric(9, 4)
- MALE — numeric(18, 0)
- FEMALE — numeric(18, 0)
- SEDAE — numeric(18, 0)
- AREA — numeric(18, 2)
- CAR_TD — char(6)
- CAR — numeric(18, 0)
- CHG_CAR — numeric(9, 4)
- CAR_R — numeric(9, 4)
- JUTAEK_TD — char(8)
- GAGU — numeric(18, 0)
- JUTAEK — numeric(18, 0)
- JUTAEK_R — numeric(9, 4)
- APT_R — numeric(9, 4)
- OLDAPT_R — numeric(9, 4)
- CHG_LQ_TD — char(8)
- CHG_LQ_1M — numeric(9, 4)
- CHG_LQ_3M — numeric(9, 4)
- CHG_LQ_6M — numeric(9, 4)
- CHG_LQ_1Y — numeric(9, 4)
- CHG_LP_TD — char(8)
- CHG_LP_1M — numeric(9, 4)
- CHG_LP_3M — numeric(9, 4)
- CHG_LP_6M — numeric(9, 4)
- CHG_LP_1Y — numeric(9, 4)
- CHG_AP_TD — char(8)
- CHG_AP_1W — numeric(9, 4)
- CHG_AP_1M — numeric(9, 4)
- CHG_AP_3M — numeric(9, 4)
- CHG_AP_6M — numeric(9, 4)
- CHG_AP_1Y — numeric(9, 4)
- CHG_AP_2Y — numeric(9, 4)
- CHG_AP_3Y — numeric(9, 4)
- MM_PY — numeric(18, 0)
- JS_PY — numeric(18, 0)
- JS_MM_R — numeric(9, 4)
- IBJU_AQ — numeric(18, 0)
- IBJU_FQ — numeric(18, 0)
- BUN_AQ — numeric(18, 0)
- BUN_FQ — numeric(18, 0)
M_JK_SUMMARY2
- GB — varchar(20) — 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
- TD — char(8) — Foreign key → M_DATE.FD — NOT NULL
- VAL — numeric(15, 2)
- NM1 — varchar(50)
- NM2 — varchar(50)
- UNIT — varchar(20)
M_JK_SUMMARY2_Y1
- GB (GB2) — varchar(20) — Foreign key → M_JK_SUMMARY2.GB — NOT NULL
- JK_GB (JK_GB2) — char(1) — Foreign key → M_JK_SUMMARY2.JK_GB — NOT NULL
- JK_CODE (JK_CODE2) — varchar(12) — Foreign key → M_JK_SUMMARY2.JK_CODE — NOT NULL
- TD (TD2) — char(8) — Foreign key → M_JK_SUMMARY2.TD — NOT NULL
- VAL — numeric(15, 2)
- NM1 — varchar(50)
- NM2 — varchar(50)
- UNIT — varchar(20)
M_JK_SUMMARY_Y1
- JK_GB — char(1) — Foreign key → M_JK_SUMMARY.JK_GB — NOT NULL
- JK_CODE — varchar(12) — Foreign key → M_JK_SUMMARY.JK_CODE — NOT NULL
- INGU_TD — char(4)
- TOT — numeric(18, 0)
- CHG_TOT — numeric(9, 4)
- MALE — numeric(18, 0)
- FEMALE — numeric(18, 0)
- SEDAE — numeric(18, 0)
- AREA — numeric(18, 2)
- CAR_TD — char(6)
- CAR — numeric(18, 0)
- CHG_CAR — numeric(9, 4)
- CAR_R — numeric(9, 4)
- JUTAEK_TD — char(8)
- GAGU — numeric(18, 0)
- JUTAEK — numeric(18, 0)
- JUTAEK_R — numeric(9, 4)
- APT_R — numeric(9, 4)
- OLDAPT_R — numeric(9, 4)
- CHG_LQ_TD — char(8)
- CHG_LQ_1M — numeric(9, 4)
- CHG_LQ_3M — numeric(9, 4)
- CHG_LQ_6M — numeric(9, 4)
- CHG_LQ_1Y — numeric(9, 4)
- CHG_LP_TD — char(8)
- CHG_LP_1M — numeric(9, 4)
- CHG_LP_3M — numeric(9, 4)
- CHG_LP_6M — numeric(9, 4)
- CHG_LP_1Y — numeric(9, 4)
- CHG_AP_TD — char(8)
- CHG_AP_1W — numeric(9, 4)
- CHG_AP_1M — numeric(9, 4)
- CHG_AP_3M — numeric(9, 4)
- CHG_AP_6M — numeric(9, 4)
- CHG_AP_1Y — numeric(9, 4)
- CHG_AP_2Y — numeric(9, 4)
- CHG_AP_3Y — numeric(9, 4)
- MM_PY — numeric(18, 0)
- JS_PY — numeric(18, 0)
- JS_MM_R — numeric(9, 4)
- IBJU_AQ — numeric(18, 0)
- IBJU_FQ — numeric(18, 0)
- BUN_AQ — numeric(18, 0)
- BUN_FQ — numeric(18, 0)
M_SEDAE
- GB_SEDAE — varchar(20) — 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
- TD — char(8) — Foreign key → M_DATE.FD — NOT NULL
- SEDAE — numeric(18, 0)
M_SEDAE_YR
- GB_SEDAE (GB_SEDAE2) — varchar(20) — Foreign key → M_SEDAE.GB_SEDAE — NOT NULL
- JK_GB — char(1) — Foreign key → M_SEDAE.JK_GB — NOT NULL
- JK_CODE — varchar(12) — Foreign key → M_SEDAE.JK_CODE — NOT NULL
- TD — char(8) — Foreign key → M_SEDAE.TD — NOT NULL
- SEDAE — numeric(18, 0)
M_SUBWAY
- LINE — int — Primary key — NOT NULL
- STATION — int — Primary key — NOT NULL
- LINE_NM — varchar(100)
- STATION_NM — varchar(100)