PENSION,KED,NICE,DART
Tables (16)
ABI_1 (NICE재무제표(IFRS))
- KIS_CD (업체코드) — VARCHAR(6) — Primary key — NOT NULL
- ACCT_CD (결산구분) — VARCHAR(1) — Primary key — NOT NULL
- STD_DT (기준일자) — VARCHAR(8) — Primary key — NOT NULL
- REPO_CD (보고서코드) — VARCHAR(2) — Primary key — NOT NULL
- RECD_CD (항목코드) — VARCHAR(4) — Primary key — NOT NULL
- TOT_AMT (금액) — VARCHAR(13)
- CONS_RT (구성비) — VARCHAR(6)
- PERT_RT (증감율) — VARCHAR(6)
- REG_DT (등록일시) — DATETIME
- UPD_DT (수정일시) — DATETIME
ABI_2 (NICE재무비율(IFRS))
- KIS_CD (업체코드) — VARCHAR(6) — Primary key — NOT NULL
- ACCT_CD (결산구분) — VARCHAR(1) — Primary key — NOT NULL
- STD_DT (기준일자) — VARCHAR(8) — Primary key — NOT NULL
- REPO_CD (보고서코드) — VARCHAR(2) — Primary key — NOT NULL
- RECD_CD (항목코드) — VARCHAR(4) — Primary key — NOT NULL
- PERT (비율) — VARCHAR(17)
- REG_DT (등록일시) — DATETIME
- UPD_DT (수정일시) — DATETIME
ABI_9 (계정코드(IFRS))
- REPO_CD (보고서코드) — VARCHAR(2) — Primary key — NOT NULL
- RECD_CD (항목코드) — VARCHAR(4) — Primary key — NOT NULL
- RECD_NM (항목명(한글)) — VARCHAR(50)
- RECD_ENG_NM (항목명(영문)) — VARCHAR(80)
- ... — ...
AB_01 (NICE재무제표)
- KIS_CD (업체코드) — VARCHAR(6) — Primary key — NOT NULL
- ACCT_CD (결산구분) — VARCHAR(1) — Primary key — NOT NULL
- STD_DT (기준일자) — VARCHAR(8) — Primary key — NOT NULL
- REPO_CD (보고서코드) — VARCHAR(2) — Primary key — NOT NULL
- RECD_CD (항목코드) — VARCHAR(4) — Primary key — NOT NULL
- TOT_AMT (금액) — VARCHAR(13)
- CONS_RT (구성비) — VARCHAR(6)
- PERT_RT (증감율) — VARCHAR(6)
- REG_DT (등록일시) — DATETIME
- UPD_DT (수정일시) — DATETIME
AB_02 (NICE재무비율)
- KIS_CD (업체코드) — VARCHAR(6) — Primary key — NOT NULL
- ACCT_CD (결산구분) — VARCHAR(1) — Primary key — NOT NULL
- STD_DT (기준일자) — VARCHAR(8) — Primary key — NOT NULL
- REPO_CD (보고서코드) — VARCHAR(2) — Primary key — NOT NULL
- RECD_CD (항목코드) — VARCHAR(4) — Primary key — NOT NULL
- PERT (비율) — VARCHAR(17)
- REG_DT (등록일시) — DATETIME
- UPD_DT (수정일시) — DATETIME
AB_09 (계정코드)
- REPO_CD (보고서코드) — VARCHAR(2) — Primary key — NOT NULL
- RECD_CD (항목코드) — VARCHAR(4) — Primary key — NOT NULL
- REPO_CD (보고서코드2) — VARCHAR(2) — Foreign key → ABI_9.REPO_CD — NOT NULL
- RECD_CD (항목코드2) — VARCHAR(4) — Foreign key → ABI_9.RECD_CD — NOT NULL
- RECD_NM (항목명(한글)) — VARCHAR(50)
- RECD_ENG_NM (항목명(영문)) — VARCHAR(80)
- ... — ...
C_303 (기업신용등급(CRI등급))
- KIS_CD (업체코드) — VARCHAR(6) — Primary key — NOT NULL
- GRD_FROM_DT (등급시작일자) — VARCHAR(8) — Primary key — NOT NULL
- KIS_CD (업체코드2) — VARCHAR(6) — Foreign key → EM_02.KIS_CD — NOT NULL
- SEQ (일련번호) — VARCHAR(4) — Foreign key → EM_02.SEQ — NOT NULL
- RGNO (사업자번호2) — VARCHAR(10) — Foreign key → EM_02.RGNO — NOT NULL
- BZ_IDX (기업번호 INDEX) — BIGINT(20) — Foreign key → EM_02.BZ_IDX — NOT NULL
- GRD_END_DT (등급종료일자) — VARCHAR(8)
- CRI_BAT_STD_DT (CRI배치기준일자) — CRI배치기준일자
- STD_ACCT_DT (기준결산일자) — VARCHAR(8)
- CRI_GRD (CRI등급) — VARCHAR(4)
DART_ENT_OVW (DART기업개황)
- CORP_CODE (고유번호) — VARCHAR(8) — Primary key — NOT NULL
- MODIFY_DATE (기업개황 최종변경일) — DATE — Primary key — NOT NULL
- CORP_NAME (회사명) — VARCHAR(255)
- BIZR_NO (사업자등록번호) — VARCHAR(30)
- STOCK_CODE (상장회사 종목코드) — VARCHAR(6)
- ... — ...
DART_FIST (DART 재무정보 TXT)
- REPORT_IDX (보고서코드) — VARCHAR(45) — Primary key — NOT NULL
- STOCK_CODE (상장회사 종목코드) — VARCHAR(8) — Primary key — NOT NULL
- CORP_CODE (고유번호) — VARCHAR(8) — Foreign key → DART_ENT_OVW.CORP_CODE — NOT NULL
- MODIFY_DATE (기업개황 최종변경일) — DATE — Foreign key → DART_ENT_OVW.MODIFY_DATE — NOT NULL
- ACCOUNT_ID (항몽코드) — VARCHAR(45)
- ACCOUNT_NM (항목명) — VARCHAR(45)
- THSTRM_NM (당기명) — VARCHAR(15)
- THSTRM_AMOUNT (당기금액) — VARCHAR(50)
- FRMTRM_NM (전기명) — VARCHAR(15)
- FRMTRM_AMOUNT (전기금액) — VARCHAR(50)
- ... — ...
DATA_PENSION_MASTER (bz_idx)
- RGNO (사업자번호) — VARCHAR(10) — Primary key — NOT NULL
- BZ_IDX (기업번호 INDEX) — BIGINT(20) — Primary key — NOT NULL
- KEDCD (KED기업번호) — VARCHAR(10)
- KIS_CD (NICE기업번호) — VARCHAR(45)
- ...
EM01 (업체개요)
- KIS_CD (업체코드) — VARCHAR(6) — Primary key — NOT NULL
- RG_NO (사업자번호) — VARCHAR(10)
- ... — ...
EM_02 (업체사업장정보)
- KIS_CD (업체코드) — VARCHAR(6) — Primary key — NOT NULL
- SEQ (일련번호) — VARCHAR(4) — Primary key — NOT NULL
- RGNO (사업자번호2) — VARCHAR(10) — Foreign key → DATA_PENSION_MASTER.RGNO — NOT NULL
- BZ_IDX (기업번호 INDEX) — BIGINT(20) — Foreign key → DATA_PENSION_MASTER.BZ_IDX — NOT NULL
- RG_NO (사업자번호) — VARCHAR(10)
- ... — ...
KED_2022_TBL0002 (기업개요)
- KEDCD (KED코드) — VARCHAR(10) — Primary key — NOT NULL
- BZNO (사업자번호) — VARCHAR(10)
- ... — ...
KED_EW_HIST (KED 신용등급)
- RGNO (사업자번호) — VARCHAR(10) — Primary key — NOT NULL
- REG_DT (기준연월일) — VARCHAR(8) — Primary key — NOT NULL
- EW_CD (신용등급) — INT
- MONTH (날짜 (월별)) — VARCHAR(6)
KED_TBL0003 (주요재무정보)
- KEDCD (KED코드) — VARCHAR(10) — Primary key — NOT NULL
- ACCT_DT (결산기준연월일) — VARCHAR(8) — Primary key — NOT NULL
- KEDCD (KED코드2) — VARCHAR(10) — Foreign key → KED_2022_TBL0002.KEDCD — NOT NULL
- SUMAASSET (총자산) — VARCHAR(50)
- PAYMENTFUND (납입자본금) — VARCHAR(50)
- FUNDTOTAL (자본총계) — VARCHAR(50)
- SALES (매출액) — VARCHAR(50)
- PROFIT (영업이익) — VARCHAR(50)
- TERMNETPROFIT (당기순이익) — VARCHAR(50)
- MONTH (날짜 (월별)) — VARCHAR(6)
PENSION (국민연금 EDA 파일)
- BZ_RGNO (국민연금 사업자번호 6자리) — VARCHAR(6) — Primary key — NOT NULL
- BZ_IDX (기업번호 INDEX) — INT — Primary key — NOT NULL
- BZ_NM (기업명) — VARCHAR(60)
- MONTH (날짜 (월별)) — INT
- ...