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