asdf

Tables (30)

TB_EEP_CMPNY_DOC_S

  • DOC_SQ — BIGINT(21) — Primary key — NOT NULL
  • CMPNY_SQ — BIGINT(21) — NOT NULL
  • FILE_SQ — BIGINT(21) — NOT NULL

TB_EEP_CMPNY_EQPMNT_M

  • EQPMNT_SQ — BIGINT(21) — Primary key — NOT NULL
  • EQPMNT_MNGMNT_NUM — BIGINT(21) — Primary key — NOT NULL
  • CMPNY_SQ — BIGINT(21) — Foreign key → TB_EEP_CMPNY_INFO_M.CMPNY_SQ — NOT NULL
  • Field6 — VARCHAR(255) — 노트북 / 모니터 / 데스크탑 / 기타
  • Field5 — VARCHAR(255) — 정상 / 고장 / 대여중
  • Field — VARCHAR(255)
  • Field2 — VARCHAR(255)
  • Field3 — VARCHAR(255)
  • Field4 — VARCHAR(255)

TB_EEP_CMPNY_INFO_M

  • CMPNY_SQ — BIGINT(21) — Primary key — NOT NULL
  • Field — VARCHAR(255)
  • Field15 — VARCHAR(255)
  • Field8 — VARCHAR(255)
  • Field11 — VARCHAR(255)
  • Field12 — VARCHAR(255)
  • Field14 — VARCHAR(255) — 자사 / 거래처 / 협력사
  • Field2 — VARCHAR(255) — 법인/개인
  • Field9 — VARCHAR(255)
  • Field10 — VARCHAR(255)
  • Field3 — VARCHAR(255)
  • Field13 — VARCHAR(255)
  • Field4 — VARCHAR(255)
  • Field5 — VARCHAR(255)
  • Field6 — VARCHAR(255)
  • Field7 — VARCHAR(255)

TB_EEP_CMPNY_MNGR_INFO_S

  • MNGR_SQ — BIGINT(21) — Primary key — NOT NULL
  • CMPNY_SQ — BIGINT(21) — NOT NULL

TB_EEP_CMPNY_PRCHSE_M

  • PRCHSE_SQ — BIGINT(21) — Primary key — NOT NULL
  • CMPNY_SQ — BIGINT(21) — Foreign key → TB_EEP_CMPNY_INFO_M.CMPNY_SQ — NOT NULL
  • PRCHSE_START_DT — DATE
  • PRCHSE_END_DT — DATE
  • PRCHSE_TCD — VARCHAR(200)
  • PRCHSE_TSQ — BIGINT(21)

TB_EEP_CMPNY_SALES_M

  • SALES_SQ — BIGINT(21) — Primary key — NOT NULL
  • CMPNY_SQ — BIGINT(21) — Foreign key → TB_EEP_CMPNY_INFO_M.CMPNY_SQ — NOT NULL
  • SALES_START_DT — DATE
  • SALES_END_DT — DATE
  • SALES_TCD — VARCHAR(200)
  • SALES_TSQ — BIGINT(21) — NOT NULL

TB_EEP_COMM_AUTH_EMPLY_R

  • AUTH_CD — VARCHAR(200) — Foreign key → TB_EEP_COMM_AUTH_M.AUTH_CD — NOT NULL
  • CMPNY_SQ — BIGINT(21) — Foreign key → TB_EEP_COMM_AUTH_M.CMPNY_SQ — NOT NULL
  • USR_SQ — VARCHAR(255) — NOT NULL
  • USR_ID — VARCHAR(255) — NOT NULL

TB_EEP_COMM_AUTH_M

  • AUTH_CD — VARCHAR(200) — Primary key — NOT NULL
  • CMPNY_SQ — BIGINT(21) — Foreign key → TB_EEP_CMPNY_INFO_M.CMPNY_SQ — NOT NULL

TB_EEP_COMM_AUTH_MNU_R

  • AUTH_CD — VARCHAR(200) — Foreign key → TB_EEP_COMM_AUTH_M.AUTH_CD — NOT NULL
  • CMPNY_SQ — BIGINT(21) — Foreign key → TB_EEP_COMM_AUTH_M.CMPNY_SQ — NOT NULL
  • MNU_SQ — BIGINT(21) — Foreign key → TB_EEP_COMM_MNU_M.MNU_SQ — NOT NULL

TB_EEP_COMM_AUTH_PRGRM_R

  • AUTH_CD — VARCHAR(200) — Foreign key → TB_EEP_COMM_AUTH_M.AUTH_CD — NOT NULL
  • CMPNY_SQ — BIGINT(21) — Foreign key → TB_EEP_COMM_AUTH_M.CMPNY_SQ — NOT NULL
  • PRGRM_SQ — BIGINT(21) — Foreign key → TB_EEP_COMM_PRGRM_M.PRGRM_SQ — NOT NULL

TB_EEP_COMM_CD_M

  • GRP_CD — VARCHAR(200) — Primary key — NOT NULL
  • CMPNY_SQ — BIGINT(21) — Foreign key → TB_EEP_CMPNY_INFO_M.CMPNY_SQ — NOT NULL

TB_EEP_COMM_CD_S

  • DTL_CD — VARCHAR(200) — Primary key — NOT NULL
  • GRP_CD — VARCHAR(200) — Foreign key → TB_EEP_COMM_CD_M.GRP_CD — NOT NULL
  • CMPNY_SQ — BIGINT(21) — Foreign key → TB_EEP_COMM_CD_M.CMPNY_SQ — NOT NULL

TB_EEP_COMM_MNU_M

  • MNU_SQ — BIGINT(21) — Primary key — NOT NULL
  • CMPNY_SQ — BIGINT(21) — Foreign key → TB_EEP_CMPNY_INFO_M.CMPNY_SQ — NOT NULL

TB_EEP_COMM_PRGRM_M

  • PRGRM_SQ — BIGINT(21) — Primary key — NOT NULL
  • CMPNY_SQ — BIGINT(21) — Foreign key → TB_EEP_CMPNY_INFO_M.CMPNY_SQ — NOT NULL

TB_EEP_EMPLY_CARR_S

  • CARR_SQ — BIGINT(21) — Primary key — NOT NULL
  • EMPLY_SQ — BIGINT(21) — NOT NULL
  • CMPNY_SQ — BIGINT(21) — NOT NULL

TB_EEP_EMPLY_CERTFCTN_S

  • CERTFCTN_SQ — BIGINT(21) — Primary key — NOT NULL
  • EMPLY_SQ — BIGINT(21) — NOT NULL
  • CMPNY_SQ — BIGINT(21) — NOT NULL

TB_EEP_EMPLY_CMMT_H

  • CMMT_SQ — BIGINT(21) — Primary key — NOT NULL
  • EMPLY_SQ — BIGINT(21) — NOT NULL
  • CMPNY_SQ — BIGINT(21) — NOT NULL

TB_EEP_EMPLY_CSTPROCSSNG_H

  • CSTPROCSSNG_SQ — BIGINT(21) — Primary key — NOT NULL
  • EMPLY_SQ — BIGINT(21) — NOT NULL
  • CMPNY_SQ — BIGINT(21) — NOT NULL
  • FILE_SQ — BIGINT(21) — NOT NULL

TB_EEP_EMPLY_DOC_S

  • DOC_SQ — BIGINT(21) — Primary key — NOT NULL
  • EMPLY_SQ — BIGINT(21) — NOT NULL
  • CMPNY_SQ — BIGINT(21) — NOT NULL
  • FILE_SQ — BIGINT(21) — NOT NULL

TB_EEP_EMPLY_EDUCTN_S

  • EDUCTN_SQ — BIGINT(21) — Primary key — NOT NULL
  • EMPLY_SQ — BIGINT(21) — NOT NULL
  • CMPNY_SQ — BIGINT(21) — NOT NULL

TB_EEP_EMPLY_EQPMNT_RNTL_H

  • EQPMNT_SQ — BIGINT(21) — NOT NULL
  • EQPMNT_MNGMNT_NUM — BIGINT(21) — NOT NULL
  • CMPNY_SQ — BIGINT(21) — NOT NULL
  • EMPLY_SQ — BIGINT(21) — NOT NULL
  • FILE_SQ — BIGINT(21) — NOT NULL

TB_EEP_EMPLY_M

  • EMPLY_SQ — BIGINT(21) — Primary key — NOT NULL
  • CMPNY_SQ — BIGINT(21) — Foreign key → TB_EEP_CMPNY_INFO_M.CMPNY_SQ — NOT NULL
  • Field7 — VARCHAR(255)
  • Field — VARCHAR(200)
  • Field2 — VARCHAR(200)
  • Field10 — VARCHAR(255)
  • EMPLY_REGNO — VARCHAR(255)
  • Field9 — VARCHAR(255)
  • Field8 — VARCHAR(255)
  • Field3 — VARCHAR(200)
  • Field11 — VARCHAR(255)
  • Field12 — VARCHAR(255)
  • EMPLY_ECN_RELATN_TCD1 — VARCHAR(255)
  • EMPLY_ECN_RELATN_NUM1 — VARCHAR(255)
  • EMPLY_ECN_RELATN_TCD2 — VARCHAR(255)
  • EMPLY_ECN_RELATN_NUM2 — VARCHAR(255)

TB_EEP_EMPLY_MRTFEE_H

  • MRTFEE_SQ — BIGINT(21) — Primary key — NOT NULL
  • EMPLY_SQ — BIGINT(21) — NOT NULL
  • CMPNY_SQ — BIGINT(21) — NOT NULL
  • FILE_SQ — BIGINT(21) — NOT NULL

TB_EEP_EMPLY_OA_S

  • OA_SQ — BIGINT(21) — Primary key — NOT NULL
  • EMPLY_SQ — BIGINT(21) — NOT NULL
  • CMPNY_SQ — BIGINT(21) — NOT NULL

TB_EEP_EMPLY_PAY_S

  • PAY_SQ — BIGINT(21) — Primary key — NOT NULL
  • EMPLY_SQ — BIGINT(21) — NOT NULL
  • CMPNY_SQ — BIGINT(21) — NOT NULL

TB_EEP_EMPLY_VACTN_H

  • VACTN_SQ — BIGINT(21) — Primary key — NOT NULL
  • EMPLY_SQ — BIGINT(21) — NOT NULL
  • CMPNY_SQ — BIGINT(21) — NOT NULL
  • FILE_SQ — BIGINT(21) — NOT NULL

TB_EEP_FILE_M

  • FILE_SQ — BIGINT(21) — Primary key — NOT NULL

TB_EEP_PLTFRM_USR_M

  • USR_SQ — VARCHAR(255) — Primary key — NOT NULL
  • USR_ID — VARCHAR(255) — Primary key — NOT NULL
  • USR_PWD — VARCHAR(255)
  • CMPNY_SQ — BIGINT(21) — NOT NULL
  • EMPLY_SQ — BIGINT(21) — NOT NULL

TB_EEP_PRJCT_H

  • PRJCT_SQ — BIGINT(21) — Primary key — NOT NULL
  • EMPLY_SQ — BIGINT(21) — NOT NULL
  • CMPNY_SQ — BIGINT(21) — NOT NULL

TB_EEP_PRJCT_SKILL_R

  • PRJCT_SQ — BIGINT(21) — Foreign key → TB_EEP_PRJCT_H.PRJCT_SQ — NOT NULL
  • DTL_CD — VARCHAR(200) — Foreign key → TB_EEP_COMM_CD_S.DTL_CD — NOT NULL