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 — 최종수정일시