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