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