toy project
Tables (4)
ISSUE
- ISSUE_ID — VARCHAR(50) — Primary key — NOT NULL
- REQUESTER_ID (USER_ID) — VARCHAR(50) — Foreign key → USER.USER_ID — NOT NULL
- MODULE_CODE — VARCHAR(30)
- INQUIRY_TYPE_CODE — VARCHAR(30) — 단순문의/오류 등
- TITLE — VARCHAR(200)
- CONTENT — VARCHAR(4000)
- DESIRED_DUEDATE — VARCHAR(20) — 완료요청일자
- EXPECTED_DUEDATE — VARCHAR(20)
- COMPLETEDATE — VARCHAR(20)
- STATUS_CODE — VARCHAR(30)
- ASSIGNEE_ID — VARCHAR(50) — 담당자
- PRIORITY_CODE — VARCHAR(20) — 우선순위 상중하
- USE_YN — VARCHAR(1) — DEL_YN
- INSERTDATE — VARCHAR(20)
- UPDATEDATE — VARCHAR(20)
ISSUE_COMMENT
- COMMENT_ID — Primary key — NOT NULL
- ISSUE_ID — VARCHAR(50)
- AUTHOR_ID — VARCHAR(50)
- USE_YN — VARCHAR(1)
- INSERTDATE — VARCHAR(20)
- UPDATEDATE — VARCHAR(20)
MODULE_MST
- MODULE_CODE — VARCHAR(30) — Primary key — NOT NULL
- MODULE_NAME — VARCHAR(100)
- USE_YN — VARCHAR(1)
- INSERTDATE — VARCHAR(20)
- UPDATEDATE — VARCHAR(20)
USER
- USER_ID — VARCHAR(50) — Primary key — NOT NULL
- USER_NAME — VARCHAR(100)
- EMAIL — VARCHAR(150)
- DEPT_NAME — VARCHAR(100)
- ROLE_CODE — VARCHAR(30)
- USE_YN — VARCHAR(1)
- INSERTDATE — VARCHAR(20)
- UPDATEDATE — VARCHAR(20)