test
Tables (18)
COVID19_INPUT
- INPUT_NO — nvarchar(50)
- DATE — nvarchar(50)
- COMPANY — nvarchar(50)
- PART — nvarchar(50)
- TEAM — nvarchar(50)
- OFFICE — nvarchar(50)
- DEPARTMENT — nvarchar(50)
- POSITION — nvarchar(50)
- REGION — nvarchar(50)
- NAME — nvarchar(50)
- MAG_REASON — nvarchar(max)
- ISOL_WAY — nvarchar(50)
- ISOL_START — nvarchar(50)
- ISOL_END — nvarchar(50)
- REPORT — nvarchar(max)
- PROGRESS — nvarchar(max)
- DEC_UPDATE — nvarchar(max)
- MAG_SORT — nvarchar(50)
- CONFIRM_CHK — nvarchar(1)
- FOREIGN_CHK — nvarchar(1)
- CREATE_ID — nvarchar(20)
- CREATE_DT — nvarchar(20)
- UPDATE_ID — nvarchar(20)
- UPDATE_DT — nvarchar(20)
COVID19_OUTPUT
- OUTPUT_NO — nvarchar(50)
- DATE — nvarchar(50)
- COMPANY — nvarchar(50)
- PART — nvarchar(50)
- TEAM — nvarchar(50)
- OFFICE — nvarchar(50)
- DEPARTMENT — nvarchar(50)
- POSITION — nvarchar(50)
- REGION — nvarchar(50)
- NAME — nvarchar(50)
- MAG_REASON — nvarchar(max)
- ISOL_WAY — nvarchar(50)
- ISOL_START — nvarchar(50)
- ISOL_END — nvarchar(50)
- REPORT — nvarchar(max)
- PROGRESS — nvarchar(max)
- DEC_UPDATE — nvarchar(max)
- MAG_SORT — nvarchar(50)
- CONFIRM_CHK — nvarchar(1)
- FOREIGN_CHK — nvarchar(1)
- CREATE_ID — nvarchar(20)
- CREATE_DT — nvarchar(20)
- UPDATE_ID — nvarchar(20)
- UPDATE_DT — nvarchar(20)
- PROC_DT — nvarchar(20)
DISPATCH
- ORG_NO — nvarchar(50)
- LTCNT — decimal(16, 0)
- STCNT — decimal(16, 0)
- DATE — nvarchar(50)
- UPDATE_ID — nvarchar(20)
- UPDATE_DT — nvarchar(20)
FIN_CHK
- USER_ID — nvarchar(50)
- DATE — nvarchar(20)
- FIN_CHK — nvarchar(1)
- UPDATE_ID — nvarchar(20)
- UPDATE_DT — nvarchar(20)
FOREIGN_BRANCH
- YYYYMM — nvarchar(6)
- DEPARTMENT — nvarchar(50)
- BRANCH — nvarchar(50)
- REGION — nvarchar(20)
- LOCAL — decimal(18, 0)
- K_LONG — decimal(18, 0)
- K_SHORT — decimal(18, 0)
- K_LOCAL — decimal(18, 0)
- UPDATE_ID — nvarchar(20)
- UPDATE_DT — nvarchar(20)
GLOBAL_EMPLOYEES
- NO — nvarchar(50)
- COMPANY — nvarchar(50)
- PART — nvarchar(50)
- TEAM — nvarchar(50)
- OFFICE — nvarchar(50)
- DEPARTMENT — nvarchar(50)
- COUNTRY — nvarchar(50)
- LONG — decimal(18, 0)
- SHORT — decimal(18, 0)
- UPDATE_ID — nvarchar(20)
- UPDATE_DT — nvarchar(20)
ISOL_WAY
- ISOL_WAY_NO — nvarchar(50)
- ISOL_WAY — nvarchar(50)
- SEQ — nvarchar(50)
- UPDATE_ID — nvarchar(20)
- UPDATE_DT — nvarchar(20)
ISSUE
- ISSUE_NO — nvarchar(50) — NOT NULL
- FOREIGN_CHK — nvarchar(1)
- TITLE — nvarchar(200)
- CONTENTS — image
- CONTENTS_TXT — nvarchar(max)
- SEQ — nvarchar(50)
- UPDATE_ID — nvarchar(20)
- UPDATE_DT — nvarchar(20)
MAG_REASON
- MAG_REASON_NO — nvarchar(50)
- MAG_REASON — nvarchar(max)
- SEQ — nvarchar(50)
- UPDATE_ID — nvarchar(20)
- UPDATE_DT — nvarchar(20)
MAG_SORT
- MAG_SORT_NO — nvarchar(50)
- MAG_SORT — nvarchar(50)
- SEQ — nvarchar(50)
- UPDATE_ID — nvarchar(20)
- UPDATE_DT — nvarchar(20)
ORG
- ORG_NO — nvarchar(50)
- COMPANY — nvarchar(50)
- PART — nvarchar(50)
- TEAM — nvarchar(50)
- OFFICE — nvarchar(50)
- DEPARTMENT — nvarchar(50)
- REF — nvarchar(200)
- REF1 — nvarchar(50)
- REGION_NO — nvarchar(50)
- SEQ — nvarchar(50)
- UPDATE_ID — nvarchar(20)
- UPDATE_DT — nvarchar(20)
ORG_ADM_GRP
- ADM_GRP_NO — nvarchar(50)
- ADM_GRP_NM — nvarchar(50)
- LEVEL — nvarchar(2)
- ORG_CD — nvarchar(50)
- UPDATE_ID — nvarchar(20)
- UPDATE_DT — nvarchar(20)
POSITION
- POSITION_NO — nvarchar(50)
- POSITION — nvarchar(50)
- SEQ — nvarchar(50)
- UPDATE_ID — nvarchar(20)
- UPDATE_DT — nvarchar(20)
REGION
- REGION_NO — nvarchar(50)
- REGION — nvarchar(50)
- COUNTRY — nvarchar(50)
- CITY — nvarchar(50)
- FOREIGN_CHK — nvarchar(1)
- SEQ — nvarchar(50)
- UPDATE_ID — nvarchar(20)
- UPDATE_DT — nvarchar(20)
TB_GLOBAL_COVID19_INF
- natKey — nvarchar(256)
- stdDay — nvarchar(30)
- nationNmEn — nvarchar(128)
- provinceNmEn — nvarchar(128)
- cityNmEn — nvarchar(128)
- natOccCnt — decimal(16, 0)
- natDeathCnt — decimal(16, 0)
- natRecoverCnt — decimal(16, 0)
- natActiveCnt — decimal(16, 0)
- createDt — datetime
- updateDt — datetime
TB_LOCAL_COVID19_INF
- seq — nvarchar(30) — Primary key — NOT NULL
- gubun — nvarchar(30)
- gubunCn — nvarchar(30)
- gubunEn — nvarchar(30)
- deathCnt — decimal(15, 0)
- defCnt — decimal(15, 0)
- incDec — decimal(15, 0)
- isolClearCnt — decimal(15, 0)
- isolIngCnt — decimal(15, 0)
- localOccCnt — decimal(15, 0)
- overFlowCnt — decimal(15, 0)
- qurRate — decimal(8, 5)
- stdDay — nvarchar(30)
- createDt — datetime
- updateDt — datetime
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
- OPTIMIZE_FOR_SEQUENTIAL_KEY — =
TB_NAT_CODE_MAST
- NatNmEn — nvarchar(64) — Primary key — NOT NULL
- ISO2 — nvarchar(2)
- ISO3 — nvarchar(3)
- ISONum — decimal(6, 0)
- NatNmKr — nvarchar(64)
- ReportYN — nvarchar(2)
- JHUNatNmEn — nvarchar(64)
- AreaNmEn — nvarchar(16)
- AreaNmKr — nvarchar(16)
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
- OPTIMIZE_FOR_SEQUENTIAL_KEY — =
__ERROR_INFO
- ErrorNumber — int
- ErrorSeverity — int
- ErrorState — int
- ErrorProcedure — nvarchar(300)
- ErrorLine — int
- ErrorMessage — nvarchar(max)
- INSERTDATE — datetime