enco
Tables (5)
TB_CO_ATCH_FILE_D (CO_첨부파일상세)
- ATCH_FILE_SEQ — DECIMAL(3,0) — Primary key — NOT NULL — 첨부_파일_순번
- ATCH_FILE_ID — VARCHAR(20) — Foreign key → TB_CO_ATCH_FILE_M.ATCH_FILE_ID — NOT NULL — 첨부파일ID
- ATCH_FILE_NM — VARCHAR(255) — NOT NULL — 첨부_파일_명
- ATCH_FILE_URL — VARCHAR(255) — NOT NULL — 첨부_파일_URL
- FRST_REGSTR_ID — VARCHAR(50) — NOT NULL — 최초등록자ID
- FRST_RGST_DTTM — TIMESTAMP — NOT NULL — 최초등록일시
- FNL_MDFR_ID — VARCHAR(50) — NOT NULL — 최종수정자ID
- FNL_MDFC_DTTM — TIMESTAMP — NOT NULL — 최종수정일시
TB_CO_ATCH_FILE_M (CO_첨부파일기본)
- ATCH_FILE_ID — VARCHAR(20) — Primary key — NOT NULL — 첨부파일ID
- ATCH_FILE_PATH — VARCHAR(500) — NOT NULL — 첨부_파일_경로
- FRST_REGSTR_ID — VARCHAR(50) — NOT NULL — 최초등록자ID
- FRST_RGST_DTTM — TIMESTAMP — NOT NULL — 최초등록일시
- FNL_MDFR_ID — VARCHAR(50) — NOT NULL — 최종수정자ID
- FNL_MDFC_DTTM — TIMESTAMP — NOT NULL — 최종수정일시
TB_CO_CMN_GRP_C
- GRP_CD_ID — VARCHAR(50) — Primary key — NOT NULL — 그룹코드ID
- GRP_CD_NM — VARCHAR(100) — NOT NULL — 그룹코드명
- GRP_CD_EXPLN — VARCHAR(4000) — 그룹코드설명
- HGRNK_CD_ID — VARCHAR(50) — 상위코드ID
- DEL_YN — CHAR(1) — NOT NULL — 삭제여부
- FRST_REGSTR_ID — VARCHAR(50) — NOT NULL — 최초등록자ID
- FRST_RGST_DTTM — TIMESTAMP — NOT NULL — 최초등록일시
- FNL_MDFR_ID — VARCHAR(50) — NOT NULL — 최종수정자ID
- FNL_MDFC_DTTM — TIMESTAMP — NOT NULL — 최종수정일시
TB_CS_FINANCE_M (CS_회원사재무조직정보)
- STD_YEAR — VARCHAR(4) — Primary key — NOT NULL — 기준년
- QUARTER_DVS_CD — VARCHAR(2) — Primary key — NOT NULL — 분기타입
- COMP_DVS_CD — VARCHAR(3) — Primary key — NOT NULL — 회사코드
- COMPTP_DVS_CD — VARCHAR(2) — NOT NULL — 회사타입코드
- TOT_ASST_AMT — NUMBER(11) — NOT NULL — 총자산금액
- PRM_INCM_AMT — NUMBER(11) — NOT NULL — 수입보험료금액
- NET_INCM_AMT — NUMBER(11) — NOT NULL — 당기순이익금액
- EMPL_CNT — NUMBER(11) — NOT NULL — 임직원수
- BRCH_CNT — NUMBER(11) — NOT NULL — 점포수
- FRST_REGSTR_ID — VARCHAR(50) — NOT NULL — 최초등록자ID
- FRST_RGST_DTTM — TIMESTAMP — NOT NULL — 최초등록일시
- FNL_MDFR_ID — VARCHAR(50) — NOT NULL — 최종수정자ID
- FNL_MDFC_DTTM — TIMESTAMP — NOT NULL — 최종수정일시
TB_CS_INSU_FINANCE_M
- STD_YEAR — VARCHAR(4) — Primary key — NOT NULL — 기준년
- QUARTER_DVS_CD — VARCHAR(2) — Primary key — NOT NULL — 분기타입
- INSU_DVS_CD — VARCHAR(2) — Primary key — NOT NULL — 보험종류코드
- INSU_AMT — NUMBER(11) — NOT NULL — 보험금액
- FRST_REGSTR_ID — VARCHAR(50) — NOT NULL — 최초등록자ID
- FRST_RGST_DTTM — TIMESTAMP — NOT NULL — 최초등록일시
- FNL_MDFR_ID — VARCHAR(50) — NOT NULL — 최종수정자ID
- FNL_MDFC_DTTM — TIMESTAMP — NOT NULL — 최종수정일시