todList

Tables (8)

DEPT_MGT

  • DEPT_NO — VARCHAR2(100) — Primary key — NOT NULL — 부서번호
  • DEPT_NM — VARCHAR2(100) — NOT NULL — 부서명

MEMBER_LOGIN (LOGIN_USER)

  • LOGIN_ID — VARCHAR2(100) — Primary key — NOT NULL — 로그인_아이디
  • PASSWORD — VARCHAR2(100) — NOT NULL — 로그인_비밀번호

MEMBER_MGT (유저관리(상세))

  • LOGIN_ID — VARCHAR2(100) — Foreign key → MEMBER_LOGIN.LOGIN_ID — NOT NULL — 로그인_아이디
  • DEPT_NO — VARCHAR2(100) — Foreign key → DEPT_MGT.DEPT_NO — NOT NULL — 부서번호
  • MEMBER_NAME — VARCHAR2(10) — NOT NULL — 이름
  • MEMBER_PHONE — VARCHAR2(20) — NOT NULL — 폰번호
  • MEMBER_EMAIL — VARCHAR2(100) — NOT NULL — EMAIL
  • MEMBER_COMPANY — VARCHAR2(100) — NOT NULL — 회사명

MEMBER_ROLE_DTL (유저_권한_상세)

  • ROLE_ID — VARCHAR2(100) — Foreign key → MEMBER_ROLE_MST.ROLE_ID — NOT NULL — 권한_아이디
  • LOGIN_ID — VARCHAR2(100) — Foreign key → MEMBER_MGT.LOGIN_ID — NOT NULL — 로그인_아이디
  • DEPT_NO — VARCHAR2(100) — Foreign key → MEMBER_MGT.DEPT_NO — NOT NULL — 부서번호

MEMBER_ROLE_MST (유저_권한_마스터)

  • ROLE_ID — VARCHAR2(100) — Primary key — NOT NULL — 권한_아이디
  • ROLE_NM (권한_이름) — VARCHAR2(100) — NOT NULL — 권한_이름

TODO_DTL (일정_상세)

  • LOGIN_ID — VARCHAR2(100) — Foreign key → MEMBER_MGT.LOGIN_ID — NOT NULL — 로그인_아이디
  • DEPT_NO — VARCHAR2(100) — Foreign key → MEMBER_MGT.DEPT_NO — NOT NULL — 부서번호
  • TODO_NO — VARCHAR2(30) — Foreign key → TODO_MST.TODO_NO — NOT NULL — 할일번호
  • FEED_ID — VARCHAR2(100) — Foreign key → TODO_DTL_FEEDBACK.FEED_ID — NOT NULL — 피드백_ID
  • TODO_CONTENT — VARCHAR2(4000) — 할일 내용
  • TODO_CONTENT_UPDATE — VARCHAR2(4000) — 수정사항
  • TODO_INS_DATE — VARCHAR2(20) — NOT NULL — 등록일
  • TODO_COMPLETE_YN — VARCHAR2(1) — NOT NULL — 할일 완료여부
  • Field

TODO_DTL_FEEDBACK (할일_상세_피드백)

  • FEED_ID — VARCHAR2(100) — Primary key — NOT NULL — 피드백_ID
  • FEED_CONTENT — VARCHAR2(4000) — NOT NULL — 피드백_내용
  • FEED_INS_ID — VARCHAR2(100) — NOT NULL — 피드백_등록일자
  • FEED_INS_DT — VARCHAR2(8) — NOT NULL — 피드백등록일자

TODO_MST (일정_마스터)

  • TODO_NO — VARCHAR2(30) — Primary key — NOT NULL — 할일번호
  • TODO_CLS — VARCHAR2(10) — 할일구분