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)