project_my
Tables (8)
TB_BOARD (게시판테이블)
- BOARD_ID (boardId) — VARCAHR2(20) — Primary key — NOT NULL — PK NOT NULL
- FILE_ID (fileId) — VARCHAR2(100) — Foreign key → TB_FILE.FILE_ID — NOT NULL — FK
- BOARD_SJ (boardSj) — VARCHAR2(500)
- BOARD_CN (boardCn) — VARCHAR2(4000)
- RGS_DT (rgsDt) — DATE
- RGS_USER_ID (rgsUserId) — VARCHAR2(30)
- UPD_DT (updDt) — DATE
- UPD_USER_ID (updUserId) — VARCHAR2(30)
- FILE_ATCH_LMTT_AT (fileAtchLmttAt) — VARCHAR2(1)
- FILE_LMTT_CNT (fileLmttCnt) — NUMBER(10)
- FILE_LMTT_SIZE (fileLmttSize) — NUMBER(10)
- FILE_NM (fileNm) — VARCHAR2(200)
TB_DEPT (부서테이블)
- DEPT_CD (deptCd) — VARCHAR2(20) — Primary key — NOT NULL — PK NOT NULL
- HIGH_DEPT_CD (highDeptCd) — VARCHAR2(20)
- HIGH_DEPT_NM (highDeptNm) — VARCHAR2(30)
- ROW_DEPT_CD (rowDeptCd) — VARCHAR2(20)
- ROW_DEPT_NM (rowDeptNm) — VARCHAR2(30)
TB_DEPT_HIST (부서이력테이블)
- DEPT_CD (deptCd) — VARCHAR2(20) — Primary key — NOT NULL — FK
- HIGH_DEPT_CD (highDeptCd) — VARCHAR2(20)
- HIGH_DEPT_NM (highDeptNm) — VARCHAR2(30)
- ROW_DEPT_CD (rowDeptCd) — VARCHAR2(20)
- ROW_DEPT_NM (rowDeptNm) — VARCHAR2(30)
- DEPT_CREAT_DE (deptCreatDe) — VARCHAR2(8)
- DEPT_CLS_DE (deptClsDe) — VARCHAR2(8)
TB_FILE (파일테이블)
- FILE_ID (fileId) — VARCHAR2(100) — Primary key — NOT NULL — PK NOT NULL
- FILE_NM (fileNm) — VARCHAR2(200)
- FILE_PATH (filePath) — VARCHAR2(1000)
- FILE_ORGINL_NM (fileOrginlNm) — VARCHAR2(200)
- FILE_SIZE (fileSize) — NUMBER2(10)
- FILE_ERR_CN (fileErrCn) — VARCHAR2(200)
TB_MAIL (메일테이블)
- MAIL_SEND_USER_ID (mailSendUserId) — VARCHAR2(500)
- MAIL_SEND_USER_NM (mailSendUserNm) — VARCHAR2(500)
- MAIL_SJ (mailSj) — VARCHAR2(500)
- MAIL_CN (mailCn) — VARCHAR2(4000)
- MAIL_USER_ID (mailUserId) — VARCHAR2(500)
- MAIL_SEND_DT (mailSendDt) — DATE
- MAIL_SEND_MAIL (mailSendMail) — VARCHAR2(500)
TB_MEMBER (직원테이블)
- MBR_CD (mbrCd) — VARCHAR2(20) — Primary key — NOT NULL — PK NOT NULL
- MBR_ID (mbrID) — VARCHAR2(30) — Primary key — NOT NULL — PK NOT NULL
- DEPT_CD (deptCd2) — VARCHAR2(20) — Foreign key → TB_DEPT.DEPT_CD — NOT NULL — FK NOT NULL
- MBR_PW (mbrPw) — VARCHAR2(30)
- MBR_PW_ERR_CNT (mbrPwErrCnt) — NUMBER(3)
- MBR_NM (mbrNm) — VARCHAR2(20)
- DEPT_NM (deptNm) — VARCHAR2(30)
- MBR_RANK_NM (mbrRankNm) — VARCHAR2(10)
- MBR_STTUS_CD (mbrSttusCd) — VARCHAR2(20)
- MBR_EMAIL (mbrEmail) — VARCAHR2(30)
- MBR_PHONE (mbrPhone) — VARCAHR2(20)
- MBR_AREA (mbrArea) — VARCAHR2(10)
TB_MEMBER_HIST (직원이력테이블)
- MBR_CD (mbrCd) — VARCHAR2(20) — Primary key — NOT NULL
- MBR_ID (mbrId) — VARCHAR2(30) — Primary key — NOT NULL — PK NOT NULL
- DEPT_CD (deptCd) — VARCHAR2(20) — Foreign key → TB_DEPT.DEPT_CD — NOT NULL — FK NOT NULL
- MBR_PW (mbrPw) — VARCHAR2(30)
- MBR_NM (mbrNm) — VARCHAR2(20)
- DEPT_NM (deptNm) — VARCHAR2(30)
- MBR_ECNY_DE (mbrEcnyDe) — VARCHAR2(8)
- MBR_RETIRE_DE (mbrRetireDe) — VARCHAR2(8)
TB_NOTICE (공지사항테이블)
- NOTICE_ID (noticeId) — VARCAHR2(20) — Primary key — NOT NULL — PK NOT NULL
- FILE_ID (fileId) — VARCHAR2(100) — Foreign key → TB_FILE.FILE_ID — NOT NULL — PK NOT NULL
- NOTICE_SJ (noticeSj) — VARCHAR2(500)
- NOTICE_CN (noticeCn) — VARCHAR2(4000)
- RGS_DT (rgsDt) — DATE
- RGS_USER_ID (rgsUserId) — VARCHAR(30)
- UPD_DT (updDt) — DATE
- UPD_USER_ID (updUserId) — VARCHAR2(30)
- FILE_ATCH_LMTT_AT (fileAtchLmttAt) — VARCHAR2(1)
- FILE_LMTT_CNT (fileLmttCnt) — NUMBER(10)
- FILE_LMTT_SIZE (fileLmttSize) — NUMBER(10)
- FILE_NM (fileNm) — VARCHAR2(200)