dashboard

테이블 (4)

마스터 (TB_STAT4_EXEC_INFO)

  • STAT_NO (Key) — INTEGER — 기본 키 — NOT NULL
  • YYYYMMDD (.) — VARCHAR(8)
  • HHMI (Field) — VARCHAR(4)
  • INS_DT (Field2) — SYSDATE

신청 (TB_STAT4_REQ)

  • STAT_NO (Key) — INTEGER — 기본 키 — NOT NULL
  • SPRMNY_SE (Field) — VARCHAR(1)
  • STAT_DIV_CODE (Field2) — VARCHAR(20)
  • SPRMNY_TRGTER_SE (Field3) — VARCHAR(1)
  • SPRMNY_TYPE_CD (Field4) — VARCHAR(2)
  • SPRMNY_TRGTER_CNT (Field5) — INTEGER
  • SPRMNY_TRGTER_AM (Field6) — BIGINT

예산 (TB_STAT4_BUDGET)

  • STAT_NO (Key) — INTEGER — 기본 키 — NOT NULL
  • SPRMNY_SE (Field) — VARCHAR(1)
  • STAT_DIV_CODE (Field2) — VARCHAR(20)
  • SPRMNY_TRGTER_SE (Field3) — VARCHAR(1)
  • SPRMNY_TYPE_CD (Field4) — VARCHAR(2)
  • SPRMNY_TRGTER_CNT (Field5) — INTEGER
  • SPRMNY_TRGTER_AM (Field6) — BIGINT
  • INS_DT (Field7) — SYSDATE

지급 (TB_STAT4_TRANS)

  • STAT_NO (Key) — INTEGER — 기본 키 — NOT NULL
  • SPRMNY_SE (Field) — VARCHAR(1)
  • STAT_DIV_CODE (Field2) — VARCHAR(20)
  • SPRMNY_TRGTER_SE (Field3) — VARCHAR(1)
  • SPRMNY_TYPE_CD (Field4) — VARCHAR(2)
  • SPRMNY_TRGTER_CNT (Field5) — INTEGER
  • SPRMNY_TRGTER_AM (Field6) — BIGINT