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) — 할일구분